« All Events

  • This event has passed.

Mastering Advanced Excel Functions and Formulas

December 2, 2020 @ 9:55 am - 11:35 am

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.

Learning Objectives

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

+ Google Calendar+ iCal Export

Details

Date:
December 2, 2020
Time:
9:55 am - 11:35 am
Event Category:

Organizer

Tennessee Society of CPAs

Other

CPE Credits
2
Level
Basic
Prerequisites
Basic knowledge of technology strategy and standards
NASBA Category
Computer Software and Applications
Instructor
Tommy Stephens
Delivery Method
Group Live Seminar
Who Should Attend
Accounting and business professionals who use Excel 2013 and Excel 2016 and are seeking to manage, analyze, and report data more efficiently using Excel
K2 Event ID
27020
Event Location
Franklin, TN
Conference Title
TN Technology Conference
Event Time Zone
CST

Venue

Franklin Marriott Cool Springs
700 Cool Springs Blvd.
Franklin,TN37067United States+ Google Map