Microsoft Excel Training Class - Introduction

Microsoft Excel Training Class Topics Covered
Topics generally covered in the Microsoft Excel course include the following. Course content may be adapted based upon the needs of the specific class.
Getting Started with Excel
Getting to know the workspace
Getting to know the cell pointer
Using the Ribbon
Exploring the Status bar
Using the Quick Access toolbar
Using the Formula bar
Moving around the worksheet
Exploring what’s new in Excel 2013
Creating an Excel Worksheet
Entering data in a cell
Working with cell ranges
Saving and opening workbooks
Editing data, and using undo and redo
Working with rows and columns
Creating additional worksheets
Printing worksheets and workbooks
Formatting a Worksheet in Excel
Understanding cell formats
Changing number formats
Changing the font and font size
Modifying row heights and column widths
Cell alignment and cell styles
Borders and shading
Copying cell formats
Using conditional formatting
Using page themes
Using Formulas in Excel
Entering simple formulas
Referencing cells from other worksheets or workbooks
Using functions and the function Library
Using the AutoSum tool
Using common functions
Working with ranges
Copying formulas
Formula auditing
Working with Charts in Excel
Understanding chart types
Creating moving, and resizing, a chart
Understanding chart elements
Using chart recommendations
Customizing the chart
Printing a chart
Using Sparklines
Working with Data in Excel
Working with lists
Creating a list
Sorting records
Filtering records
Searching records
Deleting records
Removing duplicates
Extracting records
Subtotaling data
Grouping records
Using data validation
Converting text to columns
Using Flash Fill
Working with Excel Templates
Working with templates
Saving a workbook as a template
Opening a custom template
Protecting workbooks and worksheets
Unlocking cells in a protected worksheet
Hide and protect formulas
Searching for templates
Advanced Data Analysis in Excel
Introduction to PivotTables
Creating a PivotTable
Rearranging a PivotTable
Removing fields from a PivotTable
Formatting a PivotTable
Editing and updating a PivotTable
Changing the calculation
Hiding and showing data in a PivotTable
Adding subtotals to a PivotTable
Using recommended PivotTables
Working with PivotCharts
Working with tables
What-If analysis