This course covers one of the most often performed tasks in Excel, but one that is not fully understood even by experienced, capable professionals. Learn to print a spreadsheet of almost any size starting with the first video. The course is only seven videos long and lasts about thirty minutes. Why thirty minutes just to learn how to print? Well, software developers often provide a number of ways to perform the same task, and that is the case with printing a spreadsheet in Excel. Also, some of these known ways can be combined to achieve the results we wish. Lastly, some methods may be more preferred by You, and so I did not wish to leave that out.
Participants will be able to easily scale a spreadsheet to fit all columns on a single page.
Page Break Preview is one of those hidden gems that proficient Excel users utilize often. It is an invaluable tool for resizing a spreadsheet and moving page breaks to where they are most needed.
Set the print area tells Excel that you know exactly what data your spreadsheet should display on a printed page and what it shouldn't.
True or False question on setting the print area in a spreadsheet
Full Screen Print Preview provides a last minute view of your spreadsheet with some nice built-in functionality to correct errors before you send to print.
A brief quiz to test our understanding of the capabilities associated with the Print Preview Full Screen button.
Participants will be able to use the Page Layout tab's functionality to add elements to a spreadsheet and further re-size a sheet to print.
A quiz to help us determine the correct situations in which to modify the order in which pages are printed.
Arguably, this topic could have been placed higher in the tutorial list. This is a necessary function to use when dealing with large spreadsheets, particularly when text is entered.
If I choose Wrap Text and do not see my text wrap, what may be the problem?
Excel provides robust Header and Footer features. Add the sheet name, page numbers, or custom text to your header or footer prior to printing.
This quiz tests our memory of how to quickly navigate to the area to modify an Excel Header or Footer.
A certified Excel expert and CompTIA certified Technical Trainer. Responsible for eLearning development in a corporate environment. Although professionals can be very talented and capable they may not always be comfortable with technology. My investment is in creating a comfort level with these necessary tools so that they empower its Users to fulfill their tasks.