Mastering Excel Formulas and Functions: Become a Power User and Boost Your Efficiency

Duration: 90 minutes

Most people use Microsoft Excel inefficiently, limiting themselves to just a handful of formulas and functions. They know little about the many powerful Excel functions that provide extended capabilities that make you far more productive.

Excel has nearly 300 built-in functions. And it’s no easy task to know which ones might be useful to you. That’s what this Webinar is about – exploring the tools most likely to help you

LEARNING OBJECTIVES

Expert Excel trainer Dennis Taylor will cover how to:

Simplify searching for data in tables with the lookup functions VLOOKUP, INDEX, and MATCH.
Categorize data more effectively by using the master date and time functions
Debug formulas that are giving you incorrect answers
Create short, simple formulas by using specialized rounding functions and basic statistical and financial functions
Use “array functions” that will help you tackle difficult formulas that deal with massive amounts of data.
Use frequently overlooked TEXT functions so you can extract data from within cells, combine data from different cells and give you cleanup tools for dealing with problems such as:

leading or trailing spaces
upper/lowercase changes
trailing minus signs, and
text//value conversions.

Gain programming-like capability by mastering the IF, AND, OR, and CHOOSE functions
Use the power functions SUMIF and COUNTIF to help you tabulate database totals with ease
And more.

ABOUT THE SPEAKER

Dennis Taylor is an author and highly respected computer trainer and facilitator, specializing in Excel. His focus is on those spreadsheet and database techniques that improve business efficiency and productivity. Dennis has over 20 years of training and consulting experience. A former employee of Amoco Oil, Levi Strauss, StorageTek, the Federal Government, and the University of Colorado, he has taught nearly 4,000 seminars and classes for over 100 companies, organizations, and government agencies.

Dennis is the author of “Teach Yourself Microsoft Excel 2000” and co-author of four other books on spreadsheet software. He has developed and presented specialized Excel courses (Tips and Tricks, Database Features, Advanced Formulas and Functions) to many clients over the past 20 years. In addition, Mr. Taylor has authored and presented over 50 different training courses on Excel topics (available on DVD/CD/VHS formats) and has presented numerous webinars to thousands of attendees.

$247.00
Price per connection

What You Get With Each Option

Live Only

Participation in the live upcoming webinar

Recording Only

Full MP4 recording of webinar, including Q&A. Choose digital download or CD-ROM by mail.

Live + Recording

Participation in the live webinar + Full MP4 Recording. For recording, choose digital download or CD-ROM by mail.

Event Value Pack

Participation in the live webinar + Full MP4 Recording + Audio-only MP3 recording. For recordings, choose digital download or CD-ROM by mail.

What You Get With Each Option

Live Only

Participation in the live upcoming webinar

Recording Only

Full MP4 recording of webinar, including Q&A. Choose digital download or CD-ROM by mail.

Live + Recording

Participation in the live webinar + Full MP4 Recording. For recording, choose digital download or CD-ROM by mail.

Event Value Pack

Participation in the live webinar + Full MP4 Recording + Audio-only MP3 recording. For recordings, choose digital download or CD-ROM by mail.

About Webinar Connections

Each purchase is for ONE computer to access the session.
A group may participate in a room together as long as only 1 computer is logged in.
If you need more than one computer to access the webinar, please call customer service at 888-479-2777.
A charge will apply for each connection.

Sign Up for our mailing list

Subscribe to our mailing list and always be the first to hear about what is happening.

Liquid error (layout/theme line 525): Could not find asset snippets/spurit_uev-theme-snippet.liquid