Project Description

Excel 2 Online Course Canada Sage 50 Accounting online training courses, accounting courses, bookkeeping courses

20 Course Hours   |   24/7 Online Access   |   Certificate Course   |   Assigned Instructor   |   Prerequisites: Excel 1   |   Course Fee: $220 + Tax

Register Now
Course Details
Excel Testimonials
Course Description
Topics Covered
What’s Included
Requirements & FAQ

Course Description

In this hands-on course, you will expand your knowledge of using Microsoft® Excel, a powerful application for organizing and analyzing data. You will take your basic knowledge and master the skills needed to create tables, charts, graphics, workgroup collaborations, use financial and logical functions, use date and time functions and manage workbooks.

This course is set apart from any other Excel Course, as you will gain experience with our hands-on exercises that provide step-by-step instructions and prepare you to work with Excel in a business. In addition, the video tutorials offer more than just a demonstration; they provide many useful and valuable tips and tricks to use Excel effectively. You are also assigned to an instructor to help during the course and answer questions.

This course provides exceptional value! Join the many Canadians who have completed our courses successfully and are working with the Excel Program confidently.

Topics Covered

Excel 2 Course Topics:

  • Excel Terminology
  • Creating, Entering and Formatting Tables
  • Inserting and Deleting Rows and Columns in a Table
  • Totalling and Sorting Data in a Table
  • Using Auto Filter and Creating Custom Filters
  • Converting a Table into a Range
  • Creating, Moving and Resizing Charts
  • Formatting Chart Layouts, Styles, Text, and Elements
  • Changing Chart Types
  • Customizing Axis
  • Creating Advanced Charts: Pie, Maps, Funnels
  • Moving Charts to Different Worksheets
  • Saving Chart Templates
  • Using and Customizing Sparklines
  • Inserting Pictures, Shapes, Icons and 3D Models into a Worksheet
  • Inserting WordArt and SmartArt
  • Taking a Screenshot in Excel
  • Inserting Simple and Complex Equations
  • Introduction to Logical and Financial Functions
  • Using IF, Nested IF and IFS Functions
  • Using AND and OR Functions
  • Using PMT, FV, and PV functions
  • Using the Auto Calculate feature
  • Introduction to Date and Time Functions
  • Adding and Subtracting Dates
  • Calculating Time Intervals
  • Emailing a Workbook
  • Converting Worksheets to Webpages
  • Inserting Hyperlinks and Comments
  • Creating, Editing and Using Workbook Templates
  • Showing and Hiding Workbook Elements
  • Creating a Workspace
  • Comparing Workbooks Side by Side
  • Saving Workbooks in Multiple File Formats
  • Using Data Consolidation
  • Excel Terminology
  • Creating, Entering and Formatting Tables
  • Inserting and Deleting Rows and Columns in a Table
  • Totalling and Sorting Data in a Table
  • Using Auto Filter and Creating Custom Filters
  • Converting a Table into a Range
  • Creating, Moving and Resizing Charts
  • Formatting Chart Layouts, Styles, Text, and Elements
  • Changing Chart Types
  • Customizing Axis
  • Creating Advanced Charts: Pie, Maps, Funnels
  • Moving Charts to Different Worksheets
  • Saving Chart Templates
  • Using and Customizing Sparklines
  • Inserting Pictures, Shapes, Icons and 3D Models into a Worksheet
  • Inserting WordArt and SmartArt
  • Taking a Screenshot in Excel
  • Inserting Simple and Complex Equations
  • Introduction to Logical and Financial Functions
  • Using IF, Nested IF and IFS Functions
  • Using AND and OR Functions
  • Using PMT, FV, and PV functions
  • Using the Auto Calculate feature
  • Introduction to Date and Time Functions
  • Adding and Subtracting Dates
  • Calculating Time Intervals
  • Emailing a Workbook
  • Converting Worksheets to Webpages
  • Inserting Hyperlinks and Comments
  • Creating, Editing and Using Workbook Templates
  • Showing and Hiding Workbook Elements
  • Creating a Workspace
  • Comparing Workbooks Side by Side
  • Saving Workbooks in Multiple File Formats
  • Using Data Consolidation

The Course Includes:

  • Getting Started Guide and Course Outline
  • Assigned instructor for support to answer questions
  • Excel 2 Course Manual (online to print)
  • Excel 2 Course video tutorials
  • Excel 2 Course exercises
  • Excel 2 Lesson quizzes
  • Two (2) months access to course materials, anytime from anywhere, 24/7
  • Final Exercise
  • Certificate upon completion

Note: Students are required to have the Excel Program installed on their computer. Simply Training does not provide the Excel Program.

Course Requirements & FAQ

What are the prerequisites?
Excel 2 is an intermediate course, and students must have completed the Excel 1 Course or an equivalent basic Excel Course. We offer an Excel Basic Equivalency Test for self-taught students and do not have an Excel Basic Course.

Who should take this course?
The Excel 2 Course is open to anyone who wants to take their Excel knowledge to an intermediate level.

When can I get started?
Our courses are on-demand, and you can start anytime, today or when your schedule permits.

How do courses work?
Once you have registered, you receive a welcome email with your account login to access the course student’s page to get started. The course lessons are laid out in an easy step-by-step format, with a Getting Started Guide, a Course Outline and Syllabus. Lessons have materials, videos, exercises and a short check your knowledge quiz.

Where can I access the course from?
This course is online and can be accessed 24/7 from anywhere using a computer with an internet connection.

How long does the course take?
The Excel 2 Course is estimated at 20-course hours; the estimated time includes reading course materials, viewing videos, completing exercises and quizzes and the final exercise. Course access is for two months, and your login automatically expires on the expiry date assigned. Course completion is at the discretion of the registered student.

How Do the Video Tutorials Work?
The video tutorials are streamed and are accessed only from the course student’s page. Videos are easy to view; you can watch them multiple times to assist in learning at your pace.

You must have the Full Licensed Excel Program; Excel 2013, Excel 2016, Excel 2019 and Office 365.

Note: You cannot use any Excel “Free” Programs, “Starter” Versions or “Web App” Excel Program for this course.

What are the Computer Requirements?
Windows computer with an internet connection, video player and an Excel licensed program. Mac Licensed Excel Programs are not compatible with the course content. We do not provide technical support for Mac users.

How do I contact the instructor for questions and support?
Your instructor is there to help you succeed in the course. You communicate with your instructor by email to submit exercises and quizzes, and your instructor replies with feedback. Your instructor is also available by phone and, when needed, online remote support.

Do I Receive a Certificate?
A certificate is issued to students who successfully complete the course exercises, quizzes and final exercise.

Do you provide verifiable hours for CPD (Continuing Professional Development) credits?
Yes, we can provide students with a letter upon request.

How Do I Register?
To register for a course, the online process is easy.

  1. Select the course and the “Register” button on the page
  2. Step 1: Complete student’s registration and billing information
  3. Step 2: Fees and Payment (accepted payment types: Visa, MasterCard, and e-Transfer). We also have the option to select payment by phone. We do not accept American Express or Debit Cards.
  4. Step 3: Registration confirmation, review the information and submit registration

Registration and payments are secure, and we do not share or sell your information. If you prefer to register over the phone, please call our office at (855) 422-5861.

Note: We reserve the right to make changes without notice.

Hear what our successful students have to say about the Excel 1 course…

The way I used the course was to listen to the video, read the material per lesson, then do the exercise and quiz. I found that this way if any concepts I did not quite fully understand after the video – reading the material helped to clarify. If I needed clarification, it was great to be able to reach to ask questions. The best part of being able to reach out to the instructor. I also like taking courses online as it eliminates my travel time to and from a location and I can fit it into my busy life and schedule. I found the material and videos were both well done. Thanks Alan for being my instructor.

Nancy of Calgary, AB, Completed the Excel 1 Course

I really enjoyed this course, it touched a little on everything without being overwhelming. I have previously taken an in depth spreadsheet class in college a couple years ago and this was an excellent way to refresh my memory. This course also highlighted things that’s mostly used in an every day job situation. I am looking forward to your next course and learning more.

Melinda of Port Alberni, BC, Completed the Excel 1 Course
See More Testimonials

The Excel 2 Course is open to anyone who has basic Excel skills and want to take their Excel knowledge to an intermediate level.