CONTINUING EDUCATION FOR TAX & FINANCIAL PROFESSIONALS
Subscribe
Login
Main Menu
Main Menu
Account
Cart
Webcast

Mastering Advanced Excel Functions and Formulas

2 Credits: Computer Software & Applications

$98.00

Webcasts are available for viewing Monday – Saturday, 8am – 8pm ET.
Without FlexCast, you must start with enough time to finish. (1 Hr/Credit)

 Secure Transaction

Mastering Advanced Excel Functions and Formulas

Format
Webcast
Course Level
Advanced
CPE Credits

2 Credits: Computer Software & Applications

Course Description

Excel now has approximately 500 functions, many of which are unused by most accounting and finance professionals. This two-hour session will put you on the path to improved Excel productivity by introducing you to powerful and timesaving, but little used, Excel functions. If you want to improve your knowledge and efficiency with Excel, this session is a must for you.

Show More
Show Less

Learning Objectives

Upon completing this session, you should be able to:

  • List the three Excel functions for computing payments, payment interest, and principal write down
  • Differentiate between the GETPIVOTDATA and CUBEVALUE functions
  • Recognize similarities in using the SUBTOTAL and AGGREGATE functions
  • Identify the steps necessary to create array formulas using ordinary Excel functions
Show More
Show Less

Course Specifics

Course ID
WC12206996
Revision Date
July 23, 2021
Prerequisites

Fundamental understanding of Microsoft Office Excel formulas and functions

Advanced Preparation

None

Compliance Information

NASBA Provider Number: 103220

CFP Notice: Not all courses that qualify for CFP® credit are registered by Western CPE. If a course does not have a CFP registration number in the compliance section, the continuing education will need to be individually reported with the CFP Board. For more information on the reporting process, required documentation, processing fee, etc., contact the CFP Board. CFP Professionals must take each course in it’s entirety, the CFP Board DOES NOT accept partial credits for courses.

Meet The Experts

Lawrence M. McClelland Headshot
K2 Enterprises (Lawrence A. (Mac) McClelland, MBA, JD)

Lawrence A. (Mac) McClelland, MBA, JD, is an attorney and accounting professional. Mac was formerly the director of the Centre for Financial Studies at the University of Otago in Dunedin, New Zealand, where he lived and worked from 1990 to 1997. He was also a member of the faculty of the Advanced Business Programme, ranked in the top 100 MBA programs in the world by The Economist, specializing in business strategy and strategic management accounting. Mr. McClelland gained practical experience in information systems with the National Aeronautics and Space Administration (NASA), and has an established practice in business and technology consulting. …

Related Courses