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 ....