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/excel-online-certification-course