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.

Don't miss out on everything Becker CPE has to offer!

Upgrade to Becker's on demand plus webcast subscription to get unrestricted access to our entire catalog!

 

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

 

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!