16
Apr 2019
- BY Kevin Lehrbass
- POSTED IN Solutions, Tips
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Author: Kevin Lehrbass
09
Apr 2019
- BY Kevin Lehrbass
- POSTED IN Solutions, Tips
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
I’ll show you the weighted average formula, how it calculates, and I’ll prove that the answer is correct! (more…)
09
Apr 2019
- BY Kevin Lehrbass
- POSTED IN Tips
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
So many times vlookup (or index & match) saves the day and gets your answer! ….wait…are you sure it’s correct??? Read this post to see why you should use countifs to confirm your vlookup. (more…)
03
Apr 2019
- BY Kevin Lehrbass
- POSTED IN Formulas
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Recently I was asked “How can you prove that the CAGR answer is correct?“. In this post I’ll show you how to verify the CAGR result. I’ll also review CAGR basics and pitfalls. (more…)
26
Mar 2019
- BY Kevin Lehrbass
- POSTED IN Challenges, Get & Transform
- WITH 6 COMMENTS
- PERMALINK
- STANDARD POST TYPE
21
Mar 2019
- BY Kevin Lehrbass
- POSTED IN Challenges
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
I saw Chandeep’s Data Cleanup Challenge and it looked like fun. Others solved it using Power Query (some amazing solutions) but I used good ol’ fashioned formulas! (more…)
03
Mar 2019
- BY Kevin Lehrbass
- POSTED IN Auditing, Formula or VBA
- WITH 6 COMMENTS
- PERMALINK
- STANDARD POST TYPE
A work colleague shared this challenge: extract the largest number from this text as420lkjs09nsdk2324lkjsd099 ! The answer is 2324. How do we solve this? Formulas? VBA? (more…)
12
Feb 2019
- BY Kevin Lehrbass
- POSTED IN Macros (vba)
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
How can you improve your VBA skills? Build something! Anything! Even if it’s ridiculous. I needed to practice and ended up creating a robot and a bunch of random style hearts! 🙂 (more…)
08
Feb 2019
- BY Kevin Lehrbass
- POSTED IN Tips
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Before you analyze your data it’s important to decide if you need to unpivot it. Why unpivot? What’s unpivot? Are there exceptions? (more…)
03
Feb 2019
- BY Kevin Lehrbass
- POSTED IN Get & Transform, Tips
- WITH 1 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Rearranging data is initially about recognizing the pattern. This screenshot is from Ken Puls. I instantly saw the steps to rearrange the data (thanks to Ken’s online course!) (more…)
Do You Excel?
