Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
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.
Another thing that can be very useful when you're talking about naming cells and ranges is a variation on that theme. This is a little advanced for this stage of the training, but it's an important time to mention it and this is probably where you'd be looking for it. So if I go up to the Insert menu and down to Name and Define. This is the long way around to define a range of cells with a name. So I can click on that and the dialog box that opens shows me all of the named ranges that I have in here. Here's my mistake. I'll delete that and we have our Third Quarter and the EmptyCell example that I put in earlier.
So let's add a new one. Let's go ahead and call this InterestRate and down here where it shows you what it refers to, let's clear that and put an interest-rate in of 10%. We'll say OK. Now the advantage of doing that is when you're using the interest rate in your formulas, you can say ThirdQuarter results times InterestRate, a very high level English statement, yet it's being calculated just like any other mathematical statement and if you use it repeatedly throughout your spreadsheet, especially a large complicated spreadsheet, than that interest rate can be changed by simply going back to the Name Define box, change the value from 10% to 11.5, and it will update all across your spreadsheet without having to go back and make individual changes to all of your formulae. That's very powerful when it comes to naming cells and ranges.
It should be obvious now why and when you're going to do that.
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.