by DerekHenry | May 29, 2024 | Thought Leadership
Overview Could you use an extra $17,000 a year?!? If you’re like most people these days – with very little savings – you might be surprised how much money you’re wasting without realizing it. While our standards of living have increased...
by DerekHenry | May 15, 2024 | Thought Leadership
Overview Graduating high school and college are two incredible achievements filled with joy and relief. They can also bring about a lot of change and stress. Too many people learn valuable skills that aren’t taught in school the hard way, but it doesn’t...
by DerekHenry | May 8, 2024 | Thought Leadership
Overview Acronyms are great for learning and reinforcing key concepts because they are easy to remember, and help frame our perspective. My background is mostly in accounting, where there is no shortage of acronyms. Same goes with IT and lots of other fields. If you...
by DerekHenry | May 1, 2024 | Excel Tips
Overview I like to share quotes during presentations to add some insight to what I’m presenting. There’s something about them that helps people understand the importance. When it’s a well-known author, even better! I also like to share dad jokes...
by DerekHenry | Apr 24, 2024 | Efficiency, Excel Tips
QLAMBDA and UDF Screenshot Close QLAMBDA Formula Screenshot Close QUDF Formula Screenshot Close Overview Have you ever written a custom function in Excel with a LAMBDA or a User-Defined Function (“UDF”)? They are both great options for building functions...
by DerekHenry | Apr 17, 2024 | Efficiency, Excel Tips
QDynamic Array Function Screenshot Close Overview Have you used any of Excel’s dynamic array functions (DAFs) yet? If not, you’re missing out on possibly the biggest update to Excel, possibly ever. Even though they’ve been around for a few years...
by DerekHenry | Apr 10, 2024 | Efficiency, Excel Tips
QCell Styles Screenshot (Home tab) Close QCell Styles Screenshot (style palette) Close QCell Styles Screenshot (style right-click) Close QCell Styles Screenshot (Home tab) Close Overview Do you format your Excel files one format and one cell at a time? Or do you use...
by DerekHenry | Apr 3, 2024 | Efficiency, Excel Tips, Shortcuts
QExcel Options Menu Screenshot Close QCustom ribbon tab example screenshot Close QQuick Access Toolbar example screenshot Close Overview Customizing Excel is a great way to eliminate a lot of repetitive steps you’re likely taking in almost every one of your...
by DerekHenry | Mar 27, 2024 | Efficiency, Excel Tips
QFilter Screenshot (Home tab) Close QFilter Screenshot (Data tab) Close QAdvanced Filter Screenshot Close QSlicer Screenshot Close QFILTER Function Screenshot Close QPivotTable Filter Screenshot Close QPower Query Filter Screenshot Close Overview Filtering is a common...
by DerekHenry | Mar 20, 2024 | Efficiency, Excel Tips
QNumber Format Screenshot - Ribbon Section Close QNumber Formats Screenshot - Quick Formats Close QNumber Formats Screenshot - Format Cells Box Close QNumber Formats Screenshot - Macro Code Close Overview Number formats are an important, but often overlooked part of...
Recent Comments