Microsoft Excel

Microsoft Office Word Excel PowerPoint Training Classes

After an introduction to spreadsheet terminology and Excel’s window components, students will learn how to use the Help system and navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, pictures and they will save workbooks in various formats.

Students will learn how to use multiple worksheets and workbooks efficiently, and they will start working with more advanced formatting options including styles, themes, backgrounds and watermarks. They will also learn how to create outlines and subtotals, how to create and apply cell names and how to work with lists and tables. Students will learn about data validation and database functions such as DSUM. They will learn how to work with PivotTables and Pivot Charts, how to import and export data, and how to query external databases.

PRE-REQUISITES: Computer Fundamentals and Microsoft Word, Excel, PowerPoint

NEXT COURSE START DATES

START DATE END DATE DAY TIMING CAMPUS STATUS REGISTER
November 25, 2019 December 20, 2019 MON, THU, FRI 6:00 PM - 9:00 PM Mississauga - Malton Campus Register Now
November 26, 2019 December 5, 2019 MON, TUE, WED, THU, FRI 5:00 PM - 9:00 PM Mississauga - Dundas St Campus Register Now
December 2, 2019 December 10, 2019 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Brampton Campus Register Now
January 20, 2020 January 28, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Mississauga - Dundas St Campus Register Now
January 30, 2020 February 7, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Mississauga - Malton Campus Register Now
February 27, 2020 March 9, 2020 MON, TUE, THU, FRI 9:00 AM - 2:00 PM Brampton Campus Register Now
February 27, 2020 March 6, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Brampton Campus Register Now
March 3, 2020 March 11, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Mississauga - Dundas St Campus Register Now
March 30, 2020 April 7, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Mississauga - Malton Campus Register Now
April 6, 2020 April 15, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Brampton Campus Register Now
May 27, 2020 June 4, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Mississauga - Malton Campus Register Now
June 30, 2020 July 9, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Brampton Campus Register Now
July 29, 2020 August 7, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Mississauga - Malton Campus Register Now
August 28, 2020 September 3, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 5:00 PM Mississauga - Dundas St Campus Register Now
August 31, 2020 September 9, 2020 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Brampton Campus Register Now
October 11, 2020 November 1, 2020 SAT, SUN 10:00 AM - 4:00 PM Mississauga - Dundas St Campus Register Now
November 1, 2020 November 21, 2020 SAT, SUN 10:00 AM - 4:00 PM Mississauga - Dundas St Campus Register Now
February 5, 2021 February 16, 2021 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Brampton Campus Register Now
February 23, 2021 March 3, 2021 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Mississauga - Dundas St Campus Register Now
March 21, 2021 April 11, 2021 SAT, SUN 9:30 AM - 3:30 PM Scarborough Campus Register Now
March 27, 2021 April 17, 2021 SAT, SUN 10:00 AM - 4:00 PM Mississauga - Dundas St Campus Register Now
August 14, 2021 August 29, 2021 SAT, SUN 9:30 AM - 3:30 PM Scarborough Campus Register Now
View All Schedules
Contact us directly for other start dates
Seats Available
Limited Seats
Class Full

COURSE OUTLINE

Unit 1: Overview

  • Starting Excel
  • Working in Excel Window
  • Changing Excel’s View
  • Working with an Existing Workbook
  • Working with Excel’s Help System

Unit 2: Using Backstage

  • Accessing and Using Backstage View
  • Printing with Backstage
  • Changing the Excel environment in Backstage
  • Accessing and Using Excel Templates

Unit 3: Working with Microsoft Excel

  • Creating Workbooks
  • Entering and Editing Basic Data in a Worksheet
  • Using Data Types to Populate a Worksheet
  • Cutting, Copying, and Pasting Data
  • Editing a Workbook’s Keywords
  • Saving the Workbook

Unit 4: Formatting Cells and Ranges

  • Inserting and Deleting Cells
  • Manually Formatting Cell Contents
  • Copying Cell Formatting with the Format Painter
  • Formatting Cells with Styles
  • Working with Hyperlinked Data
  • Applying Conditional Formatting to Cells
  • Clearing a Cell’s Formatting

Unit 5: Formatting Worksheets

  • Working with Rows and Columns
  • Using Themes
  • Modifying a Worksheet’s Onscreen
  • Inserting Headers and Footers
  • Preparing a Document for Printing

Unit 6: Managing Worksheets

  • Organizing Worksheets
  • Working with Multiples Worksheets
  • Using Zoom and Freeze to Change the Onscreen View
  • Finding and Replacing Data

Unit 7: Working with Data

  • Ensuring your Data’s Integrity
  • Sorting Data
  • Filtering Data
  • Subtotaling Data
  • Setting up Data in a Table Format

Unit 8: Using Basic Formulas and Functions

  • Building Basic Formulas
  • Using Cell References in Formulas
  • Using Cell ranges in Formulas
  • Summarizing Data Functions
  • Using Formulas to Create Subtotals
  • Controlling the Appearance of Formulas

Unit 9: Using Advanced Formulas and Securing Workbooks

  • Using Formulas to Conditionally Summarize Data
  • Using Formulas to Look Up Data in a Workbook
  • Adding Conditional Logic Functions to Formulas
  • Using Formulas to Format Text
  • Software Orientation
  • Securing Your Work Before Sharing it with Others
  • Distributing a Workbook by Email
  • Tracking Changes to a Workbook
  • Adding Comments to a Workbook

Unit 10: Creating Charts and PivotTables

  • Building Charts
  • Formatting a Chart with Quick Style
  • Formatting the Parts of a Chart Manually
  • Modifying a Chart
  • Creating PivotTables
  • Macros and Custom Function
  • Running and Recording a Macro
  • Working with Visual Basic Code

Unit 11: Adding Picture and Shapes to a Worksheet

  • Inserting Pictures
  • Adding Shapes
  • Copying or Moving a Graphic
  • Formatting Graphics
  • Adding Graphic Enhancements Using Picture Tools
  • facebook icon
  • facebook icon
  • twitter icon
Duration 35 Hours
Course Fees Contact Us
Faculty IT
Course Level Beginner
Features In Class, Lab, Hands-on Training
Language English

Quick Application Form









Call Now
CIMT College - Mississauga, Brampton, Toronto, Scarborough - Celebrating 20 Years

Careers Start At Cimt College - Mississauga, Brampton, Toronto

AFFILIATED PARTNERS

Our Affiliated Partners