FastCourse Microsoft Excel 2010: Level 2
Preliminary Table of Contents
FastCourse Microsoft Excel 2010: Level 2
Preliminary Table of Contents
|
Lesson 1: Working with Large Worksheets: 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 Viewing Worksheets in Multiple Windows Printing Multipage Worksheets Setting Print Format in Page Layout View Page Layout Ribbon Applying a Worksheet Background Sizing Options Headers and Footers Adding a Watermark Image Applying a Worksheet Background Setting Title Rows and Columns Sheet Options Working with Page Breaks
Lesson 2: Managing Multiple-Sheet Workbooks Using Multiple Worksheets Modifying the Default Number of Sheets Selecting Multiple 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
|
Lesson 3: Working with Tables, Lists, and Outlines 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 in Lists and Tables Sorts Filters Custom Filters Explore Number and Date Criteria Options Using the Outline Feature How Outlines Work Auto Outline Creating Groups Manually Displaying Subtotals Sorting the List The Subtotal Dialog Box
Lesson 4: 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
|
|
Lesson 5: Using Templates and Protecting Worksheets 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 Creating Digital Signatures When to Use a Digital Signature Creating a Digital Certificate Creating a Digital Signature
Index |