Formula tracing is a fantastic visual tool in Excel you can use to understand 1) which cells a given formula is referencing and 2) whether a given cell (or range of cells) is used by a formula elsewhere. Both have their uses, but it’s certainly the latter I get the most use from. Read on Read More
When you first start using Excel, you’ll quickly become familiar with using basic functions such as SUM, COUNT, MIN, AVERAGE Before long, you’ll be using VLOOKUP’s, IF’s and creating Pivot Tables in order to start bringing you data to life. However, it’s around this phase that I often see people plateauing in their Excel learning Read More
I’ve written before (albeit briefly, as more of a footnote) about finding the difference between two dates in Excel. This approach, of subtracting one date from another is fine if you want to know the number of days between two dates – and of course you can go one step further and use NETWORKDAYS to Read More
From time to time, you might have to work with both Excel and Google Sheets interchangeably. Generally, opening fairly standard Excel Files in Google Sheets works fine – Google has strong support for most Excel functions. More complex or large worksheets generally fail to open in Google Sheets – not ideal, but at least there’s no hiding from Read More
Microsoft have this month released an update which addresses a small, yet incredibly annoying ‘feature’ when working with csv files in Excel. Read on to learn more. Read More
This update shows a quick and simple example of how to use the EOMONTH function to get the first, and last, date of a given month. Read More
We currently use a mixture of Excel and Google Sheets. Not ideal, but it’s important that any output I create can behave with both platforms, there are inherent differences in the platforms. Some of these differences simply can’t be accommodated for. Others, however, can be worked around From time to time, I need my document Read More
Use this trick to create use the same Named Range across multiple worksheets, but with each worksheet holding a different value Read More
Learn about the different techniques for joining Text Strings in Excel, including the excellent new TEXTJOIN function Read More
This post will show you how to populate a drop-down menu in Excel with values, based on the value selected in another drop-down menu – all without touching VBA Read More