USING MICROSOFT EXCEL TO CREATE DASHBOARDS

Instructor explaining student the course outline

Excel Dashboard Reporting & Database Analysis

The certificate introduces students to the tools needed to analyze large datasets in order to make more informed business decisions. Gather and organize data for more effective analysis. Learn to communicate analyses in a clear and concise manner.

Topics include:

• Importing data into an analytics software package

• Performing exploratory graphical and data analysis

• Building analytics models using tools such as multiple regression and decision trees

• Finding the best model to explain correlation among variables

• Learning how to control and assess data variability

Who should participate?

• Business, marketing, and operations managers

• Data analysts or professionals in any field who deal with large amounts of data

• Financial industry professionals

• Small business owners

Sep

08

Tue

Income Tax (T1) Personal Return

Child Care, Moving, Tuition, TTC, Dependents, Medical, Stocks, RRSP - 15 CaseStudies

Sep

12

Sat

QuickBooks Level I & Level II

Bookkeeping- General Ledger, AR, AP, Inventory, Payroll, Reconciliation, Payroll & HST Remittance

Sep

15

Tue

Corporation Tax (T2) Returns- Online Classroom Live - ONLINE

GIFI Codes, Schedules, Forms, Depreciation, Inventory - 6 Corporation Tax Case Studies

Sep

22

Tue

Income Tax Level II - Self Employed / Small Business

Commissions, Rental Property, Capital Gain / Capital Allowance, Expenses