https://lichess.org/ has a Zen mode. Can I create a Zen mode in Excel to celebrate Spreadsheet Day?
Zen Mode
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
Flirting with Volatility
I had some questions and improvement ideas for my formula pixel face. I learned a lot playing around with this. Continue reading
Calculate Hours from Messy Text using Power Query
Daniel Choi solved it using Power Query! Let’s review his solutions. Continue reading
Calculate Hours from Messy Text
I need to calculate hours given data like this in each cell: “9-10, 10-11, 10-11, 12-13, 12-15+, 14-17+“ Continue reading
aggregating text part 2
Haven’t I done this before? It was almost identical except for two details. 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
whack-a-merged-cell
Do merged cells irritate you? My latest lame game gives you points for whacking merged cells! Continue reading