Gain the skills you need to start using Microsoft Excel like a pro and save with this discount bundle of two 4-hour live online workshops.

In Excel Level 1: Fundamentals, you'll learn how to navigate, manage, create formulas and use basic functions in worksheets. Then in Excel Level 2: Working with Data, you'll learn how to understand, filter and sort different types of data, work with advanced formulas, and utilize the Data Model with pivot tables. After the full day of Microsoft Excel training, 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 4-hour course provides 3.5 professional development credits for SHRM-CP or SHRM-SCP.

What You'll Learn in Excel Level 1:

• Getting Started: Exploring the Microsoft Excel Environment
• Navigating and Managing Worksheets
• Entering and Modifying Data
• Creating Formulas & Using Basic Functions
• Formatting Cells
• Full Understanding of Number Formats
• Printing Worksheets

• 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.

• Computer with Microsoft Excel 2016 or newer, webcam, microphone, and high-speed internet.
• 2 monitors (or 1 large high-resolution screen capable of having multiple windows open at a time).
• Plan to have your video camera on during the training, so the instructor can monitor your experience.
• Zoom links and Excel working files will be emailed several days prior to the class date. Download the Excel files to your computer before the class

Cancellation Policy:

• A full refund (minus a $25 processing fee) or a transfer to a new class date will be issued if the request is made at least 5 business days prior to the class. Requests must be made by calling 507-389-7203 or emailing cwe@southcentral.edu.
• No refunds or transfers will be provided if the request is made less than 5 business days before the class date.