Microsoft Excel - The Complete Excel Data Analysis Course

Explore essential Excel functions, from sum, average, and count to vlookup, if, and concatenate, with practical examples and advanced techniques to boost data analysis skills.

Master common Excel data analysis functions like sum, average, if, and vlookup to analyze sales data, use data validation, and apply exact or approximate lookups.

Create and use named ranges in Excel to simplify formulas, improve readability, and reduce errors, then apply them in sum, vlookup, and data validation with dropdowns.

Master logical and lookup functions in Excel, using if, vlookup, and index match to categorize data and retrieve prices or scores in practical datasets.

Master sorting and filtering data in Excel to organize sales figures, products, and names, and apply combined techniques to reveal the top ten sales representatives.

master conditional formatting in Excel to highlight data with rules, data bars, color scales, and icon sets; learn top/bottom rules, custom formulas, and managing rules.

Master data validation in Excel to restrict inputs with criteria like whole numbers 1–100, lists, and custom formulas, and use error checking to fix issues.

Explore Excel's data analysis tools from sorting, filtering, and pivot tables to scenario manager, data tables, regression, solver, and forecasting, empowering you to analyze and optimize datasets with confidence.

Learn to create basic charts and graphs in Excel, organize data, select ranges, insert charts, customize titles, axes, data labels, and save or share your visualizations.

Master customizing Excel charts by using the chart design tab to change styles and types, format data labels, and adjust color. Add images and text boxes to emphasize data points.

Identify your data type and message to choose the right chart style in Excel. A quick demo visualizes monthly sales of three products with a line chart to show trends.

Master pivot tables in Excel to summarize and analyze large data sets. Learn to set up data, create and customize pivot tables, and use rows, columns, values, and calculated fields.

Explore pivot tables in Excel to summarize sales data by product category and region, building reports with rows, columns, and values, then enhance insights with pivot charts.

Explore Power Query in Excel to clean and transform data, remove duplicates, split columns, and merge tables with a user-friendly interface, then load the cleaned data back into workbook.

Remove duplicates and fix errors in Excel to clean and organize data for accurate analysis. Use remove duplicates and error checking to maintain data integrity.

Split a single data column into multiple columns using delimiters with text to columns, and parse names with left, right, mid, and find functions to extract first and last names.

Master advanced Excel functions and data analysis techniques, from filter and Vlookup to data validation, pivot tables, and conditional formatting, to analyze large data sets efficiently.

Explore correlation and regression analysis in Excel using a two-variable data set (x and y), and learn to compute the correlation coefficient and perform regression to predict values.

Learn to interpret and present analysis results in Excel by using pivot tables, charts, and regression tools to reveal patterns, compare monthly sales, and visualize insights.

Master efficient and accurate data analysis in Excel by organizing data, using tables, leveraging named ranges, mastering formulas, applying conditional formatting, pivot tables, and comments.

Organize Excel workbooks with income, expense, and a summary sheet using clear structure and naming conventions. Document changes with comments, track changes, and version control to ensure auditability.

Explore real-time collaboration in Excel online, share via cloud, manage who can edit or view, track changes, and use coauthoring to work with others.