Microsoft Excel for Finance and Accounting training centre in Bangladesh

New
Get 10% discount

Microsoft Excel for Finance and Accounting

Introduction

Automate you Accounts and Finance Functions

Finance and Accounting professionals do their financial analysis and modeling works using latest spreadsheet tools like Excel. Day to day financial analysis, reporting, modeling, tools and applications are prepared with Excel. It will be an advantage for course attendees to learn practical and advanced usages of Excel for financial analysis and modeling at office and academy.

How participants will benefit after the course
HANDS ON EXPERIENCES. Most widely practiced Financial Analysis and Modeling topics using Excel are covered in the course syllabus with practical exercises. Participants will do the live exercises along with the trainer to learn faster and effectively. Learning the required Excel functionalities in course will ensure participants high performance in their career and academics.

Methodology

Office Productivity Series - Microsoft Excel is designed for practical applications at works rather than theoretical notes. Participants will go through with examples that they can relate to their office or educational works.

Contents of Training:

BREAKING THE EXCEL FEAR
Future Value
Future Value Case - Investment with Compounding
Future Value Case - Investment VS. Borrowing
Future Value Case - Ordinary Annuity VS. Annuity Due

Present Value
Present Value Case - Investment with Compounding
Present Value Case - Periodic Cash Flow
Present Value Case - Cash Flow Comparison

Net Present Value
Net Present Value Calculation Basics
Net Present Value for Investment Decisions
Net Present Value for Different Time Intervals & Cash Flows

Internal Rate of Return (IRR)
IRR calculation for Investment Decision
Modified Internal Rate of Return (MIRR)

Depreciation
Straight Line Depreciation
Double Declining Balance Depreciation

Periodic Payment
Borrower & Lender Point of View
Balloon & Delayed Payment
Period Calculation for Periodic Payment

Amortization Payment
Interest Payment Calculation for Periodic Payment
Principal Payment Calculation for Periodic Payment
Cumulative Interest Payment Calculation for Periodic Payment
Cumulative Principal Payment Calculation for Periodic Payment

Rate
Effective Annual Rate (EAR) Calculation
Annual Percentage Rate (APR) Calculation

Financial Analysis
Payback Period calculation for Investments
Goal Seek to solve financial equations
Break-Even analysis
Solver for finding optimal solutions

Related Courses

Price 13,000 Tk + VAT
Md. Jehad Uddin
  • 29 Jul - 28 Aug 2018

This course is designed in such a way that participants ...

Accounts
Enamul Haque Sujon
  • 30 Jul - 5 Sep 2018

This advance certificate course is the combination of two ...

Accounts
Enamul Haque Sujon
  • 2 - 16 Aug 2018 (5 Sessions)

Learn to make decisions that positively impact the bottom ...

Accounts
Price 5,000 Tk + VAT
Muhammad Arif-ur-Rahman
  • 3 - 4 Aug 2018 (2 Days Long)

At the end of the course you will be a confident, skilful ...

Accounts
Target audience for this training are Finance and Accounting professionals and people who aspire to pursue their career in Finance or Accounting related areas. Target departments of this particular training are Finance, Accounting and related departments.
Arrangement for Certificate, lunch and two tea-break would be made by the Organizer during the workshop.


Training is the most helpful thing to remember our education or apply to our actual workplace. Md. Mahadi Hassan Momen, Executive - Audit, Wizemanns Boggie Consultant Pvt. Ltd.