50% Off

Certificate in Advanced Excel

Rs.3,000 Rs.1,500

IISDT Offers 50% discount on all courses. Enroll your course today to avail discount offer. Government Job Valid Diploma/Certificate.

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.

Description

Course Name: Certificate in Advanced Excel

Course Id: CAE/Q1001.
Education Qualification: 10th Pass.

Duration: 90 Hrs (Equivalent to 3 Months).

How You will Get Diploma Certificate:

Step 1- Select your Course for Certification.

Step 2- Click on Enroll Now.

Step 3- Proceed to Enroll Now.

Step 4- Fill Your Billing Details and Proceed to Pay.

Step 5- You Will be Redirected to Payment Gateway, Pay Course and Exam Fee by Following Options.

Card(Debit/Credit), Wallet, Paytm, Net banking, UPI and Google pay.

Step 6- After Payment You will get Study Material Login id and Password on your email id.

Step 7- After Completion of  Course Study give Online Examination.

Step 8- After Online Examination you will get Diploma Certificate soft copy(Scan Copy) and Hard Copy(Original With Seal and Sign).

Step 9- After Certification you will receive Prospect Job Opportunities as per your Interest Area.

Online Examination Detail:

Duration- 60 minutes.
No. of Questions- 30. (Multiple Choice Questions).
Maximum Marks- 100, Passing Marks- 40%.
There is no negative marking in this module.

Benefits of Certification:

  • Government Authorized Assessment Agency Certification.
  • Certificate Valid for Lifetime.
  • Lifetime Verification of Certificate.
  • Free Job Assistance as per your Interest Area.

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.