Advanced Excel Expert Program

Duration: 100 Hrs

Price: CAD 2,000

Program Overview

Microsoft Excel is a very powerful tool for data analysis, number crunching, automation, reporting and building dashboards. This program aims to help novice excel users to pro users in about 5 days. The program is completely hands on based with embedded mini projects and use cases to make it easy for understanding and retention. The program will focus on all the essential skills that are required for expert excel users. This course would be perfect for who use excel at work and want to improve their productivity and excel at work. This course would also be ideal for those looking for job opportunities that require business intelligence, automation and building dashboards using excel.

Course Coverage

Productivity Prowess

– This module will focus on acing the essentials of excel and gearing up on speed of implementation of common and often used tasks.

Data Analysis in excel

– Understand how to apply essential data analysis tasks using excel. This module will focus on the application of graphs and pivot tables to answer business questions.

Automating tasks using Excel VBA

–Experience the joy of automation when you learn excel to automate day to day tasks at work like a pro. We will start with the fundamentals and help you build a complete solution all by yourself.

Power BI

– We show how to use the latest features in excel for querying, data manipulation and dashboarding using Power BI.

Building Professional Dashboards

–Learn to build customized professional dashboards using excel in minutes. We will focus on performance and efficiency along with visual insights in this module.

Statistical Decisions for Business

–Understand the appropriateness of tests like T-test, F-test and Chi-Square and implement the same to solve business case studies

Business Forecasting

– Professionals in the field of E-Commerce, Finance, Sales and Operations often need to build forecasting models to take sound decisions and we show you how to excel at making one. We integrate R and excel in this module and demonstrate the immense power that we gain through this.

Trainer Profile

Srikanth Balasubramanian has about 14 years of experience in training, consulting and software. He is a corporate trainer and an analytics consultant for Fortune 500 and MNC firms like VISA, Credit Suisse, Cisco, Honeywell, NXP, Metro, KPMG, PWC Analytics Advisory, Skoruz & Brillio technologies. He also has an extensive Machine Learning and Data Analytics consulting experience with SME firms like Merit Group and RVS Group, where he helped them set up new lines of business based on analytics despite constrained budgets and resources. He has a strong understanding of issues in analytics in the retail, marketing, and finance areas and hasend-to-end capabilities to link analytical models to business goals and outcomes. He works closely with mid-career and senior folks in MNCs around the globe; Canada, USA, Singapore, Hong Kong, and India.

Program Details

  • – Weekday Sessions (In-class or Live Online)
  • – Introductory Fee: CAD 1000 plus any applicable taxes [50 % discount applied on CAD 2000]
  • – Venue: SDL,5200 Dixie Rd #114, Mississauga, ON L4W 1E3 [LIVE ONLINE also available]

Early Registration Benefits

  • – Personal finance analysis – evaluating rent vs buy decisions, amortization
  • – Unlimited course access (Live online sessions) for a life time.

Refund Policy

  • – 100 % Refunds less $25 administration charges for cancellations until the program start date.
  • – No refunds after the program start date.
Ask an expert