We are faced with different types of business decisions each day that can change the data we work with along with our financial outcomes. Have you ever wondered what type of workplace skills you can learn to make wiser decisions? Learning Advanced Excel contains these tools to find the answers to your most difficult questions. This course will help you learn these required business functions along with the tools required to analyze data efficiently within the workplace. Save time for yourself by protecting your valuable data and know with assurance that the entered data is accurate without any errors.
Prerequisites
Missing prerequisites?
Learn more about VCC's academic upgrading or English as a Second Language (ESL) courses, or discover which university transfer options are right for you.
What you will learn
- Unit 1 Advanced Functions Used To Make Business Decisions
- Applying multiple criteria to functions
- Using And criteria
- Using Or criteria
- Using And and Or and Not criteria
- Advanced Logical functions
- Using If -Then control statements
- Implementing If functions with Aggregate functions - Unit 2 Functions Used to Make Financial Decisions
- Learning basic financial functions
- Applying functions to perform loan calculations
- Computing loan payments
- Computing interest rate
- Computing number of payment periods
- Computing present value of a loan
- Working with additional functions - Unit 3 Applying Different Scenarios Using Excel Data Tools
- Understanding Different What-If Analysis Tools
- Performing What-If Analysis to see how data changes outcomes in formulas
- Using Scenario Manager
- Using Data Tables
- Using Goal Seek
- Applying rules to manage cell data
- Implement validation rules to avoid invalid entries
- Entering validation rules
- Avoiding duplicate data entries - Unit 4 Powerful Tools Used to Complete Data Implementation and Analysis
- Exporting and Importing Data into Workbook
- Protecting a workbook
- Making improved business decisions using pivot tables
- Creating an Excel Dashboard to visually display relevant data
How to register
This course is offered as part of a VCC program only.
Course schedules
Select your program to see the available course schedules.
| CRN# | Duration | Delivery | Location | ||
|---|---|---|---|---|---|
| 22618 |
April 6, 2026 to May 1, 2026 |
Online | See full schedule |
Online courses listed without scheduled meeting times can be completed on your own schedule.
Contact us
If you have any question, please email at advising@vcc.ca.
† This information is intended as a guideline only. Program and course details are subject to change with the approval of VCC's Board of Governors.