Online Certification program on Training in Advance Microsoft Excel

Tools You’ll Master

What you will learn in this course?

  • 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

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

Course Price

INR 4000/-

Enroll Now