Introduction to Efficient Excel
  • A structured approach to problem solving
  • Keyboard efficiency and shortcuts
  • Quick navigation to important cells and ranges
  • Control Pasting from Other Applications
  • Use an index function to perform a lookup across multiple tables
  • Create a single lookup to replace multiple formulas
  • Arrange and summarize data more efficiently with pivot tables
  • Debug a complicated formula by evaluating it part by part
  • Create a dashboard to gather and organize outputs
  • Use functions to create in cell charts
  • Finer control over protections to allow user interaction