Excel Explained: Introduction to Spreadsheets

The first half of this session will help Microsoft Excel beginners get up to speed by learning how to assemble an amortization table from scratch. Experienced Excel users will learn new tricks, particularly during the second half. We'll discuss under-utilized aspects of Excel such as managing error prompts, filtering data (instead of sorting), as well as provide an overview of new data analysis features in Excel 2013.

We'll teach primarily Excel 2010, while noting significant differences in Excel 2007 and 2013 where applicable. Coverage of Excel 2003 will be limited to alternate instructions in the handout.

Learning Objectives:

  • Gain understanding of Microsoft Excel and how to build a spreadsheet
  • Learn keyboard shortcuts and techniques that simplify repetitive tasks in Excel
  • Get an overview of using charts and pivot tables in your workbooks

Covered Topics:

  • Get an overview of the different types of files you can create in Excel
  • Simplify repetitive tasks by creating your own keyboard shortcuts
  • Navigate large workbooks with ease using a hidden menu, as well as keyboard shortcuts
  • Discover how to quickly access folders and workbooks, either on your computer or a network
  • Streamline Filtering tasks down to one click, instead of 7 or more
  • Capitalize on new features in Excel 2013 that empower anyone to quickly analyze data
  • Discover the new Recommended Pivot Tables feature in Excel 2013

Who Should Attend?

Anyone wishing to use Microsoft Excel more effectively.

"Well worth the money we paid! The presenter switched flawlessly between his presentation slides and live Excel in a way that was clear and interesting." -Paula D., Collegiate Peaks Bank

"I was very impressed with the training. The onscreen activities and captions were easy to follow." -Danielle L., South Central Bank