by admin | Aug 21, 2013 | Excel | Intermediate Lessons
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 | Excel | General, Excel | Intermediate Lessons
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 | Excel | General, Excel | Intermediate Lessons, Excel | Useful tricks
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 | Sep 18, 2012 | Excel | Intermediate Lessons
A useful skill to have – particularly if you need to do analysis on a list (in pivot tables etc) as you want to ensure that your data entry is kept consistent. It’s also a real time saver it you need someone else to input data for you and you want to...
by admin | Aug 20, 2012 | Excel | Conditional Formatting, Excel | Intermediate Lessons
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. Please enable...
by admin | Aug 2, 2012 | Excel Formulas | Essential Functions, Excel | Intermediate Lessons
In a previous blog posting, I showed you how to set up an If statement in Excel. In this blog posting, I am going to show you how to nest an OR function into an IF function (the technique can be used equally well with a NOT, AND, TRUE, FALSE functions). Essentially...