Skip to Content

Microsoft® Excel: Date, Time Functions and Circular References

Format: On-demand

This course was created for Microsoft® Excel 2013 and newer versions including 365. The course has updates to highlight differences for Mac users and is Mac friendly.

It will be an overview of:

  • Learn to create Excel’s more advanced charts and utilize Excel controls to enhance worksheets.

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 and larger corporations to bring their personnel to a level playing field with Microsoft® Excel, 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.

Learning Objectives

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

  • Learn to use Microsoft® Excel charts to track actual performance against targeted performance.
  • Learn to use sparkline charts.
  • Learn to use spinners, scroll bars, checkboxes, dynamic labels and list boxes to control charts.
  • Create dashboards and dynamic chart labels.
  • Master Excel 2016’s new charts.

Available Formats