Certified Advance Excel Course Contents:

Section 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

Section 2

• Tabs and Menus of Excel, Office Button / File Menu
• Home Tab Options (Advanced Formatting & Paste Special)
• Specialized Effects like Cond. Formatting and many More Options
• Insert Page Elements and Page Setup with Advanced Options
• Formula Tab options with Auditing, Data Tools in Excel
• Advance Security Option from Review and View Tabs
• Section 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.

Section 4

·25 Industry Level Projects for Individual options in Excel.

• MIS Reporting Analysis Options.
• Advanced Reporting using Developer tab Options.
• Detailed Work to Handle Large Data with Data Operations like Advanced Filter.

MSR EDUSOFT PVT. LTD. ( Software Trainings and Academic IEEE Projects)

Office Address: #503 & 417,Annapurna Block, Adhithya Enclave, Beside Ameerpet Metro Station,Ameerpet, HYD-38.

EMAIL: msrprojectshyd@gmail.com, Web: www.msrprojects.org ,  facebook.com/msrprojects ,

 Call:  +91  9581464142 , +91  8977464142