ITS Calendar

Feb 17

Advanced Excel for Analysis - session 1

This class will introduce intermediate Excel users to advanced features and data analysis techniques.

Monday, February 17th, 2014
2:00 – 3:00 pm / CMC 11

This class, aimed primarily at data warehouse users (but which can be taken
by others as well), has, as its goal, to introduce intermediate Excel users to
advanced features and data analysis techniques.

This is the first class in a 3-part series.

Examples of topics to be covered, by session (tentative; subject matter will
adjust to serve the needs of those who sign up):

    Session 1,  Feb 17

        Manipulation of data using Pivot Tables
            Simultaneously filtering multiple tables with slicers
            Sprucing up tables using
                - Spark lines        
                - Conditional formatting (create heat maps)
                - Multiple Y axes

Prerequisites:  Intermediate knowledge of Excel (e.g., you can make a table or formula)


Please sign up below!


Sponsored by Information Technology Service. Contact: Richard Goerwitz, x5526