Viewers: in countries Watching now:
Excel 2003 Essential Training with Mark Swift is a movie-based workshop for users who are new to working with spreadsheets, or those wanting to improve their skills. This workshop begins with a basic overview of the application and quickly advances to cover useful formulas, functions, techniques for enhancing spreadsheets, charts, and much more. Exercise files accompany the training, allowing you to follow along and learn at your own pace.
As I mentioned earlier, the difference between a workbook and a worksheet is the difference between a file folder or container that holds many documents and the documents themselves. A spreadsheet spans over 256 columns in over 65,000 rows of information. That's over 16 million cell references within a single worksheet. Now the workbook we currently have here is called Quarterly_Sales.
Quarterly_Sales could contain several worksheets. In this case, Sheet1 is the only one that's populated with any data. Sheet2 and Sheet3 are completely blank. You can insert more sheets or remove sheets from a workbook by simply right-clicking down here on a tab, and saying Insert. At that time you have a choice to insert Worksheet, a Chart, a Macro sheet, or an Excel 5 Dialog, which we're not going to get into in this training. I'm going to leave it on Worksheet and say OK. You'll notice that it inserted the new worksheet, just prior to the tab that I had clicked on. If the tab that I have active is Sheet1, then Sheet1 is where this new sheet is going to appear before. The shortcut key for adding a new worksheet is Shift+F11 and when you do that, just like the right-clicking, it inserts a new worksheet just before your current sheet. To go the long way around, I can go up to the Insert menu and say Insert - Worksheet, and again you'll see that the worksheet has been inserted just prior to the active sheet. If I'd like to remove some sheets, again the intuitive way is to right-click Delete. Right-click Delete. And here again I'll get rid of Sheet4. Right-click Delete. Now I've gotten rid of all the sheets that weren't originally in my workbook, only just to tidy things up a little bit. Aside from right-clicking, you can also select your current sheet, go up to the Edit menu and say Delete Sheet and that will also get rid of the worksheet, whether or not it's populated with data.
There are currently no FAQs about Excel 2003 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.