₹4,500 ₹6,000

Course Includes

Duration3 Months
Enrolled0
Lectures90
Videos0
Notes0
CertificateYes

What you'll learn

Microsoft Excel is very Popular in the Business world at the moment. It contains lot of information, sometimes dynamic, on one page, so that people have access to a vast array of information without the need to juggle between many data & many figures.

MS - Excel is one of the Best Application on the market for daily reporting & analysis. It is a technique that many Excel Users may not be familiar with or know how to implement.

Course Syllabus

Advanced Formulas & Functions•
IF, Max, Min, Avg Formulas
•
Count, Counta, Countaif, Sumif
•
VLOOKUP
•
HLOOKUP
Data Management•
Schedules & Office Management
•
Data Validation
•
Text to Columns
•
PIVOT Table
Reporting & Analysis•
Attendance & Salary Statement
•
Payroll Statement
•
GST Calculations
•
Profit & Loss - Balance Sheet
Visualization•
Graphs & Charts
•
Advanced Conditional Formatting
Advanced Features•
Depth Knowledge on Excel Ribbons
•
Simple Macros
•
User Forms
•
Goal Seek
•
Printing - Themes & Many More

Course Fees

₹6000/-

Discounted Fees

₹ 4500/-

Course Duration

3 Months

Review

0.0

Course Rating (0 reviews)

Featured review

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

CERTIFICATE In ADVANCE EXCEL(S-AE-6520)

Course Includes

What you'll learn

Course Syllabus

Course Fees

Review

Featured review

More Popular Courses

ADVANCE DIPLOMA In COMPUTER APPLICATION(M-CA-1872)

CERTIFICATE In TALLY PRIME WITH GST(S-TPWG-6925)

Related Courses

ADVANCE DIPLOMA In COMPUTER APPLICATION(M-CA-1872)

CERTIFICATE In TALLY PRIME WITH GST(S-TPWG-6925)

CERTIFICATE In MS OFFICE(S-MO-2761)