Microsoft Excel Intermediate

Course Outline

Prerequisites: Excel Basic 2016 or equivalent

Module 1: Managing workbooks and worksheets

• Working with multiple worksheets

• Linking worksheets with 3-D formulas

• Linking Formulas Across Multiple Workbooks

• Grouping of Worksheets

• Consolidating of Data

Module 2: Linking a Table & Chart to PowerPoint / Freezing Panes & View Options

• Using Paste Special & Paste Link

• Using Update Link

• Working with Freezing Panes

Module 3: Grouping and Subtotals

• Grouping of data

• Creating subtotals

Module 4: Name Space & Ranges

• Creating and using names

• Managing names

Module 5: Tables, Conditional Formatting & Quick Analysis Tools

• Sorting and filtering data

• Working with tables

• Create a conditional formatting rule

• Conditional formatting presets

• Using Quick Analysis Tools Window

Module 6: New Charts, Sparklines & 3D / Power Maps

• Chart Formatting Options

• Working with the Six New Charts

• Inserting Sparkline

• Working with Power Maps

Module 7: Track Changes & Comments / Inspecting and Protecting Workbooks

• Working with Track Changes, Comments

• Workbook and Worksheet Protection

• Protecting Excel Files