Great Canadian Training Company color logo

Microsoft Excel Level 1 (Basic)
(2013, 2016, 2019, 2021, 365)

What You'll Learn in Microsoft Excel Level 1 (Basic)

Course Length:

6 hours (1 day)

Learning Objectives

In this course, you will create, edit, display and print Excel workbooks using new features and custom interface tools. You will:


  • Enter, edit, and format data to create workbooks
  • Enter data using time-saving tools like Flash Fill and Autocomplete
  • Use functions and formulas to calculate data
  • Understand Relative and Absolute Cell References
  • Format worksheets and cells
  • Manage larger workbooks
  • Print workbooks
  • Customize the interface by changing ribbon display options and customizing the Quick Access Toolbar

Target Student

This course is for those who are new to Microsoft Excel and want to gain confidence navigating the interface, using functions and formulas, and formatting their work in order to present it clearly.

Course Outline

Section 1: Creating, Opening and Saving Workbooks

What Is Excel?

Create a New Blank Workbook

Open Excel Files

Save Workbooks

Navigate a Workbook

Selection Types

Data Checkers

Help

 

Section 2: Exploring the User Interface

Backstage View

Ribbon Overview

Quick Access Toolbar

Status Bar

Shortcut Key Tips

Contextual Tabs

 

Section 3: Working with Data

Basic Data Types

Enter, Edit and Delete Data

Use Autocomplete and Autofill

Resize Columns and Rows

Insert and Delete Columns, Rows, Cells

Hide and Unhide Columns and Rows

Use Undo, Redo and Repeat

Spellcheck and AutoCorrect

Use Find, Replace and Go To

Cut, Copy, Paste and Paste Special

Use the Fill Handle

 

Section 4: Performing Calculations

Use Basic Formulas

Use Basic Functions

Understand Absolute and Relative Cell References

 

Section 5: Using Time Saving Tools

Flash Fill

AutoCalculate

 

Section 6: Formatting A Workbook

Work with Fonts and Font Attributes

Apply Borders and Shading

Use the Format Painter

Change Text Alignment

Wrap Text

Apply Manual Line Breaks

Rotate Text

Merge and Centre Text

Create and Modify Styles

Apply Number Formats

Clear Formatting

 

Section 7: Managing Large Workbooks

Rename Worksheets

Colour-code Worksheet Tab Colours

Copy, Move, Delete, and Group Worksheets

Work with Freeze Panes

 

Section 8: Printing and Viewing A Workbook

Work with Page Breaks

Work with Print Preview and Page Layout View

Change Margins and Page Orientation

Scale to Fit Worksheets

Insert Headers and Footers

Print Titles Across All Pages

Review Print Options

 

A seal with “Guaranteed to Run” written on it. In the middle is a person giving a thumbs up, standing behind a checkmark

Microsoft Excel Level 1 (Basic)

Upcoming Classes

All Public classes are held online
with a live instructor
Dates Price Qty
April 8, 2024
9:00 AM to 4:00 PM ET
$295.00 Online
May 3, 2024
9:00 AM to 4:00 PM ET
$295.00 Online
June 10-11, 2024
9:00 AM to 12:00 PM ET
$295.00 Online
* Applicable taxes will be applied on checkout

I want to talk to someone about private or customized training


Have questions about this course? See below or reach out to our training coordinators.

Group of 4 or more? Consider private training

The Great Canadian Training & Consulting Company Advantage

When you train with us, your training will not just check a box. We make sure it is GREAT!

  • Experienced Trainers
  • Guaranteed to run classes
  • Learning Guarantee
  • Anytime after-training support for 30 days
  • Bilingual training, manuals & post-training support available

This course comes with

PDF Reference Guide

Take the Reference Guide anywhere and save the environment with an electronic copy of your training Reference Guide for use on any of your computers or devices


Use Your Own Files

Whether it's one-on-one or group training you can give us files to include in your training session and help you apply what you learn even more!


Printed Reference Guide

Instead of the PDF that comes with your course, purchase a printed paper Reference Guide for use during your class and future reference


Can I customize my course?
OF COURSE!

Tailored Training

Your Reference Guide will follow a standard course outline but your class can be tailored to focus on the subjects that are most important to you

Use Your Own Files

You can include your own files in your training session to make it more applicable to your day-to-day role.