ADVANCED EXCEL & DATA ANALYTICS COURSE

This course covers a number of Statistical Data Analysis Techniques for Predictive Analytics, Data Mining, Advanced Data Visualization Techniques & much more… all using Microsoft Excel. Each method is demonstrated with examples & exercises for your own business analytics.

It combines classroom-based lectures with hands-on exercises on analyzing data using Microsoft Excel to visualize and find meaningful information and patterns. Making sense of these patterns can lead to enhanced quality and speed of decision-making processes, as well as measurable increases in productivity and efficiency.

This is a very practical, hands-on, and insightful course, full of advanced Excel techniques to bring in the data, analyze it quickly, identify trends, and visualize the information in charts, graphs and dashboards.

Learning Objective
Participants will:
Master the most up-to-date practical skills and knowledge data analysts use in their daily roles
Learn how to perform data analysis, including data preparation, statistical analysis, and predictive modeling using R, R Studio, and Jupyter
Utilize Excel spreadsheets to perform a variety of data analysis tasks like data wrangling, using pivot tables, data mining, & creating charts
Communicate your data findings using various data visualization techniques including, charts, plots & interactive dashboards with Cognos and R Shiny

Learning Contents
Best Excel functions for deeper data analysis, data mining & business analytics
Tips for cleansing, transforming & modelling data,
Sensitivity Analysis with Data Tables,
Goal Seek Find the missing pieces,
Advanced Excel Visualisation Techniques using Multiple Charts, Pivots & Slicers
Data Modeling & Linear Regression for Predictive Analysis
Creation of Excel Dashboards for Business Intelligence & Management Reporting of Insights

Who Should Attend:
Data analysts, Managers, Decision-makers, Sales Team Leaders and end users.

Date:

April 8 – 10,
August 12 – 14, 2026.