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
Populating one Drop Down based on the Selection of Another in Excel – Without VBA
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
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
Using NETWORKDAYS to calculate the number of business days between two dates in Excel
NETWORKDAYS (That’s Net Work 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.
Add Labels to Outliers in Excel Scatter Charts
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.
Format or Remove Borders from a Slicer or Timeline in Excel
Changing the formatting, or removing completely, the borders from Excel Slicers and Timelines isn’t obvious – read on to find out how
Creating a Clustered Stacked Chart in Excel – Excel 2013
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.
Inline-Replies, and Why Outlook 2013 Has Gone Blue
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.
Most Read Articles
