Formatting

  • Page setup and set print area
  • Format Cells
  • Autoformat
  • Format rows and columns
  • Conditional formatting
  • Page Set-up

    [10 minutes total]

    These seven tutorials show how to format your raw data files for printing. Create customized headers and footers; put that one column that prints on its own page back with the others; and print column headings on every page, not just the first one!

    After viewing the tutorial(s), use the back key in your browser to return to this web site.

    Format Cells

    [10 minutes total]

    These seven tutorials show how to format your Excel cells and worksheets. Use color, text alignment, borders, and other formatting features to make your data easy to read and analyze!

    After viewing the tutorial(s), use the back key in your browser to return to this web site.

    Autoformat

    [3 minutes total]

    Although the Format cells feature in Excel gives you complete control over the appearance of your data, it also can be somewhat time-consuming. Microsoft has thoughtfully included an AutoFormat feature in Excel that allows you to quickly format data for analysis or reporting. These two tutorials show how to use this handy feature.

    After viewing the tutorial(s), use the back key in your browser to return to this web site.

    Rows and columns

    [5 minutes total]

    These three tutorials show how to resize, hide, and otherwise format your row and column data. The ability to quickly resize columns to fit their data is especially useful.

    After viewing the tutorial(s), use the back key in your browser to return to this web site.

    Conditional formatting

    [12 minutes total]

    Imagine being able to quickly color code all of the data in one or more columns to highlight patterns and trends in your data file. That’s what the Conditional formatting feature does and why it’s one of the most useful Excel skills educators can possess (it’s especially useful when combined with Excel’s Filter feature). These five tutorials show how to use this powerful tool.

    After viewing the tutorial(s), use the back key in your browser to return to this web site.

    You may need to turn off your browser’s pop-up blocker or install the latest Flash plug-in to view these tutorials.