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