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...
Question: I’m trying to figure out how to use conditional formatting to check if the date column is in sequential order and highlight a cell if it is not. Answer: Here is how you can create a conditional formatting rule which would highlight dates or numbers out...
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...
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...
What’s today’s date? What time is it? Did you have to look at your calendar and clock? Data entry in Excel can be tedious enough. You are updating your Excel table with the time and date of your most recent call to a customer, you want to be fast and not...