This is a real-life example of Excel's VSTACK function. Quickly stack data from multiple sheets (even as many as 15 sheets!), filter out blank cells and even sort the summary table.
Learn how to sum values based on multiple criteria in a single columns. You probably know that you can use SUMIFS to sum values based on criteria from multiple columns. But there is also an easy way you can sum values if your criteria is in the same column.
Learn how to calculate the difference between days in Excel and exclude any week days, weekends and holidays. It's easy to exclude weekends and holidays, but how do you exclude ANY weekday of your choice? Check out the complete blog post because there's a trick you can use.
In this article, I summarize the MOST COMMON Excel questions that are currently asked during interviews. This covers positions such as business or MIS analyst, Data Analyst, Financial Analyst or more senior positions. You'll be surprised at the level of Excel that's currently required for some of these positions.
Create an Excel report with the top values and categories. What makes this impressive is that you will allow the user to define how many records are returned, such as the Top 5, Top 10, or any number they choose.
Create an automatically sorted Excel bar chart that ALSO lets you hide and show categories based on a flag in the cell. It's super easy with Excel dynamic arrays.
Excel's New Dynamic Array FILTER Function The FILTER function can be thought of as the new power lookup function; in many cases replacing the traditional VLOOKUP and INDEX/MATCH functions when searching for data in a table. Situations you will benefit from when
A Dashboard with 4 Strange Features (Excel Hash 2019) Welcome back to another edition of Excel Hash! Last year (that’s right, I said “last year”), myself and several other prominent Excel MVP online personalities participated in a challenge where we are given
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
Get ALL External Links with THIS Simple Excel Trick (as NEVER seen before!) A terrific feature of Excel is the ability to pull data from external sources, like other Excel files. But with any benefit, there comes a cost. In this case,