Microsoft Excel: Introduction

Microsoft Excel Training Series | Level 1

Course Details

Duration: 1 day (9 am – 4 pm)

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

Delivery Methods: Instructor-led classroom (ILC) | Virtual classroom (VC)

Course Dates: July 7, 2020 (Virtual) | View schedule Course schedule

Virtual Classroom: Avantix Learning courses are available in a virtual classroom format. Contact us at info@avantixlearning.ca for more information.

Course Fee: $225 CDN per person + HST (virtual), $245 CDN per person + HST (bring your own device) or $295 CDN per person + HST (Avantix Learning provides device)*

Note: Public scheduled courses are delivered as live instructor-led classroom training or virtual classroom training (as indicated). Bring your own device rates apply to live classroom courses.

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

Location and timing: Public scheduled courses are held in downtown Toronto and run from 9:00 am to 4:00 pm (Eastern Standard Time).

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.

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

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.

Copyright 2020 Avantix® Learning Inc.

Instructor writing on virtual graph in Microsoft Excel training course in Toronto.

You may like

How to Delete a Pivot Table in Excel

How to Delete a Pivot Table in Excel

A pivot table can be deleted in an Excel workbook in several ways. You can delete a pivot table, convert a pivot table to values or clear data and customizations from a pivot table to reset it. When a pivot table is created from source data in a workbook,

How to Change Commas to Decimal Points and Vice Versa in Excel (5 Ways)

How to Change Commas to Decimal Points and Vice Versa in Excel (5 Ways)

Depending on your country or region, Excel may display decimal points or dots instead of commas for larger numbers. The decimal point (.) or comma (,) is used as the group separator in different regions in the world. You can change commas to decimal points or dots or vice versa in your Excel workbook temporarily or permanently.

How to Group by Month and Year in a Pivot Table in Excel

How to Group by Month and Year in a Pivot Table in Excel

You can group by month, year or other date period in a pivot table in Excel. One option is to group by date periods in a pivot table using the Grouping feature. Alternatively, you can also create calculations in source data to extract the month name and the year from a date field and use the fields in your pivot table.

You may also like

How to Create, Use and Edit Templates in Microsoft Word

How to Create, Use and Edit Templates in Microsoft Word

You can create, use and edit templates in Microsoft Word for frequently used documents such as letters, reports, proposals and manuals. Templates include basic character, paragraph and page formatting and may include text, custom styles, tables, images, macros, sections, headers and footers.

Change Line Style, Thickness or Color of Table or Cell Borders in PowerPoint

Change Line Style, Thickness or Color of Table or Cell Borders in PowerPoint

You can change the formatting of a table border or the borders of multiple table cells in PowerPoint by changing the line style, thickness (weight) or color. Different borders can be applied to cells in the same table. For example, you could apply a thick line to header cells and a thin line to the cells in the last row of 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 | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | info@avantixlearning.ca

Upcoming Training
Course
Microsoft Excel: Introduction (Toronto classroom course)
Location
Avantix Learning, 1 Yonge Street, Suite 1801 (Toronto Star Building),Toronto, Ontario, Canada,
Next course starts
July 7, 2020
Next course ends
July 7, 2020

Pin It on Pinterest