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

NEXT COURSE START DATES

START DATE END DATE DAY TIMING CAMPUS STATUS REGISTER
May 25, 2019 June 15, 2019 SAT, SUN 10:00 AM - 3:00 PM Mississauga - Malton Campus Register Now
July 2, 2019 July 10, 2019 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Mississauga - Malton Campus Register Now
July 12, 2019 July 22, 2019 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Mississauga - Malton Campus Register Now
July 25, 2019 August 6, 2019 MON, TUE, WED, THU, FRI 9:30 AM - 2:00 PM Mississauga - Dundas St Campus Register Now
July 29, 2019 August 7, 2019 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Brampton Campus Register Now
August 9, 2019 August 19, 2019 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Brampton Campus Register Now
September 3, 2019 September 11, 2019 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Mississauga - Dundas St Campus Register Now
October 29, 2019 November 6, 2019 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Mississauga - Malton Campus Register Now
November 8, 2019 November 18, 2019 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Mississauga - Malton Campus Register Now
December 2, 2019 December 10, 2019 MON, TUE, WED, THU, FRI 9:00 AM - 2:00 PM Brampton Campus Register Now
December 12, 2019 December 20, 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 6, 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
View All Schedules
Contact us directly for other start dates
Seats Available
Limited Seats
Class Full

COURSE OUTLINE

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

AFFILIATED PARTNERS

Our Affiliated Partners