Advanced Excel for Analysis - session 1
This class will introduce intermediate Excel users to advanced features and data analysis techniques.
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