Excel Tricks and Shortcuts: Get More Done in Less Time

Wednesday, January 08, 2020 at 1pm ET           Duration: 90 minutes

Most Excel users, even experienced ones, have no idea how much time and energy they waste because of what they DON’T know about this remarkable tool. They use command sequences, formatting processes, chart configurations and formulas that are terribly inefficient. Why? Most are simply unaware of “hidden” tools and techniques that can improve productivity.

This program will show you how to become more efficient and effective Excel user. (more details below)


WHY ATTEND

If there’s a better, faster way to use Excel, why not learn it? Invest just 90 minutes in this training session so you can save untold hours in Excel in the coming days, months and years.

LEARNING OBJECTIVES

After this webinar you will be a far more efficient, productive user of Microsoft Excel. Our speaker will show you how to:

  • Navigate seamlessly through workbooks and worksheets with keystroke & mouse shortcuts
  • Reduce copy/move/paste commands to single-step actions
  • Enter data in multiple non-contiguous cells at the same time
  • Instantly enter the current date or time with keystroke shortcuts
  • Build a numeric series from one or two cells
  • Instantly display & select all worksheet formulas
  • Expand AutoSum functionality to tabulate averages, highs, and lows
  • Use entire column references to simplify formulas
  • Select all blank cells within a range and fill them with adjacent data
  • Use keystroke shortcuts to apply numeric formats - Currency, Date, Time, Percent, Scientific, Number, and General
  • Instantly convert formulas to values – without copy & paste!
  • Create charts instantly on the current worksheet or on a new sheet
  • Use Flash Fill to join or separate columnar date without commands
  • Throughout this presentation you will see dozens of additional keystroke shortcuts that will make you a more proficient Excel user.
This session will be presented in Excel 2016. Comparison info will be covered for other versions of Excel

                                                                                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 (digital download).

                                                                                Live and Recording

                                                                                Live + Recording

                                                                                Participation in the live webinar + Full MP4 Recording (digital download).

                                                                                Event Package

                                                                                Event Value Pack

                                                                                Participation in the live webinar + Full MP4 Recording + Audio-only MP3 recording. (digital download)

                                                                                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 (digital download).

                                                                                Live and Recording

                                                                                Live + Recording

                                                                                Participation in the live webinar + Full MP4 Recording (digital download).

                                                                                Event Package

                                                                                Event Value Pack

                                                                                Participation in the live webinar + Full MP4 Recording + Audio-only MP3 recording. (digital download)

                                                                                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.