03
Aug 2020
- BY Kevin Lehrbass
- POSTED IN Get & Transform
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Author: Kevin Lehrbass
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 4 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…)
06
Mar 2020
- BY Kevin Lehrbass
- POSTED IN Auditing, Challenges
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
For Mr Excel’s recent challenge I decided to go with an old school formula helper column solution. Why? I’ll explain. (more…)
09
Feb 2020
- BY Kevin Lehrbass
- POSTED IN Challenges
- WITH 7 COMMENTS
- PERMALINK
- STANDARD POST TYPE
My friend Robert Gascon was thinking about Excel formula challenges and Kentucky Fried Chicken (he loves KFC) while drinking a beer. (more…)
25
Jan 2020
- BY Kevin Lehrbass
- POSTED IN Free Data
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Let’s explore Wayne Gretzky’s goals (it’s his birthday tomorrow!). I’ve thought of some good questions and one “great” question that we can answer using this dataset. Finally, could Ovechkin break Gretzky’s goal record? (more…)
Do You Excel?
