Another plural technique for Excel
Recently I found an interesting way to handle plurals in Jordan Goldmeier’s book on dashboards. (more…)
Free Webinar Recording – Date and Time Calculations
In January 2020 I looked at solving some of the frustrations date and time calculations can cause in Excel. The detailed pdf manual and example file can be downloaded using the button below. Content listed below the video. Download Materials CPD note - if you are claiming CPD for watching this recording you need to keep your own records. People who attend the live sessions receive an annual listing of attendances. https://vimeo.com/386635825 Discover the functions that handle different types of…
Data Validation and Conditional Formats in Excel
In my previous post I showed how to have a flexible data validation and how to validate it. This post will look at adding conditional formats to inputs and validations. (more…)
Validating Data Validation in Excel
The most common type of Data Validation in Excel is a drop down list. In the example below I allow the user to select a year, then a month (using a drop down) and then enter a valid day in the month. (more…)
Hyperlinking to a Cell in Another Excel File
You can create a hyperlink to another Excel file in Excel but you can’t control what sheet or cell will be active. Well you can actually, but you need to know how. (more…)