Microsoft Excel for Data Analysis: From Beginner to Advanced

Clean and transform data with Power Query to remove duplicates, add an index column, replace nulls with absent, and load the cleaned data back to Excel.

Clean data in Excel using formulas: trim to remove extra spaces, fill blanks with absent, convert case with lower, upper, proper, format dates with text, join names with concatenate.

Master essential data analysis techniques in Excel by applying formulas and functions such as if, sumif, sumifs, index match, vlookup, and nested if, with practical retirement and income data examples.

Excel data analysis exercises teach applying formulas to identify employees eligible for salary increments, totalize transactions by James, Mike, Cathy, and Donna, and count satellites per planet.

Learn to analyze data with pivot tables in Excel, including creating a data table, building pivots, and extracting top ten data science salaries by job title, employment type, and country.

Perform an exercise on pivot tables to analyze a dataset and compute total sales by region, total units by each sales rep, and identify the top three and bottom reps.

Learn to analyze business metrics in Excel by calculating revenue, costs, and profits, and mastering KPIs such as sales, customer, and operational metrics with practical Excel examples.

Explore scenario and sensitivity analysis in Excel to forecast profit under changing price, units sold, and cost using What-If Analysis, Scenario Manager, and Goal Seek.

Explore how linear regression reveals how one variable affects another by fitting a best-fit line, predicting outcomes like sales from advertising spend, and explaining or justifying decisions.

Use a scatter chart with a linear regression trendline to reveal how monthly advertising spend relates to sales. The line enables data-driven predictions based on past data, without using formulas.

Identify four common mistakes in linear regression: mistaking regression for certainty, using unrelated data, overthinking statistics, and ignoring business context; learn practical guidance to turn numbers into business insights.

Explore forecasting concepts and techniques, using qualitative and quantitative methods with historical data in Excel to predict future sales.

Create an interactive Excel dashboard from scratch using pivot tables, charts, and slicers to filter data by year, month, country, and more.

Explore the iferror function to manage errors in complex spreadsheets, improving data clarity and reporting by replacing division by zero with a custom value like no expenses.

Explore the seven top Excel interview questions for a data analysis role, covering useful functions, VLOOKUP limitations and alternatives, pivot tables, dashboards, and data cleaning with Power Query.