Microsoft Excel Formulas and Functions: Beginner to Expert

Learn to manipulate text in Excel using concatenate to join strings, left, right, and mid to extract characters, find to locate positions, and replace to modify values in reports.

Master text formatting and data cleaning in Microsoft Excel by formatting text, highlighting high sales, trimming spaces, deduplicating, and standardizing case with upper, lower, or proper.

Explore how to use Excel's logical functions, including IF, AND, OR, NOT, IFERROR, and IFS, to evaluate student scores, determine pass or fail, handle errors, and assign grades.

Explore conditional formatting in Microsoft Excel to visually highlight data with rules, data bars, top/bottom rules, icon sets, and custom formulas for insights.

Explore date and time functions in Excel—today, now, date, time, and datedif—to automatically display current dates, compute durations, and manage deadlines in spreadsheets.

Learn to calculate durations between dates and manage deadlines in Excel using formulas and functions. Create start dates, end dates, durations, and deadlines for projects to track schedules.

Master vlookup, hlookup, index, and match to quickly retrieve price, stock, and product details from a table using lookup functions.

Learn how to use XLOOKUP in Excel to search data vertically and horizontally, replacing VLOOKUP, and look up prices by product id or ids from names, including not found handling.

Create a lookup table in Excel using simple data, and apply VLOOKUP and lookup to retrieve price and stock by product ID.

Learn to use standard deviation and variance in Excel to assess data spread. Apply average if and sumif to conditionally analyze data such as delivery times and sales.

Learn data analysis and interpretation in Microsoft Excel using a simple sales dataset—dates, product names, and sales amounts—and apply max, min, sum, and average functions.

Master core financial analysis in Excel using PMT, IPMT, PPMT, NPV, and IRR to calculate loan payments, interest, principal, and investment returns.

Choose the right chart type in Excel to visually compare sales and profits, using column, line, pie, and bar charts, with practical steps to insert and customize.

Format and customize charts in Excel to improve readability and aesthetics by adjusting colors, fonts, and elements like titles, legends, and gridlines; create a column chart from sales and profit.

Learn to add and customize data labels and legends in Excel charts, including data callouts, leader lines, and gradient text options, to clarify sales versus profit.

Learn to summarize and analyze large data sets in Excel using built-in tools and functions, applying subtotals, filters, and charts to reveal totals, averages, and trends for informed decisions.

Explore how to filter large Excel data sets by criteria to display only relevant rows and group data into collapsible sections by category, region, or numeric ranges.

Create pivot charts from a pivot table to visualize sales and profit by month, product, and region using a clustered column chart.

Choose and create the right chart types in Microsoft Excel to visually compare monthly sales and profits, using column, line, pie, and bar charts with axis titles and legends.

Master advanced data analysis techniques in Excel, pivot tables, if analysis, solver, and advanced filters, and use conditional formatting to reveal insights from complex employee data and performance scores.

Learn to use data validation in Excel to restrict numeric inputs to a defined range, such as 80 to 100, preventing invalid data and triggering errors.

Learn to create a drop-down list in Excel using data validation to standardize department entries from a predefined list and prevent errors.