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…)
Author: Kevin Lehrbass
14
Oct 2020
- BY Kevin Lehrbass
- POSTED IN Challenges, Formula or VBA
- WITH 8 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Robert Gascon not only created a shortest formula challenge but he also challenged me to write a post about it! (more…)
29
Aug 2020
- BY Kevin Lehrbass
- POSTED IN Solutions
- WITH 2 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Is it ok to make one manual adjustment to an automation task to avoid the complexity of a fully automated task?
03
Aug 2020
- BY Kevin Lehrbass
- POSTED IN Get & Transform
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
26
Jul 2020
- BY Kevin Lehrbass
- POSTED IN Formula or VBA
- WITH 3 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Another awkward dataset. Should we re-arrange the data or just find a way to calculate what we need? (more…)
26
Apr 2020
- BY Kevin Lehrbass
- POSTED IN vba
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
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. (more…)
21
Apr 2020
- BY Kevin Lehrbass
- POSTED IN Auditing
- WITH 5 COMMENTS
- PERMALINK
- STANDARD POST TYPE
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. (more…)
31
Mar 2020
- BY Kevin Lehrbass
- POSTED IN PowerBI
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
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. (more…)
22
Mar 2020
- BY Kevin Lehrbass
- POSTED IN vba
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Excel is not meant to store historical data. That’s what databases do. However, Tom Urtis shows us a trick to keep the all time min value from a single input cell. (more…)
18
Mar 2020
- BY Kevin Lehrbass
- POSTED IN PowerBI, Stats
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
I keep hearing “flatten the curve” during these uncertain times of covid-19. What’s that? What do we do? Also, what can we do to reduce anxiety? For me I decided to create a “flatten the curve” demo in Excel and in Power BI 🙂 (more…)
Do You Excel?
