What you'll learn?

  • Create, run, edit & delete macros
  • Adjust security level for macros
  • Use Lookup and Conditional Sum functions
  • Extract correlation factor between data
  • Use Financial & Investment functions
  • Calculate the depreciation rate of fixed assets

Description

Throughout this course, trainees will be able to use macros in the accounting field. They will learn how to apply security levels on macros, and how to use conditional and accounting functions related to depreciation and investment.

Audience :

This course is designed for trainees who would like to gain more experience on how to use macros capabilities in accounting, the course provides also an effective way to deal with investment, financial & depreciation functions.

Topics :

Basic Skills Of Working With Macros

o  What A Macro Is Recording A Macro Using Absolute& Relative References

o  Security Settings For Macros

o  Running A Macro

o  Deleting A Macro

Working With Running Macros Alternatives

o  Assigning A Shortcut Key For A Macro

o  Running Macros Using Photos

o  Running Macros Using Command Buttons

o  Creating Auto Open Macros

Working With Add-Ins Tools

o  Using Conditional Sum, Lookup, And Data Analysis

Using Investment Functions

o  PV & FV Functions

o  RATE & NPER Functions

o  PMT Function

o  ISPMT Function

o  IPMT Function

o  PPMT Function

o  IRR Function

o  MIRR Function

o  NPV Function

Working With Depreciation Functions

o  SLN Function

o  DB & DDB Functions

o  VDB Function

o  SYD Function

Prerequisities :

Recommended Knowledge :

Excel 2007 - Core Level YC01-0313

Recommended Course(s) :

Category :

  • Accounting

Training Materials :

YAT Official Courseware

Labs :

This course includes several labs to ensure you will gain the targeted skills and experience.

Credential :

This course is required to complete YAT Professional Diploma in Accounting (Standard YPDA).

Related Courses