Getting Started
  • Introduction
The Excel Interface
  • Creating New Files and Exploring Templates
  • Using the Menu System
  • Using the Quick Access Toolbar
  • The Structure of a Worksheet and Workbook
  • Using the Formula Bar
  • Context Menu and the MiniToolbar
Entering Data
  • Entering and Editing Data
  • Entering Data with AutoFill
  • Working with Dates and Times
  • Using Undo and Redo
  • Adding Comments
  • Using Save and Save As
Functions and Formulas
  • Creating Your First Formulas: Totals and Averages
  • Copying a Formula to Another Cell
  • Relative and Absolute References
  • Using the SUM and AVERAGE Functions
  • Using other Common Functions
Formatting Techniques
  • Font Styles and Effects
  • Adjusting Row Heights and Column Widths
  • Using Alignment and Wrap Text
  • Designing Borders
  • Using Numeric, Special, and Date Formatting
  • Using Conditional Formatting
  • Creating and Using Tables
Was this course worth your money?
  • How to Leave a Review
  • How to Get a Refund if you Were Not Satisfied