Excel 2010 Intermediate


Detailed information

Duration:4 Hour

Do you need further information?
Contact the person in charge , free and at no obligation, for information on how to register, enrollment limit, availability and more.

Request information

Course program


Using Workbooks


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


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


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


Using an Existing Template

Creating and Saving a Template

Opening a Template

Modifying a Template

Table of Contents - Volume 2:



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


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


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


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


Course location


When it comes to finding the best training in New England and across the country, CompuWorks is the hands down leader.

For over 23 years CompuWorks has been creating some of the most successful award-winning training programs in the country.

Our goal is to provide our customers with the best training solution possible. This means we don’t use a cookie cutter approach but customize a learning plan that is designed to fit each organization’s unique business needs. Our ability to be innovative, adaptable and creative in handling challenges is the key to our success.

CompuWorks is proud to be both SOMWBA-certified as a woman-owned business and a Microsoft Gold Certified Partner with competencies in Learning Solutions & Information Worker Solutions.

Search similar to IT, ICT and Computing

Sponsored links