Using Formula Tracing in Excel
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
Using the Undocumented DATEDIF() Function in Excel
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
Battery Health Status Report in Windows (8,8.1 and 10)
Anyone who routinely uses a laptop knows that the batteries in them don’t last forever. This is an inherent part of the Lithium-ion batteries used in much of today’s tech. It can therefore be helpful to get a better understanding of the current health of the battery – especially if you’re selling, or have just
Improvements in how CSV File Saves are Handled in Excel
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.
Using the New Shape Maps in Microsoft PowerBI
Could the new Map Shapes visualisation be a game-changer for PowerBI? I’m going to look at what the new feature does, and why it could well be. Although this is, I think, the first time I’ve written about Microsoft’s PowerBI, anyone who knows me personally will know I’ve been a huge fan, following its progress
Using EOMONTH() to get the First and Last Date of a Given Month in Excel & Google Sheets
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.
Determine if a file is open in Excel or Google Sheets
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
Using TEXTJOIN and CONCATENATE for combining Text Strings in Excel
Learn about the different techniques for joining Text Strings in Excel, including the excellent new TEXTJOIN function
Showing Data Bars as a ‘Proportion to Total’ in Excel
Use this trick to show Excel Data Bars (the in-cell micro-chart) as a ‘percentage to total’ rather than relative to the max value
Creating Sunburst & TreeMap Charts in Excel 2016
Familiarise yourself with two of Excels fantastic new Chart Types – the Sunburst, and Treemap (collectively known as Hierarchical charts)
Most Read Articles
