The Complete Microsoft Excel Data Analysis Bootcamp

Learn to clean data in Excel by removing duplicates with the built-in tool, select the range and columns to check, and use conditional formatting to identify duplicates before deleting.

Identify and highlight missing values using conditional formatting in Excel, then clean data by replacing, removing, or filling gaps with formulas or Power Query.

Apply Excel data transformation techniques to clean and prepare data for analysis by splitting columns with text to column feature, using Flash Fill, Find and Replace, and Power Query.

Structure data in Excel with headers, avoid mixed data types, and no merged cells to enable sorting, filtering, and analysis, apply tables, data validation, drop-down lists, and pivot tables.

Master Excel's text functions to manipulate and analyze text data. Learn left, right, mid, len, find, substitute, and concatenate to extract, format, and replace text efficiently.

Discover how to compute mean, median, and mode in Excel using the average, median, and mode functions, including array formulas for multiple modes.

Explore variance and standard deviation in Excel, and understand how these measures describe data dispersion. Apply built-in Excel functions to compute population variance and standard deviation for data sets.

Master data visualization in Excel by creating bar, line, pie, and scatter charts, customizing colors, labels, and axes, and combining chart types for deeper insights.

Create pivot tables from well-organized data, drag fields to rows, columns, and values, and use filters or slicers to analyze regions and sales, with refresh and grouping options.

Learn to create and analyze data with pivot tables in Excel, dragging fields to rows, columns, filters, and values to summarize sales data, explore trends, and customize formats.

Learn to create pivot tables and pivot charts to visualize sales data, apply bar, line, or pie charts, and use slicers and timelines for interactive analysis.

Master and apply if, and, or functions in Excel to build logical tests, return true or false, and label scores as pass or fail based on conditions.

Learn how to use conditional formatting in Excel to highlight sales figures above a threshold, apply various formatting styles, and manage or clear rules with formulas for custom conditions.

Explore vlookup, hlookup, index, and match functions to search, retrieve, and analyze data in Excel, with practical examples of lookup values, table arrays, and exact vs approximate matches.

Master dynamic ranges in Excel by using offset, the name manager, and index functions to keep charts and formulas updated as data grows, including table-based and countif approaches.

Install the data analysis toolpak in Excel to unlock a range of statistical and engineering analysis tools, such as descriptive statistics, histograms, and regression, and verify the installation.

Apply correlation and regression in Excel to analyze sales and advertising spend, interpret r square and coefficients, to make data driven decisions and forecast future sales.

Excel's chart types—column, line, pie, bar, scatter, area, radar, and combo charts—and learn when to use each to compare categories, show trends, visualize relationships, and analyze multivariate data.

Create a column chart from sales data, then customize titles, axis labels, colors, styles, and data labels to highlight key data points and improve readability.

Master sparklines in Excel to create tiny cell charts that reveal data trends at a glance, customize with colors, markers, and sparkline types for dashboards and reports.

Create interactive dashboards in Excel by converting data to a table, building pivot tables, adding slicers, and designing charts for an engaging, filterable data view.

Import and clean sales data in Excel, handle missing values and duplicates, then use pivot tables and charts to build a comprehensive sales dashboard.

Discover a practical monthly budget analysis in Excel that guides you from creating a budget template and tracking income and expenses to visualizing spending with pivot tables and pie charts.

Learn to project sales and forecast in Excel using trend, moving average, and scenario manager to visualize monthly sales with line charts and what-if scenarios.