Online Certification program on Training in Advance Microsoft Excel

Tools You’ll Master

Shortcut Keys
Use of GoTo and extensive use of Paste Special Dialog Box
Referencing-Absolute,Relative Mixed
Text Functions- Left,Right,Mid,Concatenate,Substitute,TRIM
Date Function- Days, Months,Year,Datedif,Edate,E month, Countif,Sumif,Countifs,Sumifs
Lookup-VLookUp, Index and Match
IF Function- IF , Nested IF,AND,OR
Conditional Formatting
Data Text to Columns
Data Tools-Sort and Advance filter
Data Subtotal-Single level and also Multiple level
Data Consolidation
Pivot Table-In details

Enroll Now

14hrs Live Sessions

6 hrs Practical Projects

Learn Pivot Table in Details

Learn Short-cut keys

Data Sorting, Data Representation and Data processing through Excel

Enroll Now