Learn, practice, assess your skills

This Experiential Learning bootcamp consists of 17 common analysis that can be conducted with Microsoft Excel and internet access. They do not require any programming skills, VBA, macros or coding.

  • Become an Applied Excel Analysis Professional

  • No lengthy videos to watch, just practice with realistic data

  • Acquire in-demand, employable skills. Build your reference projects

  • Download the Quick Reference Guide and Excel templates

  • Full lifetime access. PC & Mobile.

How it works

Retain 75% of what you learn, not 30%

  • Hands-On Experience

    • Download Excel template • Understand analysis example • Practice with realistic data • Assess your skills

  • OpenBadges™ Certificate as Applied Excel Analysis Professional

    • Attests the completion of all case studies • Shareable on LinkedIn and social media • Demonstrates employable skills

  • Quick Reference Guide

    • Quick access to Excel templates • Supports the transfer of new skills to your job • Enhances learning retention

Microsoft Excel is the #1 spreadsheet application

How much of Excel do we really use? 

  • 800 million
    the estimated Excel users worldwide (source: Microsoft)

  • 90%
    of them only use about 10% of its capabilities (source: Capterra)


What's the market for Excel Data Analysts?

Data analysis is among today’s fastest-growing and sought-after professions as organizations increasingly rely on data to drive their strategic decisions and implement new interventions:

  • 5,300
    The number of Excel Data Analyst jobs available on Indeed.com (US market, Dec 20)

  • $62,450
    Average Excel Data Analyst salary, Junior level. This increases to $91,580K with 5-7 years of experience (source: Glassdoor.com, US market, 2020)


With some raw data, Excel gives you the ability to extract the necessary evidence and valuable insights to define the right strategies and implement the right interventions.

This Certificate as Applied Excel Analysis Professional is designed to provide you with the skills, on-the-job support and reference projects to succeed in your work.


What you will learn and practice

If you're only using the basic Excel fonctions, you're missing out on plenty of features and methods that will benefit your organization. This Experiential Learning Bootcamp allows you to harness the full power of Excel by learning and practicing your analysis skills on realistic data. This course covers 17 common business analysis:

1. The first nine cover tools and templates to conduct a Descriptive Analysis of your data: Pareto, Dispersion, Histograms, Violin Plots, Time-Series, Geo-Mapping and Text Analysis;

2. The next eight cover Common Cost Analysis and Diagnostic Analysis: Cost Benefit Analysis, Net Present Value, Significance Tests, Variance and Causal Analysis.

Download your free Quick Reference Guide


Bootcamp overview

Learners' Feedback

★ ★ ★ ★ ★

  • 95% Confident

    How Confident Are You in using Excel for Data Analysis?

  • 94% Plan to Reuse

    To which extent do you Plan to Reuse some of the checklists and templates from this bootcamp?

  • 96% Relevant to My Work

    To which extent are the learning experiences relevant to help you improve your work outcomes?

Tuition

Access all experiential learning modules, download 17 templates, get an OpenBadges™ Certificate as Applied Excel Analysis Professional

This is not a typical course with videos

How does this Experiential Learning Bootcamp compare to other Excel online courses?


Self-paced Practice. No Video, No Teacher

Download & Reuse 17+ Case Study Excel Templates

Build Your Reference Projects

Excel Only *
No Plug-In, No Coding, No Macro

This Bootcamp: 19 modules, about 4 hours of guided practice

LinkedIn’s Advanced Excel Data & Analytics Skills

12 hours of video

VBA coding,
R for Excel

Ecornell’s Data Analytics

Instructor-led

Coursera’s Applied

Analytics/Data for

Decision Making

16 videos

15 readings

ExcelWithBusiness’s Advanced Analysis with Microsoft Excel

90 videos

VBA coding,
Macros

* and internet access

https://ispi.org
https://www.td.org
https://www.worklearning.com
https://roiinstitute.net
https://shrm.org

Who contributed to this bootcamp?

And what do we believe in?

We are a team of Learning and Performance Improvement Professionals with decades of experience in:

  • Instructional Design;
  • Performance Assessment;
  • Performance Technologies;
  • Learning Measurement;
  • Data Analysis for Decision Making.

Clara N., COO


We believe that typical online courses need to change to keep up with business demands:

  • Effective training is not about watching videos, listening to an instructor or reading documents;
  • We need to go back to the roots of training (tell me, watch me, let me) in an approach that makes the best use of available online technology;
  • This is how we designed this bootcamp;
  • This allows learners to develop and practice their skills in a safe and controlled environment.



Retain 75% of what you learn, not 30%


Videos, Readings, Listening to an instructors have learning retention rates below 30%. Practice increases retention to 75%. This bootcamp applies the principle of Guided practice together with Gagne's Nine Events of Instructions:

  • Tell Me
    • The expected Performance Objectives;
    • The presentation of the Analysis Methodology;

  • Show Me
    • An Excel file with the steps and step-by-step guidance to conduct the analysis;
    • All cases studies have a Self-Moderated Discussion to ask questions or provide feedback;

  • Let Me
    • A Practice Tab for you to apply what you learnt and conduct your own analysis. This is how you will create your own reference projects;
    • A Skill Assessment to validate the outcome from your practice (feedback);
    • The Quick Reference Guide to enhance learning transfer and skill retention.


At the end of this bootcamp, you will be ready to start teaching others.

FAQs

  • What does a case study consist of?

    Each case study consists of (1) The expected Performance Objectives; (2) The Analysis Methodology; (3) An Excel file with the steps and guidance to conduct the analysis. The Practice Tab gives the opportunity to apply what you learnt by conducting your own analysis using realistic data; (4) A Skill Assessment to report and validate the outcome from your practice.

  • How long does it take to complete the entire Experiential Learning Journey?

    It takes approximately 10 to 20 minutes to complete each module, depending on your Excel-skill level. The first modules are easier, then become more difficult. In some cases like the Hexagon Map or the Text Analysis, the goal is not to recreate all formulas, but to learn how to use the existing templates. This will allow you to generate quick results with minimum efforts. There are 19 modules to complete including the introduction and closing sections. At a pace of 4 to 6 modules per week (1 to 2 hours), you can complete this bootcamp within three weeks.

  • Who is this bootcamp for?

    (1) Anyone who wants to learn to apply data analysis techniques using Excel; (2) Anyone who wants to become good at using Excel for data analysis; (3) Anyone who wants to learn the core concepts of data analysis in Excel; (4) Anyone who wants to learn about PowerPivot, Pivot Charts etc.

  • What are the prerequisites to complete this course?

    While this bootcamp is not a replacement for a full-length statistics course, we will cover some essential concepts of statistics. You should be able to complete this course without any prior knowledge of statistics. Before you start this course, make sure that you are comfortable using the following Excel functions and features: (1) Prepare data with Sort, Filter, Find, Replace; (2) Navigate spreadsheets of more than 1,000 rows; (3) Use basic Excel functions like Average, Median, If, Cell and Number Formatting; (4) Create and configure Pivot tables; (5) Create and format simple charts: we will show you how to get the best of Excel with new chart types; (6) Activate the Data Analysis ToolPak.

  • Is this the right Excel course level for me?

    If you are New to Excel or not comfortable with common Excel functions , this is not the right course for you. Complete first an "Excel for Beginner" course and cover Excel basic functions and features. If you know how to use the Excel basic functions and have conducted some analysis using pivots and charts, this is the right course for you. If you already have experiences with complex analysis in Excel, this course will expand your skill sets to additional types of analysis and provide you with ready-to-use templates.

  • Which software do I need to complete this bootcamp?

    You need Microsoft Excel Version 16 or higher (2016 or more recent) and access to internet to complete the analysis. You do NOT need anything else: no API, no plug-Ins, no programming, no macros, no VBA, no additional fees. You can complete the practice sessions with an older version of Excel but some of the formulas and features such as the Excel map will not be available.

  • What is an OpenBadges™ Certificate?

    The course certificate is issued by Applied Data Analysis using the Badgr platform. Badgr is the home for skills-based digital credentials, stackable learning pathways, and portable learner records. It meets the OpenBadges requirement, the world's leading format for digital badges. This means that the Certificate is verifiable, portable and carries information about skills and achievements.