Introduction


Introduction to Excel

Session Description

This session will explore the basic formatting features in Excel.

At the completion of this session the team member will:

  • be familiar with the Excel toolbars and features
  • be able to create headers and footers in a spreadsheet
  • know how to change the column’s width and row’s height
  • be able to alter the alignment and format of a cell
  • be familiar with the text rotation feature for a cell
  • know how to insert and delete rows and columns in a worksheet
  • be able to insert, delete, rename, move, and copy a worksheet in a spreadsheet
  • be familiar with the merge cells feature in a worksheet
  • know how to format the borders of selected cells
  • be able to protect specific cells in a spreadsheet to avoid formula deletion
  • be capable of setting the print area for a worksheet
  • know how to apply an auto format to a spreadsheet
  • know how to use conditional formatting in a spreadsheet
  • be able to insert comments into specific cells
  • be familiar with the merge cells feature in a worksheet
  • know how to format the borders of selected cells
  • be able to protect specific cells in a spreadsheet to avoid formula deletion
  • be capable of setting the print area for a worksheet
  • know how to apply an auto format to a spreadsheet
  • know how to use conditional formatting in a spreadsheet
  • be able to insert comments into specific cells
  • know how to move selected cells and clear cell formats
  • be able to change the direction of the active cell after hitting enter
  • know how to work with the series functions (auto fill)
  • be able to set print titles and options in a spreadsheet
  • be familiar with spreadsheet page scaling and centering
  • know how to define, apply and remove a style
  • be able to use the format painter
  • know how to create hyperlinks in a spreadsheet
  • be capable of using and creating a template
  • be familiar with the send to feature in Excel
  • be familiar with using the office assistant

Who should attend? Anyone

Presenter: Linda Steele

Prerequisite: None

Program Length: 2 hours

CPE awarded: 2 hours Computer Science