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...
by DerekHenry | Aug 7, 2024 | Efficiency, Excel Tips, Shortcuts
Overview Drop-down lists are a great way to ensure quality data and make it easy for your users to enter data consistently but restricting the values they can choose from. While you can easily add a static list, it’s much more efficient and scalable to link...
Recent Comments