Tag Archives: Spreadsheets

Named Regions and Data Validation – Great Time Saver

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.

Continue reading Named Regions and Data Validation – Great Time Saver

Microsoft Excel – Weekday Function and VLookups

Microsoft Excel 2010 - LogoMicrosoft 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