ERA Southern California Chapter Meeting Excel – Tips and Tricks
August 19 @ 4:00 pm - 5:30 pm
Excel – Tips and Tricks for Busy Salespeople
Increase your productivity
Presented by ERA Southern California Chapter
Your Presenter is Byron Holloway a Manufacturers Rep and Certified Microsoft Trainer
In this class we will cover
- Basic Formulas
- Absolute vs Relative References (when to use $ notation in formulas)
- Named Ranges
- Data Clean Up (Dates that come through as text strings instead of Dates)
- Lookup Tables
- Pivot tables
- Dynamic Ranges
- 3rd Party Tools
Although this class is a Lecture, course materials are available with step-by-step instructions and sample data so you will be able to complete the tasks on your own.
Video’s to review and follow along for each topic may be found here:
Practice course files can be found here:
About you presenter
Byron Holloway has been in the industry since 1993 working in all facets of the supply chain from Manufacturers, Distributors and Representatives. He holds a BSEE and was a Microsoft Certified trainer for Office products.
He will help you understand how to take the mountain of data we receive each month and turn it into actionable information that you can use to manage your customers report to your principals.