Split and Freezing a Workbook Window Selecting Worksheets Renaming, Moving and Copying Worksheets Inserting and Deleting Worksheet Working with Multiple Workbooks 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 Sorting by colors or Icons Sorting by Multiple Columns Protecting a Workbook
|
|
Protecting a Worksheet Creating a Chart Modifying a Chart Work with Chart Labels working with Chart Axes Working With Chart Backgrounds 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
|
|