Add to Wishlist

Microsoft Excel

Enroll course

CONTACT US

+1 (905) 625-6400

Description

Certificate in Microsoft Excel

Program Overview

After an introduction to spreadsheet terminology and Excel’s window components, students will learn how to will enter and edit text, values, formulae, pictures and they will save workbooks in various formats.

Students will learn use and manage multiple worksheets and workbooks efficiently, eventually extrapolating into 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. They will learn how to work with Pivot Tables and Pivot Charts, how to import and export data, and how to query external databases.

Who Should Attend?

  • Great for professionals and higher education.
  • Those who want to master Microsoft Excel. Expected level of proficiency in MS Word: Intermediate to Advanced. Includes introduction to keyboard shortcuts.

*This program does not require approval under the Ontario Career Colleges Act, 2005.

Facilities

Facilities

  • Training on Excel 2016
  • Instructor led hands-on training
  • Windows 10. i5/i7 processors available
  • PC ratio to student is 1:1
  • Small groups for personalized attention and better learning experience
  • Special Fee for group or business

Program Schedule

There are no upcoming events.

Highlights

  • Expected level of proficiency in MS Excel: Intermediate to Advanced
  • Instructor-led classes

Course Outline

Module 1: Overview on Microsoft Excel
  • Getting Started
  • Understanding rows and columns
  • Using “Excel Help”
  • Using Backstage

Module 2: Working with Microsoft Excel
  • Creating Workbooks
  • Entering and Editing data
  • Saving the Workbook
  • Understanding different file formats for Excel

Module 3: Formatting in Microsoft Excel
  • Insert and Delete cells
  • Using Format Painter
  • Working with Hyperlinks
  • Using Conditional Formatting

Module 4: Understanding Worksheet Components
  • Using Themes
  • Working in different “views”
  • Using Headers & Footers
  • Using Print Layout and Printing

Module 5: Managing Worksheets
  • Organizing & working with multiple worksheets
  • Using “Freeze” function
  • Find & Replace data

Module 6: Working with Data
  • Ensuring Data’s integrity
  • Sorting, Filtering Data
  • Setting up Data in tabular format

Module 7: Using Basic Formulae and Functions
  • Building Basic Formulae with Cell referencing
  • Using Cell ranges

Module 8: Adding Pictures and Shapes to a Worksheet
  • Inserting Autoshapes and Inserting Pictures
  • Formatting, Changing attributes of Graphics
  • Using Picture Tools for added enhancements

Module 9: Creating Charts and Pivot Tables
  • Understanding Creating different types of Charts
  • Formatting parts of a Chart manually
  • Creating Pivot Tables

Module 10: Using Advanced Formulae and Securing Workbooks
  • Conditionally summarize Data, Look up Data using Formulae
  • Using Conditional Logic Functions to Formulae
  • Using Formulae to Format text
  • Securing workbook before Sharing
  • Emailing Spreadsheets
  • Review functions including Tracking Changes and Using comments in Workbook