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

20 Course Hours   |   24/7 Online Access   |   Certificate Course   |   Assigned Instructor   |   Prerequisites: None   |   Course Fee: $225 CAD + Tax

Course Description

This hands-on course will teach you the simplicity of using Microsoft® Excel, a powerful application for organizing and analyzing data. You will begin with the basics and master the skills to create workbooks, sort and customize data, and work with formulas.

This course is set apart from other Excel Courses, 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 provide detailed demonstrations and tips and tricks to use Excel effectively. You are also assigned an instructor to help during the course and to answer questions.

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

Topics Covered

Excel Course 1 Topics:

  • Excel Fundamentals and Terminology
  • Navigating and Understanding the Structure of Excel
  • Creating, Saving and Closing Workbooks and Worksheets
  • Customizing Excel Options
  • Entering and Editing Text, Numbers and Formulas
  • Using Undo/Redo, Find and Replace, and Go To Commands
  • Working with Ranges
  • Using Copy, Cut, Paste Commands
  • Manipulating Rows and Columns
  • Using the AutoFill and Flash Fill Commands
  • Formatting Text and Cells
  • Using the Format Cells Dialog Box
  • Hiding/Unhiding and Freezing/Unfreezing Rows and Columns
  • Adjusting Margins, Orientation and Paper Size
  • Defining Print Areas and Printing a Worksheet
  • Inserting and Editing Headers and Footer
  • Understanding Relative, Absolute and Mixed References
  • Using the AutoSum Command
  • Using the Insert Function Command for Basic Commands
  • Modifying Worksheets and Workbooks
  • Copying, Renaming, Grouping and Repositioning Worksheets
  • Adding and Deleting Worksheets
  • Changing Worksheet Tab Colours
  • Using 3D Referencing in Formulas
  • Excel Fundamentals and Terminology
  • Navigating and Understanding the Structure of Excel
  • Creating, Saving and Closing Workbooks and Worksheets
  • Customizing Excel Options
  • Entering and Editing Text, Numbers and Formulas
  • Using Undo/Redo, Find and Replace, and Go To Commands
  • Working with Ranges
  • Using Copy, Cut, Paste Commands
  • Manipulating Rows and Columns
  • Using the AutoFill and Flash Fill Commands
  • Formatting Text and Cells
  • Using the Format Cells Dialog Box
  • Hiding/Unhiding and Freezing/Unfreezing Rows and Columns
  • Adjusting Margins, Orientation and Paper Size
  • Defining Print Areas and Printing a Worksheet
  • Inserting and Editing Headers and Footer
  • Understanding Relative, Absolute and Mixed References
  • Using the AutoSum Command
  • Using the Insert Function Command for Basic Commands
  • Modifying Worksheets and Workbooks
  • Copying, Renaming, Grouping and Repositioning Worksheets
  • Adding and Deleting Worksheets
  • Changing Worksheet Tab Colours
  • Using 3D Referencing in Formulas

The Course Includes:

  • Getting Started Guide, Course Outline and Syllabus
  • Assigned instructor for support and questions
  • Excel Course 1 Manual (online to print)
  • Excel Course 1 video tutorials
  • Excel Course1 hands-on exercises and quizzes
  • Course Access for three (3) consecutive months, 24/7, anytime from anywhere
  • Final Exercise
  • Certificate upon completion

Note: Students must provide and have the Microsoft® Excel Program. Simply Training does not provide the Excel Program; system and equipment requirements are listed below.

Course Requirements & FAQ

What are the prerequisites?
This Excel Course 1 is a beginner’s course; no prerequisites are required. However, students must have basic computer knowledge of the Microsoft® Windows Operating System.

Who should take this course?
The Excel Course 1 is open to anyone who wants to learn and use the Microsoft® Excel Program proficiently.

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

How does the course work?
Once registered, you receive a welcome email with your account login to access the course page to get started. The course lessons are laid out in an easy step-by-step format, with a Getting Started Guide and a Course Outline and Syllabus. The lessons have the materials of a manual, 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 Course 1 is estimated at 20 course hours; the estimated time includes reading course materials, viewing videos, completing exercises and quizzes and completing the final exercise.

The course access is for three (3) months, and your login automatically expires on the assigned expiry date. You will complete the 20 course hours within three (3) months. Course completion is at the discretion of the registered student.

How Do the Video Tutorials Work?
The video tutorials are streamed and accessed from the course page. Videos are easy to view, can be watched multiple times, and assist in learning at your own pace.

Which Excel Program is used for this course?
Students must provide and have one of the following Full Licensed Microsoft® Excel Programs: Excel 2013, 2016, 2019 or Microsoft® Office 365.

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?
Windows computer with an internet connection, video player and the Microsoft® Excel licensed program as previously stated.

How do I contact the instructor for questions and support?
You are assigned an instructor to help and support you during the course. Communication with your instructor is via email or phone.

Do I Receive a Certificate?
A certificate is issued upon successfully completing course exercises, quizzes and the final exercise.

Do you provide verifiable hours for CPD (Continuing Professional Development) credits?
Yes, we 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. Complete the terms and conditions
  3. Step 1: Complete the student’s information
  4. Step 2: Complete the billing information and the total fees with the sales tax display.
  5. Step 3: Select Payment; we accept Debit and all major Canadian credit cards.
  6. Step 4: Submit Registration. You will receive an email registration confirmation and the payment receipt.

Other Registration and Payment Options:

Payment by Phone:
We accept payment over the phone. Select this link to register for the Excel Course 1. Complete the registration and billing information and submit. Then call our office at (855) 422-5861 to provide your Visa or MC information. We also accept e-transfers.

Registration and payment information is secure; we do not share or sell information to anyone.

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

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

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.

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

The Excel Course 1 is open to anyone who wants to learn and use the Excel Program proficiently.