Advance MS Excel
Certification in Advance MS Excel
This course will start from the beginner’s level and step by step will take you to the advance level of MS Excel. In this course, you will practically learn; MS Excel shortcuts, most frequently used excel functions, creating highly presentable charts, preparing spreadsheets, managing large sets of data and advanced excel functions like VLOOKUP, HLOOKUP, Pivot Table, What If Analysis, Index, Match, NPV and IRR etc.
.
This course is must recommended to students & professionals about to start their professional career or wish to enhance their MS Excel skills
.
Wish For Better Future Today, Enquire Now!
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
- 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
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 ....