Blog

Learn how to extract more than one column of data with a single VLOOKUP formula in Excel

It’s been well over 10 years since I started training Microsoft Excel to corporate clients. During training sessions, delegates would usually ask questions on how they can use Excel to help them become more effective in their work. Last week, a financial manager asked me how she could easily look up more than one field of data […]

Continue reading


How to effectively use custom number formatting to display your + or – values

In order to effectively analyze data, custom number formatting can be applied to your Microsoft Excel spreadsheet. Custom number formatting is used to easily identify values based on a set criteria. In a large Excel spreadsheet, you can easily highlight all negative or positive values by using custom number formatting. In this example, we are going to […]

Continue reading


Using conditional formatting with custom Excel formulas

Conditional formatting is an effective Microsoft Excel feature that allows you to highlight important information, for example; the ability to find duplicate values within your spreadsheet. You can create your own rule by applying conditional formatting to individual cells or a range of cells. When you have selected the data you want to format, you […]

Continue reading