Overview

Our expert faculty providing advance level of excal training with the most advanced functions, formulas, and types of financial analysis.

This advanced excel tutorial will help you become a expert in financial analyst/institute for careers in banking, investment, corporate development, private equity, FP&A and equity research.

Course Module

Overview of the Basics of Excel

  • Customizing common options in Excel
  • Absolute and relative cells
  • Protecting and un-protecting worksheets and cells
  • Advanced Excel Course - Working with Functions

  • Writing conditional expressions (using IF)
  • Using logical functions (AND, OR, NOT)
  • Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
  • VlookUP with Exact Match, Approximate Match
  • Nested VlookUP with Exact Match
  • VlookUP with Tables, Dynamic Ranges
  • Nested VlookUP with Exact Match
  • Using VLookUP to consolidate Data from Multiple Sheets
  • Advanced Excel Course - Data Validations

  • Specifying a valid range of values for a cell
  • Specifying a list of valid values for a cell
  • Specifying custom validations based on formula for a cell
  • Advanced Excel Course - Working with Templates

  • Designing the structure of a template
  • Using templates for standardization of worksheets
  • Advanced Excel Course - Sorting and Filtering Data

  • Sorting tables
  • Using multiple-level sorting
  • Using custom sorting
  • Filtering data for selected view (AutoFilter)
  • Using advanced filter options
  • Advanced Excel Course - Working with Reports

  • Creating subtotals
  • Multiple-level subtotals
  • Creating Pivot tables
  • Formatting and customizing Pivot tables
  • Using advanced options of Pivot tables
  • Pivot charts
  • Consolidating data from multiple sheets and files using Pivot tables
  • Using external data sources
  • Using data consolidation feature to consolidate data
  • Show Value As ( % of Row, % of Column, Running Total, Compare with Specific Field)
  • Viewing Subtotal under Pivot
  • Creating Slicers ( Version 2010 & Above)
  • Advanced Excel Course - More Functions

  • Date and time functions
  • Text functions
  • Database functions
  • Power Functions (CountIf, CountIFS, SumIF, SumIfS)
  • Advanced Excel Course - Formatting

  • Using auto formatting option for worksheets
  • Using conditional formatting option for rows, columns and cells
  • Advanced Excel Course - Macros

  • Relative & Absolute Macros
  • Editing Macro's
  • Advanced Excel Course - WhatIf Analysis

  • Goal Seek
  • Data Tables
  • Scenario Manager
  • Advanced Excel Course - Charts

  • Using Charts
  • Formatting Charts
  • vUsing 3D Graphs
  • Using Bar and Line Chart together
  • Using Secondary Axis in Graphs
  • Sharing Charts with PowerPoint / MS Word, Dynamically
  • (Data Modified in Excel, Chart would automatically get updated)
  • Advanced Excel Course - New Features Of Excel

  • Sparklines, Inline Charts, data Charts
  • Overview of all the new features
  • Advanced Excel Course - Final Assignment

  • The Final Assignment would test contains questions to be solved at the end of the Course
  •