29
Aug 2020
- BY Kevin Lehrbass
- POSTED IN Solutions
- WITH 3 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?
Author: Kevin Lehrbass
03
Aug 2020
- BY Kevin Lehrbass
- POSTED IN Get & Transform
- WITH 1 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 8 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 1 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 8 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…)
Do You Excel?
