CourseForMe

Excel 2010 Intermediate

CompuWorks
CompuWorks

Detailed information

Type:Courses
Method:Online
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

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

Course location

CompuWorks

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