Microsoft Excel - Journey from Beginner to Advanced in Excel

Explore Excel string functions left, right, and middle, and apply if statements and sumif functions to analyze data, validate conditions, and summarize yearly sales.

Explore sumifs for multi-criteria sums, then master vlookup to fetch quantities, and handle errors with iferror by displaying 'out of stock' when a product is missing.

Explore how Xlookup overcomes Vlookup by returning leftward results and handle errors with the text 'nothing arrived on this date', then master index-match for multi-criteria lookups like state and year.

Learn to keep headers visible with freeze panes, group data for focused views, and protect sheets to control edits, including password protection and locked/unlocked cell settings.

Learn to enforce correct entries with data validation in Excel by using a drop-down list of salespeople, ensuring accurate commission totals and preventing misspelled names.

Master sparklines to show trends in a small space in Excel, using insert sparklines line, select the data range, adjust weight, drag down for countries, and clear from design.

Explore flash fill to auto-complete names and emails, and use text to columns to separate underscore-delimited data, with Ctrl+E shortcuts and destination output steps.

Record and run an Excel macro to reformat weekly sales data with borders, blue background, bold text, and automatic weekly average and total.

Learn to name cells in Excel to simplify formulas, use define name to label revenue and cost, and apply these names in calculations for clarity.

Master Excel shortcuts from beginner to master, from navigation with ctrl arrows to advanced formatting, paste special, autofit, comments, and customizing the quick access toolbar.

Explore goal seek and solver to optimize profit from iPhone sales by adjusting quantity, price, and costs, then set targets for zero or one million profit under constraints.

Build a dynamic Excel dashboard from raw data to pivot tables and charts, linking key metrics like total sales, units sold, operating profit and margin, plus a monthly sales breakdown.

Make a pivot chart dynamic with a timeline filter to update sales data by date. Add a linked regional map of units sold to your dashboard for comparison.

Add slicers to filter the dashboard across totals, monthly charts, and the heat map, then connect them to pivot tables for cross-filtering by brands, retailers, regions, and timelines.

Analyze a large data set with pivot tables to show 2025 regional quantity, average price, and profitability using a calculated field; apply slicers for dynamic filtering.

Transform Apple data with interactive pivot charts and advanced pivot tables, then use slicers to create a clean, multidimensional sales dashboard for management.