by DerekHenry | Aug 8, 2018 | Excel Tips
Why Use Data Validation in Excel Data validation is a great way to ensure your data is entered accurately and consistently by adding a validation check – by restricting the type and/or content of data that can be entered – as well as an optional input...
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...
Recent Comments