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 and how we can better serve your needs as well as give feedback to ITS as a whole.
OPEN SESSION 1: 2pm, 3/14/17, Michigan Room A in the UCEN
OPEN SESSION 2: 10am, 3/15/17, Michigan Room A in the UCEN
Light refreshments will be served

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 duplicates comes in handy.

To remove your duplicates, highlight the row or column that you want to remove duplicates of. Then, go to the Data tab, and select “Remove Duplicates” (In the Data Tools group). A pop-up will appear to confirm which data you want to work with. Select “Remove Duplicates,” and you’re all set!

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 anywhere in the paragraph three times.

 

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 your keyboard!  You can add a “Save As” icon to the Quick Access Toolbar as another option.

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.

Capture

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 Helpdesk and ask for a ticket for Dennese Bandyk to contact you!

Posted in Uncategorized | Comments Off on Personalized Training