Excel: Productivity Tips and Tricks
CPD Hours: 2 |
Overview:
This course is designed to give users a demonstration of some powerful tips and tricks using some visible and not so visible features that are available in Microsoft Excel. By combining some simple tools and features, users can unlock many productivity shortcuts that can save time and improve the quality of output.
Learning Objectives:
Upon completing this course, you should be able to:
- Boost effectiveness using the new interface – installing or locking commands to the Ribbon Quick Access toolbar
- Use the Linked Picture feature for effectiveness in report development
- Learn important keyboard shortcuts to increase your productivity – adjacent and non-adjacent selections, date and time shortcuts, etc.
- Introduce the Flash Fill feature – a great timesaver in list creation
- Create and use Custom Lists – effective for recurring lists
- Use the Auto Outline feature – improve the effectiveness of your tables
Who Will Benefit:
This course is ideal for accountants, auditors, and financial professionals intrigued by AI and seeking to incorporate modern tools like ChatGPT into their workflows. It will be especially beneficial for those interested in improving efficiency, client communication, and data analysis using AI.