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	-	-	-

Popular Courses

FREE QUICK REFERENCES

Sign up to download Quick References for your favorite software programs - 100% spam free.

Copyright © 2010 CustomGuide Inc. - All rights reserved.