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



Course Length: 6 hours (1 day)
Excel is a powerful program, beautifully designed so that you can simplify your use and analysis of large amounts of data.

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

This Course Comes With

PDF Manual

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

After Training Support

Get 30 days of live 24/7 after training support via phone, email and online chat to help apply what you’ve learned


Also Available With This Course

Printed Manual

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

Quick Reference Cards

Receive durable, full-color reference cards with helpful hints and tips for use after your course is completed


Customize Your Course

Tailored Training

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

Custom Manual

Purchase the customization option and receive a custom manual with objectives you’ve selected from our different courses

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!

Level 1 (Basic)
Guaranteed to Run
Even with one participant,
our classes are guaranteed to run!
Register for Online Classes

To view additional ticket options, click the "Filter by Date" button and select more dates.


Date(s) Price Qty
October 7, 2021 9am to 4pm ET $275.00 (CAD)*  
November 8, 2021 9am to 4pm ET $275.00 (CAD)*  
December 13, 2021 9am to 4pm ET $275.00 (CAD)*  
January 20, 2022 9am to 4pm ET $275.00 (CAD)*  
February 15, 2022 9am to 4pm ET $275.00 (CAD)*  
March 15, 2022 9am to 4pm ET $275.00 (CAD)*  
April 21, 2022 9am to 4pm ET $275.00 (CAD)*  
May 12, 2022 9am to 4pm ET $275.00 (CAD)*  

* 13% HST will be applied on checkout


Online registration closes two business days before the start of the class.
Questions?
Do you have questions about this course? Would you like a class sooner or on a different date? Are you interested in scheduling a private group class? Please submit the simple form below and we will respond promptly.
Private Training for GroupsIf you are training 4+ people, a private training session may be more cost-effective. Click to contact us today and learn more.
Register for this class here
Learn more about each course here
Contact us for more information here