- Duration: 8 hours
This live online training course is offered by a collaboration of Minnesota State colleges.
Take both Excel Level 1 and 2 classes and save!
Gain the foundational knowledge you need to start using Microsoft Excel. Learn to navigate, manage, create formulas and use basic functions in worksheets. Then, 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.
Excel Level 1: Practical Excel
- Getting started: Exploring the Microsoft Excel environment
- Navigating, managing worksheets, and views
- Worksheet layout, entering and modifying Data
- Creating formulas & using basic functions
- Formatting cells, themes and cell styles
- Printing worksheets
Excel Level 2: Working with Data
- Understanding types of Excel data
- 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.
- Computer with Microsoft Excel (2016 or newer recommended), webcam, microphone, and high-speed internet.
- Your experience will be enhanced if you have 2 monitors but it is not required.
- Zoom connection information and Excel working files to download will be emailed several days prior to the class date.
- We request that participants utilize the video feature during the training session so the instructor can monitor your experience.