Formulas

Excel 3-D Formulas

With Excel 3D formulas you get to combine data from multiple worksheets into one summary sheet. This article includes a bonus Excel hack which shows you how to use wildcards in 3D reference formulas.

Excel Calendar with Holidays and Appointments

Excel Calendar with Holidays and Appointments This week’s post is a special post because it comes directly from the super-brain of one of our XelPlus community members, Adam Weaver. Adam holds both a PMP certification (Project Management Professional) and an RMP certification

Excel’s XLOOKUP – 5 Examples

Excel's XLOOKUP 5 Examples By now, you may have read about Excel’s new super lookup function called XLOOKUP. XLOOKUP has the promise of becoming the only lookup function you’ll ever need for virtually any lookup problem you encounter.  This will be a

Excel Lookup to the Left with XLOOKUP

Left Lookup in Excel with XLOOKUP (made easy) When users learn to perform a lookup in Excel, it doesn’t take long before a situation arises that causes the user to ask… “How do I perform a lookup to the LEFT?” Because most

Send Email from Excel with Hyperlink Formula

Send Email from Excel with a Hyperlink This post is about creating an email with an Excel formula. “But I already know how to do that; it’s called Insert – Hyperlink”. Don’t click away so fast.  We will put our typical XelPlus

Top 5 Excel Interview Questions

Top 5 Excel Interview Questions Over the past three decades, Excel has become the de facto standard spreadsheet program for businesses and individuals around the world.  Excel accounts for an estimated 800 million users which translates to approximately 80% of all spreadsheet

Excel XLookup Explained

Excel XLOOKUP Explained (Goodbye VLOOKUP!) In this post, we will examine Excel’s BEST function for performing a lookup… We’re going to look at how the new (upcoming) XLOOKUP function solves common lookup problems typically solved by older functions like… LOOKUP VLOOKUP HLOOKUP

MAXIFS MINIFS with Multiple Criteria

Excel MAXIFS MINIFS (MAX MIN with Multiple Criteria) Finding the largest or smallest value in a set is one of the first tasks beginning Excel users discover.  Just after the SUM function, the MAX and MIN functions quickly become one of the

Excel Hyperlink

ALL YOU Need to Know About Excel HYPERLINKS (Function & Feature) Hyperlinks!  They’re everywhere…even in Excel! “But Excel isn’t a Web browser.  How can hyperlinks be of any value?” Here are the skills we will learn to take advantage of Excel hyperlinks:

Excel Dynamic Arrays Filter Function

LOOKUP ALL values b/w two dates (Excel Dynamic Arrays Filter Function to return many match results) Extracting records from a data set that matches defined criteria is a skill most users acquire early in their learning.  This usually takes the form of