Microsoft Excel Resources

The last in a set of three looking this time at INDEX and MATCH as a way to search a table and return the contents of a cell. This combination is a more versatile and perhaps more ro...

In this section I examine the fundamentals of VLOOKUP. So what is VLOOKUP? Well it is a way of searching a table for information based on a reference value and then returning the con...

IntroductionI recently pulled together an Excel session to go through the fundamentals of the IF, VLOOKUP, INDEX and MATCH functions. To do this I started out by putting together a b...

Power Query Merge and AppendDon`t be put off by the terminology, Power Query is simply sorting and organising data that you wish to import into your Excel spreadsheet and in doing so ...

ExcelExcel is a software programme designed to take data and conduct analysis to extract useful information in tabular or graphic from. The information can then be used for a varie...

Conditional formatting What is conditional formatting? In literal terms it is getting the format of a cell to change depending upon the content of the cell linked to a rul...

I was recently asked what my favourite tip was for using Microsoft Excel more effectively. Without a lot of thought I was able to answer - Tables! "But", I hear you say, "my data is ...

Dynamic Drop Down Lists One of my previous post show that how to create Drop Down List in excel. Here I`m going to discuss how to create Dynamic Drop Down List. Copy below data. P...

Excel Tip: To copy formats only, select, then first click the Format Painter on the Home Ribbon, then click the destination cell. Excel Tip: To copy formats only, copy as nor...