Formulas & functions
How a function works, with worked examples you can paste.
- Sort Dates in Excel by Month and Day, Not the YearTo sort dates in Excel by month and day while ignoring the year, add a helper column with a date key such…
- How to Sort Dates in Excel PivotTables the Right WayTo sort dates in an Excel PivotTable, click a date label, right-click it, and choose Sort > Sort Oldest to Newest or…
- Sort by a Given List in Excel: Custom Order SortingTo sort Excel data in the order of a list you specify, select the full table, choose Data > Sort, and set…
- Sort a Filtered List in Excel Without Mixing Up RowsTo sort a filtered list in Excel, open the filter arrow in the column you want to sort, then choose an ascending…
- Excel Filter Shortcut: Turn Filters On and Use ThemIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter on or off for the current data range. The shortcut…
- Excel TRIM Shortcut: Remove Extra Spaces from CellsExcel has no dedicated keyboard shortcut that runs TRIM on selected cells. To remove extra spaces, enter =TRIM(A2) in a helper column,…
- Excel Filter Shortcut: Turn Filters On and OffIn Excel for Microsoft 365 on Windows, select a cell in your data and press Ctrl+Shift+L to turn filter arrows on or…
- Excel Filter Shortcut: Ctrl+Shift+L and How to Use ItIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter on or off for a selected data range. The shortcut…
- Excel Sequence Number Shortcut: Fast Ways to Fill a SeriesExcel has no single dedicated shortcut key that automatically numbers a sequence. In Microsoft 365 for Windows, enter the starting number, select…
- Excel Filter Shortcut: Turn Filters On and Use ThemIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter on or off for the current data range. Once the…
- Excel Filter Shortcut: Turn AutoFilter On or OffIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter on or off for the current data range. On a…
- Excel TRIM Shortcut: Remove Extra Spaces in Cells QuicklyExcel has no dedicated keyboard shortcut for the TRIM function. To remove extra spaces from text in a cell, enter =TRIM(A2) in…
- Excel Uppercase to Lowercase: Shortcut and FormulaExcel has no dedicated keyboard shortcut that changes selected text from uppercase to lowercase. The dependable method is to enter =LOWER(A2) in…
- Excel Align Text Shortcut: Left, Center, Right & MoreIn Excel for Microsoft 365 on Windows, select the cell or range and press Alt, H, A, L to align text left,…
- Excel Filter Shortcut: Apply, Use, and Clear FiltersIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn column filters on or off for the current data range. Select…
- Hide Duplicate Rows in Excel with a Filter Step by StepTo hide exact duplicate rows in Excel without deleting them, select the full data range, then choose Data > Sort & Filter…
- Sequence Number Formula in Excel: Methods That WorkFor a numbered list starting in cell A2, enter =ROW()-1 and fill the formula down; the first result is 1, followed by…
- Sales Comparison Formula in Excel: Examples & TipsFor a sales comparison in Excel, calculate the change as new sales minus old sales, then divide that difference by old sales…
- ROUND vs ROUNDUP in Excel: When to Use EachUse ROUND when you want a number rounded to the nearest place, and ROUNDUP when you need to move away from zero…
- ROUNDUP Number in Excel: 10 Useful Ways to Round UpTo round a number up in Excel, use =ROUNDUP(number,num_digits); for example, with a value in A2, =ROUNDUP(A2,2) rounds it away from zero…
- RIGHT and SUBSTITUTE in Excel: Extract a Last NameTo return the final word in a full name in Excel, enter =TRIM(RIGHT(SUBSTITUTE(TRIM(A2)," ",REPT(" ",LEN(TRIM(A2)))),LEN(TRIM(A2)))) in B2, assuming the full name is…
- How to Round Negative Numbers to Zero in ExcelIf your values are in A2 and you want every negative number to become zero while leaving zero and positive numbers unchanged,…
- Return Weekday Dates in Excel: WORKDAY and ExamplesTo return the next weekday date in Excel, use the WORKDAY function. If A2 contains Friday, January 9, 2026, and F2:F4 contains…
- Excel PivotTable Report Filter: Setup and ExamplesA PivotTable report filter lets you show only the records that match a chosen item, without changing or deleting the source data.…
- Remove Filter From an Excel Table: Steps and OptionsTo remove the filter arrows from an Excel table in Microsoft 365 for Windows, click a cell in the table, open Table…
- Rank Without Ties in Excel: Formula and ExamplesTo rank numeric values without ties in Excel, combine RANK.EQ with COUNTIF. With values in B2:B10 and the result in C2, enter…
- Rank Names in Excel: Formulas and Tie RulesIf names are in A2:A20 and their scores are in B2:B20, enter =RANK.EQ(B2,$B$2:$B$20,0) in C2 and fill it down. Excel then assigns…
- PV vs NPV in Excel: Which Function Should You Use?Use Excel’s PV function to find the present value of regular payments or a future balance; use NPV to discount a series…
- Pull Numbers From Text in Excel: Formulas & MethodsYes. In Excel for Microsoft 365, you can pull every digit from a text cell with a formula, then return the result…
- Profit and Loss Statement in Excel: Build It RightTo make a profit and loss statement in Excel, organize income and expense transactions in a dated ledger, list matching categories on…