HDI

₹2,500 ₹3,500

Course Includes

Duration03 Months
Enrolled1
Lectures10
Videos0
Notes0
CertificateYes

What you'll learn

Microsoft Excel is a spreadsheet application developed by Microsoft. It is used to organize, store, calculate, analyze, and present data in the form of tables, charts, and graphs. Excel helps users perform mathematical calculations, create reports, manage records, and analyze large amounts of information efficiently.

Course Syllabus

Microsoft Excel Syllabus

Module 1: Introduction to Excel

What is Microsoft Excel?
Features and Uses of Excel
Starting and Closing Excel
Excel Interface (Ribbon, Quick Access Toolbar, Status Bar)

Module 2: Workbook and Worksheet

Creating a Workbook
Saving and Opening Files
Worksheets and Sheet Tabs
Rows, Columns, and Cells
Cell Address and Range

Module 3: Data Entry and Editing

Entering Data
Editing and Deleting Data
Copy, Cut, and Paste
AutoFill and Flash Fill
Find and Replace

Module 4: Formatting

Font Formatting
Cell Alignment
Number Formats
Borders and Colors
Cell Styles
Conditional Formatting

Module 5: Formulas and Functions

Formula Basics
Cell References (Relative, Absolute, Mixed)
Basic Functions:
SUM()
AVERAGE()
MAX()
MIN()
COUNT()
IF()
ROUND()
TODAY()
NOW()

Module 6: Data Management

Sorting Data
Filtering Data
Removing Duplicates
Data Validation
Tables

Module 7: Charts and Graphs

Column Chart
Bar Chart
Line Chart
Pie Chart
Formatting Charts

Module 8: Pivot Tables

Creating a Pivot Table
Summarizing Data
Pivot Charts
Slicers

Module 9: Printing

Page Layout
Print Area
Headers and Footers
Page Breaks
Print Preview

Module 10: Advanced Excel (Optional)

VLOOKUP/XLOOKUP
HLOOKUP
INDEX and MATCH
IFERROR
Text Functions
Named Ranges
Basic Macros

Practical Exercises

Student Mark Sheet
Employee Salary Sheet
Sales Report
Inventory Management
Monthly Budget
Attendance Register

Course Fees

₹3500/-

Discounted Fees

₹ 2500/-

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

ADVANCE DIPLOMA IN DATA ENTRY(M-ADE-4898)

Course Includes

What you'll learn

Course Syllabus

Microsoft Excel Syllabus

Module 1: Introduction to Excel

Module 2: Workbook and Worksheet

Module 3: Data Entry and Editing

Module 4: Formatting

Module 5: Formulas and Functions

Module 6: Data Management

Module 7: Charts and Graphs

Module 8: Pivot Tables

Module 9: Printing

Module 10: Advanced Excel (Optional)

Practical Exercises

Course Fees

Review

Featured review

More Popular Courses

ADVANCE DIPLOMA IN DATA ENTRY(M-ADE-4898)

DIPLOMA In COMPUTER APPLICATION(M-CA-7693)

Related Courses

DIPLOMA In COMPUTER APPLICATION(M-CA-7693)

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