Learn Microsoft Excel

Microsoft Excel

What is Microsoft Excel?

• It is used more in calculations, business and graphs creations.
• In excel we have work book which are consists of sheets (or) we call it as worksheets.
• When you open excel workbook three work sheets are automatically added.
• Every worksheets are made of sixteen thousand (16,000) rows and two fifty six (256) columns.
• Where ever rows and columns meets that area is call cell.
• A cell is identified by cell address or cell Reference.
• The cell address includes column name and row numbers.
• In excel columns are named with alphabets rows are numbered.
• Which ever the cell border is highlighted that is active cell and we can find courser in that.

To use filter use filter features in excel:-
Step:-1 Select the data.
Step:-2 Go to home tab under that editing group select sort and filter.
Step:-3 Select filter option from list.
Step:-4 Select any filter chose eight number filter or text filter.
Step:-5 Specify your filter condition and apply filter.

• Every cell in excel is identified by cell address or cell reference.
• Cell reference is combined of column name and row number.
• There are four types of cell referencing is present:-

1. Relative reference.
2. Absolute reference.
3. Mixed reference.
4. 3d reference.

Creating of graphs or charts:- Select the data press F11 to get chart are graphs in a separate sheet.

Referencing ⇾ cell addressing.
It is combination of column and row.


Column alphabets ⇾ Row numbers.

1. Relative referencing:- The cell address changes depending on the location of the data.
For example; Assume data is there in A1, A2, A3 cells. if we apply auto sum on the cells the formula becomes = sum (A1:A3).

If suppose same formula need to be copied to the cells C1, C2, C3, C4. then the formula becomes = sum(C1:C2).

2. Absolute Referencing:-

	100	200	300
1	=1*100	=1*200	=1*300
2	=2*100	=2*200	=2*300
3	=3*100	=3*200	=3*300

In this referencing eight column name or row number will be kept constant, where as other cell address changes relatively. Such type of referencing is called absolute referencing.

To make eight row or a column constant column name or row number must be prefix with $.

	A	B	C	D
1		100	200	300
2	20	=$A$2*B1	=$A$2*C1	=$A$2*D1
3	30	=$A$3*B1	=$A$3*C1	=$A$3*D1
4	40	=$A$4*B1	=$A$4*C1	=$A$4*D1

3. Mixed Referencing:- Both column name and row number must be kept constant by adding dollar as prefix  to both column are row.

4. Functions:- Function are use to calculate sum count average etc., The commonly used functions are sum, max, mix, average, and count.
Every function must be prefixed by Equal to (=).
Every function takes cell range.

Sum            ⇾  Used for adding.
Max            ⇾  To find out maximum value in the given range.
Mix             ⇾  To find out minimum value in the range.
Average      ⇾  To find out average value in the given range.
Count         ⇾  To count all cells with numbers in the given range.
Count A     ⇾  To count all cells in the given range.

Date functions:-                                       Text:-
1. Today ( )                                               1. Cover ( )
2. Now ( )                                                 2. Upper (cell address)
                                                                 3. Lowe (cell address)
                                                                 4. Left (cell address)
                                                                 5. Right (cell address)


Macro`s:-
Macro`s are used to run certain repeated works for example, If we want to repeat formatting an different sheets create a macro using view menu tab under this use macro`s group.
Step 1:- Select the data which you want to format.
Step 2:- Under macro`s group select record macro.
Step 3:- Format you data that is increase the size, change the colour, change the style of the writing.
Step 4:- Go to macro`s group click on stop recording.
Step 5:- To apply the macro`s group → view macro`s → select previously created macro → run.

PPT:- is used to create presentations and advertisement and also create album. It has four views:-

• Normal view.
• Slide sorter view.
• Reading view.
• Slide show view.

1. Editing is possible in normal view actual side of the side can be seen in this view.
2. Slide sorter view:- In this view we can see miniyeacher of all size, here we can not edit a slide but we can add or delete a slide. we can also add transition effects, animation effects.
3. Reading view:- We can not add slide, we can not add effects, we can only read.
4. Slide show:- This view is used to start slide show.

To run a slide show continuously select all slides in slide sorter and go slide show tab.
Chose setup slide show under that show options  loop continuously until `esc'.

To the slides we can add transition effects and a time to move to the next slide.

• Slide sorter → select all slides → transitions → select the effects from the list.
• Timing slide sorter → select all → transitions → timing → advance slide → after → select time.

✱ Transition effect can be given to slides when we are in slide sorter view, at a time we can apply the transition effect to all slides. even if the slide is blank transition effect can be given.
✱ Animation effect can be given at a time to one slide with content. in normal view.