Irvine Training Company                               www.IrvineTrainingCo.com
Excel 120
Excel 120 - Make your worksheets and printouts look good
1/2 day
Prerequisite: Excel 115 or Equivalent
click here to return
Make Worksheets Readable

Improve the Appearance of Cells, Columns and Rows
    Change the font type and font size
    Add borders to cells
    Add color to cell backgrounds
    Several ways to change column width
    Several ways to change row height
    Merge multiple cells into a single cell

Improve the Appearance of Cell Contents
    Conventional usage of common number formats
    Change the number format of cells
    Other cell formats of interest
    Align cell contents
    Apply an AutoFormat

Improve the Appearance of Worksheets
    Change the name of a tab on a worksheet
    Change the color of a tab on a worksheet
    Move worksheets in a workbook
    Insert worksheets
    Delete worksheets
    Copy the whole worksheet

More Shortcuts
    Paste vs. Paste Special
    Use the Format Painter

See your on-screen data more easily
    See disconnected parts of the same worksheet by using Split
    See different worksheets on the same screen by using Arrange
    See column headings in a long worksheet by using Freeze
    See row headings in a wide worksheet by using Freeze

Make Printouts look good

Make your Excel Printout look good
    Print Column headings on each page of a multi-page printout
    Print report title and other information at the top of each page
    Print page numbers and other information at the bottom of each page

Options for resizing: How to make the printing fit on a page
    Set the page margins
    Change the page orientation
    View the page breaks
    Change the location of page breaks
    Insert and remove page breaks
    Print just part of a worksheet by setting a print range