This live online training course is offered by a collaboration of Minnesota State colleges.
Learn how to understand, filter and sort different types of data in Microsoft Excel. You will also learn advanced formulas and utilize the Data Model with pivot tables.
- Understanding types of data in Excel
- Filtering and sorting
- Excel tables
- Advanced Formulas: logic and summarizing functions (COUNTIF, SUMIF, AVERAGEIF, VLOOKUP)
- Pivot tables and pivot charts
- Using the Data Model with pivot tables
About The Instructor:
Bob Bruce is a Twin Cities-based Information Architect who has expert level skills in the Microsoft Office suite of products. He’s an Excel 2013 Microsoft Certified Expert. Bob has logged thousands of hours as a software trainer, and is energized by the prospect of improving student skills and knowledge.