In this video, staff author Jess Stratton shows how easy it is to manipulate and work with worksheets in Microsoft Excel. She'll also demonstrate how to move a chart to a new sheet.
- [Instructor] The ability to create multiple sheets…in a workbook is an easy way to keep an ongoing file.…To get started working with sheets,…you can start by right-clicking on the first sheet.…You'll notice the first four options…are the most common things that you'll do with worksheets,…such as deleting them, inserting them,…or renaming them.…I'm going to rename this sheet,…and I'm going to remove the word Chart…because I'll be moving the chart to a new sheet.…Change your text, hit the Enter key,…and the sheet has been renamed.…
The easiest way to create a new sheet…is to click the plus sign to the left of the last sheet.…It's going to create a new one,…and now I'll right-click and rename this one also.…I'll call this one Chart.…I'm going to right-click on it one more time…to show you that you can also change…the color of the tab.…I'll change it to an orange,…and you'll notice that as soon as I click off of it,…it changes to a nice bright orange.…This way I can find it quickly,…which is very helpful when you have many worksheets.…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Converting Google Sheets to Excel format
- Working anywhere with Excel Online
- Working with sheets
- Creating an Excel table
- Applying conditional formatting
- Working with formulas
- Working with charts and sparklines
- Sharing files and collaborating with others
- Reviewing and tracking changes