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...
by DerekHenry | Mar 13, 2024 | Efficiency, Excel Tips
Overview Keyboard shortcuts are crucial for working efficiently, especially in apps like Excel where we tend to spend a ton of time. Most people learn a few of them as the only way to perform some actions, but don’t give much thought into how much time they can...
by DerekHenry | Mar 6, 2024 | Efficiency, XLEV8 Add-ins
Video Overview There have been a lot of new features added to the XLEV8 Excel add-in since the last update! Several of these will help you address risk, and several allow you to format cells (conditionally and fixed) much faster. There are also a couple that will...
by DerekHenry | Feb 28, 2024 | Efficiency, Excel Tips
QConditional Formatting Rules Manager Screenshot Close QConditional Formatting Menu Screenshot Close QConditional Formatting Screenshot - Stop If True Close QConditional Formatting Show For Sheet Screenshot Close QConditional Formatting Duplicate Values Rule...
by DerekHenry | Feb 21, 2024 | Efficiency, Excel Tips
QNamed Range Screenshot Close QName Box Screenshot Close QName Manager Screenshot Close QNamed Range Define From Selection Screenshot Close QNamed Range Navigation Screenshot Close QNamed Fixed Value Screenshot Close QNamed Range Relative Reference Screenshot Close...
by DerekHenry | Feb 14, 2024 | Efficiency, Excel Tips
Overview Formulas are the backbone of Excel. Without them, it wouldn’t be much more useful than grid paper. Whether they are simple or extremely complex, they power calculations of all kinds, from finance to engineering to generic data analysis. If you’re...
Recent Comments