Author Archives: ddbandyk

ITS Open Campus Sessions

ITS will be discussing services that we offer to campus. We will give a short presentation covering our groups and services followed by a question and answer period. This event is a great opportunity to learn more about our group … Continue reading

Posted in Uncategorized | Comments Off on ITS Open Campus Sessions

Microsoft Office Open Sessions

Drop in at any time during a session with any of your Office questions. Multiple dates available – see schedule.

Posted in Uncategorized | Comments Off on Microsoft Office Open Sessions

Excel 2016 – 7 New Chart Types!

Microsoft added 7 new chart types to Excel that will help users to do a better job when it comes to visualizing hierarchical and financial data. They are Treemap, Sunburst, Waterfall, Pareto, Histogram, Box and Whisker.

Posted in Uncategorized | Comments Off on Excel 2016 – 7 New Chart Types!

Windows 10 – Getting Started!

Windows 10 – Getting Started workshop is scheduled for 4/1/2016 10:00am-11:00am. Sign-up today!

Posted in Uncategorized | Comments Off on Windows 10 – Getting Started!

Excel

Remove Duplicates Larger data sets tend to have duplicate content. For example, you might have a list of multiple contacts in a company and only want to see the number of companies you have. In situations like this, removing the … Continue reading

Posted in Excel | Comments Off on Excel

Excel Formulas for Everyday Situations

To remove unnecessary spaces, use =trim(text)

Posted in Excel | Comments Off on Excel Formulas for Everyday Situations

Microsoft Word – 2010/2013

HIGHLIGHT A SENTENCE WITH ONE QUICK CLICK!  Hold down the [Ctrl] key and click any word in the sentence, and Word will then select the entire sentence for you!  Also, if you would like to select an entire paragraph, click … Continue reading

Posted in Uncategorized | Comments Off on Microsoft Word – 2010/2013

Office 2013: Keyboard shortcut to Saving Documents without Opening Backstage View

In Office 2013 whenever you save a new document, the program will open the Backstage View.  One solution to this inability to perform “Save As” in a single step is to press the function key F12 at the top of … Continue reading

Posted in Uncategorized | Comments Off on Office 2013: Keyboard shortcut to Saving Documents without Opening Backstage View

New in Excel 2013 – Quick Analysis!

Quick Analysis is a new button that appears at the bottom right corner of selected data. Using this, you can do a lot of quick analysis tasks like sparklines, conditional formatting, charts, changing your data into tables or pivot tables.

Posted in Excel | Comments Off on New in Excel 2013 – Quick Analysis!

Personalized Training

Are you interested in some personalized training?  Did you know that ITS has an in-house trainer to work with you on Microsoft products and other University software?  For more information about what ITS has to offer for training contact the … Continue reading

Posted in Uncategorized | Comments Off on Personalized Training