Excel: Become a Power User: Tips, Tricks and Best Practices

Global Wizdom is recognized by SHRM to offer Professional Development Credits (PDCs) for SHRM-CP or SHRM-SCP. This program is valid for 1 PDC for the SHRM-CP or SHRM-SCP.

Key Take Away:
Search the web for the phrase “Power Users” and you’ll probably find that it’s defined as someone who has an intermediate-to-advanced knowledge of an application. That’s what this training is about…showing you some “wow moments” and at the same time taking your knowledge of Excel to the next level and helping you to become more productive.

Overview:
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!

Why Should You Attend:
As a basic-level user of Excel, you’d love to reduce the number of “hair-tearing-out” moments. You’d love to be able to do things faster so you can go home on time. You’d love to be seen as an “Excel Hero” in your organization. As an added bonus, because Excel is so widely used across the globe, having good-to-excellent Excel skills means you’ll be more marketable in today’s highly competitive job market!

Areas Covered in the Session:
•  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
•  Pivot Table power tips
•  Managing external data