Microsoft Excel user? Consider these 5 Productivity Hacks!
Anyone who uses Excel everyday spends a LOT of time doing the same repetitive tasks. For example:
- Customizing worksheet preferences (formatting, printing setup, etc.)
- Seeking toolbar ribbon items to perform specific tasks
- Analyzing basic datasets
- Using the mouse for task-specific items, when keyboard shortcuts are dramatically faster
- Keying in data to develop analysis
The presentation below highlights 5 tools for consideration that will fundamentally change how you work with Excel. Yes, behavior change is required (and that is generally not easy), but it will result in much more effective use of Excel.
“Faced with the choice between changing one’s mind and proving that there is no need to do so, almost everyone gets busy on the proof.” — John Kenneth Galbraith
The five productivity hacks are:
- ASAP Utilities add-in — “The tools from ASAP Utilities add new functionality to Excel and are guaranteed to save you time and speed up your work.”
- Quick Access Toolbar (“QAT”)
- Pivot Tables for Data Analysis
- Excel template workbook and worksheet
- Using a Personal Macro Workbook
Download the presentation here (includes numerous helpful links!)