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.
Among 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
YOUR EXPERT INSTRUCTOR
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 extensively with Mac OSX and Mac-related software since 2006.
Mike has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors including pharmaceutical, healthcare, legal, retail and public sector. In addition to training, he designs and develops Microsoft Office-based solutions that automate key business tasks and processes, which in turn saves time and money and improves productivity. Mike is a Fellow of The Learning and Performance Institute.
HRCI CREDIT: This program has been approved for credit hours through the HR Certification Institute. For more information about certification or recertification, please visit the HR Certification Institute website:www.hrci.org.
SHRM CREDIT: Aurora Training Advantage is recognized by SHRM to offer Professional Development Credits (PDCs) for the SHRM-CPSM or SHRM-SCPSM. For more information about certification or recertification, please visit www.shrmcertification.org.