In this session Excel expert David Ringstrom helps beginners get up to speed in Microsoft Excel. However, even experienced Excel users will learn some new tricks, particularly when David discusses under-utilized aspects of Excel such as using templates, filtering data (instead of sorting), and well as provide an overview of new data analysis features in Excel 2013.
David will teach primarily from Excel 2010 while noting significant differences in Excel 2007 and 2013 where applicable. Coverage of Excel 2003 will be limited to alternate instructions listed within in the handout.
Topics Covered:
- Get an overview of the different types of files you can create in Excel.
- Simplify repetitive tasks by creating your own keyboard shortcuts
- Never type $ signs manually in a formula again, use a keyboard shortcut instead!
- Learn how to add clickable icons for macros that you record on to Excel's Quick Access toolbar.
- 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.
Learning Objectives:
- Gain an 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