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