Excel Training

Data Entry, Tables, Formulas, Functions, Pivots 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

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​

ADVANCED

CLASS 1:

Working with Tables​

Data Entry & Management

Pivot Tables​

CLASS 2:

Interactive Dashboard

Special Tips and Tricks

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...

DECEMBER 14th, 2019

WINTER BATCH STARTS...

JANUARY 18th, 2020

Career Roadmap

1 - 3 Yrs
3 - 5 Yrs
5+ Yrs
  • Administrative Assistant

  • Office Assistant

  • Data Entry Operator

  • Contract: $25/hr 

  • Salary: $40K - $50K

  • Office Manager

  • Data Entry Specialist

  • Contract: $20-$40/hr 

  • Salary: $60K - $80K

  • Executive Assistant

  • Data Analyst

  • Lead Data Entry Operator

  • Contract: $30-$50/hr

  • Salary: $60K - $90K

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

Program Room 1/2

Thornhill Community Centre Library

7755 Bayview Ave, Thornhill

L3T 4P1

Mississauga

Classroom 2

Central Library

301 Burnhamthorpe RD W

L5B 3Y3

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