Certificate In Advanced Excel

by IISDT Indian Institute of Skill Development Training Claim Listing

Advanced Excel refers to features and functions of Microsoft Excel tool which helps the user to perform complex and large calculations, data processing on the huge amount of data, performing data analysis, better representation of data, etc.

$2500

Contact the Institutes

Fill this form

Advertisement

IISDT Indian Institute of Skill Development Training Logo

img Duration

90 Hours

Course Details

Advanced Excel refers to features and functions of Microsoft Excel tool which helps the user to perform complex and large calculations, data processing on the huge amount of data, performing data analysis, better representation of data, etc.

 

Syllabus:

  • Introduction to Advanced Excel: Introduction to excel, excel interface, creating open workbook, saving & Sharing Books, cells basic, modifying column, function of excel.
  • Function & Formula in Advance Excel: foundation function & formulas, nesting function, IF Formula, VLOOKUP, VLOOKUP with OFFSET, Money Function, Calculate payment towards principle, future value, Depreciation, 3D formula.
  • Data Validation: Introduction to data validation, Rules of consistency, Types of Date Validation, Data Validation dialog box, applying Data Validation.
  • Pivot Table:  what is pivot table, preparing your data, creating your first pivot table, Modifying subtotals & grand totals, sorting table, filtering pivot table, formatting pivot table, printing pivot table.
  • Conditional formatting: Understanding Conditional Formatting, Formatting cells containing values, clearing conditional formatting, more cells formatting options, more top & bottom formatting options, working with data bars, working with color scale,  working with icons.
  • Spreadsheets: introduction to excel worksheet, staring excel, excel screen, column & cells, Sheet & Workbook, moving around in excel, data entry, formatting, formula creation & Math Function, creating charts, chart wizard, text import wizard, printing.
  • Indore Branch

    1187, Scheme No. 114, Vijay Nagar- 452010, Indore

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy