Advance Excel

ADVANCED EXCEL WITH FORMULAS – LEVEL 1

You can Learn All Excel Command and more than 200 Excel Worksheet formulas based on Tricks for Report Automation.

Data Analytics
MIS Reporting
Data Cleaning
Financial Modeling
Nested Formulas writing
Array Formula
Form Controls
PowerPivot Reporting
Dynamic Chart Creation
Dashboard Creation

Advance Nested Functions To Related Dynamic Project
Dynamic Attendence Sheet With Function
Dynamic Filter with Function
Dynamic Chart with Function
Dynamic Vlookup With Function
Dynamic Pivot Table With Function
Dynamic Name Vlookup Repeated With Function

Excel Professional Project

1.Data manipulation, import and export
2.Full scale applications -Portfolion management & modelling
3.Legacy Applications – modification and migration
4.Macros
5.Plug-ins
6.Reports, graphs and charts
Excel Financial Project

1. TAX PLANNING
2. FINANCIAL BUSINESS STRUCTURING
3. LEGAL SERVICES AND REPRESENTATION
4. AUDITING SERVICES
5. ACCOUNTING SOFTWARE SUPPORT

Our Trainers:

  • Experience in VBA Anaylitics
  • More than 8 years of industry experience
  • More than 5 years of teaching experience