I was given a curious problem the other day by a client who required some Microsoft Excel consultancy. They had an issue whereby multiple worksheets referenced the same information in data validation drop downs. So lets say one of these drop downs was people within the team and was used to assign work to individuals.
Microsoft Excel is the world’s most used spreadsheet tool. But what do people use it for really? I would admit that I began using it at school for creating lists and slight calculations. However, now with what I have learnt in terms of automation, KPI creation, VBA and analysis. Continue reading Microsoft Excel – Weekday Function and VLookups