Microsoft® Excel: Tables
Learning objectives

After completing this course, the learner should be able to:

  • Learn how to use Microsoft® Excel tables to make your formulas automatically update when you add new data.
  • Learn how to use tables to make your charts automatically update when you add new data.
  • Learn how to use table filters and/or slicers to perform complex calculations or create chart based on a subset of your spreadsheet data.
Instructor Wayne Winston

Instructor bio

Dr. Wayne Winston is a Visiting Professor at the Bauer College of Business at the University of Houston and Professor Emeritus of Decision Sciences at the Kelley School of Business at Indiana University. He holds a B.S. in mathematics from M.I.T. and a Ph.D in operations research from Yale. He won over 40 teaching awards at Indiana University. He has written over a dozen books including Marketing Analytics, Data Analysis and Decision Making, Operations Research, Practical Management Science, Excel 2016 Data Analysis and Business Modeling, and Mathletics. Dr. Winston has taught classes and consulted for many leading global organizations. He is also a two-time Jeopardy! Champion and has consulted for the NBA’s Dallas Mavericks and New York Knicks.

National Registry of CPE Sponsors

A Becker Professional Education is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org

Becker Professional Education Sponsor I.D. Numbers NASBA: 107294, New York: 002087, New Jersey: 20CE00226700, Texas: 009580, Ohio: CPE.186, Illinois 158.002405, Pennsylvania: PX177823

Now Leaving Becker.com

You are leaving the Becker.com website. Once you click “continue,” you will be brought to a third-party website. Please be aware, the privacy policy may differ on the third-party website. Adtalem Global Education is not responsible for the security, contents and accuracy of any information provided on the third-party website. Note that the website may still be a third-party website even the format is similar to the Becker.com website.

Continue