
Explore how regional settings in Excel affect formula syntax, including comma versus semicolon separators, and learn to adapt functions like correlation to your locale.
Enable the analysis toolpak in Excel to access data analysis tools like regression and ANOVA. Install the translator option to support language translations and adapt to regional number formats.
Download the MOVIES data file containing fictional films, including academy award nominations, budgets, ticket and dvd sales, and marketing costs; perform integrated exercises using the code book.
Learn three ways to copy data in Excel—the icon button, right-click copy, and the Ctrl+C keyboard shortcut—plus access to a complete list of keyboard shortcuts.
Examine Ed Wood's life and Plan 9 from Outer Space to show budget constraints shaping creativity, then explore geometric mean, arithmetic mean, mode, and median with a Hollywood dataset.
Explore measurement scales in data analysis, using a pizza analogy to distinguish nominal, ordinal, and parametric scales, with examples like nationality, age, education, location, and income.
Choose the appropriate measurement scale: parametric, ordinal, or nominal, for data analysis, understanding that parametric offers the most freedom and downgrading is always possible, while upgrading is not.
Discover Ed Wood's do-it-yourself movie making, directing, writing, and acting with cheap resources. See how a common household item powered Plan Nine from Outer Space's special effects.
Identify the mode as the most frequent rating in data, illustrated by one and five appearing most often, including bimodal cases, and note its role alongside the mean.
Illustrate how the median, a central-tendency measure, equals the middle value when data are ordered, and how to average the two middle values if there is no single middle.
Compare mean and median to understand when to use each, and demonstrate how extreme values distort the mean, recommending reporting both to reveal central tendency.
Explore a Microsoft Excel file that tracks yearly movie output and average ROI, then compute basic statistics from losses and gains to analyze studio performance.
Learn to calculate mean, mode, min, and max in Excel using the average, mode, min, and max functions. Explore bimodal data and interpret multiple modes in a data set.
Learn to calculate the median in Excel using the median function, select the data range, and interpret the middle value when data is ordered from low to high.
Explain the difference between arithmetic mean and geometric mean and show how geometric mean better reflects cumulative percent changes in a four-year capital scenario.
Apply the geometric mean to perceptual changes, better capturing central tendency than the arithmetic mean, by converting percent changes to multipliers, multiplying them, and taking the 1/n root.
Learn how to raise numbers to a power in Excel using the caret operator, demonstrated by eight raised to 0.5 with a simple formula.
Compute the geometric mean to analyze central tendency for perceptual changes and return on investment in Excel. Learn to convert input and output percentages and apply the geometric mean function.
Compute mode and median from the data, compare arithmetic and geometric means for percentages and perceptual changes, and interpret a 47.5% annual visitor decline.
Examine Ed Wood's Plan Nine from Outer Space flying saucers, highlighting budget-friendly effects made from hubcaps or modified paper plates under financial constraints.
Choose the right Excel chart for your data, from long time series line charts to bar charts for groups, pie charts for distribution, and Pareto charts and histograms.
Learn to create and customize a two-line chart in Excel to compare Holland and Belgium profits over years, with proper data selection, axes, and axis titles in US dollars.
Demonstrates how a logarithmic scale on the y axis reveals large price changes, using bitcoin and a fictional currency, and shows applying format axis in Excel to highlight business-relevant shifts.
Use Excel 2016 to create a Pareto chart that plots frequency and cumulative percentage, revealing key drivers like expensive hardware and poor game quality for targeted improvements.
Master creating bar charts in Microsoft Excel from scratch using 1980 and 1981 production data for Ahmadabad, New Delhi, and Bangalore, and customize axes, series, and layouts.
Create a pie chart from scratch in Microsoft Excel to show passenger proportions by destination, using data, axis labels, and quick layouts to display percentages or counts.
Identify common chart mistakes, including missing axis labels, choosing the wrong chart type, and overusing 3D effects, to convey data clearly.
Create a line chart for team A, B, and C over the years; then build a pivot chart to compare DVD sales for films with or without special effects.
Explore how Coca-Cola shaped the Santa Claus image through the 1920s campaigns and 1931 Sundblom illustrations, then apply standard deviation theory to an Excel file about Coca-Cola.
Analyze data in Microsoft Excel using standard deviation as a key technique, visualize distributions with histograms, and understand the normal (Gaussian) distribution.
Learn to create histograms in Excel to visually assess normality for plant A, B, and C, tuning bin width to inspect distribution.
Learn how standard deviation measures data dispersion and, with the mean, applies the three standard deviation rules of thumb to bound data within 88–92, 86–94, and 84–96.
Track how Santa's appearance shifted from the early 20th century to 1939 depictions, shaped by Coca-Cola's Christmas campaigns seen by a US traveler returning from Japan.
Excel computes standard deviation for plant A and B, using population vs. sample options, showing plant B has greater spread while means stay near 30 cm.
Understand the normality assumption, where a perfect bell-shaped distribution yields 68%, 95%, and 99% rules of thumb, yet these rules remain rough approximations when data isn't perfectly normal.
Clarify standard deviation through a bottling plant example, highlighting that 95% of sample data lies between mean ± two standard deviations under normal distribution, and not about all bottles.
Inspect an Excel file that records bottle contents in centiliters for three plants A, B, and C, with sample values like 30.5 cl, 29 cl, and 10 cl.
Use excel's norm.dist function to compute the cumulative probability left of 91, with a mean of 90 and a standard deviation of 2, showing 69% below and 31% above.
Apply the norm.dist function in Excel to compute the probability under a normal distribution. Compute mean 90 and sd 2 with x=88.5 to obtain about 23% (area under the curve).
Examine how advertising influences culture as Santa shifts from green to red and white, possibly reflecting Coca-Cola branding in public depictions.
Analyze a Mars mission dataset and forecast the number of passenger volunteers using Excel data analysis to inform terraforming projections.
Learn how the Pearson correlation coefficient (r) measures the strength and direction of a linear relationship, from -1 to 1, with examples of positive, negative, and no linear association.
Explore a Mars data file covering 2030 to 2043, detailing passengers (thousands), average net monthly income, ticket price, living space, health check cost, and training duration.
Visualize data with a scatter plot in Excel to assess the relationship between passenger numbers and monthly income, adjust axes, and identify outliers before computing the correlation coefficient.
Calculate correlation coefficients in Excel, starting with individual correlations and then building a correlation matrix. Use the correlation function to compare data, noting a near -0.99 negative linear correlation.
Learn to create a correlation matrix in Excel using the Data Analysis Toolpak, including labels, selecting input range, and interpreting coefficients like 0.3 and -0.6.
Inspect a correlation matrix in Excel to see which variables relate to passenger numbers, noting negative links with income and positive links with inflation, ticket price, and Mars living space.
Explore the controversial idea of using nuclear bombs to establish a presence on mars and preview how they could provide benefits.
Explore correlation in Excel by analyzing a mock stock price dataset against short-term rates, the S&P 500, unemployment, long-term rates, and crude oil prices.
Unlock the Analysis ToolPak, generate a correlation matrix with labels in the first row, and note strong positive links between unemployment rate, crude oil price, and ABC 123 stock price.
Explore the difference between correlation and causality using a classic ice cream and drownings example, and identify how hidden variables like temperature confound relationships.
Explains that correlation coefficients capture only linear patterns, so non-linear relationships may show weak correlations. A low correlation does not prove the absence of a relationship.
Identify how outliers distort correlation analysis by affecting the R value, and learn to investigate causes before removing data, never excising more than 5%, and evaluating real-world context.
Explore how to respect outliers in data analysis, examining how outliers affect the correlation coefficient between temperature and visitors, and when to remove or keep them based on context.
Explore how time lag affects data relationships by testing delayed correlations, using unemployment rate and revenue as examples, and learn to shift data to reveal stronger insights.
Explore time-lag analysis in Excel by correlating promotional expenses with sales, testing zero to three week lags to identify the strongest lag for sales impact.
Explore how to assess time lag in Microsoft Excel by shifting promotional expenses and sales data, computing correlation coefficients, and finding a two-week lag with strongest impact.
Examine how nuclear explosions on Mars might create craters as reservoirs, melt ice to form water, and release CO2 to thicken the atmosphere for longer liquid water.
Explore single ols regression in Excel, interpreting the equation y = a + b x, including the slope, intercept, R-squared, residuals, and the concepts of homoscedasticity and heteroscedasticity.
Perform an ordinary least squares regression in Excel with sales as the dependent variable and marketing spend (in thousands of euros) as the independent variable, using a scatterplot and trendline.
Perform a single ols regression in Microsoft Excel to practice data analysis techniques and strengthen skills for the Excel Data Analysis Expert accreditation.
Explore non linear regression in Excel by comparing exponential, logarithmic, and power trendlines to a linear fit, and interpret R-squared to reveal diminishing returns in levels versus satisfaction.
Explore the theory of multiple OLS regression and learn how Excel calculates it to isolate the pure effects of experience and training on mistakes, guided by R squared.
Explore the rules of multiple ols regression, including parametric scales for y and preferably x, avoiding high-cardinality nominals and multicollinearity, with Excel-based calculations in part 3.
Perform a practical multiple OLS regression in Excel using the data analysis toolpak, check multicollinearity with correlations, and interpret R-squared, adjusted R-squared, ANOVA significance, and coefficients.
Perform a multiple OLS regression in Excel to analyze how drink sales (in thousands) depend on the number of stands, ticket price, and concert duration, assess model fit and significance.
DATA ANALYTICS AND BUSINESS STATISTICS PROFESSIONAL
MASTER DATA ANALYTICS, BUSINESS STATISTICS AND DATA-DRIVEN DECISION-MAKING
Turn data into meaningful insights, uncover patterns, understand statistical relationships, and make smarter business decisions. In this practical, beginner-friendly course, you will develop essential data analytics and business statistics skills used across business, finance, management, and other data-driven professions.
Data analytics is no longer a skill reserved for specialists. As organizations increasingly rely on data and AI to guide their decisions, the ability to interpret information, evaluate evidence, and communicate insights has become increasingly valuable. Whether you want to strengthen your CV, advance your career, or make better decisions in your current role, this course provides a practical foundation in data analysis and statistical thinking.
You will learn how to apply statistical methods, identify trends, investigate relationships between variables, build interactive dashboards, and analyze business scenarios. Microsoft Excel (2016, 2019, 2024 and Microsoft 365) is our practical analysis tool, allowing you to develop these skills without learning programming or investing in specialized software.
WHY CHOOSE THIS COURSE?
There are hundreds of courses teaching spreadsheet functions. This course goes further by focusing on the analytical and statistical skills behind effective business decisions. Rather than simply showing you which buttons to click, we explain what the results mean, why the methods matter, and how to apply them to real business problems.
NO PRIOR EXPERIENCE REQUIRED: Start from the fundamentals and progressively build your confidence in data analytics and business statistics. No previous Excel or statistical knowledge is necessary.
PRACTICAL, CAREER-RELEVANT SKILLS: Learn descriptive statistics, correlation, regression analysis, scenario modeling, and data visualization—techniques relevant to analytical roles across many industries.
STATISTICS MADE ACCESSIBLE: Understand statistical concepts through clear explanations and practical examples, regardless of your educational background.
LEARN THROUGH STORYTELLING: Follow relatable business scenarios that make complex analytical concepts easier to understand, remember, and apply.
FOCUS ON BUSINESS DECISIONS: Go beyond calculations to understand how data can help you evaluate alternatives, identify opportunities, and support better decisions.
LEARN AT YOUR OWN PACE: Study whenever and wherever you want, revisit challenging topics, and develop your skills step by step.
WHAT YOU WILL LEARN
Our curriculum takes you from the foundations of data analysis to applied business statistics, statistical modeling, and interactive reporting. We begin with a brief introduction to Excel, ensuring everyone can follow along, before moving quickly into the analytical techniques that form the core of the course.
BUSINESS STATISTICS AND DESCRIPTIVE ANALYSIS
Learn how to summarize, interpret, and understand business data using fundamental statistical techniques. You will explore measures of central tendency, variability, and probability distributions, and discover how these concepts help you evaluate performance and make sense of numerical information.
Descriptive statistics and data interpretation
Mean, geometric mean, median, and mode
Standard deviation and data variability
Normal distribution
Identifying patterns, trends, and outliers
CORRELATION AND REGRESSION ANALYSIS
Discover how analysts investigate relationships between variables and use statistical models to understand business performance. You will learn how to interpret correlations, evaluate regression models, and recognize the limitations of statistical relationships.
Pearson correlation and correlation matrices
Identifying relationships between variables
Simple ordinary least squares (OLS) regression
Nonlinear regression
Multiple OLS regression
Interpreting R² and regression results
Understanding the role of outliers and time lags
BUSINESS ANALYTICS AND DECISION MODELING
Learn how to evaluate business scenarios, investigate alternatives, and use quantitative techniques to support decisions. These tools help you understand how changing assumptions can affect outcomes and how to approach practical optimization problems.
What-if and scenario analysis
Goal Seek and sensitivity to assumptions
Solver and optimization
Comparing alternative business outcomes
Applying analytical results to business decisions
DATA VISUALIZATION AND INTERACTIVE DASHBOARDS
Learn how to transform numerical information into clear, actionable visual insights. Explore charts, PivotTables, and interactive dashboards to summarize performance, communicate findings, and make complex datasets easier to understand.
Business charts and data visualization
Histograms and Pareto analysis
PivotTables and PivotCharts
Interactive dashboards
Slicers, timelines, and dropdown menus
Conditional formatting and pattern recognition
ESSENTIAL DATA ANALYSIS TOOLS
To ensure the course is accessible to everyone, we also cover the essential Excel functionality needed to perform practical analysis. These lessons are designed to support your analytical development rather than turn the course into another general-purpose spreadsheet tutorial.
Essential formulas and cell referencing
VLOOKUP, IF, nested IF, and AND functions
Data filtering and organization
Formatting, worksheet protection, and navigation
Keyboard shortcuts and efficient workflows
WHO IS THIS COURSE FOR?
This course is designed for anyone who wants to become more confident working with data, understanding statistics, and making evidence-based decisions. It is particularly relevant for aspiring data analysts, business analysts, finance professionals, managers, entrepreneurs, students, and professionals looking to strengthen their analytical capabilities.
You do not need a background in mathematics, statistics, programming, or data analysis to get started. We introduce the concepts step by step and focus on making them understandable and applicable.
YOUR CERTIFICATE AND COURSE BENEFITS
Your enrollment also includes lifetime access to the course materials, the flexibility to learn at your own pace, and Udemy's 30-day money-back guarantee, subject to its refund policy. The course is taught by qualified university lecturers from Six Sigma Academy Amsterdam, a well-establoished training and credential provider with roughly 300,000 students as of 2026.
SOFTWARE COMPATIBILITY
All demonstrations use Microsoft Excel as an accessible analytical tool. The course is designed for Excel 2016, 2019, 2024 and Microsoft 365, and its core statistical and analytical techniques are applicable across supported versions. Some interface elements or functions may differ depending on your version.
START BUILDING YOUR ANALYTICAL SKILLS TODAY
Data is valuable. Knowing how to interpret it is what makes the difference. Develop practical expertise in business statistics, regression analysis, dashboards, and data-driven decision-making through accessible, real-world examples.
Enroll today and start building analytical skills you can apply throughout your career.