CMPP 0003 - Microsoft Excel Level III
Course Description
Microsoft Excel allows users to create and manage spreadsheets to manipulate data used in personal finance, budget preparation, financial and investment analysis, business modeling, sales forecasting and other calculating and analytical applications.
We are now offering both in-person and live online sections. Check section details for format.
Live Online Requirements:
To participate remotely, you must have:
- Microsoft Excel 2019, Excel 2021 or Excel for Microsoft 365 (Desktop version only)
- Reliable internet connection
- Microphone and speakers/headphones
- Webcam (required for attendance and engagement)
- Mouse (preferred over a touchpad for precision)
- Tip: A second monitor or extended screen setup is highly recommended for ease of learning.
Course Outline/Topics
Course Content Microsoft Excel Level III
Lesson 1: Working with Multiple Worksheets and Workbooks Simultaneously
Use 3-D References
Use Links and External References
Consolidate Data
Lesson 2: Sharing and Protecting Workbooks
Collaborate on a Workbook
Protect Worksheets and Workbooks
Lesson 3: Automating Workbook Functionality
Apply Data Validation
Work with Forms and Controls
Work with Macros
Lesson 4: Applying Conditional Logic
Use Lookup Functions
Combine Functions
Use Formulas and Functions to Apply Conditional Formatting
Lesson 5: Auditing Worksheets
Trace Cells
Search for Invalid Data and Formulas with Errors
Watch and Evaluate Formulas
Lesson 6: Using Automated Analysis Tools
Determine Potential Outcomes Using Data Tables
Determine Potential Outcomes Using Scenarios
Use the Goal Seek Feature
Activate and Use the Solver Tool
Analyze Data with Analysis ToolPak Tools
Lesson 7: Presenting Your Data Visually
Use Advanced Chart Features
Create Sparklines
Testimonials
"Love the instructor’s ability to tailor the educational process to meet the needs of the students in the class."
- Program Policy and Analyst, 2019
"The instructor was very detailed and understandable. I really appreciated that we were able to focus on personal needs as well as cover class materials. We were able to get all questions answered and still completed all the material."
- International Sales Analyst, 2019
Instructors
Applies Towards the Following Credentials
- Business Analysis Certificate : Elective