Bestseller

0 rating

0 students

CERTIFICATE IN ADVANCED EXCEL

Last updated Nov, 2025
Certified Course

₹5,000 ₹6,000

Enquire Now

Duration1 Months
Enrolled0
Lectures45
Videos0
Notes0
CertificateYes

What you'll learn

CERTIFICATE IN ADVANCED EXCEL

Course Syllabus

Entering of Data

Addressing Method (Relative, Absolute & Mixed)

Cell Referring to Worksheet

Cell Referring to Another Workbook

Assign Security to Workbook, Worksheet & Cells

Data Validation

Working with Shortcut Keys

MS-Excel Functions

Mathematic Functions
Trigonometry Functions
Statistical Functions
Date & Time Functions
Text Functions
Lookup Functions
(Lookup, VLookup, HLookup)
Financial Functions
Logical Functions

Quick Sort & Custom Sort

Using of Filter & Advanced Filter

Using of Subtotal

Goal Seek

Pivot Table

MIS Reporting

Export of Data & Macros

Page Setup & Printing

Work on Live Assignments of:

Salary Statements
Sales Management Report
Calculation of Income Tax
Calculation of Interest (Simple & Compound)
Calculation of Commission
Preparation of Loan Statement
Students Report
Calculation of Depreciation (Straight Line & Written Down Value Method)

Duration: 1 Month

Course Fees

₹6000/-

Discounted Fees

₹ 5000/-

Course Duration

1 Months

Review

0.0

Course Rating (0 reviews)

Featured review

No reviews yet. Be the first to review this course!

CERTIFICATE IN ADVANCED EXCEL

What you'll learn

Course Syllabus

Course Fees

Review

Featured review

More Popular Courses

CERTIFICATE IN MS-CIT

DIPLOMA IN OFFICE AUTOMATION

Related Courses

CERTIFICATE IN MS-CIT

CERTIFICATE IN TALLY PRIME ACCOUNTING PACKAGE WITH GST

CERTIFICATE IN ADVANCED TALLY PRIME WITH GST