Advance Excel

(Course Duration 6 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