Ms-Excel
Introduction-Ms-Excel
Chapter1 Basic of Ms-Excel
Introduction
Features of Ms-Excel 2000
Starting Excel
Excel Environment
Using the Help Function
Moving within the Spreadsheet
Chapter2 Working in Ms-Excel
Introduction
Views
Page Setup
Types of Data
Entering Numbers
Adding a Row or a Column
Increasing or Decreasing Column Width
Selecting Objects
Chapter3 File Management
Introduction
Opening a File
Create a new WorkBook
Saving a Worksheet
Closing a File
Updating a Document
Inserting a new Worksheet
Hyperlinks
Linking Different Sheets
Security Feature in Microsoft Excel
Sharing a Workbook
Chapter4 Formatting Worksheets
Introduction
Format Toolbar
Formatting Numbers
Creating Borders
Text Alignment
Moving and Copying
Formulae and Functions
Copying Data or Formulas
Using Keyboard Shortcuts
Relative & Absolute Referencing
Range Names
Excel Charts
Creating a Chart
Different types of Charts
Chapter5 Advance Features
Introduction
Data Forms
Filtering
Export and Import
Pivot Table
Freezing pane