Excel 2010 - Intermediate

3 Hours, 31 Minutes


Delivery Method

Educate 360 Pro from New Horizons

This class is part of a 12‑month Educate 360 Pro Subscription

Course Overview

In this course, you will learn how to use multiple worksheets and workbooks efficiently. You will also learn how to create outlines and subtotals, how to create and apply Range Names, and how to create and format charts. You will work with templates, collaborate in workbooks, and use the drawing tools to enhance and annotate spreadsheets.

Course Objectives

Using Workbooks, Working with Range Names, Applying Outlines and Subtotals, Working with Templates, Collaborating, Creating Charts, Formatting a Chart, Drawing Objects

Course Prerequisites

The recommended pre-requisite for this course is Introductory Excel training or equivalent knowledge.


1 - Introduction

  • Introduction

2 - 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
  • Creating Formulas Between Worksheets
  • Using the Watch Window

3 - Working with Range Names

  • Assigning a Range Name
  • Creating a Range Name From Headings
  • Moving To and Deleting Range Names
  • Creating 3D Range Names
  • Inserting Hyperlinks to Range Names

4 - Applying Outlines and Subtotals

  • Applying an Outline Manually
  • Expanding and Collapsing an Outline
  • Applying an Automatic Outline
  • Modifying Outline Settings
  • Creating Subtotals
  • Clearing Subtotals
  • Changing the Function Used in Subtotals

5 - Working with Templates

  • Using an Existing Template
  • Creating and Saving a Template
  • Opening and Modifying a Template

6 - Collaborating

  • 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

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

8 - Formatting a Chart

  • Applying Quick Layouts and Quick Styles
  • Adding a Chart Element
  • Formatting Chart Elements
  • Customizing 3D Effects on a Chart
  • Creating a Picture Chart

9 - Drawing Objects

  • Adding a Text Box
  • Drawing a Line or Arrow
  • Drawing a Rectangle or Oval
  • Modifying Objects
  • Formatting Objects
  • Inserting SmartArt

10 - Conclusion

  • Course Recap

What is Educate 360 Pro?

Educate 360 Pro is a 12-month subscription that provides unlimited access to full-day or short-duration live classes, on-demand video courses, class recordings, and quick reference cards. New Horizons offers more learning solutions for Microsoft Office than any other training provider and they are all included in your Educate 360 Pro subscription.

  • Unlimited enrollments into over 90 full-day and short-duration live training classes
  • Over 750 hours of on-demand video based content
  • A full library of digital quick reference cards for your favorite Office applications
  • Access to class recordings so you never have to worry about missing a scheduled class

Benefits of an Educate 360 Pro Subscription

Our Educate 360 Pro subscription is built to fit in and around your schedule. It will change the way you think about training.

  • Ask questions and get immediate answers during our full-day and short-duration live classes
  • Learn how to perform specific tasks instead of wasting time learning things you already know
  • Collaborate with fellow students and gain insight into new ways to solve problems
  • View on-demand courses with instructors that never leave your screen
  • Utilize course assessments to validate new skills
  • Take full day training classes on your schedule by accessing our class recordings
  • Revisit a prior class to further enhance your skills

Need more information? Click here to learn more about Educate 360 Pro.