SOFTTECH INSTITUTE OF EDUCATION TECHNOLOGY

₹3,500 ₹5,000

Enquire Now

Course Includes

Duration03 Months
Enrolled1
Lectures24
Videos0
Notes0
CertificateYes

What you'll learn

Course Details

Course Name: Advanced Excel
Duration: 3 Months
Training Mode: Practical Computer Classes
Level: Beginner to Advanced
Certificate: Certificate after course completion
Admission: Open

Course Syllabus

Module 1: Excel Fundamentals

Excel interface, worksheets and workbooks
Data entry, formatting and tables
Sorting, filtering and conditional formatting

Module 2: Formulas & Functions

SUM, AVERAGE, COUNT, IF and SUMIF
COUNTIF, IFERROR and nested IF
VLOOKUP, HLOOKUP and XLOOKUP
Text, date and logical functions

Module 3: Data Analysis

Pivot Tables and Pivot Charts
Charts, graphs and dashboards
Data validation and data cleaning
Remove duplicates and identify errors

Module 4: Practical Projects

Salary and payroll sheets
Student result management
Sales reports and business dashboards
Office reporting and real-time case studies

Eligibility

Who can apply for this course

10+

Course Fees

₹5000/-

Discounted Fees

₹ 3500/-

Course Duration

03 Months

Review

0.0

Course Rating (0 reviews)

Featured review

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

Call

Text Message

Review

CHAT

CERTIFICATE In ADVANCED EXCEL(S-CAE-4783)

Course Includes

What you'll learn

Course Details

Course Syllabus

Eligibility

Course Fees

Review

Featured review

More Popular Courses

CERTIFICATE In GRAPHIC DESIGN(M-CGD-8019)

CERTIFICATE In ADVANCED EXCEL(S-CAE-4783)

Related Courses

CERTIFICATE In GRAPHIC DESIGN(M-CGD-8019)

CERTIFICATE In POWER BI(S-CPB-7238)

CERTIFICATE In ITALIAN LANGUAGE(S-IL-4600)