Blog

Calculating someone’s age or an anniversary (or, more generally, the number of years between two events) is a common mental task, as well as a spreadsheet task. 1st Approximation As a quick first approximation (often performed mentally), we merely subtract the...

It’s very frustrating when you try to unhide some Excel rows or columns that appear to be hidden, but they nevertheless remain hidden.  This can be caused by several situations listed here in roughly how often they occur: Active filters are forcibly hiding rows that...

Under $8 for a comprehensive 775-page book delivered to your door!  The key to getting such a great price is that the screen prints and step-by-step instructions for using even the latest versions of Excel are basically the same as for Excel 2007!  So buying this used...

Our local library offers free adult education computer classes as a public service.  The teachers donate their time.  When I teach my 5-session Intro to Excel class, the syllabus emphasizes several basic concepts that help newbies understand spreadsheet basics: 1)  A...

As a service to our clients and students, we want to provide a blog especially useful to the everyday Excel user … those folks to whom Excel is just a tool to help them do the rest of their job.  Many Excel blogs are dedicated to advanced Excel topics like programming...