A combination of online courses that are supplemented with live help from instructors to enhance participant learning while reducing total classroom time and costs.
- 5 Pre-recorded lessons with Quick Challenge Questions to test understaning
- Graded workshop assignments
- Virtual help from live instructors
Course Time
12 Hours Total
- 2 Hours to View Lessons – 30-40 minutes per lession
- 10 Hours of Hands on Workshop Practice – 2 hours per assignment
Suggested delivery schedule is 5 weeks. 1 lesson per week.
Pre-Requisites
Basic familiarity with EXCEL such as setting up spreadsheets and using functions like Sum()
Course Overview
The advanced Excel Workstation Skills course provides a comprehensive overview of the functionality that makes Excel such a powerful tool in the workplace. The course provides practical information for using Excel to solve real world problems and to increase productivity.
The course is broken into five concise lessons that can be accessed at anytime from anywhere which are supplemented with hands on workshop assignments and help and grading from live instructors.
Key Topics
Lesson 1: Formulas & Functions – Working with powerful, but often missed, formulas and functions that can be used for analysis and calculations when adding up the rows just isn’t enough. Functionality covered:
- SumIf
- CountIf
- DSum
- Date Functions
- Absolute versus Relative Referencing
Lesson 2: Making Data Easier to Manage – Reducing spreadsheet errors by minimizing data entry and using Excel Functionality to check for errors. Functionality covered:
- Named Ranges
- Vlookup
- Hlookup
- Match and Index
- Data Validation
- Spreadsheet Protection
Lesson 3: Creating Basic Reports – Formatting and organizing data. Functionality covered:
- Left/Right
- Trim
- Subtotaling
- Concatenate
- Filtering
- Sorting
Lesson 4: Making Sense of Data – Using tools within Excel to better understand the story behind the raw data and best practices for what types of data are best displayed with which tools. Functionality covered:
- Tables
- Pivot Tables
- Charts and Graphs
- Conditional Formatting
Lesson 5: Working with Macros – Using Macros to automate common tasks (improve quality, improve efficiency). This lesson provides an introduction to recording and modifying macros. We touch on basic Visual Basic constructs such as: If…then…else, looping, checking conditions, declaring and assigning values to variables, and selecting sheets, cells and ranges.
Share with others