Applied Excel Analysis
Guided, self-paced, experiential learning • Case study templates • No coding
Hone your descriptive and diagnostic analysis skills. These experiential learning courses only require Microsoft Excel and internet access. No programming, VBA, macros or coding.
No lengthy videos to watch, just practice with realistic data
Acquire in-demand, employable skills. Build your reference projects
Seven free modules and quick reference guide. No Credit Card Required
Get started for free. Full lifetime access. PC & Mobile.
Money-back satisfaction guaranteed* (if you purchase new modules)
Looking for additional income? Join our team as Program Affiliate
Start with Free Learning Modules | No Credit Card Required
LinkedIn Test Prep & Bootcamp
Descriptive Analysis
Descriptive Analysis
Descriptive Analysis
Diagnostic Analysis
Diagnostic Analysis
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 functions, you're missing out on plenty of features and methods that will benefit your organization. These Experiential Learning courses will allow you to harness the full power of Excel by learning and practicing your analysis skills on realistic data.
Get started with our free modules. No credit card required.
Download the Excel Analysis Reference Guide
What are the prerequisite you should be comfortable with?
While the courses are not a replacement for a full-length statistics course, we will cover some essential concepts of statistics. You should be able to complete the modules with a basic understanding of statistics.
Before you start this course, make sure that you are comfortable using the following Excel functions and features:
How does this Experiential Learning Bootcamp compare to other Excel online courses?
* Only Excel and internet access
And what do we think is the best way to learn?
Who We Are
We are a team of Learning and Performance Improvement Professionals with decades of experience in:
We believe that typical online courses need to change to keep up with business demands:
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%.
Our courses apply the principle of Guided practice together with Gagne's Nine Events of Instructions:
At the end of the courses, you will be ready to start teaching others.
Each Analysis module 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.
It takes approximately 15 to 30 minutes to complete each module, depending on your Excel-skill level. Some of the modules are easier, other 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.
(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.
While the courses are not a replacement for a full-length statistics course, we will cover some essential concepts of statistics. You should be able to complete the modules with a basic understanding 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.
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 common functions and have already conducted some analysis using pivots and charts (intermediate level), 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.
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.
Please check our Affiliate program page. It contains the program details, financial conditions and FAQs. Go to www.applieddataanalysis.com/pages/affiliate or click below JOIN OUR TEAM AS AFFILIATE