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

NIED Education Logo

Certificate In MS Office

Certificate in MS-Office is offered by NIED Education for all skill level. Our team always focuses on to bring out and built the personality of the student and provides deep and adequate knowledge to change life-style by new technologies and providing awareness to upcoming technologies.

by NIED Education [Claim Listing ]
Techno Expert Solutions Logo

MS-Word (Beginner)

Techno Expert Solutions provide real-time and placement focused MS-Word Beginner training in Delhi. Microsoft Word is a generally utilized business word processor created by Microsoft.

by Techno Expert Solutions [Claim Listing ]
4C Training Logo

MS Excel (Basic & Advance)

MS Excel training is offered by 4C Training. 4C Training targets to design & deliver the right training programs for the growth of participants. We intend to become one of the well-known, respected, and preferred training partners for clients for all verticals. 

by 4C Training [Claim Listing ]
SkiLL HiKeR Logo

Certificate Course in MS-Excel

Certificate Course in MS-Excel is offered by SkiLL HiKeR. We offer short-term training programs (2/4/6 weeks) as well as 6-month training in the latest technologies throughout the year at all our centers, complete with placement assistance.

by SkiLL HiKeR [Claim Listing ]
Advance Computer System Technology Of Management Logo

MS Access (Latest Version)

MS Access course is offered by Advance Computer System Technology Of Management. ACSTM is the biggest educational which provides a great platform in IT sectors in the Indian sub-continent.

by Advance Computer System Technology Of Management [Claim Listing ]

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