Introduction to Microsoft Excel Objectives: To define spreadsheets and explain basic functionality Start Excel, open an existing workbook, and save a workbook. Move the active cell in a worksheet. Select cells and enter data in a worksheet. Edit and replace data in cells. Zoom, preview, and print a worksheet. Close a workbook and exit Excel. Section 1 Introduction Excel 2010 is a powerful spreadsheet application that allows users to produce tables containing calculations and graphs. Ese can range from simple formulae through to complex functions and mathematical models. How To Use This Guide. Introduction to Microsoft Excel 2010 Page 2 Microsoft Excel 2010 Layout Excel is a spreadsheet program that manipulates, graphs, and analyzes numeric data. Common uses for Excel are: budgets, grade books, address lists, or simple inventories. The The Name Box tells you the name/coordinates of the cell selected. Note how cell A1 is where.
- Introduction To Ms Excel 2010 Ppt
- Ms Excel 2010 Crack
- Introduction To Microsoft Excel Free
- Introduction To Excel Free
MS Excel 2010: How to Change Data Source for a Pivot Table. This Excel tutorial explains how to change the data source for a pivot table in Excel 2010 (with screenshots and step-by-step instructions). Introduction to worksheets. When you open an Excel workbook, there are three worksheets by default. The default names on the worksheet tabs are Sheet1, Sheet2, and Sheet3. To organize your workbook and make it easier to navigate, you can rename and even color code the worksheet tabs.
Lesson 7: Worksheet Basics
/en/excel2010/creating-simple-formulas/content/
Introduction
Every Excel workbook contains at least one or more worksheets. If you are working with a large amount of related data, you can use worksheets to help organize your data and make it easier to work with.
In this lesson, you will learn how to name and add color to worksheet tabs, as well as how to add, delete, copy, and move worksheets. Additionally, you will learn how to group and ungroup worksheets and freeze columns and rows in worksheets so they remain visible even when you're scrolling.
Introduction to worksheets
When you open an Excel workbook, there are three worksheets by default. The default names on the worksheet tabs are Sheet1, Sheet2, and Sheet3. To organize your workbook and make it easier to navigate, you can rename and even color code the worksheet tabs. Additionally, you can insert, delete, move, and copy worksheets.
Optional: You can download this example for extra practice.
To rename worksheets:
- Right-click the worksheet tab you want to rename. The worksheet menu appears.
- Select Rename.Selecting the Rename command
- The text is now highlighted by a black box. Type the name of your worksheet.
- Click anywhere outside the tab. The worksheet is renamed.Renamed worksheet
To insert new worksheets:
Click the Insert Worksheet icon. A new worksheet will appear.
You can change the setting for the default number of worksheets that appear in Excel workbooks. To access this setting, go into Backstage view and click Options.
To delete worksheets:
Worksheets can be deleted from a workbook, including those containing data.
- Select the worksheets you want to delete.
- Right-click one of the selected worksheets. The worksheet menu appears.
- Select Delete. The selected worksheets will be deleted from your workbook.Deleting a worksheet
To copy a worksheet:
- Right-click the worksheet you want to copy. The worksheet menu appears.
- Select Move or Copy.
- The Move or Copy dialog box appears. Check the Create a copy box.Checking the Create a copy box
- Click OK. Your worksheet is copied. It will have the same title as your original worksheet, but the title will include a version number, such as January (2).
To move a worksheet:
- Click the worksheet you want to move. The mouse will change to show a small worksheet icon .
- Drag the worksheet icon until a small black arrow appears where you want the worksheet to be moved.Moving a worksheet
- Release your mouse, and the worksheet will be moved.
To color code worksheet tabs:
Introduction To Ms Excel 2010 Ppt
You can color worksheet tabs to help organize your worksheets and make your workbook easier to navigate.
Ms Excel 2010 Crack
- Right-click the worksheet tab you want to color. The worksheet menu appears.
- Select Tab Color. The color menu appears.
- Select the color you want to change your tab.Changing the worksheet tab color
- The tab color will change in the workbook. If your tab still appears white, it is because the worksheet is still selected. Select any other worksheet tab to see the color change.
Switching between worksheets
If you want to view a different worksheet, you can simply click the tab to switch to that worksheet. However, with larger workbooks this can sometimes become tedious, as it may require scrolling through all of the tabs to find the one you want. Instead, you can simply right-click the scroll arrows in the lower-left corner, as shown below.
A dialog box will appear with a list of all of the sheets in your workbook. You can then double-click the sheet you want to jump to.
Watch the video below to see this shortcut in action.
Grouping and ungrouping worksheets
![Introduction To Ms Excel 2010 Introduction To Ms Excel 2010](https://www.maxiorel.com/files/images/2009/10October/852/08-excel-2010.png)
You can work with each worksheet in a workbook individually, or you can work with multiple worksheets at the same time. Worksheets can be combined into a group. Spider man 2001 pc full version. Any changes made to one worksheet in a group will be made to every worksheet in the group.
To group worksheets:
- Select the first worksheet you want in the group.Selecting the first worksheet to group
- Press and hold the Ctrl key on your keyboard.
- Select the next worksheet you want in the group. Continue to select worksheets until all of the worksheets you want to group are selected.
- Release the Ctrl key. The worksheets are now grouped. The worksheet tabs appear white for grouped worksheets.
While worksheets are grouped, you can navigate to any worksheet in the group and make changes that will appear on every worksheet in the group. If you click a worksheet tab that's not in the group, however, all of your worksheets will become ungrouped. You will have to group them again.
To ungroup all worksheets:
- Right-click one of the worksheets. The worksheet menu appears.
- Select Ungroup. The worksheets will be ungrouped.
Freezing worksheet panes
The ability to freeze specific rows or columns in your worksheet can be a useful feature in Excel. It is called freezing panes. When you freeze panes, you select rows or columns that will remain visible all the time, even as you are scrolling. This is particularly helpful when working with large spreadsheets.
To freeze rows:
- Select the row below the rows you want frozen. For example, if you want rows 1 and 2 to always appear at the top of the worksheet even as you scroll, then select row 3.
- Click the View tab.
- Click the Freeze Panes command. A drop-down menu appears.
- Select Freeze Panes.Selecting the Freeze Panes command from the View tab
- A black line appears below the rows that are frozen in place. Scroll down in the worksheet to see the rows below the frozen rows.
![Introduction to ms excel 2010 ppt Introduction to ms excel 2010 ppt](https://www.znanje.org/ebooks/excelMMXengl/52slike/01_introduction.jpg)
To freeze columns:
- Select the column to the right of the columns you want frozen. For example, if you want columns A and B to always appear to the left of the worksheet even as you scroll, select column C.Selecting column C
- Click the View tab.
- Click the Freeze Panes command. A drop-down menu appears.
- Select Freeze Panes.Selecting the Freeze Panes command from the View tab
- A black line appears to the right of the frozen area. Scroll across the worksheet to see the columns to the right of the frozen columns.
To unfreeze panes:
- Click the View tab.
- Click the Freeze Panes command. A drop-down menu appears.
- Select Unfreeze Panes. The panes will be unfrozen, and the black line will disappear.Selecting the Unfreeze Panes command from the View tab
Challenge!
Introduction To Microsoft Excel Free
- Open an existing Excel 2010 workbook. If you want, you can use this example.
- Insert a new worksheet.
- Change the name of a worksheet.
- Delete a worksheet.
- Move a worksheet.
- Copy a worksheet.
- Try grouping and ungrouping worksheets.
- Try freezing and unfreezing columns and rows.
/en/excel2010/printing/content/
Introduction To Excel Free
This Excel tutorial explains how to change the data source for a pivot table in Excel 2010 (with screenshots and step-by-step instructions).
See solution in other versions of Excel:
Question: In Microsoft Excel 2010, I've created a pivot table and now I need to change the data source. How do I change the data source for an existing pivot table?
Answer:Select the Options tab from the toolbar at the top of the screen. In the Data group, click on Change Data Source button.
When the Change PivotTable Data Source window appears, change the Table/Range value to reflect the new data source for your pivot table. Click on the OK button.
Now when you return to your pivot table, it should display information from the new data source.