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.
