Microsoft Excel

Microsoft Office Word Excell Powerpoint Training Classes

Microsoft Excel is a course that presents skills training and assessment for some of the skill sets that form the Microsoft Office Excel Expert. This course provides competency in customizing the Excel interface, using templates, using custom chart types, using workbook collaboration features, using workbook integration and XML features, creating and editing macros, controlling macro assignments and functionality, and troubleshooting macros.

Guided, step-by-step labs provide opportunities to practice new skills. You can challenge yourself and review your skills after each lesson in the Lesson Summary and Lesson Review sections. Additional skill reinforcement is provided in Activities, Optional Labs, Lesson Quizzes and a Course Assessment.

PRE-REQUISITES: Computer Fundamentals and Internet


April 01, 2019 April 12, 2019 2 weeks Mon, Tue, Wed, Thu, Fri 5:00 PM - 9:00 PM Mississauga - Malton Campus* Register Now
May 02, 2019 May 10, 2019 2 Weeks Mon, Tue, Wed, Thu, Fri 9:00 AM - 2:00 PM Mississauga - Dundas St Campus* Register Now


Module I

  • Introduction to Excel
  • Creating Workbooks
  • Modifying Worksheets
  • Formatting Worksheets
  • Printing Worksheets
  • Working with Formulas
  • Working with Basic Functions
  • Enhancing Worksheets
  • Using Templates, Styles, Worksheet Backgrounds and AutoFormats
  • Finding and Replacing Data

Module II

  • Working with Multiple Worksheets
  • Adjusting the Screen Display
  • Working with Advanced Functions
  • Using Advanced Print Options
  • Filtering Data and Using Comments
  • Working with Names
  • Working with Charts
  • Protecting Data
  • Using Basic Integration and Web Features

Module III

  • Working with Databases
  • Sorting Database Data
  • Using Database Functions
  • Using Advanced Filters and
  • Automatic Subtotals
  • Creating PivotTables and
  • Pivot Charts
  • Formatting and Adjusting
  • PivotTable
  • Auditing Worksheets and
  • Performing What-If Analyses
  • Working with Scenarios

Module IV

  • Customizing the Excel Interface
  • Using Templates and Custom
  • Chart Types
  • Using Collaboration Features
  • Using Advanced Integration and
  • XML Features
  • Creating Macros
  • Editing Macros
  • Controlling Macro Assignments and Functionality
  • facebook icon
  • facebook icon
  • twitter icon
Duration 40 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


Our Affiliated Partners