Topics

  • Essential Worksheet Operations
  • Entering and Editing Worksheet Data
  • Working with Cells and Ranges
  • Introducing Tables
  • Worksheet Formatting
  • Using and Creating Templates
  • Printing Your Worksheets
  • Working with Formulas and Functions
    • Logical functions
    • Lookup & Reference functions
    • Statistical count functions
    • Date and time functions
    • Mathematical functions
    • Text functions
    • Financial functions
    • Massive functons
    • Additional functions
  • Getting Started Making Charts
  • Visualizing Data Using Conditional Formatting
  • Using Data Validation
  • Protecting Your Work
  • Introducing Pivot Tables