Excel Level 1 & 2 - Jan. 2020
We offer five different courses of Microsoft Excel courses through Bob Bruce, an instructor who has trained people on Microsoft products for more than 20 years.
Each course takes 3.5 hours. St. Cloud State provides a laptop and mouse to use for this hands on training.
For human resource professionals, each course provides 3.5 professional development credits for SHRM-CP or SHRM-SCP.
Excel 2016 Level 1: Practical Excel
- Getting started: Exploring the Excel 2016 environment
- Navigating, managing worksheets, and views
- Worksheet layout, entering and modifying Data
- Creating formulas and using basic functions
- Formatting cells, themes and cell styles
- Printing worksheets
Excel 2016 Level 2: Working with Data
- Understanding types of 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
Date and Time
Thursday Jan 30, 2020
8:00 AM - 4:00 PM CST
- Excel 1: 8-11:30 a.m.
- Excel 2: 12:30-4 p.m.
- Excel 1 and 2: 8 a.m.-4 p.m.
Location
St. Cloud State University Welcome Center
Fees/Admission
Cost: Early-bird registration fee applies 2 weeks prior. Registration closes 1 week prior
Contact Information
Tammy Anhalt-Warner
320-208-6100
Send Email
