Excel (Level 1)

by The Great Canadian Training & Consulting Company

Designed for new Excel users who want to become more comfortable using Excel's most commonly used features. Your Results: Understand the key concepts that make Excel tick and feel confident using it at work.

$295

Contact the Institutes

Fill this form

Advertisement

The Great Canadian Training & Consulting Company Logo

img Duration

1 Day (6 Hours)

Course Details

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

 

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

  • Downtown Branch

    130 Albert Street, Suite 902, Downtown, Ottawa

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy