Course Overview

The Microsoft Excel – Beginner to Pro course covers basic to advance functions of Microsoft Excel, including creating/managing worksheets and workbooks, customizing ribbons, copying and pasting, formulas and functions, formatting labels and values, conditional formatting, charting. Data analysis is covered in detail, including sorting, data forms, subtotal command, filtering and pivot tables, macros etc. This course also includes advanced tools and new features of Microsoft Excel 2013.

 

We welcome auditing student.*

* Provided there is space available on the first class, undecided students may join the first half of class to observe. Please contact us to schedule in advance.

Beginner

  • Creating a Microsoft Excel Workbook
  • The Ribbon
  • The Backstage View (The File Menu)
  • The Quick Access Toolbar
  • Entering Data in Microsoft Excel Worksheets
  • Formatting Microsoft Excel Worksheets
  • Using Formulas in Microsoft Excel
  • Working with Rows and Columns
  • Editing Worksheets
  • Finalizing Microsoft Excel Worksheets
  • Microsoft Excel 2013 New Features

Intermediate

  • Advanced Formulas
  • Working with Lists
  • Visualizing Your Data
  • Working with Tables
  • Presenting & Reporting

Advanced

  • Using Pivot Tables
  • Auditing Worksheets
  • Data Analysis
  • Tracking & Privacy
  • Recording and Using Macros
  • Advanced Tools
  • Microsoft Excel 2013 New Features

Pro (Power User)

  • Using Pivot Tables
  • Auditing Worksheets
  • Data Analysis
  • Tracking & Privacy
  • Recording and Using Macros
  • Advanced Tools
  • Microsoft Excel 2013 New Features

About the Course

Classes are held in a Computer Lab

Completion

  • Certificate of Completion
  • Tax Receipt Form for tuition fees for courses taken in the calendar year. To qualify, the fees must be more than $100 for the year.

Prerequisite

Basic knowledge of Windows

About the Instructor

Taha Hafiz is a dynamic performance-driven professional with extensive experience in Finance, Project & Program Management, Change Management, Business Intelligence, ERP Implementation and Business Process Improvement. He possess extensive experience in leading Finance and Operations Modernization projects involving Business Process Re-engineering.

Personal Qualities:
Possess proven interpersonal skills with the responsibility of directing, implementing, and monitoring critical business & technology functions and strategic initiatives.

Specialties:
– ERP Implementation- Functional (HR & Finance modules): Oracle, SAP, PeopleSoft
– Software: SharePoint, MS Office with Expert Level in Excel (VBA), SQL, SSRS, SSMS, Discover, Hyperion, Crystal Reports, Cognos, and Monarch etc.
– Presentation software: Visio, PPT, iGrafx
– Business & Technology Frameworks: Balance Scorecard, RBA, NQI, COSO, COBIT, ITIL, RACI
– Key Skills: Lean/Six Sigma, Business & Technology SOX Compliance, Process Mapping, Systems Audit, Data Management (Mapping, Mining, Modeling, Warehousing, Integration, and Analysis), Business Intelligence, SDLC, BIA, TRA, BCP, DRP, System Rationalization and Application Development.

Next Session:

Feb 10, 2018 |Toronto

Saturdays | 9:00 A.M. – 2:00 P.M. (4 weeks, 20 Hours)

This is a new course starting to be offered in the beginning of 2018. We will post the reviews after the first cohort completes the classes.