Advance Pro Excel

(Course Duration 9 Months)

Module 1: Introduction of MS-Excel

• Calculations in Excel (Basic Formula's & Advanced Formula's)
• Calculations in Excel (Absolute/ Relative/Sheet Reference)
• Linking between Excel Files and Data, Chart Preparation in Excel with Details Features

Module 2: Advanced Functions of MS-Excel

• Tabs and Menus of Excel, Office Button/File Menu
• Home Tab Options (Advanced Formatting & Paste Special)
• Specialized Effects like Formatting, Page Elements & Setup with Advanced Options
• Formula Tab options with Auditing, Data Tools in Excel
• Advance Security Option from Review and View Tabs

Module 3:

• Advanced Data Analysis (Adv. Sort, Filter, Subtotal, Validation, Consolidation)
• Goad Seek and Scenario Features in Excel Industry Work
• PIVOT Table and Data Analysis using options of Pivot Table
• More Useful Functions in Excel (Date/Time, Text, Mathematical, Statistical etc.)
• V-Lookup and H-Lookup Functions and its use in Industry

Module 4:

• 25 Corporate Level Projects for Individual options in Excel
• MIS Reporting Analysis Options.
• Detailed Work to Handle targe Data with Data Operations like Advanced Filter.
• Introduction to VBA, Macro and How to Use Macro in Excel I to save Work Time

Module 5:

• Multiple-level Sub Total Reports
• Filtering database & Sorting data
• Securing & Protecting Worksheets
• Linking Multiple Sheets
• Sheet Referencing
• Dynamic Linking Word/Excel/Powerpoint
• Functions: LOOKUP, VLOOKUP
• HLOOKUP
• COUNTIF, SUMIF
• What-if-analysis
• Goal Seek
• Pivot Tables & Pivot Charts
• Scenario Manager
• Date Functions
• Age Calculations
• NESTED IF
• Consolidation of Data
• Data Validation
• Logical functions.
• (AND, OR, NOT)
• Macro: Definition & Concepts
• Record & Run a macro
• Store a macro
• Introduction to VBA Prog
• 25+ Projects of Practical Training