by DerekHenry | Feb 28, 2024 | Efficiency, Excel Tips
QConditional Formatting Rules Manager Screenshot Close QConditional Formatting Menu Screenshot Close QConditional Formatting Screenshot - Stop If True Close QConditional Formatting Show For Sheet Screenshot Close QConditional Formatting Duplicate Values Rule...
by DerekHenry | Feb 21, 2024 | Efficiency, Excel Tips
QNamed Range Screenshot Close QName Box Screenshot Close QName Manager Screenshot Close QNamed Range Define From Selection Screenshot Close QNamed Range Navigation Screenshot Close QNamed Fixed Value Screenshot Close QNamed Range Relative Reference Screenshot Close...
by DerekHenry | Feb 14, 2024 | Efficiency, Excel Tips
Overview Formulas are the backbone of Excel. Without them, it wouldn’t be much more useful than grid paper. Whether they are simple or extremely complex, they power calculations of all kinds, from finance to engineering to generic data analysis. If you’re...
by DerekHenry | Feb 7, 2024 | Efficiency, Excel Tips
Overview We’ve all heard the phrase “garbage in, garbage out” when it comes to data quality. But it’s amazing how many companies still place such important decisions on bad data. It’s a problem across industries, functional groups, and...
by DerekHenry | Jan 31, 2024 | Thought Leadership
Overview Tenacity is a word you probably don’t think of much. I know it wasn’t for me, but when evaluating core values to round out the acronym HEART, it seemed to fit perfectly. When you think of people who hang on when letting go appears most...
by DerekHenry | Jan 24, 2024 | Thought Leadership
Overview What do you think of when you hear the word resourceful? The first thing that comes to mind for me is the show MacGyver. It ran in the 1980’s, then had a reboot in the 2016-2021 years. My parents watched the older version, while my wife and I enjoyed...
by DerekHenry | Jan 17, 2024 | Thought Leadership
Overview Accountability is a crucial and game-changing concept. It can make or break a business, a group, or even a family. Holding others accountable is just as important as being accountable. Although I’ve generally been pretty responsible for as long as I...
by DerekHenry | Jan 10, 2024 | Efficiency, Thought Leadership
Overview Efficiency is one of those concepts that isn’t necessarily sexy, but it can make or break a business. Throughout my entire career, I’ve been somewhat obsessed with efficiency. Three key events drove this. First, I had an awesome accounting...
by DerekHenry | Jan 3, 2024 | Thought Leadership
Overview When people think of the term hospitality, they often think of the hospitality industry (restaurants, hotels, etc.). But hospitality is more than an industry. It’s a mindset that can work wonders whether you are interacting with people externally like...
by DerekHenry | Dec 27, 2023 | Efficiency
Overview I’m a big fan of habits. I guess you could say Stephen Covey’s 7 Habits of Highly Effective People made a big impression on me. If you’ve never read it, I highly recommend it, even if you just read the summary and get familiar with the...
Recent Comments