by admin | Nov 30, 2020 | Tracking Training Records in Excel
A while back one of my customers asked me about a way to create a unique ID from a customer’s name and a random number. Of course I was intrigued and using a combination of Left(), Right() and Randbetween() helped her do just that. Yum, I do love me an Excel...
by admin | May 3, 2012 | Excel Path - Step by Step
Excel min In this post we are going to look at the min function (which finds the lowest value in a list) [flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/05_min_demo.m4v’] As always, here is a file you can practise...
by admin | Apr 30, 2012 | Excel Path - Step by Step
How to add in Excel 2010 (and 2007) [flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/01autosumdemo.m4v’] This post will show you how to sum in Excel (2007/2010). We will be using the Excel sum...
