Tag Archives: Data Formatting

Microsoft Excel Custom Formats – Celcius

Microsoft Excel LogoMicrosoft Excel is an amazing tool and provides a multitude of different formatting options.  However, there isn’t one for Celcius (or Fahrenheit for that matter).  Have you ever being in a situation where you need to compare temperatures?  Well I have.  A recent course I delivered required this exact thing.

Continue reading Microsoft Excel Custom Formats – Celcius

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