This advanced Excel course is designed to take Excel users to the next level by illustrating advanced functions and formulas. Understand how to reference data using INDEX and MATCH. Manipulate text-string data using functions like RIGHT, CELL, LEN, and FIND. Apply data analysis tools, like data tables and PivotTables. Look-up, IF Funcion Etc.

Advanced Excel possess all the features and functions of Microsoft excel tool which helps the users to perform complex and large calculations, data processing of large number of numerical data, better representation of data, performing data analysis and much more.Advance excel is a most demanded skills of the countless companies and the industries today.

With the rise of big data and data analytics, advanced Excel skills are a real skill for both, the job and everyday work tasks.

 Font formatting  Number formatting  Table formatting  Conditional formatting  Hide / Unhide  Sort / filter  Paste special  Find and select

 Sum / Average / Count / Max / Min  Basic Text / date / time / lookup / information functions  Name manager  Formula Auditing

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