Introduction
  • Course Introduction
  • Practice files
Getting Started
  • Excel Start-up Screen
  • Excel Interface
  • Saving and Opening Excel Document
Data Formatting
  • Textual and Numeric Data
  • Date Format
  • Format Painter
Formatting Cells in Excel Worksheet
  • Font Formatting
  • Background Color of Cells
  • Adding Borders to Cells
  • Cell Styles
  • Merging and Centering Cells
  • Conditional Formatting
Editing Excel Worksheet
  • Moving and Copying Data
  • Inserting Rows and Columns
  • Changing the Width and Height of Cells
  • Renaming, Deleting and Coping Excel Worksheet
Common Excel Formulas and Functions
  • Mathematical Operations
  • SUM Function
  • Autofill Command
  • AutoSum Function
  • Relative and Absolute References
  • AVERAGE Function
  • MIN and MAX Functions
  • COUNT FUNCTION
Excel Shapes and Images
  • Inserting Images
  • Working with Excel Shapes
  • Working with Excel SmartArt
Creating Charts in Excel
  • Excel Bar Charts
  • Excel Line Charts
  • Excel Pie Charts
  • Modifying Data on Excel Chart
  • Formatting Excel Chart
Printing Excel Worksheet
  • Margins, Scaling and Orientation
  • Adding Header and Footer Content
  • Printing Options
  • Printing a Specific Range of Cells
Excel Templates
  • Finding Excel Templates
  • Creating a Custom Excel Template
Excel Lists
  • Sort Lists in Excel
  • Custom Sorts
  • AutoFilter Tool
  • Format a List as a Table
  • Removing Duplicates
  • DSUM Function
  • DAVERAGE Function
  • DCOUNT Function
  • SUBTOTAL Function
Excel PivotTables
  • Creating Excel PivotTable
  • Modifying Excel PivotTable Calculations
  • Grouping PivotTable Data
  • Formatting PivotTable Data
  • Extracting Data from PivotTable
  • Filtering PivotTable Data
  • Creating PivotCharts
Advanced Excel Functions
  • Excel Name Ranges
  • IF Function
  • AND Function
  • Excel Nested Functions in a Formula
  • COUNTIF Function
  • SUMIF Function
  • IFERROR Function
  • VLOOKUP Function
  • INDEX Function
  • MATCH Function
  • LEFT Function
  • RIGHT Function
  • MID Function
  • LEN Function
  • SEARCH Function
  • CONCATENATE Function
Advanced Excel Tools
  • Data Validation
  • Importing and Exporting Data
  • Freeze Panes Tool
  • Grouping Data
  • Linking Worksheets
  • Consolidating Data Tool
  • Protecting Excel Worksheets, Workbooks and Cells
Additional Resources
  • Additional Resources to Boost Your Excel Skills