Advanced Excel

For an experienced professional, it’s easier to work with different techniques and formulas of Advanced Excel in a “standalone” mode. E.g. Just VLookup() formula or Consolidate technique. However, you will be able to extract the Ninja-level power from the different formulas and techniques. If you can nest different formulas together and combine various techniques. E.g. VLookup() + Match() with Indirect() and range naming will allow you to build a 3-dimensional lookup with data pull-up power. This Advanced Excel Training program is best suited for people who use Microsoft Excel in their day-to-day work, and know the basics fairly well, but would like to extend their knowledge of the more advanced functions of Excel to become more productive and make the most of Excel. The course is designed for students would want to learn how sort and filter data, import and export data sets, and analyze data using the rich features provided in Excel. It will impart the necessary skills to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data. In addition, the course is also for students desiring to prepare for the Microsoft Certified Application Specialist exam in Microsoft® Office Excel®, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

  • Introduction to MS Excel.
  • Sorting and Filtering Data
  • Conditional Formatting, Working with Styles
  • Logical functions
  • Mathematical and Statistical Functions
  • Lookup Functions
  • Data Validation
  • Working with Templates
  • Date and Time Functions
  • Text Functions
  • Database Functions
  • Financial Functions
  • Creating Pivot Tables using Pivot Table options.
  • Security and Protection for Worksheets.
  • Excel VBA Macros
  • Project & Assignment
  • SSC & HSC
  • Graduation & Above
1 to 2 Months
  • Computer Knowledge