Accounting & Business Software
CERTIFICATE IN MS EXCEL 2010
Certificate in MS Excel 2010 is a short-term computer course designed to teach students how to use Microsoft Excel for data entry, calculations, data analysis, charts, and reporting. This course helps...
Duration: 2 Months / 40 hrs
Certificate: ISO Certified
₹3,500
About This Course
Course Overview
The CERTIFICATE IN MS EXCEL 2010 program provides comprehensive computer education with practical training. Students learn essential software applications, internet skills, and basic programming. Our industry-aligned curriculum prepares graduates for various IT and office-based job opportunities.
Syllabus
Course Curriculum
01
Introduction to Microsoft Excel
- What is Spreadsheet Software
- Features of MS Excel 2010
- Excel Interface (Ribbon, Tabs, Groups)
- Creating and Saving Workbooks
- Opening and Closing Files
02
Working with Worksheets
- Rows, Columns, and Cells
- Entering and Editing Data
- Selecting Cells and Ranges
- Inserting and Deleting Rows & Columns
- Copy, Cut, Paste, and Fill Handle
03
Formatting Worksheets
- Font and Text Formatting
- Cell Alignment and Borders
- Number Formatting (Currency, Percentage, Date)
- Conditional Formatting
- Page Setup and Print Options
04
Formulas and Functions
- Introduction to Formulas
- Arithmetic Operations in Excel
- Common Functions: ( SUM, AVERAGE, COUNT, MAX / MIN , IF Function )
- Relative and Absolute Cell References
05
Charts and Graphs
- Creating Charts
- Types of Charts :( Column Chart, Bar Chart, Pie Chart, Line Chart)
- Editing Chart Layout and Style
06
Data Management
- Sorting Data
- Filtering Data
- Creating Tables
- Data Validation
- Remove Duplicates
07
Basic Data Analysis
- Subtotals
- Pivot Table (Basic)
- What-If Analysis (Introduction)
08
Printing and Sharing
- Page Layout
- Print Area
- Print Preview
- Exporting Excel Files
Career Paths
Career Opportunities
Computer Operator
Data Entry Executive
Office Assistant
IT Support Specialist
Web Developer
Software Trainee
Eligibility & Requirements
Minimum Education + Basic Computer Knowledge
Other Courses Here
CERTIFICATE IN TALLY PROFESSIONAL
4 Months / 80 hrs
DIPLOMA IN OFFICE AUTOMATION
6 Months / 120 hrs
DIPLOMA IN FINANCIAL ACCOUNTING
6 Months / 120 hrs
CERTIFICATE IN OFFICE AUTOMATION
2 Months / 40 hrs
CERTIFICATE IN COMPUTER APPLICATION
2 Months / 40 hrs
CERTIFICATE IN AUTOCAD - MECHANICAL
4 Months / 80 hrs
More Courses
More at TNCS COMPUTER EDUCATION CENTRE- PERUMANALLUR
Explore other courses offered at this center
Ready to Start Learning?
Join TNCS COMPUTER EDUCATION CENTRE- PERUMANALLUR and kickstart your career today.
