COMMUNITY EVENT: 2016 Excel Training

We offer two levels 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