February | 2010 | Rocky Mountain Hi-Tech 2010 February | Computer Training Online and Offline

Sorting Worksheet Data
Sorting by a Single Column
Sorting Selected Rows
Sorting by Multiple Columns
Using Flexible Worksheet Views
Freezing Rows or Columns
Splitting the Worksheet Window
Printing Multipage Worksheets
Setting Print Format in Page Layout View
Page Layout Ribbon
Sizing Options
Headers and Footers
Setting Title Rows and Columns
Sheet Options
Working with Page Breaks

Adding Graphics to Worksheets

Using Illustrations with Excel
Design Principles
The Illustrations Group on the Ribbon
Inserting Pictures and Clip Art
Inserting a Picture from a File
Inserting Clip Art
Moving, Sizing, and Rotating Images
Scaling and Cropping Images
Adjusting Images and Special Effects
Getting into Shapes
Inserting Shapes
Introducing SmartArt
Using SmartArt
Adding Text to SmartArt
Formatting SmartArt

Using Templates and Protecting Workbooks

Using Templates
Template Features
The New Workbook Dialog Box
Template Storage Locations
Customizing Templates
Creating Your Own Templates
Modifying Custom Templates
Protecting Workbooks and Worksheets
Protecting the Workbook Structure
Protecting Worksheet Elements
Password Protection
Protecting Cells
When to Use a Digital Signature

Managing Multiple-Sheet Workbooks

Using Multiple Worksheets
Modifying the Default Number of Sheets
Linking Cells and Formulas
Why Link Cells?
Linking Formulas
Copying Worksheets
The Move or Copy Dialog Box
Copying Formats between Worksheets
Naming Cells and Ranges
Naming Rules
Creating Defined Names
Using Defined Names
Modifying and Deleting Defined Names
Creating Hyperlinks
Types of Hyperlinks
Insert Hyperlink Dialog Box
Editing and Removing Hyperlinks
Printing Multiple-Sheet Workbooks
Applying Page Setup Options to Multiple Sheets
Printing All Sheets in a Workbook
Printing Selected Sheets

Creating Tables and Outlines

What Happened to Excel Databases?
Why Use a Table?
Working with Tables
Table Rows
Table Columns
Creating a Table
Converting a Range to a Table
Creating a New Blank Table
Renaming a Table
Header Row
Total Row
Formatting a Table
Adding and Deleting Rows and Columns
Selecting Table Rows and Columns
Calculated Columns
Converting a Table to a Range
Printing a Table
Deleting a Table
Understanding Structured References
Formulas with Structured References
Using Enhanced Sorting and Filtering
Sorts
Filters
Custom Filters
Using the Outline Feature
How Outlines Work
Auto Outline
Creating Groups Manually
Displaying Subtotals
Sorting the List
The Subtotal Dialog Box