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
I came across a question on LinkedIn from someone who wanted to know how to count the number of working days in a month. Now I know that there is a WORKDAY function within Excel which is supposed to take into account holidays but, this doesn’t take into account different national holidays in different time-zones (to the best of my knowledge).