In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists.
Eric Hoffer
Monthly Archives: November 2023
Outside Borders in Excel
How to apply to a range
I use the thin all borders format a lot. But there are times when I need to use the thin outline (outside) borders. This border is not as straight forward to apply to a range.
There is nothing either good or bad, but thinking makes it so.
William Shakespeare, 1564-1616
SUMIFS Wildcard Limitation
SUMIFS can use wildcard characters, but the wildcards only work on text-based codes.
The difficulties of life are meant to make us better, not bitter.
Anonymous
Clearing All Formats in Excel
Sometimes with Excel formatting you just want to clear everything and start again from scratch. You can clear just the formats, and there is an icon you can add to the Quick Access Toolbar to make clearing all the formats earlier.
The greatest value of a picture is when it forces us to notice what we never expected to see.
John W Tukey, Exploratory Data Analysis
Yesterday and Tomorrow in Excel
I recently saw a post about using a LAMBDA function for the dates for yesterday and tomorrow. You don’t need to use LAMBDA, you can just use range names.
Education is the ability to listen to almost anything without losing your temper or your self-confidence.
Robert Frost