Introduction
  • Getting started with Microsoft Excel
  • Parts of an Excel window
  • Ribbon - the wardrobe of Excel commands
  • Backstage view or File tab
  • Quick access toolbar
  • Creating a new workbook
  • Saving workbook
  • Navigating workbook
  • Undo and Redo changes
Working with cells, columns and rows
  • Selecting cells
  • Selecting columns and rows
  • Adjusting column width and row height
  • Merge cells
  • Hide columns and rows
  • Inserting and deleting columns and rows
Entering data in Excel
  • Entering text in excel
  • Entering numbers, currencies, percentages
  • Entering dates
  • Editing data
  • Delete data
Font formatting
  • Changing font style and size
  • Changing font color
Formatting cells
  • Cell borders
  • Fill color in cells
Working with data
  • Freezing panes and View options
  • Sorting data
  • Filtering data
  • Creating basic charts
  • Conditional formatting
Introduction to formulas
  • Cell references
  • Introduction to formulas
  • Complex formulas