304 Microsoft Excel – Viewing and printing

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

 

The Australian Small Business Training and Support

Subscribe to our business blogCourses, Training and Support.

Get bookkeeping, marketing, operations, customer service, sales and finance knowledge via email. Keep up to date with new and emerging trends and technologies and get our free samples.

Enquiry Form

  • This field is for validation purposes and should be left unchanged.
Call Now Button
%d bloggers like this: