Start with the equals sign to turn data into formulas in Excel, performing basic math with plus, minus, multiply, and divide. Watch the formula update instantly as you modify numbers.

Learn to use cell references following the golden rule, never type numbers into formulas, to make dynamic totals that automatically update when prices or hours change.

Build a personal budget in Excel for January–March, total income, expenses, and net income with formulas, and use the fill handle to copy formulas for a dynamic quarterly budget.

Master the Excel sum function to add a range quickly and accurately, replacing plus signs with a clean, quicker formula that updates totals automatically, making budgets faster and more professional.

Discover the autosum one-click shortcut to auto-fill the sum function, quickly adding numbers and revealing totals with a single press.

Learn to use autosum to quickly add, average, count, and find max and min in a dynamic Q1 budget, with color-coded profit, expenses, and income.

Master relative, absolute, and mixed references as you drag formulas, and use the dollar sign to lock the row or column to keep correct values.

Transpose a table to flip months and items, and learn how relative and absolute references behave, using dollar signs and F4 to lock rows, columns, or both.

Apply absolute references to lock the tax rate with the dollar sign. Calculate cost as unit price times quantity and total as cost plus tax, updating automatically when tax changes.

Apply the bodmas rule in Excel to evaluate expressions correctly, prioritizing brackets, exponents, division, multiplication, addition, and subtraction. Practice with examples and observe the answer cell turning green when correct.

Master the if function in Excel by evaluating a logical test with comparison operators, returning yes or no based on the condition, and applying it to practice data.

Set the target in c15 to 5000, write an if formula in d that returns true when c18≥c15, and lock c15 with absolute references for copying down.

Explore the if function with an absolute reference to D29, compare C31 to the target, return 'achieved' or 'not achieved', and copy the formula down for a dynamic report.

Explore the IFS function to assign multiple grades in Excel. Create ordered tests (90+ → A, 80+ → B, 70+ → C) with a final true default, then fill down.

Master the IFS function to classify revenue against a locked target with dollar signs, returning met, almost, or not yet based on revenue ≥ target and ≥90% of target.

Master or and functions in Excel to test multiple conditions and return true or false. Use apple, milk, carrot examples and score checks to illustrate multi-condition logic.

Learn to build IFS logic with or and trim to classify items as fruit, dairy, or other, and clean input data by removing extra spaces to prevent errors.

Learn to use sum if and sumifs to add sales by one or multiple conditions, such as fruits, dairy, vegetables in the north, and meat in the south.

Master the iferror function to replace errors with clean messages and activate only on errors, such as 'check denominator' for division by zero.

Learn how to calculate the mean with and without conditions using Excel's average and averageif functions, with practical examples like the sales department scores.

Learn counting functions in Excel, including count and counta, with practice on numeric and non-empty data. Explore countif and countifs for single and multi-criteria scenarios using tables and conditional results.

Learn how to use Excel text functions to extract characters with left, right, and mid; fix capitalization with upper, lower, and proper; and combine names with concat or ampersand.

Explore how Excel handles rounding with three functions: round, roundup, and round down. Learn their syntax and rules, using 123.49 as an example to contrast normal rounding, up, and down.

Master Vlookup to find an exact match in Excel with a four-argument formula: lookup value, table array, column index, and false for exact match. Lock the range with absolute references.

Discover the power of vlookup to pull a product’s category, region, month, and sales from a master table, using absolute references and the exact-match setting for a dynamic report.

Learn to prevent vlookup errors by adding data validation with a drop-down list, locking references, and building a robust, user-proof Excel dashboard.

Master hlookup in Excel by performing horizontal lookups across the first row to retrieve category, region, month, and sales using exact-match formulas to create dynamic reports.

Use data validation drop-downs to select product codes and wrap HLOOKUP with IFNA for robust not-found handling. This approach improves user experience and creates a more professional dashboard feel.

Learn how index and match overcome vlookup’s limitations by locating the exact product with sales of 800, using match to find the row and index to retrieve the product name.

Explore Excel's choose function to pick the nth item from a list or dynamic ranges, then combine it with sum to total a chosen region's sales (north, south, east).

Xlookup represents the evolution from Vlookup and index-and-match, combining their power with a simple lookup style to search any column and return values from any other column, left or right.

Discover how Xlookup replaces Vlookup and index and match by returning multiple columns with a single formula, enabling exact matches and flexible search directions from bottom or top.

Build dates from year, month, and day with the date function to create valid dates. Compute days between dates by subtraction and use eomonth and edate for dynamic timelines.

Rank clients by revenue with Excel's rank function and build a live top clients report using Xlookup, showing the top client and their profit as data changes.

Master turbo navigation in Excel with ctrl plus arrow keys to jump to data edges. Add ctrl plus shift plus arrow to select entire rows or columns quickly.

Discover how to use go to special to quickly select blanks, formulas, errors, and constants in large datasets, saving time and improving data cleaning.

Create multiple lines in a single cell with Alt+ enter, and use wrap text to auto adjust row height for a clean, organized look.

Learn to use find and replace in Excel with Ctrl+H to update words via find what and replace all, remove formatting, and adjust formulas across large data sets.

Master the text to columns tool in Excel to split messy text into multiple columns using delimited or fixed width options, handling commas, dashes, and other separators for clean data.

Sort data in Excel by salary, department, and priority using multi-level options. Apply custom lists and color sorts to create clear, professional reports.

Convert a data range into an official Excel table to gain filters, styles, a total row with averages, max, min, dynamic growth, and structured references for cleaner formulas.

Learn to filter data in Excel with auto filter and advanced filter to display east region and sales over 5000, and combine conditions for precise reporting.

Learn how named ranges in excel improve readability and reduce errors by replacing cell references with meaningful names like sales and tax rate; define and manage them with name manager.

Create named ranges that store constant values, such as tax rates and exchange rates, and reference them in formulas to keep worksheets clean and uncluttered.

Define named ranges for unit and hours, then concatenate quantities with those names to produce outputs like ten kilograms or eight hours, updating all results when names change.

Master data validation and drop down lists in Excel to create dynamic, dependent dropdowns with named ranges, tables, and the indirect function for future proof data entry.

Lock headers and side names in large spreadsheets with freeze panes, using top row, first column, or both, then unfreeze to return to normal scrolling.

Create a website-like workbook in Microsoft Excel with an interactive index sheet and clickable links to each sheet, plus a home button for instant navigation.

Master conditional formatting in Excel to highlight trends, outliers, and risks using rules, data bars, icons, and custom formulas, with examples on a profit and loss statement.

Discover how ready-made Excel templates save time and provide professional, auto-updating workbooks with built-in formulas, formatting, and dashboards, so you can replace data and learn by reverse engineering.

Master printing in Excel by controlling page size, margins, scaling, and page breaks. Set landscape, choose A4 or letter, center content, and scale to fit one page, using print preview.

Set a print area to print the first 100 rows, and repeat the header on every page. Use page break preview to create four pages of 25 rows with headers.

Learn to print a 36-month Excel report with repeated headers, print titles, and adjustable page breaks, aligning the print order with how the audience reads the data.

Insert professional headers and footers in Excel reports with date, time, file or sheet names, and page numbers, then adjust margins, scaling, printing areas, and repeating headers.

Pivot tables instantly summarize large data into an interactive report by region and month. Create one by inserting the pivot table and dragging region to rows and sales to values.

Build your first pivot table to summarize total sales by region, using drag-and-drop fields in rows and values, and explore value settings for sum, count, and average.

Customize your pivot table by placing region and category in rows and columns to create a two-dimensional view, nest fields for deeper drill-down, and manage grand totals.

Use pivot table filters to focus on specific data slices like sales by region. Learn to build a base report, apply filters, and reset views to compare Emma's 2024 sales.

Create interactive dashboards by using slicers and timelines to turn a pivot table into a dynamic report, enabling region and category filters with clear, clickable buttons.

Connect one slicer to multiple pivot tables to build coordinated dashboards where region, category, and salesperson slicers update all charts and tables simultaneously.

Create a proper date column by combining month and year for the slicer. Convert range to a dynamic Excel table to enable timeline slicer filters by year, month, and day.

Explore pivot tables to convert numbers into insights with value field settings, show values as percent, rank, running totals, and create calculated fields such as average price per item.

Create column and bar charts in Excel to turn sales data into clear visual stories with descriptive titles and data labels for regional comparisons, using live, dynamic charts.

Line charts reveal trends over time in Excel. Use a pivot table to summarize monthly sales, add markers, data labels, and a trendline, and compare regions with distinct colors.

Explore pie and donut charts to depict market share by region with percentages, using a pivot table to prepare data, add data labels, explode slices, and choose bars for categories.

Master combination charts in Excel by building a dual-axis cluster column and line chart to visualize monthly revenue and growth rate, with professional formatting and executive storytelling.

Create bar, column, and 100% stacked column charts in Excel to compare hospital visits by department and by month, add data labels and titles, and reveal insights.

Learn to create histograms and Pareto charts in Excel using age, height, weight, and BMI data. Interpret distributions and the 80/20 Pareto line to identify key groups.

Explore line charts and trend lines to analyze revenue trends for two companies, using R-squared values to compare linear and polynomial fits and reveal growth patterns from June to December.

Explore area charts in Excel to reveal trends over time and department shares using stacked and 100% stacked area charts with a 2024 monthly hospital dataset.

Transform department cost and revenue data into compelling visuals with pie and donut charts in Excel, using basic pie, donut, and multi-level donut charts to compare cost versus revenue.

Create a right-side half doughnut chart series for each department to show percent to target and revenue gap, using a compact KPI dashboard with concentric rings and a helper table.

Use scatter charts to reveal the relationship between spend and sales, add a trendline with r-squared, and predict outcomes; extend with bubble charts for three variables: spend, sales, and reach.

Compare two scatter charts to read R squared and interpret strong versus weak relationships, using a real dataset to show how traffic relates to leads and scroll depth.

Learn to build a box and whisker chart in Excel to compare swimmers by time, visualize the center and spread, spot outliers, and guide training decisions.

Build a secure, macro-driven data entry system in Excel with a single input row, protected sheet, and password-based access, using data validation, grouping, and automatic sorting for reliability.