Viewers: in countries Watching now:
Whether you're a novice or an expert wanting to refresh your skillset with Microsoft Excel, this course covers all the basics you need to start entering your data and building organized workbooks. Author Dennis Taylor teaches you how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and how to automate many of these tasks with macros.
We're using the workbook 09-02-RegionalSales. The sheet names are appropriate except for Sheet3 and so changing the name of the sheet is something you want to be able to do quickly and easily. You can access many features related to sheet tabs simply by Right-Clicking a sheet and that brings up a menu. Here, of course, is a choice for Rename. It's much faster, however, simply to Double-Click a sheet tab. This Sheet3 for example contains Annual Performance Scores. It contains some sparklines in column H . Let's just change the name of it by Double-Clicking and we could type anything we want.
Why not Annual Scores? You can have spaces in sheet names. They can be up to 31 characters. Simply type in the name you wish and press Enter. If we need to add a new sheet, we can simply Right-Click and we're about to insert a new sheet. If we choose Worksheet here and then OK, a worksheet just to the left of the sheet that had been selected. But there are two faster ways, if we want a new sheet to the right of any worksheet, suppose we're going to add a new region between South and West. Maybe it's going to be a mountain region.
We want a new sheet to the right of South here. Click the South tab and then to the right of our sheet names, we'll see a plus, simply Click New Sheet and we got a new sheet here called Sheet4, which we will rename eventually, Mountain. And there's the keystroke shortcut method as well. We might want to put a summary sheet to the left of the East sheet. If you press Shift+F11, you will automatically get a new sheet to the left of the current sheet. All sheet actions, except for changing tab colors, cannot be undone or you cannot use the Undo feature.
That's particularly meaningful if you're about to delete a sheet. Maybe I'm not thinking too clearly or maybe the thought has occurred to me that I don't need this sheet, I Right-Click and choose Delete and now I see this message, You can't undo deleting sheets. You might be removing some data. If you don't need it, Click Delete. It is a strong warning and so if I were to press Delete here, I can't use the Undo capability to bring back that sheet. What I might need to do in a case like that if I had second thoughts, is simply close the file without saving it and then reopen it.
Of course sometimes that happens after you've done a lot of good things along the way. So you want to be very careful about deleting sheets. So as we've seen, we can rename sheets, we can insert sheets, we can delete sheets either by Right-Clicking or using some of the shortcuts I suggested.
There are currently no FAQs about Excel 2013 Essential Training.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.