Welcome to XectiQ Computer Education

WELCOME

CERTIFICATE IN MS-EXCEL ( S-C303 )

BASIC INFORMATION

  • Course Fees : 1000.00 2500.00/-
  • Course Duration : 1 MONTH
  • Minimum Amount To Pay : Rs.300.00

Microsoft Excel:

1. Introduction to Microsoft Excel:

   - Overview of the Excel interface

   - Worksheets and workbooks

2. Data Entry and Formatting:

   - Entering and formatting data

   - Cell formatting (number, text, date)

3. Formulas and Functions:

   - Basic arithmetic operations

   - Common functions (SUM, AVERAGE, IF, VLOOKUP)

4. Data Analysis:

   - Sorting and filtering data

   - PivotTables and PivotCharts

5. Charts and Graphs:

   - Creating and customizing charts

   - Data visualization techniques

6. Data Validation:

   - Setting up data validation rules

   - Preventing data entry errors

7. Advanced Excel Features:

   - Macros and automation

   - Conditional formatting

Eligibility Criteria:

- Minimum educational qualification: Class 5 and above