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...
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...
by DerekHenry | Jul 24, 2024 | Efficiency, Excel Tips, Shortcuts
Overview If you’ve ever worked with an Excel file filled with similar worksheets, you probably know how annoying it is that some Excel features don’t play well with multiple sheets, such as filtering. These can be especially frustrating for businesses in...
by DerekHenry | Jul 3, 2024 | Efficiency, Excel Tips, Shortcuts
Overview Worksheets are a key component of any good Excel file. They help you organize your files and separate the inputs, outputs, and other areas. Whether you work with simple files containing just a couple of sheets, complex files with hundreds of sheets, or...
by DerekHenry | Jun 19, 2024 | Efficiency, Excel Tips
Overview If you’re an accountant charged with preparing or reviewing account reconciliations, chances are you’re using Excel a lot. Even with a variety of purpose-built account reconciliation tools available, Excel is still heavily used throughout the...
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...
Recent Comments