Mastering Advanced Excel Functions and Formulas
Salepage : Mastering Advanced Excel Functions and Formulas
Archive : Mastering Advanced Excel Functions and Formulas Digital Download
Delivery : Digital Download Immediately
Excel today offers over 500 functions, many of which are rarely utilized by accounting and financial experts. This two-hour course will get you started on the road to increased Excel productivity by exposing you to powerful and time-saving Excel tools that are underutilized. If you want to increase your Excel understanding and efficiency, this seminar is a must-attend.
Fundamental Course Information
Objectives of Learning
After finishing this session, you should be able to:
List the three Excel functions used to calculate payments, payment interest, and principal write down.
Distinguish the GETPIVOTDATA and CUBEVALUE routines.
Recognize parallels between the SUBTOTAL and AGGREGATE functions.
Determine the steps required to generate array formulae using standard Excel functions.
Major Topics
Calculating loan payments, depreciation, and cash flows using financial functions
Using the GETPIVOTDATA and CUBEVALUE methods, you may retrieve summary data.
Using array formulae to do complex calculations
More from Categories : Business & Sales
Reviews
There are no reviews yet.