This Microsoft program is best suited for people who use Microsoft Excel in their day-to-day work, and know the basics fairly well which includes knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts, sorting, and filtering data.

This course extends your knowledge of the more advanced functions of Excel to become more productive and make the most of Excel.

The class size varies between 1-5 persons with students of different skill levels, and the instructor will dedicate individual time for each student to teach them as per their learning requirements and assign them tasks to practice the introduced tools.

You will learn:

• more complex formulas
• troubleshoot and customize excel application
• automate excel files and create dashboards
• how Sort and Filter works
• more specific data
• import and export data sets
• analyze data using the rich features provided in Excel. It will impart the necessary skills to create Macros

After the successful completion of the advanced Excel training program, students will be able to:

• Automate Workbooks with Advanced Functions / Formulas (Formula Nesting, Mega Formula, Array Formula)
• Work with large datasets, files with advanced data handling techniques.
• Advanced usage of Conditional Formatting, Data Validation, Filters, Protection, Pivot Table, Chart, and Formats.
• Analyze and present data using Pivot Tables and Pivot Charts.
• Creating dashboards using Pivot and Controls.
• Customize, Troubleshoot and enhance workbooks and the Microsoft® Office Excel® Environment.
• Advanced Excel certification

Detailed Course Outline:

• Workbooks (File) & Worksheet Handling
  
  • Excel Limitation.
  • Excel Shortcut use and Benefits.
  • Excel Setting and Custom List Creation.