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

SICS (Shah Institute Of Computer Science) Logo

MS Visio

MS Visio course is offered by SICS ((Shah Institute Of Computer Science). SICS offers courses in diverse domains to college students, graduates and experienced working professionals. These courses enable individuals to get an unrivaled boost in their career graph.

by SICS (Shah Institute Of Computer Science) [Claim Listing ]
CEl (Computer Education Institute) Logo

MS Excel

MS Excel course is offered by CEl (Computer Education Institute). Since 2000, CEl has been offering professional training to students. It is run and managed by seasoned professionals who lead a team of educators and trainers having relevant domain expertise.

by CEl (Computer Education Institute) [Claim Listing ]
  • Price
  • Start Date
  • Duration
Bapu Institute Of IT & Management Logo

MS Office

We provide full training in MS Office which includes Excel, Word, PowerPoint, etc. Our highly professional certified trainers are here to provide you the best testing training.

by Bapu Institute Of IT & Management [Claim Listing ]
Grant Thornton India LLP Logo

Advanced Excel Boot Camp

In today’s evolving business environment, all organisational functions need to work on complex spreadsheets representing financial results, budgets, forecasts and plans. As a result, Microsoft Excel has become an integral data processing and analysing tool for making critical business decisions.

by Grant Thornton India LLP [Claim Listing ]
RIC Education Logo

MS Office

MS Office course is offered by RIC Education. RIC is one of most popular Institute of Odisha's Google ranking. As such we educate, make innovative discoveries and generate entrepreneurial ideas for improving student’s lives and power of the digital skills.

by RIC Education [Claim Listing ]

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