Excel Basics 3: PivotTables & Conditional Formatting

Build on your basic Microsoft Excel skills and learn to use Excel data effectively.

In this third session, you will:

• Use Conditional Formatting to visualize data
• Explore the power of PivotTables for data summary and analysis
• Sort and filter the data in tables and using slicers
• Take home practice data to improve your new skills

Upon completion of this class, you will be able to get more from your data using Pivot tables.

Prerequisites: Excel Basics 1 and 2 or equivalent knowledge. Basic mouse and keyboard skills required.

Format: Hands-on with demonstrations

Information Collection Notice: The personal information on this form is collected by the Toronto Public Library under the Public Libraries Act, sections 20(a), 20(c), and 20(d). The information will only be used for event and program registration, delivery and evaluation. Questions about how the library handles your information can be directed to Answerline staff at answerline@tpl.ca, 416-397-5981, 789 Yonge Street, Toronto ON M4W 2G8.