Table of Contents
STARTING WITH MS-EXCEL
INTRODUCTION TO EXCEL
Excel is a window-based spreadsheet which is a product of Microsoft Corporation. It is used to record and calculate data and present it in an attractive manner. Microsoft Excel is application software Hundreds of millions of people around the world use Microsoft Excel. You can use Excel to enter all sorts of data and perform financial, mathematical or statistical calculations.
Workbook
In Microsoft Excel, a workbook is a collection of one or more spreadsheets is called a workbook.
Worksheet
A worksheet or sheet is a single page you work on in Excel is called a spreadsheet. Spreadsheet is an interaction of horizontal and vertical lines, which forms rows and columns. Using these row and columns, details analysis of data can be represented easily.
Starting Excel
- Click Start Button
- All Programs
- Microsoft Office
- Click Microsoft office Excel
Shortcut Open MS- Excel
- Run Open (Window Key + R)
- Type = excel
- Enter
The Contents of Worksheet
Rows
In a single worksheet Rows and numbered from top to bottom.
(1 to 1048576).
Columns
Columns are labeled from left to right (A to XFD) for a total of 16384 columns.
Cell
Cell is the intersection of row and column. Cell is referred by the column name and row number.
Formula Bar
Provides a space for typing or editing cell data and formula.
Name Box
Display the address or name of the active cell.
Status Bar
It displays valuable information like current mode or option, keyboard status and the result of auto calculate functions.
Columns
Give the comment of any word.
- Click on the word for giving the comment
- Review tab
- Click New Comment
- Type comment
- Comment will be show on the word as superscript
Delete
Delete all comment giving on the word in the document.
Preview and Next
See one by one all comment apply on the word in the document.
Show Comments
Show and Hide comments apply on the all word in the document.
Track Change
Change or add anything in your document and if you want to see it later, use Track Change.
- Click anything in the document
- Review tab
- Track Changes option
- Track Change
- Change or add text
Note: – Text will be show in different color.
Accept and Reject
It is use to after using the Track Changes.
Accept: – Accept the text using the track changes.
Reject: – Delete the text using the track changes.
- Click on the text apply track change
- Review tab
- Click Accept or reject
Compare
Compare two document using compare option.
- Create new page
- Work anything
- Save the file with name day 1
- Close your document
- Again open the file Day 1
- Work anything
- Save the file with name day 2 using Save as
- Now Click Review tab
- Click Compare option
- Compare
- Give the original document like Day 1
- Give the revised document like day 2
- Ok
Note: – revised document text will be show in different color.
Protect
Protect your files and documents with a password, there is no change and deletion of your file.
- Review tab
- Protect
- Restrict formatting and editing
- Allow only this type of editing in the document
- Yes, Start Enforcing Protection
- Type two time password
- Ok
- Your document will be protected