Microsoft Excel Notes

MS Excel 2013
application softwsre
Microsoft Excel is a "Spread.sheet.software This software is an
which is including Microsoft office package.

Exténsion of the Excel file= .XLSX
To open Microsoft Excel
Start
programs
>Microsoft Office 2007
Microsoft Excel 2007. www




Or, Start>Run> Type "excel" > OK


Quick Access Toolbar

Right click anywhere on the ribbon, and then click Cüstomize
Quick Acces
Toolbar. . *******************




Under Choose commands from, select.
Commands Not in the Ribbon.
RNEPRA ****www.***********
Select Form and click Add.
Click OK. Costenie the ebon.


remove a command from the, Quick Access
****************************************
***To *************************************************
and
Toolbar, right click the command Excd Option
**********


X

then click Remove from Quick
Custcriz: the CUk Ao:cSS Toclkax.
Access Toolbar.
P:::os
wwww. *****
**********
$2*
*****"V*V*iS*******
************* **********
*




**
Rikbc
Shoaic:artass Taska: Selo» the wwwwwww.
iseiczi

Cutomie tre ilbc..

... *** *************




..
:




*rennn*****
****** ***
.



*********
***********************************
toisstiras



wwww :
iii ******* ***


To Rename a sheet-
Right Click to the Sheet name
2 ******
» Click on Rename
**
*****************




Type any name
Enter

,To color of the sheet-
Right click to the Shcct name
Click on Tab color
- Sclect any coloor.
uuuuuuuuui
**************************"********************vvony ev-***dgrenepuneyo
25
Insert new worksheet-
44lRlya
Click on the insert workshcct icon REAd
%4S,ALINEZY1¥;+*A
(Shift+F11) from the sheet tab.

E
Group Worksheets maadadddndaadaY invisidiuiisirddussesdrtdetdsddveoevo to******o*
.....ne.e JaJarier 1Oater 2 avarter Qsarrer 4
To group workshcets, hold down Coffee $2,123 53,426 $5,90A s24C0
CTRL and click the sheet tabs of the Tea $4,929 $2,143 3,913 $5,921
4 $1423 SA,234 $5,336 Si.535
sheets you want to group. +eeenresenena saon

Release CTRL. North ; South,3At4
Mid ******
FAMi
Now you can edit multiple
worksheets at the same time. 1
auiaunasuuuaunnssus
Quarter 2 Qsarter 2 Quarter 3 Qsarer4
For example, on the North sheet, 2Coffee Tea
S1,00 S3,436 $5,9¢4 $9,400
3
S4,939 S2.143 $3.918
change the value of cell B2to eaaadaaa S5,921
$1000 and delete row 4.
- **-********* ***s************
Go to the other two worksheets Horth Mid South
4a4 a*d*
*s*d**a*ad********* **** ****
and you'll see that these *iv**
**************-*-**---
**********



worksheets have been edited as wel1
To ungroup, right click onë,of the
******
sheet tabs and click Ungroup Quarter i Cuarter 2 Qvarter3 Quarter 4
Sheets or click any sheettab
outside the groûp. For ¢xample, the
2 Coflee

ea
***wwww.
Si,CCG
Se,cc2 $9,737
S478
L
$7.156 $3,C37


wweetwewwewv
.
sheet tab of Sheet4
North Mid South Ste+t
Y***** ***


* ****************aT*




2

, Home
To open a NEW page-
Office button 2Temalts
idiiunidtinuiiiiiiiilítiiin
Btank snd recent
New Installed Templat
Blank work book
Create tevr y templates.
Hetrom exisüng
Mirosoft ofice Dnlire
2To Open a Template Featured
Office button hgendas

> Click on new option Budgets
BHng stement
Click on installed templated Calerdas
Choose any design of template
Create

3. Create a Template-
Create a workbook.
On the File tab, click Save As.
> Click Browse.
Enter a file name.
Select Excel Template (*.xltx) from the dropdown list.
******
titittiititi
-> Click Save.
On the File tab, click New.
Click Personal.
Click Above your file

A. To OPEN a Previous page :#**

Officebutton
on
>Click Open óption
Write the fileinarme
»Open
A
5. To SAVE a' documénat e
>Office button
Clickon sáve option pen
Write the file name
Save Savt
6. To SAVE AS a document-
Office button
Click on save As option
Sare *******


> Write the file name rint
Save
/7. To Display the PRINT PREVIEW -
Prepare
Office button
Click on Print option
»Click on the Print Preview option.