Excel made easy
Database of Excel tips and tutorials.
Latest Excel Tips and Tutorials
XLOOKUP with Multiple Criteria
In order to perform an XLOOKUP with multiple Criteria, you need to concatenate the lookup values and arrays. In our example, this is achieved by using “&” between […]
Continue readingSiteground vs Cloudways in 2022
Life with SiteGround We are going to look at our experience between SiteGround vs Cloudways in 2022. Excelbuddy has been hosted at SiteGround since early 2017. Before Siteground, […]
Continue readingCalculate Steel Pricing by hundredth weight (CWT)
Learn how to quickly calculate steel pricing by hundredth weight (CWT) using the following formula. For a quicker option, download the demonstration file. Quickly download the spreadsheet: Calculate […]
Continue readingPassword Protect Excel Sheets
Learn how to quickly password protect an Excel Sheet. In Excel, you can quickly set password protection to any document. When a user, including yourself, opens the protected […]
Continue readingPV Function in Excel (Present Value)
The PV function in Excel returns the present value of an investment. The alternative function is the FV function (Future Value). The PV Function is used to obtain […]
Continue readingLearn about XLOOKUP
Learn how to use the XLOOKUP function in Excel. See for yourself why this new function makes Excel that much easier.
- XLOOKUP with Multiple Criteria
Perform an XLOOKUP with multiple Criteria using concatenate features in Excel - XLOOKUP Horizontal Lookup
With XLOOKUP, you no longer have to use the very limited HLOOKUP function. - XLOOKUP Function in Excel
XLOOKUP replaces VLOOKUP AND HLOOKUP permanently! - Fix XLOOKUP #SPILL Error
Learn to easily fix an XLOOKUP #SPILL Error in Excel.
camera tool ceiling criteria date DAYS dynamic effect end_date exact format_text holidays index indirect ltv mass delete match minute months multiple named ranges number num_digits pmi pmt range range_lookup return_type rounding search_key second separate serial_number significance start_date Subtract if sumif sum_range table text tips value weekend xlookup year _xlfn