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

Duration: 60 minutes

Microsoft Excel has more than 300 built-in functions. Unfortunately, most users limit themselves to using just a tiny fraction of them. That’s a missed opportunity for a huge gain in productivity and efficiency—with software most employees already have and use on a regular basis.

Move beyond the basics with expert Excel trainer Dennis Taylor in this fast-paced and information-packed training session. (details below)


WHY ATTEND

Category by category, he’ll take you through a library of powerful Excel functions—Power, Rounding, Statistical, Text, COUNTIF, Date/Time—and teach you how and when to use each one. You’ll learn how to use functions Microsoft has recently added to the software. Plus, Dennis will give you dozens of time-saving tips and tricks to help you get more done faster.

LEARNING OBJECTIVES

Join us for Excel Functions and Formulas: Become a Power User and Boost Your Efficiency to learn how to:

  • Simplify searching for data in tables with the lookup functions VLOOKUP, INDEX, and MATCH.
  • Debug formulas that are giving you incorrect answers
  • Use “array functions” that will help you tackle difficult formulas that deal with massive amounts of data
  • Master the frequently overlooked ways to extract data from within cells and combine data from different cells
  • Use 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
  • Deploy the power functions SUMIF and COUNTIF to help you tabulate database totals with ease

                            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.

                            What You Get With Each Option

                            Live Recording

                            Live Only

                            Participation in the live upcoming webinar

                            Recording

                            Recording Only

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

                            Live and Recording

                            Live + Recording

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

                            Event Package

                            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 close

                            Live Recording

                            Live Only

                            Participation in the live upcoming webinar

                            Recording

                            Recording Only

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

                            Live and Recording

                            Live + Recording

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

                            Event Package

                            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 close

                            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.