Excel Training

Data Entry, Tables, Formulas, Functions, Pivot Tables and Macros

The Basic Microsoft Excel training course is suitable for those who are looking to develop a fundamental understanding and skill set in Microsoft Excel 2016. It is a two-day crash course in the basics of Microsoft Excel.

The basic level course will cover how to create and format worksheets, create charts, summarize and manage data in tables, apply formulas and functions and create executive data reports. 

The advanced level course will cover how to use tables, create and manipulate pivot tables to analyze data sets, create pivot charts and other advanced charts, use INDEX(MATCH()), and create reporting dashboards.

Completion of this course prepares you to take the Excel 2016: Core Data Analysis, Manipulation, and Presentation (Exam 77-727) exam offered by Microsoft. This exam will count as a credit towards the Microsoft Office Specialist certification. Please let the instructor know if you're interested in pursuing this.

The primary objectives of this course are to help students understand how to use the basic functionality available in Microsoft Excel, to equip students the skills & knowledge needed to do basic data entry, manipulation, summarizing and reporting and to prepare students to be able to do basic Excel activities and tasks in the workplace.

The required materials to be successful in this class are a laptop with access to Microsoft Excel and a Notebook.

There are no grades being provided at the end of the course. Optional practice material will be provided at the end of the first session to recap the lessons.

This course is divided into Basic and Advanced skill set.

What You Get

2 day program (two Saturdays)

2 Weeks of training

2 days online access to teacher
16 hours (2 Weeks) in total

8 hours every Saturday lecture

( 9:30am - 5:30pm)

24x7 access to Lab

Installation of all required software

Have fun in a high energy class

Work Term placement + Job Referral and Hiring

Flexible Payment Plan
Group Discount

What You'll Learn

BASIC

CLASS 1:

Working with Tables

Data Entry & Management​

Creating Charts

Working with Tables​

CLASS 2:

Basic Formulas & Functions​

Basic Conditional Formatting​

Lookup Formulas​

Co-op bonus: 

  • Interview Questions & Answers

  • 1-3 Months Co-op

ADVANCED

CLASS 1:

Working with Tables​

Data Entry & Management

Pivot Tables​

CLASS 2:

Interactive Dashboard

Special Tips and Tricks

Co-op bonus: 

  • Interview Questions & Answers

  • 1-3 Months Co-op

We also offer Full stack Developer, DevOps, Big Data Science, Automation Testing, Scrum Master training. View our classes page to see a full list of our classes. Contact us for any question.

NEXT BATCH STARTS...

OCTOBER 19th, 2019

WINTER BATCH STARTS...

NOVEMBER 2nd, 2019

Career Roadmap

1 - 3 Yrs
3 - 5 Yrs
5+ Yrs
  • Entry-level Front End Developer

  • Contract: $50/hr 

  • Salary: $50K - $75K

  • Angular Developer (Intermediate)

  • Contract: $50-$70/hr

  • Full Stack Developer 

  • Salary: $80K - $99K

  • Senior Angular Developer

  • Senior Javascript Developer

  • Senior Full-Stack Developer

  • Contract: $80-$85/hr

  • Salary: $100K - $120K

BusyQA Alumni have been hired by some of the largest companies in Canada

Know your Instructor

(Brampton)

Hi, I'm Adedayo

Microsoft Basic & Advanced

Adedayo is a project manager in the investments industry. With 5+ years of industry experience, Adedayo is an Excel wizard. He has experience delivering training programs and workshops to people of all skill levels. He has a hands on approach to his teaching and is always ready to provide help.

Head office :

Suite 1532

4 Robert Speck Parkway
Mississauga ON L4Z 1S1 

Training Centers  (appointment only):

 

Mississauga

Iceland Mississauga,
705 Matheson Blvd E, Mississauga, ON L4Z 3X9

Toronto

Swansea Town Hall Community Center

95 Lavinia Ave, Toronto

ON M6S 3H9

Markham

Armadale Community Center

2401 Denison St

Markham ON

L3S 1E7

Brampton

Brampton Soccer Center

1495 Sandalwood Pkwy E

Brampton ON

L6R 0K2

Call

Tel: 1-905-499-3705

Open Mon - Fri : 9AM- 6PM

            Saturday: 9AM- 2 PM

 

© 2019

busyQA Inc

 

  • facebook
  • Twitter Clean
  • LinkedIn Clean