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
Microsoft Office Open Sessions
Drop in at any time during a session with any of your Office questions. Multiple dates available – see schedule.
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.
Windows 10 – Getting Started!
Windows 10 – Getting Started workshop is scheduled for 4/1/2016 10:00am-11:00am. Sign-up today!
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
Excel Formulas for Everyday Situations
To remove unnecessary spaces, use =trim(text)
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
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
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.
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