Advanced Excel Training for Corporate's, Professionals & Students:

Advanced Excel Training course offered by Excel Prodigy. that makes you master in microsoft excel. We have conducted 750+ Corporate Training and Trained more than 22,500+ Professionals on Advanced Excel, VBA Macro, PowerPoint & Ms Office in India & International.

Advanced Excel Training Overview:

Our Advanced Excel training course will really show you how to make Excel work for you. The course is aimed at fairly experienced Excel users whom need to learn more complex functions, nesting, data manipulation and protect data using the security features. You will gain an insight into data tables and using excel advanced look up features to automate worksheets and analysis tools to forecast figures based on a range of scenarios and use consolidation to bring together information. Find out how you can utilise advanced ‘If’ statements.

PivotTables methods of Advanced Excel Training Course

Creating, Formatting Simple PivotTables. Page Field in a PivotTable, Formatting a PivotTable, Creating/Modifying a PivotChart.

Logical Functions

IFs and Nested IF Functions. Using AND/OR/NOT Functions

Statistical Functions

Using The SUMIF/COUNTIF Functions. Using The AVERAGE/COUNT/LARGER/SMALLER Functions

Advanced Excel Training Course

Course Duration of Advanced Excel Training Course: 16 Hours (2 Days)

Absolute Referencing

Problems with Absolute/Relative Cell Referencing, Creating Absolute/Mixed References

LOOKUP Functions

The VLOOKUP/HLOOKUP Functions

Excel 2007 & 2010 Quick Overview

Difference between Excel 2003, 2007 and 2010, Use of Excel, its boundaries & features

Basic Formula of Advanced Excel Training Course

Formulae that Add/Subtract/Multiply/Divide • BODMAS/Formula Error Checking • The Sum Function and power BI

How can we help you?

Drop Email For Corporate Training Across India & International or Call

Why Us

ADVANCED

Advanced
Filters

Extracting Records with Advanced Filter. Using Formulas In Criteria

Advanced
Sorting

Sorting by Top to Bottom / Left to Right. Creating / Deleting Custom List. Sort by using Custom List…

Hyper / Data Linking

Hyper linking data, within sheet / workbook. Linking & Updating links between workbooks & application.

Math & Trigonometry Functions

Using SUMPRODUCT Functions. Using FLOOR/ CEILING/ MROUND/ MOD/ QUOTIENT Functions

Summarizing Data

Creating Subtotals/Nested Subtotals. SUBTOTALS Formula

Outlining

Creating/Working with an Automatic/Manual Outline. Grouping / Ungrouping

Consolidation

Consolidating Data with Identical/Different Layout

Using Auditing Tools

Displaying/Removing Dependent & Precedent Arrows. Evaluate Formula – Step IN / Step Out

Custom Views

Creating Custom Views. Displaying Custom Views, Deleting Custom Views

Sharing and Protecting Workbooks

Sharing Workbooks & Tracking Changes. Protecting sheets / workbooks / Files

Importing & Exporting Data

Importing Data from Database/ Text Files/ Web. Exporting Data, Changing External Data Range. Feel free to connect with our experts: Get a free Quote