Forgot your password?

Excel 2007 Training Intermediate

Title Banner
Expand All | Collapse All

Chapters Courseware Online
Learning
Skills Assessments

5. Creating and Working with Charts

Creating a Chart Demo Demo Demo
Resizing and Moving a Chart - - -
Changing Chart Type - - -
Applying Built-in Chart Layouts and Styles - - -
Working with Chart Labels - - -
Working with Chart Axes - - -
Working with Chart Backgrounds - - -
Working with Chart Analysis Commands - - -
Formatting Chart Elements - - -
Changing a Chart’s Source Data - - -
Using Chart Templates - - -

6. Managing Workbooks

Viewing a Workbook Demo Demo Demo
Working with the Workbook Window - - -
Splitting and Freezing a Workbook Window - - -
Selecting Worksheets in a Workbook - - -
Inserting and Deleting Worksheets - - -
Renaming, Moving and Copying Worksheets - - -
Working with Multiple Workbooks - - -
Hiding Rows, Columns, Worksheets and Windows - - -
Protecting a Workbook - - -
Protecting Worksheets and Worksheet Elements - - -
Sharing a Workbook - - -
Creating a Template - - -

7. Working with Page Layout and Printing

Creating Headers and Footers Demo Demo Demo
Using Page Breaks - - -
Adjusting Margins and Orientation - - -
Adjusting Size and Scale - - -
Adding Print Titles, Gridlines and Headings - - -
Advanced Printing Options - - -

8. More Functions and Formulas

Formulas with Multiple Operators Demo Demo Demo
Inserting and Editing a Function - - -
AutoCalculate and Manual Calculation - - -
Defining Names - - -
Using and Managing Defined Names - - -
Displaying and Tracing Formulas - - -
Understanding Formula Errors - - -

9. Working with Data Ranges

Sorting by One Column Demo Demo Demo
Sorting by Colors or Icons - - -
Sorting by Multiple Columns - - -
Sorting by a Custom List - - -
Filtering Data - - -
Creating a Custom AutoFilter - - -
Using an Advanced Filter - - -

10. Working with Tables

Creating a Table Demo Demo Demo
Working with Table Size - - -
Working with the Total Row - - -
Working with Table Data - - -
Summarizing a Table with a PivotTable - - -
Using the Data Form - - -
Using Table Styles - - -
Using Table Style Options - - -
Creating and Deleting Custom Table Styles - - -
Convert or Delete a Table - - -

11. Working with Objects

Inserting Clip Art Demo Demo Demo
Inserting Pictures and Graphics Files - - -
Formatting Pictures and Graphics - - -
Inserting Shapes - - -
Formatting Shapes - - -
Resize, Move, Copy and Delete Objects - - -
Applying Special Effects to Objects - - -
Grouping Objects - - -
Aligning Objects - - -
Flipping and Rotating Objects - - -
Layering Objects - - -
Inserting SmartArt - - -
Working with SmartArt Elements - - -
Formatting SmartArt - - -
Using WordArt - - -
Inserting an Embedded Object - - -
Inserting Symbols - - -

12. Working with PivotTables

Creating a PivotTable Demo Demo Demo
Specifying PivotTable Data - - -
Changing a PivotTable’s Calculation - - -
Filtering and Sorting a PivotTable - - -
Working with PivotTable Layout - - -
Grouping PivotTable Items - - -
Updating a PivotTable - - -
Formatting a PivotTable - - -
Creating a PivotChart - - -
  • Logo
  • Logo
  • Logo
  • Logo
  • Logo
  • Logo
  • Logo
  • Logo
  • Logo

© 2013 CustomGuide, Inc. All rights reserved.