We offer two 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. Participants are expected to supply their own laptop, mouse and webcam for this course.
For human resource professionals, each course provides 3.5 professional development credits for SHRM-CP or SHRM-SCP.
Excel Level 1: Practical Excel
- Getting started: Exploring the Excel 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 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
Feedback from attendees
- Bob was a great trainer with a wealth of knowledge. His experience and ability to relate the topics to real life was great. He kept our audience's attention in what could have been a fairly flat topic.
- It was helpful to learn how unintimidating Excel can be.
- Great investment of time and money. Nice job!
- I loved the multiple shortcuts used to save time
- The workbook will help cement all we have learned.
- The class was excellent!
- The pivot tables portion was all new to me and will benefit my day to day Excel use.
- Vlookup and pivot tables were very helpful
- The class was very helpful and exactly what I expected. Thank you!
- The examples were great. I really enjoyed the entire presentation.
- Loved the shortcuts and new features!