Why you will never size Excel columns correctly

No better time to learn about the weird and wonderful: how Excel measures stuff. If you have ever tried to fit your spreadsheet columns to fit exact measurements in inches or centimetres and have failed before, this short post explains measurement units in Excel and...

Comment Excel formulas with the N() function

Three-in-one today. That’s right, today you will discover one shortcut to add a comment to an Excel formula, discover how to use the N() function to add a comment and learn about N(). Using comments provides potential users -and yourself- with additional...

Friday Fun: Spreadsheet Heroes to the Rescue

You can’t PivotTable stuff all day long! So here is a selection of three pieces of Excel art which will amuse you, amaze you, surprise you. Pow! Bang! #N/A! #N/A! #N/A! #N/A! Batman! This one will rescue you if your workbook is full of errors. Oh, oh, oh! Sweet...