Image
Overview
Excel Mastery Adv
Learning Advanced Excel contains these tools that can help you prepare your worksheets accurately, examine your data for authentication, and then find those 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. By completing the course, discover how to attractively visualize your data into meaningful information with confidence.
Please email STTCE@fanshawec.ca or call 519-633-2030 to ensure your email is accurate to obtain access to this course.
Please note this is not a Fanshawe Certificate or course. Ensure your contact information is up to date on Web Advisor. This course runs asynchronously online and is offered in partnership with LERN and UGotClass. Once completed you will obtain a LERN certificate.
Themes:
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
For each Unit, you will:
- Read the print readings (about 20 pages a week)
- Have the option of accessing the online readings
- Listen to the audio presentation for the Unit and view the slides
- Have the option of taking a self-quiz to see how much you have learned
- Engage in written online discussion with your instructor and other participants
For best learning, you should make one or more comments at 2-3 different times each week.
The content (readings, audio lectures, slides) and self quizzes are accessible for the entire course, so you can work ahead, or go back and review again, at your convenience.
Course Code:
COMP-9730
Area of Interest:
Computers, Design, and Media
Prerequisites:
Credential:
Course Offerings
Summer 2025
to
$280.00
Delivery:
Online
Location:
St. Thomas
Days & Times:
Section Number:
65ST
Refund Policy:
7 days after course start date
Contact the Registrar’s Office to register at 519-452-4444.
to
$280.00
Delivery:
Online
Location:
Days & Times:
Section Number:
65ST
Refund Policy:
7 days after course start date
Course Details
More details
Download the Part-time Studies Guide
What's included:
- How to assess if part-time learning is right for you
- Part-time learning options and the differences between each
- How to pay for your part-time education
- Part-time options within your area of interest
- How to sign up for part-time studies and where to get help