Introduction
  • Welcome to this course
  • Enhance your course experience
  • An introduction to Excel 2013
Viewing data
  • Effectively navigate a spreadsheet
  • Check what you've learnt in this lecture
  • Sort and filter data to find answers
  • Check what you've learnt in this lecture
Cleaning and modifying data
  • Rearrange and clean up your data
  • Check what you've learnt in this lecture
  • Modify your data using Flash Fill
  • Check what you've learnt in this lecture
Analyzing and visualizing data
  • Analyze data using a PivotTable
  • Check what you've learnt in this lecture
  • Visualize data using charts
  • Check what you've learnt in this lecture
Using formulas to perform calculations
  • Use simple formulas to fill out a budget
  • Check what you've learnt in this lecture
  • Use Lookup formulas to fine-tune your spreadsheet
  • Check what you've learnt in this lecture
Closing
  • Summary
  • Check what you've learnt in this course