08 6210 8500
by Wyn Hopkins How and why to use XLOOKUP It’s August 2019 and we get our first glimpse of this glorious new function. In May 2016 I raised a UserVoice request to create a simpler and safer version of VLOOKUP and INDEX MATCH. As of May 2020 many Office 365 users now have it, and [...]
Dependent Drop Down Box How to do one of those trickier tasks in Excel: set up a drop down box that is dependent on the result of another drop down box. The scenario If coffee is selected from drop down A then I want a list of coffee types to appear in drop [...]
Easy Cumulative totals in Tables The single greatest advancement in Excel in the last 10 years was the introduction of Tables. Yet although Tables were introduced in Excel 2007 there is still a huge number (I'd even say the majority) of Excel users that don't know how to create tables or understand what they do. This [...]
By Wyn Hopkins This simple tip may save you a lot of time and effort, but it must be used carefully. With the arrival of Excel 2013 we were finally able to easily split Excel between two screens and happily copy and paste between the two with full paste capability and without the worry of worksheet [...]
Depreciation is one of those concepts that sounds easy and simple … until you try to put it into a financial model! In this blog, we start with Excel’s standard depreciation functions, then show two much better, more functional and more elegant ways to calculate depreciation. 1. Excel Functions Excel has some [...]
Introducing SUBTOTAL SUBTOTAL is an incredibly useful function for producing reports … yet it’s relatively unknown. If you have a list of values that are in categories and you want a subtotal for each category, then a grand total at the bottom, it’s so much better & far more reliable than using SUM. The key [...]
Apologies for the Dad joke above (not really), but in this article, I’ll show you how you can easily get data labels on all your data series, even if you have LOTS. All it takes is a little VBA code. In the data set below, I’ve made up some stats about how [...]
Sticking with the theme of the health of your spreadsheet, have you ever notice spreadsheet become inexplicably bigger? Suddenly becoming 20MB instead of 2MB. One cause is unused rows and columns. How do I check and how do I fix it? Simple, on each worksheet in your file press End then Home. Your cursor will [...]
Excel 2013 New Features of Excel 2013 By Sean Vincent Dual Screen Use One of the simplest updates to Excel in the latest version is the ability to now have 2 separate Workbooks open on shared screens. This allows much greater flexibility in the work environment. Rather than having to Tab between workbooks (potentially [...]
Pay my invoice
