Excel 2007 Level II
Three Hour Class

Basic Excel spreadsheet skills are a prerequisite for taking this class. Students will learn how to use large spreadsheets as well as how to format and group worksheets. They will also learn how to create 3-D formulas. Creating charts is also an important feature covered in this class.

Split and Freezing a Workbook Window
Selecting Worksheets
Renaming, Moving and Copying Worksheets
Inserting and Deleting Worksheet
Hiding Rows, Columns and Worksheets
Review Formulas and Basic Functions
Creating 3-D Formulas
Using Cell Comments
Using the Paste Special Command
Using the Research Task Pane
Applying Conditional Formatting
Sorting by One Column

Protecting a Workbook/Worksheet
Creating/Modifying a Chart
Work with Chart Labels and Axes
Inserting/Formatting Clip Art and Pictures
Inserting/Formatting Shapes
Resize, move, Copy and Delete Objects
Applying Special Effect to Objects
Grouping objects
Flipping and Rotating Object
Layering Objects
Inserting SmartArt
Inserting WordArt