Microsoft Excel: Introduction

Microsoft Excel Training Series | Level 1

Course Details

Duration: 1 day (9 am – 4 pm)

Microsoft® Excel® Versions: 2013 | 2016 | 2019 | 2021 | 365 (Windows)

Delivery Methods (Instructor-led): In-person (Live classroom) | Virtual classroom

Course Dates: October 6, 2022 (Virtual classroom or In-person) | November 7, 2022 (Virtual classroom or In-person) | View schedule Course schedule

Course Fee: $245 CAD per person + HST (Virtual classroom), $275 CAD per person + HST (Bring your own device for in-person courses) or $345 CAD per person + HST (Avantix Learning provides device for in-person courses)*

Timing: Public scheduled courses run from 9:00 am to 4:00 pm (Eastern Time).

Virtual classroom courses: Our instructor-led virtual classroom courses are delivered in a virtual classroom environment. Students will be sent a virtual classroom invitation prior to the course.

In-person classroom courses: Our instructor-led, live classroom (in-person) courses are held in downtown Toronto at 18 King Street East, Suite 1400, Toronto, Ontario, Canada. Some courses are also held at an alternate downtown Toronto location.

Custom training: This course may be delivered at your site or ours as an instructor-led or virtual classroom solution. Contact us at info@avantixlearning.ca for more information including savings for custom group training.

Register for this training course.

Course Overview

During this hands-on course, novice users will learn core skills to work effectively with Microsoft Excel worksheets. Students will learn to enter and edit different types of data and to enter formulas using operators and functions. Various strategies will be used to format and edit worksheets and workbooks. Different print settings will be applied and then previewed. At the end of the day, students will also learn to create simple charts quickly and easily. Throughout this course, the instructor will include numerous tips, tricks and shortcuts. Each student will also receive a full course manual.

Prerequisite: Basic keyboarding and computer skills

Next course in this series: Microsoft Excel: Intermediate / Advanced

Related training: View all Microsoft Excel courses >

INCLUDED IN THIS COURSE

  • Comprehensive course manual
  • Keyboard shortcuts quick reference
  • Sample and exercise files
  • Refreshments (for classes conducted in Avantix Learning classrooms)
  • Certificate of completion
  • Follow-up email support

Course Topics

Working in the Microsoft Excel Environment

  • Overview of the Ribbon and the Quick Access Toolbar
  • Navigating quickly in a worksheet
  • Selecting cells and cell ranges using different strategies and shortcuts
  • Entering different types of data
  • Resizing columns and rows quickly and easily

Managing Workbooks and Worksheets

  • Creating a new Excel workbook
  • Saving a workbook
  • Naming worksheets
  • Moving or copying worksheets
  • Inserting and deleting rows and columns
  • Inserting and deleting worksheets in a workbook
  • Using various strategies and shortcuts to cut, copy and paste data

Formatting Cells, Rows and Columns

  • Applying number formatting
  • Changing font and size
  • Changing alignment
  • Applying borders and shading

Creating Basic Formulas

  • Creating simple formulas using basic operators
  • Changing data and viewing updated results
  • Showing and hiding formulas
  • Entering formulas using the common Excel functions SUM, AVERAGE, MIN, MAX and COUNT

Understanding Errors and Error Checking

  • Types of errors
  • Choosing error checking options
  • Ignoring errors

Previewing and Printing

  • Setting a print area
  • Changing margins
  • Adding headers and/or footers
  • Previewing your final result

Getting Started with Filtering

  • Working with lists or data sets
  • Understanding field names and records
  • Turning Filtering (AutoFiltering) on
  • Filtering text, number and date fields
  • Removing filtering

Creating a Simple Chart

  • Creating a basic bar or column chart from data
  • Formatting the chart
  • Changing the underlying data and view the updated results in the chart

Register Now for a public course at our downtown Toronto location at 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada.

Do you have any other questions? Contact us!

If you are looking for more information regarding versions, check out our Microsoft Excel versions overview.

Want to know more about our Excel courses? Check out our Frequently Asked Questions.

To request this page in an alternate format, contact our staff.

*Prices subject to change.

Our instructor-led courses are delivered in virtual classroom format or at our downtown Toronto location at 18 King Street East, Suite 1400, Toronto, Ontario, Canada (some in-person classroom courses may also be delivered at an alternate downtown Toronto location). Contact us at info@avantixlearning.ca if you'd like to arrange custom instructor-led virtual classroom or onsite training on a date that's convenient for you.

Copyright 2022 Avantix® Learning

Microsoft Excel training man pointing to icons.

Custom training

Register now for a public scheduled course or contact us at info@avantixlearning.ca  for more information about any of our courses or to discuss custom training options (virtual classroom or live classroom).

Related courses

Microsoft Excel: Intermediate / Advanced

Microsoft Excel: Data Analysis with Functions, Dashboards and What-If Analysis Tools

Microsoft PowerPoint: Introduction

Microsoft Access: Introduction

Microsoft Project: Introduction

VIEW MORE COURSES >

 

You may like

How to Password Protect Your Excel Worksheets and Workbooks

How to Password Protect Your Excel Worksheets and Workbooks

Protect Worksheets and Workbooks in Excel by Avantix Learning Team | Updated June 10, 2022 Applies to: Microsoft® Excel® 2013, 2016, 2019, 2021 or 365 (Windows) You can password protect worksheets and workbooks in Excel. If you want to prevent other users from opening...

How to Freeze Row and Column Headings in Excel Worksheets

How to Freeze Row and Column Headings in Excel Worksheets

Easily Freeze Row and Column Titles in Excel by Avantix Learning Team | Updated February 21, 2022 Applies to: Microsoft® Excel® 2010, 2013, 2016, 2019, 2021 and 365 (Windows) As many Excel worksheets can become quite large, it can be useful to freeze row and column...

How to Convert Text to Numbers in Excel (5 Ways)

How to Convert Text to Numbers in Excel (5 Ways)

5 Ways to Convert Numbers Stored as Text to Numbers in Microsoft Excel Worksheets by Avantix Learning Team | Updated February 12, 2022 Applies to: Microsoft® Excel® 2010, 2013, 2016, 2019, 2021 and 365 (Windows) There are several ways to convert text to numbers in...

How to Insert Multiple Rows in Excel (4 Fast Ways with Shortcuts)

How to Insert Multiple Rows in Excel (4 Fast Ways with Shortcuts)

Insert Multiple Rows Quickly in an Excel Worksheet by Avantix Learning Team | Updated January 31, 2022 Applies to: Microsoft® Excel® 2013, 2016, 2019, 2021 and 365 (Windows) You can quickly insert multiple rows in Excel using the context menu, keyboard shortcuts or...

You may also like

4 Ways to Delete a Table in Word

4 Ways to Delete a Table in Word

Delete a Table in Microsoft Word by Avantix Learning Team | Updated September 25, 2022 Applies to: Microsoft® Word® 2013, 2016, 2019, 2021 and 365 (Windows) You can delete a table in a Word document in 4 simple ways - using the Ribbon, using the context menu, using...

How to Make Columns in Word

How to Make Columns in Word

Create and Format Newspaper-style Columns in Word Documents by Avantix Learning Team | Updated September 6, 2022 Applies to: Microsoft® Word® 2013, 2016, 2019, 2021 and 365 (Windows) You can make columns in Word documents in a few different ways. There are two types...

4 Ways to Create a Table in Word

4 Ways to Create a Table in Word

Insert and Edit a Table with Multiple Columns and Rows in Word by Avantix Learning Team | Updated August 23, 2022 Applies to: Microsoft® Word® 2013, 2016, 2019, 2021 and 365 (Windows) You can create a table in a Word document in 4 easy ways using the Ribbon. A table...

Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.

Avantix Learning |18 King Street East, Suite 1400, Toronto, Ontario, Canada M5C 1C4 | Contact us at info@avantixlearning.ca

Upcoming Training
Course
Microsoft Excel: Introduction (in-person in Toronto or online in virtual classroom format)
Location
Avantix Learning, 18 King Street East, Suite 1400,Toronto, Ontario, Canada,
Next course starts
October 6, 2022
Next course ends
October 6, 2022
Description
Microsoft Excel Introduction training course online in virtual classroom format or in-person in Toronto, Ontario, Canada. This instructor-led Excel course is designed for 365, 2021, 2019, 2016, and 2013. In-person classes are delivered in downtown Toronto or arrange custom virtual or onsite training at your location. Virtual classroom courses are available to our clients in Toronto, Mississauga, London, Calgary, Edmonton, Ottawa, Vancouver, Winnipeg, Halifax and other cities in Canada and the United States.

Pin It on Pinterest