Microsoft Excel Beginner

CAD 350.00

Intensive, hands-on, one-day Excel Beginner course delivered online by a Live Trainer and not recorded Videos. Please read prerequisites and other details in the description below.

We have distinct course dates for Pacific and Eastern Time zones. You can explore both options below.

Microsoft Excel Beginner

O365/2021/2019/2016

Microsoft Excel is a spreadsheet application used all over the world in commercial and industrial applications where numbers are involved. This includes analysis, payroll, inventory, finance, accounting, charting, data listing and complex calculations of any kind.

Our Excel Beginner course is designed for office users or those planning to work in an office. It is a foundation course that prepares you to take an intermediate course. It is recommended for those who are self-taught as it fills the holes and gaps in their learning. Please refer to the detailed course outline below to learn what is covered in the course.

Prerequisites: At least six months of work experience in Windows environment. Good mouse skills.
Course Duration: One Day
Class Times-1: 9:00 AM to 5:00 PM Pacific Time (Vancouver)
Class Times-2: 9:00 AM to 5:00 PM Eastern Time (Toronto)
Course Pace and Style: Medium-to-Fast; Hands-on, Intensive, Interactive
Course Delivery Format: OnLine and In-Person
(In-Person option is available for group training only)
Course Outline Download: Excel_Beginner_Level
Cancellation & Date Change Policy: Cancellation Policy
Technical Requirements for Taking OnLine Courses: OnLine Tech Requirements

Course Outline
Lesson 1: Mastering the Excel Interface

  • Spreadsheet Basics
  • Running Microsoft Excel
  • The Excel Screen
  • Changing the Workbook View
  • Working with the Quick Access Toolbar
  • Working with Help

Lesson 2: Data Entry, Navigation & Data Selection

  • Using the Auto Fill
  • Entering Information
  • Working with Dates
  • Editing Data
  • Deleting Data
  • Navigating Within a Worksheet
  • Selecting Cells
  • Copying Cells
  • Dragging & Dropping
  • Working with the Office Clipboard
  • Aligning Cell Data
  • Formatting Numbers

Lesson 3: Working with Formulas & Functions

  • Entering a Formula
  • Using Cell Addresses
  • Correcting Formulas
  • Absolute Cell Addressing
  • Working with Function Arguments
  • The AutoSum Feature
  • Accessing other Functions

Lesson 4: Worksheet Formatting

  • Applying Formatting Attributes
  • Changing Fonts & Point Size
  • Cell Borders and Colors
  • Customizing Cell Formats
  • Using Cell Styles
  • Using the Format Painter
  • Hiding & Unhiding Columns
  • Inserting a Row/Column
  • Deleting a Row/Column
  • Adjusting Column Width & Row Height
  • Spell Checking the Worksheet
  • Freezing Column & Rows
  • Splitting the Screen

Lesson 5: Managing a Workbook

  • Working with Multiple Sheets
  • Naming Worksheets
  • Deleting a Worksheet
  • Grouping Sheets
  • Switching Between Workbooks

Lesson 6: Printing Excel Worksheets

  • Printing
  • Changing the Page Setup
  • Changing the Print Area
  • Defining Print Titles
  • Customizing Headers/Footers

Appendices:  Handy Keyboard Shortcuts

  • Appendix A: Function Keys
  • Appendix B: Cursor Movement Keys
  • Appendix C: Shortcut Keys

Hands-on Exercises

 

Class Start Time

9:00 AM Pacific Time, 9:00 AM Eastern Time

Course Date

07-Oct-2024, 04-Nov-2024, 02-Dec-2024, 30-Dec-2024, 06-Jan-2025, 03-Feb-2025, 03-Mar-2025, 31-Mar-2025, 28-Apr-2025, 26-May-2025, 23-Jun-2025, 21-Jul-2025, 18-Aug-2025, S, 23-Sep-2024, 21-Oct-2024, 18-Nov-2024, 16-Dec-2024, 20-Jan-2025, 19-Feb-2025, 17-Mar-2025, 14-Apr-2025, 12-May-2025, 09-Jun-2025, 07-Jul-2025, 06-Aug-2025, 03-Sep-2025