Certification in Advance MS Excel

In today's scenario, Microsoft Excel is a important tool for working and analysing data. Knowing how to leverage Excel enables you to simplify complex tasks, essential to daily work responsibilities. In this advance course, you gain the skills needed to create Excel worksheets, applying functions, develop formulas, analyse data and apply sophisticated formatting to capture and present your data.

Key Course Highlights:

Module 1 : Working with workbook

  • Quick Access Tool Bar: Add and delete functions
  • Shortcuts: Paste special, Add row & column, Delete row & columns, Hide & Unhide row & columns, Filter, Find & Replace, Working with cells and many more
  • Referencing: Absolute and Relative referencing

Module 2: Working with Tabs

  • Home: Format painter, Merge & Centre, Wrap text, Filter, Find & Replace

  • Insert: Smart art, Line, Column and Pie charts

  • Page Layout: Margins, Orientation, Scale
  • Formulas: Financial, Logical, Text, Date & Time, Lookup, Mathematical
  • Data: Sorting, Remove duplicates 

  • Review: Protect workbook, Protect sheet and Share workbook

  • View: Freeze panes

Module 3: Special Functions

  • Paste Special, Conditional Formatting, Hyperlink, Pivot Table, Vlookup, Hlookup, Amortization Schedule, NPV, IRR, Retirement Planning, EMI Calculation, Transpose, What If Analysis, Sum If, Data Validation, many more ....

Our Offerings

  • Library
  • Practise sheets & ebooks

  • Practical Based Training
  • 100% Placement Assistance

  • Well Qualified and Experienced Faculties

Drop us a line
The brightness is also a process dynamics
Enquiry Now