Excel Introduction - First Look
  • Excel Introduction - First Look
Excel Level 1 - Beginner
  • Exercise Files, Instructor's Notes, Quiz and Answers
Basics
  • Themes, Save Location, Back Stage & Fonts
  • Quick Access Toolbar
  • Ribbon
  • Navigating Shortcuts, Tips, Tricks & Selecting Cells
  • Data Entry & Basic Worksheet
  • Save, Save As & Backup Copy
  • Convert To 2016
  • Compatibility Checker
  • Tell Me What You Want To Do - The New Help Feature
  • Basics Quiz
Functions & Formulas
  • Basic Formulas
  • SUM & AVERAGE
  • MIN & MAX
  • COUNT & COUNTA
  • Move, Copy, Cut, & Paste Data into Cells
  • Absolute & Relative References
  • Mixed References
  • AutoFill
  • FlashFill
  • Converting Text into Columns
  • Functions & Formulas Quiz
Editing Worksheets
  • Editing Cell Data
  • Insert & Delete Cells, Columns and Rows
  • Find & Replace Data
  • GoTo
  • Transpose or Flip a Range of Data
  • Change Height, Width, & Hide Rows and Columns
  • Check Worksheet or Workbook Spelling with Spell Check
  • Smart Lookup & Thesaurus
  • Editing Worksheets Quiz
Formatting
  • Formatting Text
  • Basic Number Formats
  • Basic Custom Number Format
  • Adding Borders & Colors to Cells
  • Formatting Shortcuts
  • Adding Background
  • Align, Merge & Wrap Cell Data
  • Cell Styles
  • AutoFormat
  • Applying Themes
  • Basic Conditional Formatting
  • Conditional Formatting Manager
  • Formatting Quiz
Print
  • Print Page Breaks, Grildines & Headlines
  • Page Orientation
  • Print Rows at the Top of Each Page - Repeat Column Headers
  • Headers & Footers
  • Editing Page Margins & Center on Page
  • Page Breaks
  • Setting Print Range & Scaling
  • Print Quiz
Modifying Worksheet Appearance
  • Name, Move, Copy, Color, Link Worksheets in Workbook
  • Hide Worksheets & Workbooks
  • Split Worksheet
  • Freeze Panes
  • New Windows - Multiple Workbook Views
  • Customize Formula Options
  • Speak Cells
  • Modifying Worksheet Appearance Quiz
Excel Level 2 - Intermediate
  • Exercise Files, Instructor's Notes, Quiz & Answers
Advanced Formulas & Functions
  • Named Ranges
  • Auto-Save Version Control
  • Linking Data From One Cell, or Range into Another
  • Convert Text to Upper, Lower, or Proper Case using Formulas
  • CONCATENATE
  • LEFT, SEARCH & FIND Functions
  • RIGHT, FIND & LEN Functions
  • MID
  • AND & OR
  • IF
  • Combining & Nesting Functions AND & IF
  • IFERROR
  • PMT or Payment
  • Display & Print Formulas
  • SUMIFS, COUNTIFS & AVERAGEIFS
  • CONVERT
  • MATCH & INDEX
  • LOOKUP
  • VLOOKUP
  • HLOOKUP
  • Single & Multicell Array Formulas
  • Advanced Formulas & Functions Quiz
Tables
  • Create Tables
  • Modifying Tables
  • Format Table
  • Custom Table Styles
  • Table Sorting & Filtering