Course Description
This advanced Excel course takes your skills to new levels, equipping you to organize and analyze data efficiently. Building on the foundational and intermediate knowledge from Excel Courses 1 and 2, you will master advanced techniques such as conditional formatting, importing and exporting data, using VLOOKUP and HLOOKUP functions, tracing formula precedents and dependents, and leveraging PivotTables, data tables, macros, and workbook collaboration.
You will deepen your understanding of Excel’s core functions, including tables, charts, graphics, financial and logical functions, date and time functions, and workbook management. What sets this course apart is its emphasis on practical, hands-on learning. Step-by-step exercises provide real-world experience, preparing you to use Excel confidently in a business environment. Video tutorials go beyond demonstrations, offering helpful tips and tricks, and you will have an instructor assigned to guide you and answer any questions throughout the course.
This course offers outstanding value. Join the hundreds of Canadians who have completed our Excel training and now use Excel with confidence.
Topics Covered
Excel Course 3 Topics:
- Importing External Data into Excel
- Importing Text Data into Excel
- Converting Text to Columns
- Removing Duplicate Rows of Data
- Importing Data from a Database
- Linking to Another File and Embedding Objects
- Exporting Data from Excel
- Publishing Worksheets & Workbooks to the Web
- Creating Web Queries
- Creating Custom Number Formats
- Using Conditional Formatting based on Top/Bottom Rules
- Applying Specialized Conditional Formatting
- Creating your own Formatting Rules
- Managing and Clearing Conditional Formatting
- Naming a Range and Using a Named Range
- Managing Named Ranges
- Understanding Lookup & Reference Functions
- Using the VLOOKUP Function
- Using the HLOOKUP Function
- Understanding Text Functions
- Using LEFT, RIGHT, and MID Functions
- Using the CONCATENATE Function
- Using UPPER, LOWER and PROPER Functions
- Formula Auditing
- Tracing Formula Precedent, Cell Dependents and Fixing Errors
- Error Checking Worksheets
- Creating a PivotTable
- Rearranging a PivotTable
- Setting PivotTable Options
- Formatting a PivotTable
- Filtering PivotTable Data using Slicers and using Inline
- Creating Custom Filters
- Filtering PivotTable Data using Timelines
- Creating PivotCharts
- Adding Subtotals to a List and Nesting Subtotals
- Applying Advanced Filters
- Adding Group and Outline Criteria to Ranges
- Using Data Validation
- Reviewing Data Using Quick Analysis
- Setting Formula Options
- Using Goal Seek and Solver
- Creating and Displaying Scenarios
- Using Data Tables
- Forecasting Future Values
- Creating a Macro, Running a Macro and Editing a Macro
- Saving and Opening a Workbook with Macros
- Adding a Macro to the Quick Access Toolbar
- Locking/Unlocking Cells in a Worksheet
- Protecting a Worksheet
- Showing/ Hiding Formulas
- Protecting and Encrypting a Workbook
- Marking a Workbook as Final
- Inspecting Workbooks
- Checking Document Compatibility and Accessibility
- Importing External Data into Excel
- Importing Text Data into Excel
- Converting Text to Columns
- Removing Duplicate Rows of Data
- Importing Data from a Database
- Linking to Another File and Embedding Objects
- Exporting Data from Excel
- Publishing Worksheets & Workbooks to the Web
- Creating Web Queries
- Creating Custom Number Formats
- Using Conditional Formatting based on Top/Bottom Rules
- Applying Specialized Conditional Formatting
- Creating your own Formatting Rules
- Managing and Clearing Conditional Formatting
- Naming a Range and Using a Named Range
- Managing Named Ranges
- Understanding Lookup & Reference Functions
- Using the VLOOKUP Function
- Using the HLOOKUP Function
- Understanding Text Functions
- Using LEFT, RIGHT, and MID Functions
- Using the CONCATENATE Function
- Using UPPER, LOWER and PROPER Functions
- Formula Auditing
- Tracing Formula Precedent, Cell Dependents and Fixing Errors
- Error Checking Worksheets
- Creating a PivotTable
- Rearranging a PivotTable
- Setting PivotTable Options
- Formatting a PivotTable
- Filtering PivotTable Data using Slicers and using Inline
- Creating Custom Filters
- Filtering PivotTable Data using Timelines
- Creating PivotCharts
- Adding Subtotals to a List and Nesting Subtotals
- Applying Advanced Filters
- Adding Group and Outline Criteria to Ranges
- Using Data Validation
- Reviewing Data Using Quick Analysis
- Setting Formula Options
- Using Goal Seek and Solver
- Creating and Displaying Scenarios
- Using Data Tables
- Forecasting Future Values
- Creating a Macro, Running a Macro and Editing a Macro
- Saving and Opening a Workbook with Macros
- Adding a Macro to the Quick Access Toolbar
- Locking/Unlocking Cells in a Worksheet
- Protecting a Worksheet
- Showing/ Hiding Formulas
- Protecting and Encrypting a Workbook
- Marking a Workbook as Final
- Inspecting Workbooks
- Checking Document Compatibility and Accessibility
Course Includes:
- Getting Started Guide, Course Outline and Syllabus
- Assigned instructor for support and questions
- Excel Course 3 Manual in PDF to save/print
- Excel Course 3 video tutorials
- Excel Course 3 hands-on exercises and quizzes
- Course Access for three (3) consecutive months, 24/7, anytime from anywhere
- Final Exercise
- Certificate upon completion
- Excel Course 3 Badge
Note: Simply Training does not supply the Excel Program for this course. Students must have access to the Microsoft Excel program listed in the computer requirements.
Requirements & FAQ
What are the prerequisites?
This Excel Course 3 is an advanced-level course, and students must have completed Excel Course 2 or an equivalent intermediate Excel Course.
Which Excel Program is required for this course?
Students must have access to one of the following full-licensed Microsoft Excel Programs: Excel 2016, 2019, 2021, 2024 or Microsoft 365. Simply Training does not provide the Excel Program for this course.
Note: You cannot use any Excel “Free” or “Starter” Program Versions, “Web App” or Mac Excel programs for this course.
What are the Computer Requirements?
- A Windows computer with an internet connection
- Microsoft® Excel licensed program: versions previously listed
- Video player to view videos
- PDF Reader to read/print materials
- A printer (optional) if you prefer to print course materials
What are the computer skills requirements?
Students must have basic knowledge of working with computers and the internet, and of using File Explorer to organize course materials. You also need to know how to send emails with attachments back and forth to the instructor.
How long does the course take?
Your login account provides access to the course for three (3) consecutive months, and your access expiry date will be included in your login email. The course takes approximately 20 hours to complete, including reading the lessons, completing and submitting exercises, and watching the videos. Please plan to schedule about 20 hours of study time within your three-month access period.
Course language:
All course materials are available in English only.
When can I get started?
You can start the course whenever it works for you, on your schedule — everything is available online. Everyone can join — no application or admission requirements, you can start learning today!
How does the course work?
After you submit your registration, we will begin processing it and set up your account login. You will then receive an email with your login details so you can access the course and get started. On the course page, the lessons are organized step-by-step and include a Getting Started Guide, the course syllabus and lesson materials.
How do I access the course?
The course is delivered online and offers 24/7 access from any location through a computer with an internet connection.
How does the Video Work?
The instructional videos are streamed and accessed from the course page. They are easily viewable on any device using a video player. Videos can be viewed multiple times at your own pace.
How do I contact the instructor with questions and support?
An instructor will be assigned to guide you and provide ongoing support throughout the course. After registration, you will receive an email from your instructor to establish contact. All submitted exercises will be reviewed and returned with feedback. If you need assistance, your instructor can be reached by email or phone.
Do I Receive a Certificate?
Students receive a certificate after completing the course requirements, including course exercises, quizzes, and the final exercise.
How Do I Register and Make Payment?
Registration for courses is online, and all fees are in Canadian Dollars (CAD).
Below are the steps for registration:
- Select the course and the “Register” button on the page.
- Read and complete the terms and conditions.
- Step 1: Complete the Student information.
- Step 2: Complete the Billing information. It will display the course fee, sales tax, and the total payment.
- Step 3: Select Payment; we accept all major Canadian debit and credit cards.
- Step 4: Submit the registration. The student receives confirmation of registration via email. The Biller receives the payment receipt and confirmation of the student’s registration.
Note: Registration and payment information is secure; we do not share or sell any information to anyone.
If you have additional questions, please give us a call, TF: (888) 385-7007, or fill out the Contact Us form