by DerekHenry | Nov 20, 2024 | Efficiency, Excel Tips, XLEV8 Add-ins
Overview If you’ve worked with Excel long enough, chances are you’ve made some errors. Although it’s a fabulous application – many say the most important ever built – its power and wide array of features make it highly likely that...
by DerekHenry | Nov 13, 2024 | Efficiency, Excel Tips
Overview If you haven’t tried the LET function in your Excel formulas yet, you’re really missing out, especially if you work with a lot of formulas! LET is a unique function that lets you define reusable variables in your formulas. It’s a key...
by DerekHenry | Oct 30, 2024 | Efficiency, Excel Tips, Shortcuts, XLEV8 Add-ins
Overview If you haven’t yet tinkered with the new(ish) Dynamic Array Functions (aka “DAFs”) in Excel, you’re missing out! They can add a significant amount of automation to your files, saving you time and reducing risk. They can return...
by DerekHenry | Oct 16, 2024 | Efficiency, Excel Tips, Shortcuts
Overview Did you know the average person spends 28% of their work time dealing with email? That’s almost 1.5 days a week! When you combine that with the other repetitive tasks people often do in Outlook like managing meetings, personal calendars, and contacts,...
by DerekHenry | Sep 18, 2024 | Efficiency, Excel Tips, Shortcuts
QManually-built TOC Close QFormula-driven TOC Close QNavigation Pane TOC Close QMacro-driven TOC (list) Close QMacro-driven TOC (gallery) Close QInserting an in-workbook link Close Overview If your Excel files have a lot of sheets, you know how cumbersome they can be...
by DerekHenry | Aug 21, 2024 | Efficiency, Excel Tips, Shortcuts
QERROR.TYPE Function Codes Error code Error type 1 #NULL! 2 #DIV/0! 3 #VALUE! 4 #REF! 5 #NAME! 6 #NUM! 7 #N/A! 8 #GETTING_DATA 9 #SPILL! 10 #CONNECT! 11 #BLOCKED! 12 #UNKNOWN! 13 #FIELD! 14 #CALC! 19 #PYTHON! Close Overview If you use Excel much at all, you’ve...
Recent Comments