Certificate in Office Administration
MS- Excel
Chapter No
Topics
1
Excel Basics
  • Features of MS-Excel
  • Parts of Excel Screen

2
Working with Excel
  • Formatting And Mathematical Calculations
  • Changing the Font, Font Size, and Font Color
  • Adding Bold, Underline, and Italic by Using the Menu

3
Working with Long Text
  • Performing Mathematical Calculations
  • Cell Addressing
  • Conditional Formatting

4
Using Operators and Functions in Excel
  • Reference Operators
  • Functions
  • Filling Cells Automatically
  • Conditional Logic

5
Printing a Worksheet
  • Setting a Default Printer
  • Setting the Print Area
  • Printing Gridlines
  • Printing Row and Column Headings

6
Creating Charts
  • Creating a Column Chart
  • To insert cells, rows or columns
  • Insert a new worksheet
  • Move or copy sheets

7
Data Processing With Excel
  • Creating Database In MS-Excel,
  • Using Advanced Filters
  • Activate any cell of the database list.
  • Data Consolidation
  • Index Function

Certificate in Office Administration

Top