DOT NET COMPUTER EDUCATIONAL SOCIETY

₹3,500 ₹8,500

Course Includes

Duration3 Months
Enrolled0
Lectures5
Videos0
Notes0
CertificateYes

What you'll learn

आज के समय में Excel सिर्फ Data Entry का नहीं, बल्कि Data Analysis, Reporting और Office Management का एक महत्वपूर्ण skill है।

Dot Net Computer Pihani का Advanced Excel Course आपको Basic से Advanced Level तक Practical Training के साथ Excel में Expert बनने में मदद करेगा।

इस कोर्स में आप सीखेंगे:

✅ Advanced Excel Formulas & Functions

✅ VLOOKUP, XLOOKUP, INDEX, MATCH

✅ Pivot Table & Pivot Chart

✅ Charts & Professional Dashboards

✅ Data Analysis & Reporting

✅ Power Query & Power Pivot

✅ Data Cleaning & Management

✅ Real-Life Practical Projects

✅ Office & Job-Oriented Excel Skills

Course Syllabus

📌 Module 1: Excel Basics & Fundamentals

Excel Interface & Workbook Management
Rows, Columns, Cells & Worksheets
Data Entry & Formatting
Number, Date & Custom Formatting
Sort & Filter
Find & Replace
Page Setup & Printing

📌 Module 2: Excel Formulas & Functions

Basic Mathematical Formulas
SUM, AVERAGE, MIN, MAX
COUNT, COUNTA, COUNTIF, COUNTIFS
SUMIF & SUMIFS
IF, AND, OR, NOT
IFERROR
Nested IF

📌 Module 3: Lookup & Reference Functions

VLOOKUP
HLOOKUP
XLOOKUP
INDEX & MATCH
Multiple Criteria Lookup
Practical Lookup Projects

📌 Module 4: Data Management

Data Validation
Drop-down Lists
Remove Duplicates
Text to Columns
Flash Fill
Conditional Formatting
Data Cleaning & Preparation

📌 Module 5: Pivot Table & Pivot Chart

Creating Pivot Tables
Sorting & Filtering Pivot Data
Grouping Data
Calculated Fields
Pivot Charts
Slicers & Timelines
Practical Reporting

📌 Module 6: Charts & Dashboard

Column, Bar, Line & Pie Charts
Combo Charts
Dynamic Charts
Professional Dashboard Design
KPI & Summary Reports
Interactive Dashboard with Slicers

📌 Module 7: Advanced Data Analysis

What-If Analysis
Goal Seek
Scenario Manager
Advanced Filtering
Subtotal & Consolidation
Data Analysis Techniques

📌 Module 8: Power Query

Introduction to Power Query
Importing Data
Data Cleaning
Merge & Append Queries
Transforming Data
Combining Multiple Files
Refreshable Reports

📌 Module 9: Power Pivot

Introduction to Power Pivot
Data Models
Relationships Between Tables
Calculated Columns
Basic DAX Functions
Advanced Data Analysis

📌 Module 10: Practical Projects

Student Attendance Report
Salary & Payroll Sheet
Sales Report
Stock/Inventory Management
Employee Management Report
Monthly Expense Report
Professional MIS Report
Interactive Excel Dashboard

📌 Module 1: Excel Basics & Fundamentals

Excel Interface & Workbook Management
Rows, Columns, Cells & Worksheets
Data Entry & Formatting
Number, Date & Custom Formatting
Sort & Filter
Find & Replace
Page Setup & Printing

📌 Module 2: Excel Formulas & Functions

Basic Mathematical Formulas
SUM, AVERAGE, MIN, MAX
COUNT, COUNTA, COUNTIF, COUNTIFS
SUMIF & SUMIFS
IF, AND, OR, NOT
IFERROR
Nested IF

📌 Module 3: Lookup & Reference Functions

VLOOKUP
HLOOKUP
XLOOKUP
INDEX & MATCH
Multiple Criteria Lookup
Practical Lookup Projects

📌 Module 4: Data Management

Data Validation
Drop-down Lists
Remove Duplicates
Text to Columns
Flash Fill
Conditional Formatting
Data Cleaning & Preparation

📌 Module 5: Pivot Table & Pivot Chart

Creating Pivot Tables
Sorting & Filtering Pivot Data
Grouping Data
Calculated Fields
Pivot Charts
Slicers & Timelines
Practical Reporting

📌 Module 6: Charts & Dashboard

Column, Bar, Line & Pie Charts
Combo Charts
Dynamic Charts
Professional Dashboard Design
KPI & Summary Reports
Interactive Dashboard with Slicers

📌 Module 7: Advanced Data Analysis

What-If Analysis
Goal Seek
Scenario Manager
Advanced Filtering
Subtotal & Consolidation
Data Analysis Techniques

📌 Module 8: Power Query

Introduction to Power Query
Importing Data
Data Cleaning
Merge & Append Queries
Transforming Data
Combining Multiple Files
Refreshable Reports

📌 Module 9: Power Pivot

Introduction to Power Pivot
Data Models
Relationships Between Tables
Calculated Columns
Basic DAX Functions
Advanced Data Analysis

📌 Module 10: Practical Projects

Student Attendance Report
Salary & Payroll Sheet
Sales Report
Stock/Inventory Management
Employee Management Report
Monthly Expense Report
Professional MIS Report
Interactive Excel Dashboard

Eligibility

Who can apply for this course

✅ 10वीं पास या उससे ऊपर के विद्यार्थी

✅ 12वीं / Graduate / Post Graduate विद्यार्थी

✅ College Students

✅ Job करने वाले Students

✅ Office Staff / Business Owners

✅ Data Entry और Computer Field में Career बनाने वाले विद्यार्थी

✅ Basic Computer Knowledge रखने वाले विद्यार्थी

Course Fees

₹8500/-

Discounted Fees

₹ 3500/-

Course Duration

3 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 ADVANCE EXCEL(S-CA-2303)

Course Includes

What you'll learn

Course Syllabus

📌 Module 1: Excel Basics & Fundamentals

📌 Module 2: Excel Formulas & Functions

📌 Module 3: Lookup & Reference Functions

📌 Module 4: Data Management

📌 Module 5: Pivot Table & Pivot Chart

📌 Module 6: Charts & Dashboard

📌 Module 7: Advanced Data Analysis

📌 Module 8: Power Query

📌 Module 9: Power Pivot

📌 Module 10: Practical Projects

📌 Module 1: Excel Basics & Fundamentals

📌 Module 2: Excel Formulas & Functions

📌 Module 3: Lookup & Reference Functions

📌 Module 4: Data Management

📌 Module 5: Pivot Table & Pivot Chart

📌 Module 6: Charts & Dashboard

📌 Module 7: Advanced Data Analysis

📌 Module 8: Power Query

📌 Module 9: Power Pivot

📌 Module 10: Practical Projects

Eligibility

Course Fees

Review

Featured review

More Popular Courses

DIPLOMA In COMPUTER APPLICATION(S-DCA-1549)

ADVANCE DIPLOMA IN INFORMATION TECHNOLOGY(M-AAD-9952)

Related Courses

CERTIFICATE In COMPUTER APPLICATION(M-CA-9603)