Other
Microsoft Excel Notes
- Course
- Institution
This is a complete Microsft Excel Notes who want to learn Excel
[Show more]
Seller
Follow
indranilchakraborty
Content preview
MS Excel 2013application 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.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through EFT, credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying this summary from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller indranilchakraborty. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy this summary for R198,37. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
69052 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy summaries for 15 years now