✦ About Program
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.
✦ Course Curriculum
1
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
2
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
3
Formatting Worksheets
- Font and Text Formatting
- Cell Alignment and Borders
- Number Formatting (Currency, Percentage, Date)
- Conditional Formatting
- Page Setup and Print Options
4
Formulas and Functions
- Introduction to Formulas
- Arithmetic Operations in Excel
- Common Functions: ( SUM, AVERAGE, COUNT, MAX / MIN , IF Function )
- Relative and Absolute Cell References
5
Charts and Graphs
- Creating Charts
- Types of Charts :( Column Chart, Bar Chart, Pie Chart, Line Chart)
- Editing Chart Layout and Style
6
Data Management
- Sorting Data
- Filtering Data
- Creating Tables
- Data Validation
- Remove Duplicates
7
Basic Data Analysis
- Subtotals
- Pivot Table (Basic)
- What-If Analysis (Introduction)
8
Printing and Sharing
- Page Layout
- Print Area
- Print Preview
- Exporting Excel Files