Formulas & functions
How a function works, with worked examples you can paste.
- PowerShell Excel Alignment: Center, Left, and Right TextYes. In PowerShell on Windows, use Excel’s COM automation to set a cell range’s HorizontalAlignment and, if needed, VerticalAlignment properties. For example,…
- Power Automate Excel Table Filter: How It WorksTo filter an Excel table in Power Automate, add the Excel Online (Business) action List rows present in a table, select the…
- Pop-Up Calendar Excel Formula: What WorksExcel has no formula that opens a true pop-up date picker when you select a cell. For a formula-based calendar display in…
- Percentage Change Calculator Formula in Excel: ExamplesTo calculate percentage change in Excel, subtract the old value from the new value, then divide by the old value: =(B2-A2)/A2. With…
- Percent Change Calculator Excel Formula and ExamplesIn Excel, calculate percent change as (new value − old value) ÷ old value. If the old value is in B2 and…
- Packing List Excel With Formula: Build a Smart ChecklistYes. In an Excel packing list, put each item in column A and its packing status in column D; with item names…
- Pandas read_excel vs read_csv: Choose the Right ReaderUse pandas.read_csv() for delimited text files such as CSV, and pandas.read_excel() for Excel workbooks such as XLSX. The key difference is that…
- Number Value in Excel: Use the VALUE FunctionIn Excel, use the VALUE function to convert text that represents a number into a number Excel can calculate with. If the…
- Number Format in Concatenate Excel: Keep Dates & DecimalsExcel concatenation turns numbers into text, but it does not carry over the number format shown in the source cell. To keep…
- NPV vs PV in Excel: Formulas and Key Differences ExplainedIn Excel, use NPV to discount a series of periodic cash flows, but keep a time-zero investment outside the function and add…
- Multiply Key in Excel: Use the Asterisk or FormulaIn Excel, multiplication uses the asterisk key (*) inside a formula, not the letter x or the × symbol. Start with an…
- Excel Ordered List Formula: Number Rows AutomaticallyIn Excel for Microsoft 365, enter =ROWS($A$2:A2) in B2 when your list items are in A2:A20, then fill the formula down to…
- MS Excel Formula List: Essential Functions and ExamplesAn MS Excel formula list is a guide to the expressions you can enter in a cell to calculate, compare, find, or…
- Excel FILTER Function: Multiple Criteria and ExamplesYes. In Microsoft Excel for Microsoft 365, use the FILTER function with multiplication (*) to require multiple conditions at once (AND), or…
- Excel Filter Shortcut Key: Apply, Toggle, and Use FiltersIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter on or off for the selected data range. To open…
- Midpoint of Two Dates in Excel: Formula and ExamplesTo find the midpoint of two dates in Excel, enter the start date in A2 and the end date in B2, then…
- MIN Function for Dates in Excel: Find the Earliest DateTo find the earliest date in an Excel range, use the MIN function: if your dates are in B2:B10, enter =MIN(B2:B10). Excel…
- MID and FIND in Excel: Extract Text Between DelimitersTo extract text between parentheses in Excel, use MID with FIND to locate the opening and closing characters. With a string such…
- Excel XLOOKUP Multiple Criteria: Formulas and ExamplesYes. In Microsoft Excel for Microsoft 365, XLOOKUP can match multiple criteria by multiplying comparison tests so that a row qualifies only…
- Microsoft Excel TRIM Function: Remove Extra SpacesMicrosoft Excel’s TRIM function removes leading and trailing ordinary spaces from text and reduces repeated spaces between words to a single space.…
- Microsoft Excel RANK Formula: How to Rank ValuesIn Microsoft Excel for Microsoft 365, use RANK.EQ to rank a number against a list: with scores in B2:B10 and the first…
- Microsoft Excel Profit and Loss Template: Setup & FormulasYes. In Excel for Microsoft 365 on Windows, choose File > New and search for “profit and loss” or “income statement” to…
- Microsoft Excel LAMBDA Function: How It WorksMicrosoft Excel’s LAMBDA function lets you create reusable custom functions using an Excel formula, without writing VBA. For example, you can define…
- Microsoft Excel LEFT Formula: How to Extract Text from CellsMicrosoft Excel’s LEFT function returns a chosen number of characters from the beginning of text. With the source text in A2 and…
- Excel INDEX MATCH Lookup: Formula, Examples, and TipsIn Microsoft Excel for Microsoft 365, INDEX and MATCH work together to look up a value: MATCH finds the position of a…
- Excel Interpolate Function: How to Calculate ValuesMicrosoft Excel does not have a built-in function named INTERPOLATE. To estimate a value between two known points, use a linear interpolation…
- Excel IFERROR Function: Syntax, Examples, and TipsMicrosoft Excel’s IFERROR function returns a value you choose when a formula produces an error; otherwise, it returns the formula’s result. For…
- Excel INDEX MATCH Formula: How to Use It in Microsoft ExcelIn Microsoft Excel, combine INDEX and MATCH to find a value in one range and return the value from the same position…
- Excel INDEX and MATCH: Find Values in Large WorksheetsIn Excel, INDEX and MATCH work together to find a value in one range and return the corresponding value from another. With…
- Microsoft Excel: How to Sort Dates in a Table EasilyTo sort dates in Microsoft Excel for Microsoft 365 on Windows, select a cell in your date column and choose Data >…