Certificate In Advanced Excel

Description

Course Name: Certificate in Advanced Excel

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

Duration: 90 Hrs.

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.