Combining data from multiple Excel files

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...

CREATE A DROPDOWN LIST IN EXCEL

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...