Microsoft Excel

Microsoft Office Word Excell Powerpoint Training Classes

MS 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 DURATION DAY TIMING CAMPUS REGISTER
July 04, 2017 August 01, 2017 4 Week(s) T W Th 6:00pm- 9:00pm Mississauga - Dundas St Campus Register Now
July 08, 2017 July 30, 2017 4 weeks Sa Su 10:00am - 3:00pm Mississauga - Malton Campus Register Now
July 18, 2017 August 08, 2017 3 Week T, F 9:30am- 2:30pm Scarborough Campus Register Now
July 18, 2017 August 08, 2017 3 Week T, F 9:30 A.M. - 2:30 P.M. Scarborough Campus Register Now
July 22, 2017 July 20, 2017 3 Week Sa & Su 9:30 A.M. - 2:30 P.M. Scarborough Campus Register Now
August 09, 2017 September 06, 2017 4 Week(s) Mon, Tue, Wed 6:00pm- 9:00pm Brampton Campus* Register Now

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

Careers Start At Cimt College - Mississauga, Brampton, Toronto

AFFILIATED PARTNERS

Our Affiliated Partners