Introduction
  • Introduction
Using the Application
  • The Microsoft Excel 2016 for Mac Application
  • Creating Spreadsheets
  • Saving a Spreadsheet
Working with cells
  • Cells
  • Finding and Replacing Data
  • Sorting Data in a Spreadsheet
  • Filtering Data
  • Cut, Copy and Paste Content and Deleting Cell Content.
Managing Worksheets
  • Rows and Columns
  • Worksheets
Formulas and Functions
  • Creating formulas
  • Formula Quiz
  • Using the Autofill button
  • Absolute Cell Reference
  • Functions
  • The IF Statement
Formatting
  • Cell Formatting
  • Formatting Cell Contents (Fonts)
Charts
  • Creating a chart
  • Editing Charts
Outputs
  • The Page Set Up Options
  • Printing
Practice 1
  • Practice Part one
  • Practice Part two
  • Bonus Lecture
Conditional Formatting
  • Conditional formatting - The Basics
  • Condition Formatting - creating rules
  • Conditional Formatting- Clearing formatting
  • Conditional Formatting - Dates
  • Conditional Formatting- Data Bars