Skip to content
- Export Notion Table to Excel: 3 WaysYes, you can export a Notion table to Excel. The simplest method is to open the table’s menu (the three dots at…How-to basics
- Export KML to Excel: 4 Easy WaysYes, you can export KML to Excel, and the simplest way is to use a free online converter or Excel’s built-in 3D…How-to basics
- Export Import Excel Revit: How to Move Data Both WaysYes, you can export data from Revit to Excel and import Excel data back into Revit, but the process is not a…How-to basics
- Export EndNote to Excel: 4 Easy WaysYes, you can export references from EndNote to Excel. The fastest method is to use EndNote’s built-in “Export References” feature to save…How-to basics
- Export Email to Excel: 4 Quick WaysYes, you can export emails to Excel. The quickest way is to save the email as a CSV file from your email…How-to basics
- Export AutoCAD Table to Excel with FormulasYes, you can export an AutoCAD table to Excel with formulas intact, but only if you use the Export command (EXPORTTABLE) or…Formulas & functions
- NPV Formula in Excel: How to Use ItThe NPV (Net Present Value) formula in Excel is =NPV(rate, value1, [value2], ...), where rate is the discount rate per period and…Formulas & functions
- SUMPRODUCT in Excel: How It Works & ExamplesThe SUMPRODUCT function in Excel multiplies corresponding values in two or more arrays and then adds the results, returning a single number.…Formulas & functions
- PV Formula in Excel: How to Use ItThe PV function in Excel calculates the present value of a loan or investment based on a constant interest rate. You enter…Formulas & functions
- PMT Formula in Excel: Full Guide with ExamplesThe PMT function in Excel calculates the periodic payment for a loan or investment based on a constant interest rate and a…Formulas & functions
- Excel LAMBDA Function Explained SimplyThe LAMBDA function in Excel lets you create custom, reusable functions using standard Excel formulas, without needing VBA or macros. You define…Formulas & functions
- IFERROR Formula in Excel: How to Use ItThe IFERROR function in Excel returns a custom result when a formula produces an error, and the formula’s normal result when there…Formulas & functions
- Excel Yearly Attendance Tracker Template: How to Build OneThe best way to get an Excel yearly attendance tracker template is to build one yourself in about 15 minutes using a…How-to basics
- Excel Zip Extract: How to Open ZIP FilesTo extract a ZIP file in Excel, you do not use Excel itself—you use Windows File Explorer or macOS Finder to unzip…How-to basics
- Excel Yearly Budget Template: How to Build OneYes, you can build a yearly budget template in Excel in about 15 minutes using a simple layout: list your income and…How-to basics
- Excel Y or N in Cell: How to Add Yes/No DropdownsYes, you can put Y or N in an Excel cell, and the cleanest way is a data validation dropdown that limits…How-to basics
- Excel XPS Export Options: How to Save as XPSExcel does not have a dedicated “Export to XPS” button, but it includes XPS as a file format in the Save As…How-to basics
- XLSX or XLS Viewer: Which File Format Should You Use?For viewing spreadsheets, XLSX is the better format in nearly every situation: it is the modern, default format for Excel (since 2007),…How-to basics
- Excel XLOOKUP with Wildcard: How to Use ItYes, XLOOKUP supports wildcards, and you use them exactly like you would with VLOOKUP: put an asterisk (*) for any number of…Formulas & functions
- Excel XLOOKUP with CONCATENATE: How to JoinYes, you can use XLOOKUP with concatenated values by building the lookup value with the & operator or the CONCAT function, and…Formulas & functions
- Excel XLOOKUP Wildcard Search: How to Use ItYes, Excel’s XLOOKUP function supports wildcard characters (* and ?) for partial-match lookups, but you must set the match_mode argument to 2.…Formulas & functions
- Excel XLOOKUP Transpose: How to Flip ResultsTo transpose XLOOKUP results in Excel, wrap the XLOOKUP function in the TRANSPOSE function, like this: =TRANSPOSE(XLOOKUP(lookup_value, lookup_array, return_array)). This flips a…Formulas & functions
- Excel XLOOKUP Wildcard Match: How to Use ItYes, Excel’s XLOOKUP function supports wildcard matching when you set its match_mode argument to 2. In the simplest form, you write =XLOOKUP("*"&A1&"*",…Formulas & functions
- XLOOKUP Return Value: How It Works and ExamplesXLOOKUP returns the matching value from the column or row you specify, based on a lookup value you provide. For example, =XLOOKUP("A-100",…Formulas & functions
- Excel XLOOKUP Not Finding Match? FixesIf your Excel XLOOKUP is returning #N/A or an unexpected result, the most common causes are mismatched data types (text vs. number),…Formulas & functions
- Excel XLOOKUP on Two Criteria: How-ToTo look up a value using two criteria in Excel, use the XLOOKUP function with a concatenated lookup value and a concatenated…Formulas & functions
- Excel XLOOKUP Next Match: How to Get the 2nd ResultTo get the next match with XLOOKUP in Excel, use the match_mode and search_mode arguments together with a helper column, or wrap…Formulas & functions
- Excel XLOOKUP Max Date: How to Find Latest EntryTo find the max date with XLOOKUP in Excel, use the formula =XLOOKUP(MAX(date_range), date_range, return_range). This returns the value from the return…Formulas & functions
- Excel XLOOKUP Multiple Criteria: Return a ValueTo return a value in Excel using XLOOKUP with multiple criteria, combine the criteria into a single lookup value with the ampersand…Formulas & functions
- Excel XLOOKUP Multiple Criteria Boolean LogicYes, you can use XLOOKUP with multiple criteria by building a boolean (TRUE/FALSE) expression that multiplies comparison tests together, then using that…Formulas & functions