Get 20% discount

Microsoft Excel for Finance and Accounting

  • Date : Friday, December 29, 2017
  • Duration : Day(9.30 AM-5.30 PM)
  • No. of Classes/ Sessions : Day Long
  • Last Date of Registration : 28 December, 2017
  • Venue : Bdjobs Training, BDBL Building (Level 19), 12 Kawran Bazar C/A, Dhaka 1215.

Introduction

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

Enamul Haque Sujon
  • 22 Nov - 25 Dec 2017

Tally is a most powerful, yet very simple and easy, ...

Accounts
Enamul Haque Sujon
  • Saturday, November 25, 2017

Tally is a most powerful, yet very simple and easy, ...

Accounts
Enamul Haque Sujon
  • 25 Nov - 18 Dec 2017

The 5 Basic Functions of QuickBooks. by creating the ...

Accounts
Dr. Md. Abdur Rouf
  • Friday, December 1, 2017

The purpose of this program is to provide the participants ...

Accounts

Price: Tk. 3,500+VAT

(15% VAT is applicable in every purchase.)

Contact

9140345, 9117179 , 01811410862, 01811 487981

workshop@bdjobs.com

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.

Resource Person

Abu Shams Mahmood Arif

Associate Director

Mr. Shams has been working in a leading multi-national bank for several years. His extensive work experiences are in Business Analytics & MIS, Process Re-engineering & Automation, Business Research & Development and Project Management.
He has graduated from North South University. After that he completed his MBA. His major accomplishments and contributions are Business Operations Analytics, BOLD (Six Sigma Initiative), CBS (Core Banking System), BEFTN (Bangladesh Electronic Fund Transfer Network). .

He has been a reputed public and corporate trainer for several years on subjects like Management Information System(MIS), Financial Analysis & Modeling, MS Excel, Macros & VBA, MS Access, MS PowerPoint, MS Word and MS Outlook up to advanced level.
For last several years, he has been a reputed public and corporate trainer on subjects like Business Analytics, Financial Analysis & Modeling, MIS, MS Excel, Macros & VBA, MS Access, MS PowerPoint, MS Word and MS Outlook up to advanced level.

Courses from this trainer 118

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.


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.