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,...
Recent Comments