Explore the Excel interface, learn how to write formulas and functions, master relative, absolute, unmixed referencing, and use shortcuts to write formulas faster.

Learn to use Excel functions such as sum, average, max, min, and count, and discover multiple ways to write them from the formulas tab to the insert function menu.

Master VLOOKUP to find data to the right in a table by using four arguments—lookup value, table array, column index, and exact match.

Explore the key limitations of VLOOKUP and HLOOKUP, including direction constraints, column/row number reliance, and sensitivity to table structure, and learn how index match offers a robust alternative.

Learn to perform actions in Excel based on conditions using the if function, including nesting ifs with and and or, plus if error and count ifs.

Explore key comparison operators—greater than, less than, equal to, greater than or equal to, less than or equal to, and not equal to—and learn how they drive logical functions like IF to evaluate conditions.

Combine the if function with or and and to classify survey feedback on weight loss and energy into unsatisfactory, satisfactory, and standard met using logical tests and visual tick indicators.

Learn to count specific values with the countifs function by applying multiple criteria ranges and criteria, locking ranges, and counting items based on color, product, or region.

Master text case in excel using upper, lower, and proper functions to convert strings to uppercase, lowercase, or proper case, and apply these tips to clean data efficiently.

Learn to use Excel's len to count characters (spaces included) and the difference between search and find for locating text within strings, with a second-dash example using a start position.

Learn to extract job titles from dash-delimited strings using len, search, and switch with right, left, and mid in excel, and apply proper and lower for formatting.

Master conditional formatting in Excel by applying highlight cell rules, top bottom rules, data bars, color skills, and icon sets, then use formulas and manage rules to visualize data effectively.

Master conditional formatting in Excel. Access it from the home tab and apply highlight cell rules, top bottom rules, data bars, color skills, and icon sets.

Learn to apply conditional formatting with highlight cell rules using text that contains, then switch to linking the target text to a cell for dynamic highlighting via a dropdown.

Apply conditional formatting to visualize data with data bars, color skills, and icon sets, using monthly sales, expenditures, and net profit to reveal performance patterns.

Learn how macros automate repetitive tasks in Excel by recording and running macros, and explore absolute versus relative macro recording, plus an introduction to VBA and the Visual Basic Editor.

Discover how Excel macros let you record a sequence of actions with the macro recorder and execute them with a single click to automate routine tasks.

Learn to record your first Excel macro, set a name and shortcut, choose where to store it, describe its purpose, and run or edit it to automate formatting tasks.

Discover how pivot tables in Excel summarize large data sets, build a table with fields, include totals and grand totals, and use slices and timelines to filter insights.

Select a data cell, insert a pivot table, let Excel detect the source range, adjust if needed, and place the pivot table on a new or existing worksheet.

Explore pivot table style options by using the design tab to apply styles, toggle row and column headers, and enable banded rows or columns to customize your pivot table.