Microsoft Excel – Viewing and printing
Views: There are several ways you can view your spreadsheet on the screen and each has its own purpose. The most important thing to note is that none of these views affect the way your spreadsheet prints. Topics include: Zoom (set and custom), Print Preview and page break preview versus Normal view.
Page Setup: Including page orientation, Scaling and margins, and changing these settings.
Print areas: Setting and clearing defined print areas, understanding the difference between default and set page breaks, Inserting and moving page breaks, Changing the print order of pages, centering the spreadsheet when printing and showing/hiding gridlines and headers.
Introduction to headers and footers, using preset and custom headers and footers, including the use of file information and common fields.
Freezing panes when viewing so that certain information headers remain on the screen while you scroll through lists, and Repeating rows so that when the information is printed rows or column headers are repeated.
Printing options.
Training Video List
Section 1 videos
Views: There are several ways you can view your spreadsheet on the screen and each has its own purpose. The most important thing to note is that none of these views affect the way your spreadsheet prints. Topics include: Zoom (set and custom), Print Preview and page break preview versus Normal view. Page Setup: Including page orientation, Scaling and margins, and changing these settings.
304101 – Excel – Print Preview (Length 3:09)
304102 – Excel – Zoom and Print Preview (Length – 2:26)
304103 – Excel – Normal and Page Break Preview (Length – 2:38)
304104 – Excel – Introduction to Page Setup (Length – 3:50)
304105 – Excel – Page Setup – Orientation (Length – 2:33)
304106 – Excel – Page Setup – Scaling (Length 3:14)
304107 – Excel – Scaling using Page Break Preview (Length – 2:34)
304108 – Excel – Page Formatting and Margins (Length – 3:32)
304109 – Excel – Margins in Print Preview (Length – 2:56)
Section 2 videos
Print areas: Setting and clearing defined print areas, understanding the difference between default and set page breaks, Inserting and moving page breaks, Changing the print order of pages, centering the spreadsheet when printing and showing/hiding gridlines and headers.
304201 – Excel – Set and Clear the Print Area (Length – 3:49)
304202 – Excel – Inserting a page break (Length – 2:49)
304203 – Excel – default and set page break (Length – 1:55)
304204 – Excel – set page breaks (Length 2:51)
304205 – Excel – page print order (Length – 3:12)
304206 – Excel – Centering and showing guidelines (Length – 3:12)
Section 3 videos
Introduction to headers and footers, using preset and custom headers and footers, including the use of file information and common fields. Freezing panes when viewing so that certain information headers remain on the screen while you scroll through lists, and Repeating rows so that when the information is printed rows or column headers are repeated. Printing options.
304301 – Excel – Preset Headers and Footers (Length – 2:53)
304302 – Excel – Intro to Custom Headers and Footers (Length – 2:49)
304303 – Excel – Text Header (Length – 2:09)
304304 – Excel – File Information fields in footer (Length – 2:43)
304305 – Excel – Freezing Panes (Length – 2:39)
304306 – Excel – Repeating Rows at top of page (Length – 2:45)
304307 – Excel – Printing multiple sheets (Length – 2:35)
Back to Microsoft Excel Training Courses outline Enrol now
