Irvine, CA 90630 USA
1-949-339-9451
era@erascal.org
Loading Events

« All Events

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
  • Hyperlinks
  • 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:
https://www.youtube.com/playlist?list=PL_GjIXlixds6CAd57dU61BIxPK5dcgMSE

Practice course files can be found here:
https://www.dropbox.com/s/q3kqp35u5u2kwr5/Excel%20Class%202018%20Files.zip?dl=0

 

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.

 

Click here to load this Caspio Cloud Database

 

Details

Date:
August 19
Time:
4:00 pm - 5:30 pm
Event Categories:
,