Advanced Microsoft Excel

  Venue Details

Please contact us at

  Trainer Details

Please contact us at

Advanced Microsoft Excel Training in India

Rating:    Votes:  234
Learners: 1281

This course will teach you how to analyse and report on data frequently, work in collaboration with others to deliver actionable organizational intelligence, and keep and maintain workbooks for all manner of purposes. You will also learn how to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you’ll be able to focus on getting the answers you need from the vast amounts of data your organization generates.

1. Working with Multiple Worksheets and Workbooks

Use Links and External References

Use 3-D References

Consolidate Data

2. Using Goal Seek, Solver and VLookup

Setting up the Worksheet

Using Goal Seek

Running Solver

Generating Reports and Scenarios with Solver

Modifying Constraints

Setting Solver Options

Use VLookup

3. Analyzing Data

Enabling the Analysis ToolPak

Using Data Analysis Tools

Using Data Tables

4. Managing Data

Consolidating Information

Removing Duplicates

Configuring Data Validation

Transposing Data

Converting Text to Columns

5. Using the Inquire Add-In

Installing Inquire

Generating a Workbook Analysis Report

Viewing Workbook and Worksheet Relationships

Viewing Cell Relationships

Comparing Two Workbooks

6. Working with Slicers

Inserting and Using a Slicer

Renaming the Slicer

Changing Slicer Settings

Formatting a Slicer

Clearing the Slicer

7. Forecasting Data

Determine Potential Outcomes Using Data Tables

Determine Potential Outcomes Using Scenarios

Creating Scenarios

Loading Scenarios

Merging Scenarios

Editing Scenarios

Creating a Scenario Summary Report

Deleting Scenarios

Use the Goal Seek Feature

Forecasting Data Trends

8. Introducing Power View

Enabling Power View

Creating a Power View

Adding and Removing Fields

Arranging Fields

Filtering Data

Sorting Data

Refreshing Data

Choosing a Visualization

Changing Tile Display

Setting Display Options

9. PivotTable Features

Creating a Basic PivotTable

Creating a Basic PivotChart

Using the PivotTable Fields Pane

Adding Calculated Fields

Sorting Pivoted Data

Filtering Pivoted Data

10. Introducing PowerPivot

Enabling PowerPivot

Importing Access Data

Importing Excel Data

Integrating Data with Relationships

Creating a PivotTable with PowerPivot Data

11. Automating Workbook Functionality

Apply Data Validation

Search for Invalid Data and Formulas with Errors

Work with Macros

Gain Industry Relevant Skills : Learn Advance Excel skills and techniques which are applicable to any industry.

Career Growth : The program will be a great value-add to your resume, which can help you pursue a promising career

Enhanced Job Opportunities : Get hired as Data Analyst, Business Analyst, Operations Manager, Financial Analyst, Accountant, Sales and Marketing & HR Specialist etc.

Discuss Industry Trends : Live Web based sessions (classes) with faculty for discussion on current industry trends and doubt clearance of concepts.

Learn Data Analysis Techniques : Learn through case studies which explain data analysis in a real time scenario.

Prep for Microsoft Office Specialist Exam : The program is oriented towards preparing you for Microsoft Office Specialist certification exam.

Advanced Excel 2016 course is recommended for end users seeking proficiency in the use of Microsoft Excel 2016 at an advanced level or seeking to obtain Microsoft Office Specialist certification in Microsoft Excel 2016 at Expert level or an equivalent, A must for every professional from entry to senior level managers in any industry, Management graduates, For students aspiring for entry level jobs in any domain this is mandatory.

What version of Excel is used in Skopoz Training & Consulting Pvt Ltd.

Microsoft Excel 2016 is currently used by most of the classroom, online and corporate Training sessions.

  Your Location

Delhi NCR, India
Change city


 Price Details

INR 22990

Group Discounts

group discount

Training Gallery