by admin | Oct 7, 2013 | Case Studies - How To
One of the issues I come across frequently in class are people who have to work with large amounts of data. That often means a Lot of scrolling and selecting of lists of data and I have often wondered how I could make this easier for people. I have found an answer...
by admin | Aug 21, 2013 | Case Studies - How To
In many cases we need to combine information from multiple sources together. Using the Vlookup function is one way to do this (if we just want to pull in matching information) but sometimes we actually need to add information together e.g. from branches of the same...
by admin | Jul 18, 2013 | Case Studies - How To
In this tutorial I plan to show you how to create a cover page/table of contents for your Excel sheets. i.e. how to create hyperlinks to jump to another worksheet in your workbook. I’m going to look at two options. In the first one – we are just going to...
by admin | Jul 10, 2013 | Case Studies - How To
I was recently doing some training and one of the issues that came up was that the user had the following problem: Two stock lists (identical items), two physical locations and he needed to get a summary that showed the total number of items. I first thought about...
by admin | Nov 13, 2012 | Case Studies - How To
Yes, I bet that got your attention. No, this is not a step by step guide for developing multiple identities or promoting any sort of fraud or even some ideas for a name if you ever went into the Witness Protection Programme (note to self – time to stop watching...
by admin | Oct 23, 2012 | Case Studies - How To
In this blog posting, I’m going to show you how to use a feature in Excel to create a large table of values. The feature is called Data Tables and I’m going to use the PMT function with it to show you how to quickly create a large table of loan repayment...
