Towards the top-left corner of every Salesforce page, you’ll see this icon: What do you call this thing? This icon is actually called the App Launcher, see below. Click on…
Posts published by “Ian Jamieson”
In this blog post, we’ll take a look at the PROPER function in Excel, which is guaranteed to save you time and effort when handling text data. The PROPER function…
I only recently found out about the EDATE() function in Excel and I love it. I wish I’d known about it long before now. It’s nice and simple to create…
What did we do before Excel offered Flash Fill? I can’t quite recall but I do remember it involved lots of Find, Left, Right and other formulas. Don’t know what…
One of the simplest and most effective functions of Excel is Conditional Formatting. Data can become much more easily understood in a few clicks. What is conditional formatting? It’s when…
The =SEARCH and =FIND functionality in Excel may sound very similar, and they are. I use =SEARCH when I’m trying to find text regardless of case i.e. upper case or…
There are a number of ways to use formulae to calculate a person’s Age from their Date of Birth (D.O.B.) in Excel but I just want to share my preferred…
If you are looking to analyse stocks and shares in Excel then take a look at the Stock Data Type available in Excel 365. I wish this had existed 20…
Do you want to know how to create dropdowns in Excel cells for users to select their input? Or forgotten how to do it? Then read on and I will…
The Text To Columns functionality in Excel is useful if you want to split a cell by a character within a cell. For example, in the data below we want…