Start learning with our library of video tutorials taught by experts. Get started
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.
Standard toolbar and click the Print icon, but note within the Microsoft Office Suite, that icon goes immediately to the printer and doesn't give you a chance to configure your print job. If you go up to the File menu and down to Print, that gives you an opportunity to print a range of pages, maybe only the active worksheet, which is by default selected, or you can change that to your entire workbook, the list that you currently have selected. You can access Print Preview from here and, if you increase the number of copies that you want to print, you make sure that you have Collate on so that the printer does all work for you and your jobs come out in bunches ready to go. Let me cancel that.
Another option that you may want to exercise when you're printing or even if you're just displaying this on screen is to hide certain elements of data. You can hide data by selecting your range, right-clicking and choosing Hide. That's an easy way to get to it from the quick menu. If I want to bring that back again, I can select a range of cells that encompass the hidden range and right-click and choose Unhide, or if I right-click here, choose Hide, I can go up to the Format menu, down to Column, say Unhide. Be warned if you've hidden rows, let me hide these three rows together, you cannot go up to the Format menu, down to Columns and say Unhide. If you do, it'll be ineffectual. You need to go to the Format menu > Row and say Unhide. So you have to be somewhat aware of what's hidden within a spreadsheet before you can accurately unhide it.
Before we do unhide that information, let's go and take a File > Print Preview, and you'll see that those three pieces are missing from our final printout.
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.