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.
- 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.
- 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
Who Should Attend?Anyone wishing to use Microsoft Excel more effectively
Please note: This site employs features that may cause unexpected behavior in older versions of Internet Explorer. If you experience a problem, try refreshing your screen. If this doesn't solve the problem, click on this link.
You may contact us by using the Online Chat button below.