Excel Specialization for Accounting & Finance

Master Excel for Accounting, Finance, & Financial Analysis

Module 1

Up and running with Excel

Excel functions and formulas for Accounting & Finance

Financial Reporting & Financial Analysis with Excel

Financial Modeling with Excel

Module 2

Module 3

Module 4

Module 1:

Microsoft Excel Beginner to Pro

• Start from scratch, right from learning about cells, columns, and rows.

• Learn to store, modify and analyze data.

• Learn systematic Data Analysis with Excel Pivot Tables.

• Learn to prepare stunning dashboards.

• Deep dive into the Advance Data Analysis with Power Pivot.

• Writing dynamic formulas with DAX.

Module 2:

Microsoft Excel for Finance, Accounting, & Financial Analysis

Master Finance & Accounting specific functions and formulas like:

• Deprecation

• PV & FV

• NPV & IRR

• Loan & mortgage calculations formulas

• Bond Valuation

• What-if analysis

• Goal Seek

• Scenario analysis

• Financial Statements preparation - basic

• Financial Statement horizontal & vertical analysis

• Preparing GL for Reporting & Analysis

Module 3:

Financial Reporting & Financial Analysis with Excel

• Understanding Accounting database

• Connecting database with Excel

• Connecting tables of data - Data Modeling

• Preparing Financial Statements with Power Pivot

• Calculating Financial Ratios with DAX

• Preparing Financial Snapshot Dashboards

Module 4:

Financial Modeling in Excel

• Understanding Financial Model

• Preparing three statement model

• Deriving Business Value from Financial Model

• Scenario Analysis