If you’ve ever spent hours – or perhaps days – ‘cleaning up’ a spreadsheet, or tracking down errors, this session is intended for you. Wasting time on repetitive, drawn-out tasks is in the past. Learn essential, click-saving shortcuts in Excel. Follow fundamental rules to make your tools work more effectively. Automate core functions with easy-to-implement macros. Learn to leverage Excel’s most powerful new tool to clean, combine, and compare data in seconds.

Learning Objectives:

• Navigating, selecting, and editing shortcuts with keyboard shortcuts
• Structuring data and workbooks effectively for easy updating and analysis
• Using Tables to automatically update analytics and visualizations
• Plan your Quick Access Toolbar with hidden tools and useful macros
• Leverage Power Query to combine and clean data in seconds

NOTE – Laptops are required for this training. Charging strips will be provided throughout the room.