Introduction
  • Introduction
Microsoft Excel Basics
  • Launching Excel
  • Excel Home Screen
  • Introduction to Excel Interface
  • Quick Access Toolbar
  • Status Bar
  • Structure of an Excel Workbook
  • Saving an Excel Document
  • Opening a Saved Excel Document
  • Common Excel Shortcuts
Entering and Editing Data In Excel
  • Entering Data and Highlighting Cells
  • Entering Text
  • Entering Numbers
  • Entering Dates
  • Using Cell References
  • Creating First Formula
  • Relative Versus Absolute Reference
Microsoft Excel Basic Functions
  • Excel's SUM Function
  • Excel's MIN & MAX Functions
  • Excel's AVERAGE Function
  • Excel's COUNT Function
  • Adjacent Cell Error
  • Excel's AutoSum Function
  • Excel's AutoFill Command
Modifying An Excel Worksheet
  • Copy and Paste Data in Excel
  • Inserting and Deleting Columns and Rows
  • Adjusting Cell Height and Width
  • Hiding and Unhiding Columns and Rows
  • Renaming an Excel Sheet
  • Deleting an Excel Sheet
  • Moving and Copying an Excel Sheet
Formatting Data In Excel
  • Using Font Formatting Commands
  • Changing a Cell's Background Color
  • Adding Cell Borders
  • Formatting Data as Currency
  • Formatting Data as Percentages
  • Using Format Painter
  • Creating Cell Styles
  • Merge and Center Cells
  • Conditional Formatting
Inserting Shapes and Images Into Excel
  • Inserting Images
  • Inserting Shapes
  • Formatting Shapes
  • Using Smart Art
Creating Charts In Excel
  • Create a Column Chart
  • Using the Chart Ribbon
  • Modifying Data of a Chart
  • Moving a Chart
  • Create a Pie Chart
Printing an Excel Worksheet
  • Using Print Preview
  • Changing a Sheet's Print Properties
  • Using the Page Layout View
  • Adding Header and Footer Content
  • Printing a Specific Set of Cells
Using Excel Templates
  • Introduction to Excel Templates
  • Using Excel Templates
  • Creating an Excel Template
Congrats!
  • Congratulations
Working With Lists
  • Basics of Excel Lists
  • Single Level Sorting
  • Multi Level Sorting
  • Custom Sorting
  • Using the AutoFilter Tool
  • Creating Subtotals
  • Format List as a Table
  • Conditional Formatting to Find Duplicates
  • Remove Duplicates
Excel List Functions
  • DSUM Function
  • DAVERAGE Function
  • DCOUNT Function
  • SUBTOTAL Function
Data Validation in Excel
  • Intro to Data Validation
  • Create A Validation List
  • Custom Validation Error
  • Dynamic Formulas and Data Validation
Excel PivotTables
  • Intro to PivotTables
  • Creating a PivotTable
  • Modifying PivotTable Calculations
  • Grouping PivotTable Data
  • Formatting PivotTable Data
  • Drilling Down PivotTable Data
  • Creating PivotCharts
  • Filtering PivotTable
  • Using the Slicer Tool
Excel PowerPivot