by DerekHenry | Dec 11, 2024 | Efficiency, Excel Tips
Overview Is there anything more annoying than opening up an Excel file and seeing a ton of ######## characters? Or cut-off text? Or text that takes up so much space you can’t see any other columns? Resizing Excel columns is a really common task – and there...
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...
Recent Comments