Learn advanced functions and formulas in Microsoft Excel. After this 4-hour live online workshop, you’ll be able to organize and analyze data more efficiently and effectively to make informed business decisions.
Follow along with the instructor as you practice various tools and functions using the downloadable exercise files provided. You'll also receive a comprehensive guide with step-by-step instructions, shortcuts, and tips for everything you learn in this class.
For human resource professionals, each course provides 3.5 professional development credits for SHRM-CP or SHRM-SCP.
What You'll Learn:
- Filtering and Sorting Review
- Excel Tables
- Nesting Functions
- Advanced Formulas: Logic and Summarizing Functions (COUNTIF, SUMIF, AVERAGEIF)
- vLookup & xLookup Functions and Applications
- Pivot Tables & Pivot Charts
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.
This live online training course is offered by a collaboration of Minnesota State colleges and universities.