Excel Intermediate

Module 3: List/Table Essentials & Charting 

Topics:

• What is a well-defined list?
• Inserting Tables 
• Flash fill
• Multi-Level Sorting
• Removing Duplicates
• Filtering Records
• Using Slicers to filter
• Automatic Subtotals
• The Quick Analysis Tools
• Inserting Data Charts
• Recommended Charts
• Editing Chart Elements
• Adding/Removing Data From A Chart
• Creating Custom Chart Templates
• Printing Charts
• Inserting Sparkline

Module 4: Pivot Tables, Protecting & Linking Data

Topics:

• Creating Pivot Tables From Lists Or Tables
• Office 365 Pivot Table Enhancements
• Filtering Pivot Tables
• Multi-Select Slicers
• Working With Pivot Charts
• Data Validation Rules
• Applying Built In Conditional Formatting
• Creating Custom Conditional Formats
• Comments
• Linking Data
• Cell, Sheet, And File Protection

What We'll Explore:

1. Create tables to help make analyzing large data sets easier with table tools
2. Using Filters and Sorting tools on a data sets show the data you are looking for
3. Create and save visuals and charts for data sets
4. Find discoveries within data sources using PivotTables
5. Create Pivot Charts out of PivotTables for visual representations of reports.
6. Protect and lock worksheets and workbooks to restrict users.