Microsoft® Excel Fundamentals + Data Analytics Certificate

$329.00

VLOOKUP, pivot tables, INDEX and other critical Microsoft Excel functions are an essential part of an accountant’s daily tasks. Improve your Excel skills with this comprehensive program that covers everything from the essential fundamentals all the way to in-depth applications for data analytics. This program is perfect for those who want a full end-to-end training in the foundations of Excel, data visualization, and advanced analytics. You will receive CPE credit for each course completed and a certificate once all 14 courses are completed.

Credit(s):
28.00
Course Format:
On Demand
Certificate Program ID:
22
Type:
Certificate Program
Lifecycle:
_none

What's included

  • Courses taught by Dr. Wayne Winston - the man who literally wrote the book on Excel
  • A thorough overview of all aspects of Excel as well as practical ways to effectively and efficiently perform job functions
  • Excel templates to follow along with Wayne as he teaches the course and to keep as a useful reference
  • Examples relevant to finance and accounting professionals
  • A resume-boosting Becker certificate once all the courses are completed
Included courses*
Introduction to Formulas

Credits 2

Filtering, Sorting and Removing Duplicates

Credits 1.5

Basic Charts

Credits 1.5

Range Names and the Auditing Tool

Credits 1.5

VLOOKUP, HLOOKUP, CHOOSE, MATCH and INDEX Functions

Credits 2

Tables

Credits 1

IF Statements

Credits 2.5

Text Functions

Credits 2

Date, Time Functions and Circular References

Credits 1.5

Conditional Counts,Sums and Averages

Credits 2

Conditional Formatting

Credits 2

Pivot Tables

Credits 3

Advanced Charts and Controls

Credits 2.5

Descriptive Statistics

Credits 3

A headshot of Wayne Winston
Instructor bio

Dr. Wayne Winston is a 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 PhD in operations research from Yale. He won more than 40 teaching awards at Indiana University. He has written more than a dozen books including "Marketing Analytics", "Data Analysis and Decision Making", "Operations Research", "Practical Management Science", "Excel 2019 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.

Alex RicheyCPA
Senior tax accountant at Suggs Johnson, LLC**
Before taking Becker’s Excel Certification program, I considered myself a fairly proficient Excel user. However, I was quickly humbled by the amount of Excel’s tools and functions I was not aware of and how much I was able to learn from the program. The program’s courses are easy to understand and the “follow along” examples helped me stay engaged. I am so glad that I took the Certification program.

Get your CPE all-access pass.

Take advantage of everything Becker has to offer with access to our entire CPE catalog, including all premium content, state-specific ethics and industry-specific courses.

Purchase Prime package

*These courses were also included in the Microsoft Excel Fundamentals Certificate and the Microsoft Excel Data Analytics Certificate, sold separately.

**Participant received free access to courses

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