CONTINUING EDUCATION FOR TAX & FINANCIAL PROFESSIONALS

Mastering Advanced Excel Functions and Formulas

Icon_Webcast
Webcast
Icon_Level
Advanced
Credits
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.

Major Subjects Covered
  • Using financial functions to calculate loan payments, depreciation, and cash flows
  • Retrieve summarized data with the GETPIVOTDATA and CUBEVALUE functions
  • Making sophisticated calculations with array formulas

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

Course Specifics

Course ID
WC12206996
Advanced Preparation

None

Compliance information

NASBA Provider Number: 103220

Course Instructor

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. Mac gained practical experience in information systems with the National Aeronautics and Space Administration (NASA), and has an established practice in business and technology consulting. Mac …

K2 Enterprises (Lawrence A. (Mac) McClelland, MBA, JD) Read More »

Mastering Advanced Excel Functions and Formulas

CPE CREDITS
2 Credits: Computer Software & Applications

$125.00

Icon_Webcast
Webcast
Icon_Level
Advanced
Credits
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.

Major Subjects Covered
  • Using financial functions to calculate loan payments, depreciation, and cash flows
  • Retrieve summarized data with the GETPIVOTDATA and CUBEVALUE functions
  • Making sophisticated calculations with array formulas

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

Course Specifics

Course ID
WC12206996
Advanced Preparation

None

Compliance information

NASBA Provider Number: 103220

Course Instructor

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. Mac gained practical experience in information systems with the National Aeronautics and Space Administration (NASA), and has an established practice in business and technology consulting. Mac …

K2 Enterprises (Lawrence A. (Mac) McClelland, MBA, JD) Read More »

Mastering Advanced Excel Functions and Formulas

CPE CREDITS
2 Credits: Computer Software & Applications

$125.00