Mississauga College of Technology

Tel: 905.232.8628 Fax: 905.232.1672

Address: 240-33 City Centre Dr. Mississauga, ON. L5B 2N5

E-mail: info@mississaugacollege.com

Microsoft Excel: [Exam 77-602]   <MSEX415>

Scope

Covering complete Microsoft Office Excel academic course, and to meet the requirements to be certified.

Objective

The instructor lead and hands-on experience will lead students to build most complicated worksheet, reports independently and confidently.

Topics

  • - Fundamentals and orientation of Excel and its existing workbook
  • - Creating, Editing, modifying, and saving workbook
  • - Formatting and Ranging Cells, establishing Hyperlink
  • - Worksheet Formatting, using Headers and Footers, Preparing and Printing Documents
  • - Managing and Administrating Worksheet
  • - Working with Data such as sorting, filtering, subtotaling etc…
  • - Applying Basic Formulas and Functions such as SUM, AVERAGE, COUNT, MIN, MAX, COUNTA etc…
  • - Using more advanced formulas such as SUMIF, COUNTIFS, AVERAGEIF etc…
  • - Creating, manipulating and Managing Charts using Data
  • - Inserting pictures, shapes in the Worksheet
  • - Distributing and tracking changes in workbook by email
  • - Protecting and Sharing Documents

Achievements

With instructor lead and hands-on experience the student shall be able to work on the most powerful spread sheet, meeting all the requirements to build technical documents such as accounting, finance and database. Also to be prepared for Microsoft Excel Certification.

Pre-requisites

Windows, Microsoft Word

Audience

Beginners who want to pursue career in Computer Field.

Duration:39 hours

Fee:$880.00

Copyright © 2012 Mississauga College of Technolog All Rights Reserved
Call Today: 905-232-8628
blogger
linkedin
twitter
facebook
EmailEmail: info@mississaugacollege.com
AddressAddress: 240-33 City Centre Dr. Mississauga, ON. L5B 2N5
Developed by Jimvisual