Recently I found an interesting way to handle plurals in Jordan Goldmeier’s book on dashboards.
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.
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.
Discover the functions that handle different types of calculations.
See how to avoid some of the frustrations that dates and times can cause. Topics covered include:
- adding months to a date
- formulas for the first and last day of the month
- using today’s date in a formula
- handling days of the week calculations
- automating dates in headings
- how to avoid the traps in time calculations
- remove times from dates
- generating random dates (for testing)
As always there will be a few other tips and tricks shared during the session.
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.
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.
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.