Applied Excel Analysis Professional Bootcamp
17 cases studies • Guided, self-paced, experiential learning • Build reference projects • No coding, no add-ins • OpenBadges™ Certificate
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 much of Excel do we really use?
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:
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
Dispersion Analysis & Box Plots: Description & Skill Practice
Dispersion Analysis & Box Plots: Skill Assessment
One quick question to help clarify your goals and expectations.
Histogram and Bell Curve: Description & Skill Practice
Histogram and Bell Curve: Skill Assessment
Population Pyramids & Violin Plots: Description & Skill Practice
Population Pyramids & Violin Plots: Skill Assessment
Time-Series Analysis: Description & Skill Practice
Time-Series Analysis: Skill Assessment
Quick Check: How Confident Are You?
Geo-Mapping & Density Analysis Description & Skill Practice
Geo-Mapping & Density Analysis: Skill Assessment
Density Maps: Description & Skill Practice
Density Maps: Skill Assessment
Treemaps & Lollipop Graphs: Description & Skill Practice
Treemaps & Lollipop Graphs: Skill Assessment
Simple Text Analysis & Word Clouds: Description & Skill Practice
Text Analysis & Word Clouds Maps: Skill Assessment
Quick Check: Using Checklists and Templates?
Total Cost Analysis & Waterfall Charts: Description & Skill Practice
Total Cost Analysis & Waterfall Charts: Skill Assessment
Net Present Value & Stacked Columns: Description & Skill Practice
Net Present Value & Stacked Columns: Skill Assessment
Cost Benefit Analysis & Slope Graphs: Description & Skill Practice
Cost Benefit Analysis & Slope Graphs: Skill Assessment
Correlations & Scatter Plots: Description & Skill Practice
FREE PREVIEWCorrelations & Scatter Plots: Skill Assessment
FREE PREVIEWQuick Check: How Relevant is the Course Content?
Significance Tests (Hypothesis & t-Test): Description & Skill Practice
Significance Tests (Hypothesis & t-Test): Skill Assessment
Analysis of Variance (ANOVA): Description & Skill Practice
Analysis of Variance (ANOVA): Skill Assessment
Causal Analysis with Randomized Experiments: Description & Skill Practice
Causal Analysis with Randomized Experiments: Skill Assessment
Exploratory Causal Analysis: Description & Skill Practice
Exploratory Causal Analysis: Skill Assessment
Your Quick Reference Guide
FREE PREVIEWJust before you get your Certificate...
How does this Experiential Learning Bootcamp compare to other Excel online courses
* Only Excel and internet access
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.
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.