17
Oct 2021
- BY Kevin Lehrbass
- POSTED IN vba
- WITH 2 COMMENTS
- PERMALINK
- STANDARD POST TYPE
https://lichess.org/ has a Zen mode. Can I create a Zen mode in Excel to celebrate Spreadsheet Day?
Author: Kevin Lehrbass
08
Aug 2021
- BY Kevin Lehrbass
- POSTED IN Formulas, Free Data
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
I explored ideas to make DSUM function’s criteria argument as flexible as a gymnast. Is it a spreadsheet miracle? Maybe. (more…)
29
Jul 2021
- BY Kevin Lehrbass
- POSTED IN Formulas, Free Data
- WITH 2 COMMENTS
- PERMALINK
- STANDARD POST TYPE
You may never need this…but I did recently and it’s just fun knowing that Excel can solve this! (more…)
04
Jul 2021
- BY Kevin Lehrbass
- POSTED IN Formulas
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
I had some questions and improvement ideas for my formula pixel face. I learned a lot playing around with this. (more…)
30
May 2021
- BY Kevin Lehrbass
- POSTED IN Get & Transform
- WITH 2 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Daniel Choi solved it using Power Query! Let’s review his solutions. (more…)
29
May 2021
- BY Kevin Lehrbass
- POSTED IN Formulas
- WITH 1 COMMENTS
- PERMALINK
- STANDARD POST TYPE
I need to calculate hours given data like this in each cell: “9-10, 10-11, 10-11, 12-13, 12-15+, 14-17+“ (more…)
08
Apr 2021
- BY Kevin Lehrbass
- POSTED IN Formulas, Get & Transform
- WITH 2 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Haven’t I done this before? It was almost identical except for two details. (more…)
07
Feb 2021
- BY Kevin Lehrbass
- POSTED IN Reviews, T_Education
- WITH 1 COMMENTS
- PERMALINK
- STANDARD POST TYPE
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! (more…)
23
Jan 2021
- BY Kevin Lehrbass
- POSTED IN Reviews
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Let’s forget 2020 but I will review my posts. Thanks Excel for helping me through the year. (more…)
23
Nov 2020
- BY Kevin Lehrbass
- POSTED IN Macros (vba)
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Do merged cells irritate you? My latest lame game gives you points for whacking merged cells! (more…)
Do You Excel?
