Microsoft Excel Intermediate

Course Overview

Microsoft Excel Intermediate

Understand the tools available in Excel to automate calculations, control large data lists and work with data across multiple sheets.

Course Content

Working with Multiple Worksheets and Workbooks

• Moving between worksheets
• Inserting, deleting and renaming worksheets
• Moving and copying worksheets
• Using group editing
• Arranging multiple files
• Entering formulae across worksheets and workbooks

Conditional Formatting

• Highlighting cells using rules and conditions
• Identify trends with data visuals and icon sets
• Create new rules and manage existing rules

More Formulas and Functions

• Creating statistical functions
• Logical IF functions
• Calculating percentages

Manipulating Data Lists

• Remove duplicate values
• Automatic subtotals and grand totals
• Data grouping and outlining tools
• Inserting Excel tables
• Manipulating data in an Excel table

Working with Charts

• Creating charts and graphs
• Quick analysis tools
• Formatting charts
• Modifying chart layouts
• Adding and removing chart elements
• Filtering chart data
• Creating combination charts
• Saving charts as templates
• Creating sparklines
• Previewing and printing charts