Excel 2007 - Intermediate

Duration
2 Hours, 24 Minutes

 

Delivery Method
Self-Paced

Educate 360 Pro from New Horizons

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

Course Overview

This course is designed to expand on the skills learned in the Introduction to Excel 2007 training. Specifically, this class will focus on using multiple sheets in a workbook, the advantages of working with range names, creating and applying spreadsheet templates, using the outline features and creating subtotals, and understanding all the options found in Paste Special. A significant amount of the course will be spent covering creating and manipulating charts and using drawing tools to annotate charts and spreadsheets.

Course Objectives

Workbooks, Range Names, Working with Outlines and Subtotals, Using Paste Special, Charts, Drawing Objects, Creating Hyperlinks, Working with Templates

Course Prerequisites

There are no prerequisites for this course.

Agenda

1 - Introduction

  • Introduction

2 - Workbooks

  • Navigate, Name, and Color Worksheets
  • Naming Worksheets
  • Setting the Tab Color
  • Inserting and Deleting Worksheets
  • Moving and Copying Worksheets
  • Moving a Sheet to Another Workbook
  • Grouping Worksheets
  • Formatting Grouped Worksheets
  • Entering 3D Formulas
  • Using the Watch Window
  • Anchoring the Watch Window

3 - Range Names

  • Viewing Rules for Range Names
  • Naming a Range of Cells
  • Moving to a Range Name
  • Creating a Range Name from Headings
  • Name Manager
  • Performing Calculations with Range Names
  • Creating 3D Range Names
  • Using Range Names in 3D Formulas

4 - Working with Outlines and Subtotals

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

5 - Using Paste Special

  • Pasting with No Borders
  • Transposing
  • Paste Values
  • Linking Worksheets and Workbooks
  • Using the Arrange Windows Tool

6 - Charts

  • Creating an Embedded Chart
  • Moving a Chart to a Separate Sheet
  • Selecting Chart Designs and Styles
  • Changing the Chart Type
  • Switching Row/Column Data
  • Selecting a Chart Layout
  • Using Chart Titles and Axis Labels
  • Creating a Chart Legend, Data Labels, and a Data Table
  • Formatting the Chart Axis

7 - Drawing Objects

  • Inserting a Text Box
  • Adding and Formatting Shapes
  • Using Connector Lines
  • Adding Shape Effects and Styles

8 - Creating Hyperlinks

  • Using Hyperlinks
  • Linking to a Named Range
  • Linking to a Specific Cell
  • Linking to a URL
  • Linking to an External File

9 - Working with Templates

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

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.