18
Jan 2020
- BY Kevin Lehrbass
- POSTED IN vba
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Over the holidays I saw some vba code for checkboxes from the book ‘More Excel Outside the Box’ by Bob Umlas.
(more…)
Author: Kevin Lehrbass
31
Dec 2019
- BY Kevin Lehrbass
- POSTED IN Reviews
- WITH 1 COMMENTS
- PERMALINK
- STANDARD POST TYPE
I’ll review the posts I wrote in 2019. But first, a challenge inspired by a Wall Street Journal article. (more…)
22
Dec 2019
- BY Kevin Lehrbass
- POSTED IN Macros (vba), Reviews
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Jordan Goldmeier’s rollover technique runs a VBA User Defined Function when you hover the mouse over a hyperlink formula. Let’s take a closer look! (more…)
02
Dec 2019
- BY Kevin Lehrbass
- POSTED IN Challenges, Efficiency
- WITH 2 COMMENTS
- PERMALINK
- STANDARD POST TYPE
MMULT function is incredibly powerful and yet mysterious to most. Let’s explore this complex function (this post inspired by a formula challenge from contextures.com )
17
Nov 2019
- BY Kevin Lehrbass
- POSTED IN Gurus
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Let’s explore an advanced way to use Conditional Formatting in Excel. We’ll make a face move around the screen without any vba! Bonus: see how to interact with target cells! (more…)
17
Oct 2019
- BY Kevin Lehrbass
- POSTED IN Macros (vba)
- WITH 2 COMMENTS
- PERMALINK
- STANDARD POST TYPE
I got this crazy idea for an Excel game while drinking a Space Invader IPA from www.amsterdambeer.com It turned out to be a great way to learn more VBA! (more…)
08
Oct 2019
- BY Kevin Lehrbass
- POSTED IN Stats
- WITH 1 COMMENTS
- PERMALINK
- STANDARD POST TYPE
How tall is tall? How smart is smart? How do we compare? Normal Distribution and Standard Deviation answer this. We’ll review the concepts and use Excel to crunch the numbers. (more…)
28
Sep 2019
- BY Kevin Lehrbass
- POSTED IN Macros (vba)
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
These days dynamic arrays, power query and DAX seem to be all the rage. But let’s not forget about an old friend: VBA UDFs (User Defined Function). (more…)
23
Aug 2019
- BY Kevin Lehrbass
- POSTED IN Auditing, Other
- WITH 3 COMMENTS
- PERMALINK
- STANDARD POST TYPE
FEN notation provides the necessary info to restart a chess game from a given position. See how I created a FEN viewer in Excel! (more…)
10
Aug 2019
- BY Kevin Lehrbass
- POSTED IN Auditing
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
In Canada we have long harsh winters but July was REALLY hot this year! How hot? Let’s combine heat & humidity to determine the real temperature we feel.
Do You Excel?
