Recently I found an interesting way to handle plurals in Jordan Goldmeier’s book on dashboards.
Monthly Archives: January 2020
Free Webinar Recording – Date and Time Calculations
Feedback score 95% based on 61 responses
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.
Data Validation and Conditional Formats in Excel
Part Two - a good combination
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.
Validating Data Validation in Excel
Part One
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.
Hyperlinking to a Cell in Another Excel File
It is possible
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.