Microsoft Excel Intermediate Course 304 Training Manual & Workbook – Viewing & Printing

$49.00 inc GST

This Training Manual and Workbook contains step-by-step tasks using Microsoft Excel for training case studies based on real world scenarios including.

  • Instant download in PDF format (20 pages)
  • Based on real world case studies
  • Includes 11 practice Excel exercise files
  • Course Content for Excel Intermediate Certificate
  • Upgrade path to Full course
  • Skills using database, page breaks and formatting files

Description

  • 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.