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.
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
REGISTRATION
Already have Aurora Training Advantage access? Log in to your account here: https://auroratrainingadvantage.com/login/
Need to purchase an Aurora Training Advantage access? Click here: https://ataapril2018.eventbrite.com