by DerekHenry | Aug 8, 2018 | Excel Tips
Why to Use The INDIRECT formula is a powerful formula that lets you build dynamic references. Any part of the range address – the file path, file name, sheet name, column letter, or row number – can be in a cell that is referenced within the INDIRECT...
by DerekHenry | Aug 8, 2018 | Excel Tips
Excel Reference Types There are four types of references in Excel – relative, absolute, row-absolute, and column absolute. This is all about how the formula references move when you copy and paste. The reference types are indicated by $ symbols before the...
by DerekHenry | Aug 8, 2018 | Excel Tips
Why Use Named Ranges in Excel Named ranges allow you to specify a unique name for a range of one or more contiguous cells within a sheet. Cells can also be assigned to multiple named ranges. This is helpful for referencing rows, columns, or cells in a sheet that may...
by DerekHenry | Aug 8, 2018 | Excel Tips
Why Customize the Excel QAT and Ribbon Did you know that you can customize the QAT (Quick Access Toolbar) and ribbon within Excel and most other Microsoft Office applications? Customizing the QAT and ribbon can save you time searching for commonly-used commands that...
by DerekHenry | Aug 8, 2018 | Shortcuts
Setting Up Folders Did you know you through VBA macros, Excel can add entire folder hierarchies for you? In fact, any Microsoft application that uses VBA can do this. You can set up huge folder structures based on dates, revenue/cost centers, products, customers,...
by DerekHenry | Aug 8, 2018 | Shortcuts
Using Navigation Keyboard Shortcuts This article and accompanying video describe some of the more common navigation keyboard shortcuts in Excel and other applications. These are shortcuts you absolutely need to learn and master to be efficient, not just in Excel, but...
by DerekHenry | Jul 10, 2018 | XLEV8 Add-ins
The XLEV8 Add-in Suite has officially been released! Please take a look at the XLEV8 product page and download your 30-day free trial! Please use the feedback form to share issues or feature requests. See the application-specific pages below for lists of popular...
Recent Comments