Microsoft® Excel Fundamentals Certificate Program

$279.00

In this certificate program we assume no prior knowledge of Excel and take you through advanced skill-sets such as how to create range names and tables, conditional counts and sums, pivot tables, and conditional formatting.

Becker’s Microsoft® Excel Series features Wayne Winston, Microsoft® Press author for more than a decade with 40 teaching awards for his instruction. Wayne is sought out by many of the Big 4 accounting firms and larger corporations to bring their professionals to a level playing field with Microsoft® Excel, which is necessary today for success in the accounting profession. Wayne’s success as a Microsoft® Excel instructor is closely tied to his teaching style that has students watch and then do realistic, engaging problems in the software. Students learn through using Microsoft® Excel to cement their understanding before progressing to the next building block.

Becker Professional Education is not affiliated with, sponsored, or endorsed by Microsoft Corporation. Content reflected within courses is used with permission from Microsoft.

Courses must be completed in order.

 

What's included

  • Courses taught by Dr. Wayne Winston - the man who literally wrote the book on Excel
  • A thorough overview of all the fundamental 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
  • CPE credits earned at the completion of each CPE course within the program (22.5 total) and receive a Becker certificate
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

*These courses are also included in the Microsoft® Excel Data Analytics Certificate Program

Instructor 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.

John Markez
Not only do they have the best content around, it's continually updated. No other CPE provider I can find offers that. Add in their low subscription prices and I'm a customer for life!
Learn how to visualize data like a pro

Choose our Microsoft Excel Data Analytics Certificate to learn how to analyze and visualize large sets of data, and master the statistical concepts necessary to convert data into useful information.