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 VBARead More
NETWORKDAYS (That’s NetWork Days, not Network Days) is a versatile spreadsheet function that lets you calculate working days between two dates, allowing for weekends, public holidays and more.Read More
Scatter charts are a great way to present the relationship between two data points
In my example, I’m using a scatter charts to monitor student test results – I want to compare their latest test score against how that score has changed from their last test.
Learn how to create a combined Stacked, Clustered Chart in Excel. One of the trickier charts to get to create in Excel – but is certainly possible.Read More
For many years, Office has followed a consistent colour scheme for its applications – Blue for Word, Green for Excel, Red/Pink for Access etc. And Outlook was always a yellow/orange colour. 2010 & 2007 2003 2000 ’95 Well, you get the idea. And the application itself would also follow this same yellow hue.Read More