Advance MS Excel

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.

Advance MS excel:
In today's scenario, Microsoft Excel is an 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:

    • 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

    • Page Layout: Margins, Orientation, Scale
    • Formulas: Financial, Logical, Text, Date & Time, Lookup, Mathematical
    • Home: Format painter, Merge & Centre, Wrap text, Filter, Find & Replace

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

    • Data: Sorting, Remove duplicates 

    • Review: Protect workbook, Protect sheet and Share workbook

    • View: Freeze panes

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