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

Check out more MS Excel courses in India

DASVM Logo

Microsoft Visio

Visio is a drawing and diagramming program that includes a variety of pre-drawn shapes and picture elements that can be dragged and dropped onto the illustration. Users can define their own elements and place them onto the Visio palette.

by DASVM [Claim Listing ]
MicroPaceIT Computer Academy Logo

Microsoft Word

Microsoft Word course is offered by MicroPaceIT Computer Academy. Unlock mastery with concise training. Elevate Microsoft Word skills for enhanced productivity in impactful, well-structured documents.

by MicroPaceIT Computer Academy [Claim Listing ]
Mittal Computer Education Industry Logo

Certificate In Ms Access

MCEI (Mittal computer Education Industry) is an inimitable organization working with single minded purpose to bring a gigantic transformation in the world.

by Mittal Computer Education Industry [Claim Listing ]
Vedasys Logo

Advanced Excel 2019 Course

Learn Excel through our Advanced Excel course in Goa and boost the impressions you make on your boss or in the board room. Data is currency of the new age and you need to be adept at data reading and data analytics.

by Vedasys [Claim Listing ]
Shree Ram Tally Academy Logo

Advance Excel

Advance Excels course is offered by Shree Ram Tally Academy.

by Shree Ram Tally Academy [Claim Listing ]
  • Price
  • Start Date
  • Duration

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