Microsoft Excel: Introduction

Microsoft Excel Training Series | Level 1

Course Details

Duration: 1 day (9 am – 4 pm)

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

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

Course Dates: May 5, 2021 (Virtual classroom) | View schedule Course schedule

Course Fee: $245 CDN per person + HST (Virtual classroom), $275 CDN per person + HST (Bring your own device for live classroom courses) or $325 CDN per person + HST (Avantix Learning provides device for live classroom courses)*

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.

Public scheduled courses are delivered as live classroom training or virtual classroom training (as indicated). All courses are instructor-led.

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 virtual classroom format or in downtown Toronto and run from 9:00 am to 4:00 pm (Eastern Time).

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.

Our instructor-led courses are delivered in virtual classroom format or at our downtown Toronto location at 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada (some live 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 training on a date that's convenient for you.

Copyright 2021 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 Convert Cm to Inches in Excel (or Inches to Cm)

How to Convert Cm to Inches in Excel (or Inches to Cm)

Convert Inches to Centimeters or Vice Versa in Excel Worksheets by Avantix Learning Team | Updated November 27, 2020 Applies to: Microsoft® Excel® 2010, 2013, 2016, 2019 and 365 (Windows) You can convert cm to inches (inches to centimeters or centimetres) using...

How to Hide Comments or Notes in Excel Workbooks

How to Hide Comments or Notes in Excel Workbooks

Hide Notes and Comments in Microsoft Excel by Avantix Learning Team | Updated October 17, 2020 Applies to: Microsoft® Excel® 2010, 2013, 2016, 2019 and 365 (Windows) You can hide comments and notes in Excel workbooks. In addition to adding comments in Excel, there is...

How to Delete Blank Rows in Excel (5 Ways)

How to Delete Blank Rows in Excel (5 Ways)

Easy Ways to Remove Blank Rows in Microsoft Excel Worksheets by Avantix Learning Team | Updated April 5, 2021 Applies to: Microsoft® Excel® 2010, 2013, 2016, 2019 and 365 (Windows) You can delete blank rows in Microsoft Excel worksheets manually or you can use several...

You may also like

How to Insert a Nonbreaking Space in Word

How to Insert a Nonbreaking Space in Word

Insert a Nonbreaking Space in Word to Keep Words or Characters Together by Avantix Learning Team | Updated April 5, 2021 Applies to: Microsoft® Word® 2010, 2013, 2016, 2019 and 365 (Windows) If you want to keep words or characters together on the same line in a Word...

How to Use a Laser Pointer in PowerPoint (with Shortcuts)

How to Use a Laser Pointer in PowerPoint (with Shortcuts)

Display a Laser Pointer During a PowerPoint Slide Show by Avantix Learning Team | Updated January 29, 2021 Applies to: Microsoft® PowerPoint® 2010, 2013, 2016, 2019 and 365 (Windows) During a PowerPoint slide show, you can change your mouse into a laser pointer to...

How to Add Audio in PowerPoint Presentations

How to Add Audio in PowerPoint Presentations

Add Audio in PowerPoint from a File on Your PC or Shared Drive by Avantix Learning Team | Updated April 13, 2021 Applies to: Microsoft® PowerPoint® 2013, 2016, 2019 and 365 (Windows) You can add audio in PowerPoint from a file on your PC or from a shared drive. Audio...

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 (Online in virtual classroom or in Toronto)
Location
Avantix Learning, 1 Yonge Street, Suite 1801 (Toronto Star Building),Toronto, Ontario, Canada,
Next course starts
May 5, 2021
Next course ends
May 5, 2021

Pin It on Pinterest