Formulas & functions
How a function works, with worked examples you can paste.
- How to Capitalize Every Word in Excel with a FormulaTo capitalize every word in Excel, enter =IF(A2="","",PROPER(A2)) in an empty column beside the text in A2, then fill the formula down.…
- Capitalize Each Word in Excel: Shortcut and FormulaExcel does not have a single keyboard shortcut that changes selected text to Proper Case. To capitalize the first letter of each…
- Calculate Number of Years in Excel: Dates and FormulasTo calculate the number of complete years between two dates in Excel, enter the earlier date in A2 and the later date…
- How to Calculate OT Hours in Excel: A Formula GuideTo calculate daily overtime in Excel, put a shift’s start time in C2, end time in D2, and unpaid break length in…
- Calculate Age in Excel by Birth Date: Exact FormulasTo calculate age in completed years, put the birth date in A2 and enter =DATEDIF(A2,TODAY(),"Y") in another cell. Excel returns the number…
- Calculate Hours in Excel: Formulas and Time FormatsTo calculate elapsed hours in Excel, put the start time in A2 and end time in B2, then enter =(B2-A2)*24 in C2…
- How to Calculate Numbers in Excel With Simple FormulasTo calculate numbers in Excel, start a cell entry with an equals sign and use cell references or values with an arithmetic…
- Calculate Dates in Excel From Today With Simple FormulasTo calculate a date a set number of days from today, enter =TODAY()+30 in any blank cell, such as B2, to return…
- XLOOKUP in Excel: Build a Formula Step by StepTo find a value in one Excel column and return its match from another, put the lookup codes in A2:A6, prices in…
- How to Build a VLOOKUP in ExcelTo build a VLOOKUP, enter a formula that names the value to find, the lookup table, the return-column number, and whether you…
- Weighted Average in Excel: Formula, Steps, and ExamplesTo calculate a weighted average in Excel, multiply each value by its corresponding weight, add those products, then divide by the total…
- XLOOKUP in Excel: How to Build and Use the FormulaTo look up a product price by ID, put the ID to find in E2, the product IDs in A2:A6, and prices…
- How to Auto Number Rows in Excel: Formulas and FillTo auto number rows in Excel, enter a row-based formula in the first cell of your numbering column and fill it down.…
- Excel Filter Shortcut Key: Turn Filtering On or OffTo apply a filter in Excel for Microsoft 365 on Windows, click a cell in your data range and press Ctrl+Shift+L. Excel…
- Horizontal Filter in Excel: How to Filter Across ColumnsTo filter data arranged across columns in Excel for Microsoft 365, use the FILTER function with a horizontal condition row; ordinary Data…
- Duplicate Filter in Excel: Find and Review Repeated ValuesTo filter duplicate values in Excel, add a helper column with a COUNTIF formula, then turn on the filter and show only…
- How to Apply a Filter in Excel to Find Data FastTo apply a filter in Excel, click a cell in your data, then choose Data > Filter. Use the dropdown arrow in…
- How to Align Dates in Excel: Format and Match ThemTo align dates visually, select the date cells and choose an alignment option in Home > Alignment, such as Align Left, Center,…
- How to Add a Sequence of Dates in Excel: 3 Easy WaysTo add a sequence of dates in Excel, enter a starting date and the next date in two adjacent cells, select both,…
- How to Add in Excel Using a Formula with SUM and +To add numbers in Excel, enter a formula in the cell where you want the total. With values in B2:B6, select B7…
- Add in Excel Without a Formula: Practical Ways to TotalTo add numbers in Excel without putting a formula in a cell, select the numbers and read their total on the status…
- Add in Excel Without Hidden Rows: Use the SUBTOTAL FormulaTo add only the visible rows in an Excel range, use the SUBTOTAL function with function number 109. For example, if the…
- How to Add Hours in Excel: Formulas and Time FormatsTo add hours in Excel, enter each duration in a cell, total the cells with SUM, then format the result as [h]:mm…
- How to Add Numbers in Excel With the SUM Formula: A GuideTo add a range in Excel, select the cell where you want the total and enter =SUM(B2:B4). If B2 contains 4, B3…
- How to Add Filter Options in Excel: A Step-by-Step GuideTo add filter options in Excel for Microsoft 365 on Windows, select a cell in your data, then choose Data > Filter.…
- Add a Border in Excel Using a Formula: Step-by-StepTo add a border based on a formula in Excel, use conditional formatting: select the cells, choose Home > Conditional Formatting >…
- How to Add a Filter to a Column in ExcelTo add a filter in Excel for Microsoft 365 on Windows, click a cell in your data, choose Data > Filter, then…
- How to Add a New Line in Excel CONCATENATETo add a new line between text values joined with Excel’s CONCATENATE function, insert CHAR(10) between the cell references, then turn on…
- WORKDAY in Excel: Calculate Dates Without WeekendsIn Excel, WORKDAY calculates a date a chosen number of working days before or after a start date, skipping Saturday and Sunday…
- Add Leading Zeros in Excel: Formatting and FormulasTo show a zero before a number in Excel, select the cells and apply a custom number format such as 00000; Excel…