by DerekHenry | Aug 8, 2018 | Excel Tips
Why to Use PivotTables and PivotCharts in Excel PivotTables and PivotCharts are powerful tools that let you quickly summarize and analyze your structured data. They are so powerful and full of features that there are full-day courses dedicated to them! We’ll...
by DerekHenry | Aug 8, 2018 | Excel Tips
Why to Use Conditional Formatting in Excel Conditional formatting is a powerful feature that gives your reports a very polished look, and can also help identify exceptions in your data, such as blanks, differences, or variances outside tolerable thresholds. ...
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...
Recent Comments