Table of Content
 

 

Introduction to Advance Excel

  • Importing cv prn files
  • MS Access and Customized Data Base
  • Importing web queries
  • Formatting Data
  • Pivot table_1
  • Pivot Table_2
  • Data Base Function
  • Converting Data Tabular Format
  • Conditional Formatting
  • Pivot Table Chart

Recording and using Macros - Introduction to VBA

  • Introduction to VBA
  • Defining Events Using Macro
  • VBA Functions
  • VBA Coding I
  • VBA Chart
  • Recording Macro Efficiently
  • Breaking Circular Reference using Macro
  • Importing Web Data using Macro
  • User Defined Function using Macro
  • Sharing Function

Building Sensitivity and What-If analysis

  • Finding BE Quantity using Goal Seek
  • Sensitivity Analysis using Data Table
  • Using Solver and Scenario Manager to Achieve Desired Outcome
  • Usage of Monte Carlo Simulation
  • Forecasting using Monte Carlo Simulation

Advance Excel

  • Isolating Outliers
  • Receivable Aging
  • Tracking Changes
  • Protecting and Hiding Worksheet
  • Evaluate and Auditing Formula
  • Identifying and Removing Duplicates
  • Removing Circular References
  • Benford Law

Maintaining Financial Statements in Excel

  • Financial Statements Consolidate Conditionally 1
  • Financial Statements Consolidate Conditionally 2
  • Consolidating Data
  • Creating Invoice using Macro
  • Converting Excel Book into Flexible PDF
  • Merging Multiple Files

 

Apply for certification

https://www.vskills.in/certification/accounting-banking-and-finance/Excel-for-Accountants