Microsoft Excel Training: Managing Worksheets and Data (Part 3)
Explore “Managing Worksheets and Data” in this Microsoft Excel Training lesson. Part 3 of the five-part series brings together the source material and lesson topics. Use the contents links to find a section, read the notes, and consult the complete original teaching slides below.
Lesson topics
- Rename a Sheet
- Insert a Sheet
- Delete a Sheet
- Group Worksheets
- DATA MANAGEMENT FEATURES
Contents
- Read the original document
- Rename a Sheet
- Insert a Sheet
- Delete a Sheet
- Group Worksheets
- DATA MANAGEMENT FEATURES
- PIVOT TABLE
- FORMULAS AND FUNCTIONS
- In Excel, a formula is an expression that operates on values in a range of cells or a cell. For example,
- Functions
- Lecture Two
- IMPORTANT FORMULAS
- IF AND RELATED FUNCTIONS
REQUEST THE COMPLETE DOCUMENT ON WHATSAPP
Read the original source document
Microsoft Excel Training: original teaching slides for this study series.
Rename a Sheet
Rename a Sheet To rename a sheet: Right-click on the name of the sheet that you wish to rename. In this example, we want to rename Sheet1. Then select Rename from the popup menu. Enter the new name for the sheet and press the Enter key on the keyboard when finished.
Insert a Sheet
Insert a Sheet To insert a sheet: Click on the plus button to the right of the sheet names. It will insert a new sheet to the right of the current sheet.
Delete a Sheet
Delete a Sheet To delete a sheet: Right-click the Sheet tab and select Delete. Or, select the sheet, and then select Home > Delete > Delete Sheet.
Group Worksheets
Group Worksheets
You can quickly perform tasks on multiple worksheets at the same time by grouping worksheets together. If you group a set of worksheets, any changes you make on one worksheet are made in all the other worksheets in the group in the exact same location on the worksheets. If you want to create, for example, standard tables or calculations on a large number of worksheets, grouping can save you a lot of time. This works best if the worksheets already have identical data structures.
Group Worksheets
Group Worksheets To perform the same tasks for a particular set of worksheets, follow the steps below. Press and hold down the Ctrl key, and click the worksheet tabs you want to group. Make the changes on one of the worksheets. You see the changes is performed on the other selected worksheets.
DATA MANAGEMENT FEATURES
DATA MANAGEMENT FEATURES
PIVOT TABLE
PIVOT TABLE A PivotTable report is an interactive way to quickly summarize large amounts of data. Use a PivotTable report to analyze numerical data in depth and to answer unanticipated questions about your data. A PivotTable report is especially designed for: Querying large amounts of data in many user-friendly ways.
Subtotaling and aggregating numeric data, summarizing data by categories and subcategories, and creating custom calculations and formulas. Expanding and collapsing levels of data to focus your results, and drilling down to details from the summary data for areas of interest. Moving rows to column or columns to rows (or "pivoting") to see different summaries of the source data.
Filtering, sorting, grouping, and conditionally formatting the most useful and interesting subset of data to enable you to focus on the information that you want. Presenting concise, attractive, and annotated online or printed reports.
REQUEST THE COMPLETE DOCUMENT ON WHATSAPP
FORMULAS AND FUNCTIONS
FORMULAS AND FUNCTIONS
In Excel, a formula is an expression that operates on values in a range of cells or a cell. For example,
In Excel, a formula is an expression that operates on values in a range of cells or a cell. For example, =B2-B3, which finds the profits value for the following example
Functions
Functions Functions are predefined formulas in Excel. They eliminate laborious manual entry of formulas while giving them human-friendly names. For example: =SUM(B2:G2). The function sums all the values from B2 to G2.
Lecture Two
Lecture Two.
IMPORTANT FORMULAS
IMPORTANT FORMULAS
IF AND RELATED FUNCTIONS
IF AND RELATED FUNCTIONS
Review questions and answers
What are the key points about Rename a Sheet?
Rename a Sheet To rename a sheet: Right-click on the name of the sheet that you wish to rename. In this example, we want to rename Sheet1. Then select Rename from the popup menu. Enter the new name for the sheet and press the Enter key on the keyboard when finished.
What are the key points about Insert a Sheet?
Insert a Sheet To insert a sheet: Click on the plus button to the right of the sheet names. It will insert a new sheet to the right of the current sheet.
What are the key points about Delete a Sheet?
Delete a Sheet To delete a sheet: Right-click the Sheet tab and select Delete. Or, select the sheet, and then select Home > Delete > Delete Sheet.
What are the key points about Group Worksheets?
Group Worksheets You can quickly perform tasks on multiple worksheets at the same time by grouping worksheets together. If you group a set of worksheets, any changes you make on one worksheet are made in all the other worksheets in the group in the exact same location on the worksheets. If you want to create, for example, standard tables or calculations on…
What are the key points about PIVOT TABLE?
PIVOT TABLE A PivotTable report is an interactive way to quickly summarize large amounts of data. Use a PivotTable report to analyze numerical data in depth and to answer unanticipated questions about your data. A PivotTable report is especially designed for: Querying large amounts of data in many user-friendly ways. Subtotaling and aggregating numeric…
More lessons from this document
- Microsoft Excel Training — Part 1
- Microsoft Excel Training — Part 2
- Microsoft Excel Training — Part 3
- Microsoft Excel Training — Part 4
- Microsoft Excel Training — Part 5
Conclusion
The important points in DATA MANAGEMENT FEATURES should be reviewed alongside the definitions, examples and comparisons given above. Continue with the other four articles to cover the rest of the source material.