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.
Let's keep looking at ways that we can customize our view to maximize our workspace. Let's go back to that Student Folder and open up Movie List. Now the movie list isn't long enough to extend beyond one screen, but it soon could be. One of my tiny, yet favorite features inside of Excel is the Freeze Pane. The secret to using Freeze Pane is to select the row or rows and columns to the right and bottom of the area you want to freeze. Let me give you an example of a frozen pane first, and then we'll discuss how that's done. I've selected row 2, and I'll go up to the Window menu and select Freeze Panes. When I do that, it isolates the titles above row 2 as a separate window, and now as I scroll through my list, you'll see that the titles for my data stay fixed. This is only a view option, but it's very powerful and versatile. If I go back up to the Window menu and unfreeze those panes, I'll show you what I meant by to the right and bottom. If I select this area of data and say Freeze Panes, now it's going to lock up everything on the left hand side and my titles. Now let me deselect and scroll. You'll see the way my data is scrolling into the titles and away from the row headings. Of course we always have our zoom tools. If you go to the View menu, you'll find the Zoom submenu here. We have our presets 200, 100, 75, 50%, etc. Fit selection is a popular one, and a Custom zoom. If you need a bigger view you can go to 200%. And if you want to bring that back down to reality, you can use the Zoom drop-down on the Standard toolbar to set your size to any level you want. There's 50%, 75, and I can see that my hidden panes are coming into play here. We also have view presets. For example, if we were viewing at 200% and it was this particular view of the data that we had, let's scroll that over, there we go, we can go to the View menu and into Custom Views, and here in Custom Views, we can add this view and name it. Let's name it CloseUp. Say OK. Then we can take a view level say at 100%, and add that view, Add, FullScreen, and now using the View menu, we can quickly switch between CloseUp and FullScreen. Obviously that feature would be a little more useful if we had a complex sheet of data or we were looking on multiple sheets and we wanted to have focused views on different areas. We could quickly switch between our views and you can add custom views to a toolbar and have it be a drop down just like your zoom drop down is here. Last but not least as we're talking about screen displays, we should talk about the toolbars. I mentioned earlier that the toolbars are customizable, and right now by default they are stacked one beside the other. Well you know, you can right-click and open up a number of toolbars. With all of these toolbars if you have any more thantwo open, you're going to need to start stacking and docking toolbars around your screen in order to get a decent working environment. To start with I would click and drag the Formatting toolbar down below the Standard toolbar. This way we can have far more icons appear on our toolbars by adding and removing buttons, and we don't have to constantly wonder if there are more options available to us. If we open up another toolbar, for instance the Chart bar, we can drag that up here and dock it beside one of our existing toolbars. By doing this, you can have many of your commonly used toolbars available to you at any time. And that's a quick overview, looking at our screen display and some options we have for viewing the work.
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.