Workbook A workbook is another word for your Excel file Excel automatically creates a blank workbook when you open it Open an Existing Workbook To open a workbook youve created in the past execute the following steps ID: 567178
Download Presentation The PPT/PDF document "MS-EXCEL PART 2" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
MS-EXCEL PART 2Slide2
Workbook
A workbook is another word for your Excel file. Excel automatically creates a blank workbook when you open it.
Open an Existing Workbook
To open a workbook you've created in the past, execute the following steps.1. Click on the green File tab.Slide3
What you see next is called the backstage view and it contains all the workbook related commands
.
3. Click Open to open a workbook that is not on the list.Slide4
Close a Workbook
If you are new to Excel, it's good to know the difference between closing a workbook and closing Excel. This can be confusing in the beginning.
1. To close an Excel workbook, click the lower X.Slide5
Open/close a workbook
2. If you have multiple workbooks open, clicking the upper right X closes the active workbook. If you have one workbook open, clicking the upper right X closes Excel
.
Create
a New Workbook
Although Excel creates a blank workbook when you open it, sometimes you want to start all over again.
1. To create a new workbook, click New and then click Create
.Slide6
Move a Worksheet
To
move a worksheet, click on the sheet tab of the worksheet you want to move and drag it into the new position.
1. For example, click on the sheet tab of Sheet4 and drag it before Sheet2.
Result:Slide7
Delete a Worksheet
To delete a worksheet, right click on a sheet tab and choose Delete.
1. For example, delete Sheet4, Sheet2 and Sheet3.
Result:Slide8
Copy a Worksheet
Imagine, you have got the sales for 2010 ready and want to create the exact same sheet for 2011, but with different data. You can recreate the worksheet, but this is time-consuming. It's a lot easier to copy the entire worksheet and only change the numbers.
1. Right click on the sheet tab of Sales 2010.Slide9
The 'Move or Copy' dialog box appears.
3. Select (move to end) and check Create
a
copy.
4. Click OK.
Note: you can even copy a worksheet to another Excel workbook by selecting the specific workbook from the drop-down list (see the dialog box shown earlier).Slide10
Format Cells
When we
format cells
in Excel, we change the appearance of a number without changing the number itself. We can apply a number format (0.8, $0.80, 80%,
etc
) or other formatting (alignment, font, border,
etc
).
1. Enter the value 0.8 into cell B2.
By default, Excel uses the General format (no specific number format) for numbers. To apply a
number format
, use the 'Format Cells' dialog box
.Slide11
2. Select cell B2.
3. Right click, and then click Format Cells (or press CTRL + 1).Slide12
The 'Format Cells' dialog box appears.
4. For example, on the Number tab, select Currency.
Note: Excel gives you a life preview of how the number will be formatted (under Sample).Slide13
Cell B2 still contains the number 0.8. We only changed the appearance of this number, not the number itself. The most frequently used formatting commands are available on the Home tab.
On the Home tab, in the Alignment group, center the number.Slide14
On the Home tab, in the Font group, change the Font color.Slide15
On the Home tab, in the Font group, add borders.Slide16
Find & Select
You can use Excel's
Find and Replace
feature to quickly find specific text and replace it with other text. You can use Excel's Go To Special
feature to quickly select all cells with formulas, comments, conditional formatting, constants, data validation, etc
.
Find
To quickly find specific text, execute the following steps.
1. On the Home tab, click Find & Select, Find...Slide17
The 'Find and Replace' dialog box appears.
2. Type the text you want to find. For example, type Ferrari.
3. Click 'Find Next'.
Excel selects the first occurrence.Slide18
Click 'Find Next' to select the second occurrence.
5. To get a list of all the occurrences, click 'Find All'.Slide19
Go To Special
You can use Excel's Go To Special feature to quickly select all cells with formulas, comments, conditional formatting, constants, data validation, etc. For example, to select all cells with formulas, execute the following steps.
1. Select a single cell.
2. On the Home tab, click Find & Select, Go To Special...Slide20
Note: Formulas, Comments, Conditional formatting, Constants and Data Validation are shortcuts. They can also be found under Go To Special.
3
. Select Formulas and click OK.Slide21
Note: you can search for cells with formulas that return Numbers, Text,
Logicals
(TRUE and FALSE) and Errors.
These check boxes are also available if you select Constants.Excel selects all cells with formulas.
General note: if you select a single cell before you click Find, Replace or Go To Special, Excel searches the entire worksheet. To search a range of cells, first select a range of cells.Slide22
Templates
Instead of creating an
Excel
workbook from scratch, you can create a workbook based on a template. There are many free templates available, waiting to be used.
Existing Templates
To create a workbook based on an existing template, execute the following steps.
1. On the green File tab, click New.
2. To choose a template from one of the sample templates (these are already installed on your computer), click on Sample templates.Slide23
3. To choose a template from the Office.com Templates, click a category. For example, click Calendars.Slide24
To
download a template, select a template and then click Download.Slide25
Excel creates a workbook (UniversalCalendar1.xlsx) based on this template. Excel also stores the template (UniversalCalendar.xltx) in the Templates folder. You can access this folder by clicking on My templates (see first picture). Read on for more information about the Templates folder
.
Create a
Template
If you create your own template, you can safely store it in the Templates folder. As a result, you can create new workbooks based on this template without worrying that you overwrite the original file.
To create a template, execute the following steps.
1. Create a workbook.
2. On the green File tab, click Save As.
3. Enter a file name.
4. Select
Excel Template (*.
xltx
)
from the drop-down list.Slide26
Template
Excel automatically activates the Templates folder. Notice the location of the Templates folder on your computer. It's usually located here:
C:\Users\<username>\AppData\Roaming\Microsoft\Templates
5. Click Save.Slide27
8. Select
WeddingBudget
.
9. Click OK.Slide28
Excel creates a workbook (WeddingBudget1.xlsx) based on this template.
Note: to edit a template, on the green File tab, click Open to open the template. Edit the file and save the file to its original location.