by DerekHenry | Apr 1, 2021 | Efficiency, Excel Tips
Summary I’ve worked with many people throughout my career that spend a lot of time downloading, organizing, building, analyzing, reviewing, or distributing reports. Obviously many of those were financial in nature, but many were around other data points such as...
by DerekHenry | Oct 17, 2018 | Excel Tips
Why to Use Review Templates in Excel Setting up files so that they are easy to review can make a huge difference in the quality of the files you work with. Your colleagues and reviewers will also appreciate being able to quickly navigate your files, find what they...
by DerekHenry | Oct 15, 2018 | Excel Tips
Why to Use Auto Fill and Flash Fill in Excel Auto fill is an awesome feature that helps you quickly fill data in Excel. You can fill single values or formulas (basically copying and pasting), or fill a series of common list values, such as numbers, dates, days of the...
by DerekHenry | Sep 20, 2018 | Excel Tips, XLEV8 Add-ins
People often ask me which macros in the XLEV8 Excel add-in are my favorites. As you can imagine, I use a lot of them, but the ones below stand out, and below I explain why. It helped to run the Macro Usage report to show which ones I use the most frequently and...
by DerekHenry | Aug 8, 2018 | Excel Tips
Why to Use Macros There are several reasons to use macros but the obvious answer is that they can save you a tremendous amount of time. From creating shortcuts for common tasks to automating large, complex, or repetitive processes, macros are probably the most...
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...
Recent Comments