Blog
-
Divine appointments: We often minister to others by just being ourselves … words may not be necessary.
While this is clearly a blog on an Excel website, as a change of pace, from time to time I will post on meaningful, but unrelated topics. This is the first such post. It is a decades-old true biker anecdote from Reader’s Digest (as I vaguely remember it): I am an elderly grandmother living
-
Accurate Age Calculations
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 beginning year from the ending year: = YEAR(EndDate) – YEAR(BegDate) This math is easy,
-
Unhide Not Working; Rows or Columns Remain Hidden
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 roughly by how often they occur: Active filters are forcibly hiding rows that don’t meet the filter criteria. (This impacts rows, but not
-
The Best Book for the Average Excel User
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 book from Amazon (or elsewhere) can save you
-
Excel Spreadsheets: Rock-Bottom Basic Concepts for Newbies
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 spreadsheet consists of thousands of individual data cells organized into rows and columns. Cells are named
-
A hearty welcome to those visiting our revised website
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 VBA macros and the