Explore
  • Adobe
  • Autodesk
  • Bentley
  • Business
  • Education
  • Google
  • Human Resources
  • Microsoft
  • Retrieve Software Suites
  • Technical
  • Miscellaneous
  • Vectorworks
    • Cart

    You have no items in your shopping cart.

    Excel 2010 Intermediate

    • Excel 2010 Intermediate

      $30.00
    $30.00

    Product Overview

    Excel 2010 Intermediate

    Product Description

    Students will use learn to streamline and enhance spreadsheets with 3D formulas, range names, templates, and outlines and subtotals. In addition, students will learn to enhance spreadsheets with charts and other graphic objects.



    Table of Contents - Volume 1:



    • Introduction

    • Using Workbooks


      • Overview

      • Navigating a Workbook

      • Renaming Sheets

      • Applying Tab Color

      • Inserting and Deleting Sheets

      • Moving and Copying Sheets

      • Moving a Sheet to Another Workbook

      • Grouping Worksheets

      • Formatting Grouped Worksheets

      • Creating Formulas Across Worksheets

      • Adding a Watch Window

      • Anchoring the Watch Window

      • Linking to Another Workbook



    • Working with Range Names


      • Overview

      • Assigning a Range Name

      • Creating a Range Name from Headings

      • Moving to a Range Name

      • Using Range Names in Formulas

      • Creating 3D Range Names

      • Using Range Names in 3D Formulas

      • Inserting Hyperlinks into Range Names



    • Applying Outlines and Subtotals


      • Overview

      • Applying an Outline Manually

      • Expanding and Collapsing an Outline

      • Applying an Automatic Outline

      • Clearing an Outline

      • Modifying Outline Settings

      • Creating Subtotals

      • Clearing Subtotals

      • Changing the Function Used in Subtotals



    • Working with Templates


      • Overview

      • Using an Existing Template

      • Creating and Saving a Template

      • Opening a Template

      • Modifying a Template




     


    Table of Contents - Volume 2:



    • Collaborating


      • Overview

      • Adding Comments

      • Sharing a Workbook

      • Tracking Changes in a Workbook

      • Comparing and Merging Workbooks

      • Using the Document Inspector

      • Saving a Workbook as a PDF

      • Emailing a Workbook



    • Creating Charts


      • Overview

      • Creating an Embedded Chart

      • Creating a Chart on a Separate Sheet

      • Moving and Resizing a Chart

      • Switching Row/Column Data

      • Changing the Chart Range

      • Changing the Chart Type

      • Printing a Chart



    • Formatting a Chart


      • Overview

      • Applying Quick Layouts and Quick Styles

      • Adding Chart Elements

      • Formatting Chart Elements

      • Customizing 3D Effects on a Chart

      • Scaling an Axis

      • Creating a Picture Chart



    • Drawing Objects


      • Overview

      • Adding a Text Box

      • Drawing a Line or Arrow

      • Drawing a Rectangle or Oval

      • Moving and Resizing Objects

      • Removing or Changing the Fill Color

      • Adding Text to an Object

      • Inserting SmartArt

      • Conclusion




     

    Related Content