by admin | Oct 10, 2012 | Case Studies - How To
As part of the Excel Hero Academy that I’ m now doing, one of the first things we did was learn more about named ranges. Daniel Ferry showed us a really useful trick that allows you to view your ranges (with their names on their sheet). The trick is to reduced...
by admin | Sep 25, 2012 | Case Studies - How To
In Part One of this blog posting, we’ve already looked at using Conditional Formatting to identify duplicates (and unique values). In the second scenario, I’m going to look at where we have a list of rooms/dates/times and we want to see if there are any...
by admin | Sep 25, 2012 | Case Studies - How To
In this post, I’m going to show you how to locate duplicates in Excel. I’m going to look at two scenarios. In the first scenario – we just have to identify duplicate/unique values in a list. For this I’m going to use Conditional Formatting . I...
by admin | Sep 5, 2012 | Case Studies - How To
In this video, I’m going to show you how to construct a simple cash flow statement that you can use to keep a running balance of your money coming in and out. It’s based in Excel 2010 but the formulas are the same in all versions. It’s very useful if...
by admin | Aug 27, 2012 | Case Studies - How To
I was recently asked about generating random numbers in Excel – for example if you have a list of numbered questionnaires and you need to randomly check 20 of them, how can you use Excel to the generate random number required. Today I’m not going to use...
by admin | Aug 20, 2012 | Case Studies - How To
In a previous post, I showed you how to use conditional formatting in Excel to highlight entire rows based on a specified criteria. In this post, I am going to show you how to use the AND function to conditionally format rows based on multiple criteria. [flowplayer...
