Excel Data Analysis: The Complete Analysis Masterclass

Explore how to use Excel for data analysis by turning a simple sales dataset into a table, calculating totals, averages, and revenue, and applying sort, filter, and clustered column charts.

Explore the difference between regular ranges and Excel tables to boost data analysis with filtering and dynamic range expansion. Create tables with headers, totals, and structured references.

Master Excel data analysis by sorting and filtering data. Create tables with headers, sort by score from smallest to largest, and filter by criteria such as greater than.

Explore essential Excel formulas for data analysis, including sum, average, count, and if, applied to a simple data set of employees, departments, and performance scores.

Learn to remove duplicate data in Microsoft Excel by selecting your dataset, using the Data tab to remove duplicates, and preserving unique values with optional column-specific checks and backups.

Apply data validation in Excel to restrict inputs, create drop down lists for departments, and display helpful input messages to prevent bad data and keep datasets clean.

Explore how to split full names into first and last names and to combine data using flash fill and text to columns in Excel, with no formulas needed.

Learn to handle errors and blanks in Excel with iferror, isblank, and other logical functions using a revenue per unit example to prevent division by zero and missing data issues.

Master date and time data in Excel by calculating day differences from start to end dates, tracking hours with clock in/out, and using today, now, and date extraction functions.

Learn to compute descriptive statistics, mean, median, mode, and standard deviation, with simple Excel formulas on a sample data set, using a table with headers and math scores.

Learn to visualize data with conditional formatting in Excel, highlighting top performers and low values using color scales, trends, and data bars to make reports readable and support decision making.

Learn to create and customize Excel charts: column, bar, line, and pie, to visualize data insights quickly for presentations, reports, and dashboards. Explore how to insert charts from the insert tab, add data labels and legends, and customize axis titles and trend lines to clarify your dataset.

Learn to add trendlines and sparklines in Excel to reveal trends, patterns, and outliers with simple charts, line charts, and basic forecasting.

Explore lookup and reference functions for data analysis in Excel, mastering VLOOKUP, HLOOKUP, INDEX, and MATCH to retrieve salaries from large data sets and flexibly locate values.

Explore how Excel tables enable dynamic data analysis with automatic expansion, sorting, filtering, and structure referencing to manage and visualize data sets effectively.

Learn to enable Excel's data analysis toolpak and perform descriptive statistics, regression, and histograms on sample data.

Discover advanced pivot table techniques, including creating calculated fields and slicers, to summarize sales data efficiently. Build a table, insert a pivot table, and filter results by product with slicers.

Explore how to perform correlation and regression analysis in Excel using a simple sales dataset, and interpret outputs like r-squared, p-values, and anova results for data-driven decisions.

Enable Power Pivot, import data into the data model, create relationships between sales and product data using product ID, and build a pivot table to analyze sales by product.

Learn to automate repetitive Excel tasks with macros and Visual Basic for Applications, record actions, and write simple code to automate data entry, formatting, and calculations for data analysis.

Explore scenario analysis and what-if analysis in Excel, using scenario manager and goal seek to test different sales conditions and optimize revenue.

Explore three Excel chart types—bar charts, line graphs, and pie charts—using a simple sales dataset to visualize categories, trends, and proportions.

Learn to create a basic Excel chart from a table of monthly sales and profit, then customize its appearance with titles, axis labels, colors, data labels, and trend lines.

Learn how to perform regression analysis in Excel using the data analysis toolpak. Analyze how advertising cost affects sales revenue and interpret the regression output, including coefficients and R-squared.

Visualize customer feedback in Excel to reveal insights on satisfaction, pain points, and improvement opportunities, using tools like average rating charts, bar charts, and pie charts.

Build a dynamic dashboard by creating pivot tables and pivot charts from a simple data set, then use slicers to explore revenue by product and region.

Customize pivot charts by editing axis titles, legends, and data labels to tell a clear data story. Build pivots from simple data to create meaningful quarterly sales visuals.