Aurora Training Advantage Webinar

Excel – How to Become a Power User


Few people learn or use Excel for fun. In fact, many people see it as a necessary evil. So if you have to use it, why not learn to use it faster and more effectively? How often have you found yourself in Excel thinking, “there must be a better and faster way to do this?”

In this session you’ll learn a handful of powerful productivity-boosting tips and secrets that will speed up your work in Excel, save you hours of time and remove some of those hair-tearing-out moments! The training will be delivered using Excel 2016 for Windows although much of the functionality is available in earlier versions of Excel on both Windows and Mac.

Amongst the topics covered are:

  • Data entry shortcuts including Transpose, AutoFill and Flash Fill
  • How to copy and paste with a single mouse-click
  • Automating cell formatting with Conditional Formatting
  • Taking Find and Replace to the next level
  • Using data across worksheets and workbooks
  • Creating and managing dynamic ranges
  • Using protection to “bullet-proof” your spreadsheets
  • Using the power of The Cloud to collaborate and increase efficiency
  • Working in a mobile world: Excel on an iPad
  • Pivot Table power tips
  • Managing external data

Guest Speaker

Mike-Thomas

Mike Thomas


Mike Thomas has worked in the IT training business for 26 years. His expertise and experience covers designing and delivering training courses, creating written training materials (Quick Reference Guides and step-by-step tutorials), recording and editing video-based tutorials and providing support to users. He is a subject matter expert in a range of Microsoft technologies including Microsoft Office, Lync/Skype for Business and SharePoint. He has extensive experience of working with Cloud-based collaboration tools such as Box and OneDrive and has worked…View Full Profile