https://lichess.org/ has a Zen mode. Can I create a Zen mode in Excel to celebrate Spreadsheet Day?
Zen Mode
Post Category → Articles
DSUM gymnastics
I explored ideas to make DSUM function’s criteria argument as flexible as a gymnast. Is it a spreadsheet miracle? Maybe. Continue reading
CELL Function Adventure
You may never need this…but I did recently and it’s just fun knowing that Excel can solve this! Continue reading
Discover Data Types templates
I was working on a demo file about Excel’s new Data Types but I found an incredible set of templates created by Elisabetta Caldesi! Continue reading
review of 2020 posts
Let’s forget 2020 but I will review my posts. Thanks Excel for helping me through the year. Continue reading
Robert Gascon’s Shortest Formula Challenge
Robert Gascon not only created a shortest formula challenge but he also challenged me to write a post about it! Continue reading
Awkward Data
Another awkward dataset. Should we re-arrange the data or just find a way to calculate what we need? Continue reading
Add color to letters inside a cell
VBA can color certain characters within a cell. It was fun to practice vba and build this but it doesn’t work well with many rows of text. Continue reading
Calculate Wind Chill in Excel
It’s April 21 and winter is supposed to be finished here in the Toronto area. However, I went for a walk and it’s still cold out! A combination of cold & wind. Let’s calculate the wind chill in Excel. Continue reading
arithmetic progression
Let’s take a look at something that’s SO easy to calculate today with a simple spreadsheet but was very challenging to calculate in the past. Continue reading