Advanced Excel Training

by Excel4all Claim Listing

Advanced Excel Training program is meant for those who are the basic/intermediate users and want to shine or willing to be smart enough or wish to enrich their excel knowledge with the built-in tools/ features, functions and hidden commands.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Excel4all Logo

img Duration

Please Enquire

Course Details

Advanced Excel Training program is meant for those who are the basic/intermediate users and want to shine or willing to be smart enough or wish to enrich their excel knowledge with the built-in tools/ features, functions and hidden commands. 

16 hours of customised module having the comprehensive topographies empower the user to the optimum level and can make the difference at their work place.

 

Content:

  • Using logical functions
    • Naming ranges
    • - Creating named ranges
    • - Using named ranges in formulas
    • The IF function (recap)
    • Creating nested IF functions
    • AND and OR functions
    • Combining logical functions
  • Working with lookups 
    • The VLOOKUP function
    • The HLOOKUP function
    • Multi Criteria VLOOKUP
    • Advanced VLOOKUP
    • Combo V-Lookup
  • Advanced list management
    • Using data validation
    • - Setting criteria for entry of text, values and dates
    • - Creating a dropdown list
    • Using database functions
    • - Setting up criteria
    • - DSUM
    • - DAVERAGE
    • - DCOUNT
  • PivotTables and PivotCharts 
    • Using the PivotTable Wizard
    • Rearranging PivotTables
    • Exploring the PIVOT Features
    • Usage of Calculated Field
    • Working with Expand & Collapse Button
    • Exporting Report to Multiple Sheets
    • Using the PivotTable toolbar
    • Creating PivotCharts
    • Using Slicers to manipulate PivotTables
    • Making a dashboard Feeling 
    • Interactive Pivot Charts
  • Using analytical options
    • Using Goal Seek
    • Using the Solver add-in
    • Working with scenarios
    • - Creating and saving scenarios
    • - Scenario Summary
  • Macros
    • Creating macros
    • Using the macro recorder
    • Viewing and editing macro VBA code
  • Pune Branch

    Flat 405, Block B1, Pune
  • Patna Branch

    Plot No 16, Lane 2, Adarsha Vihaar, Patna

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy