Excel 2007 Intermediate

Expand your Excel abilities with charts, outlines, workbooks and much more
4.5 (3 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
108 students enrolled
$30
Take This Course
  • Lectures 55
  • Contents Video: 2.5 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2013 English

Course Description

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.

What are the requirements?

  • Basic Microsoft Windows and Microsoft Excel 2007 training or equivalent experience

What am I going to get from this course?

  • Use multiple worksheets in a workbook
  • Create formulas across multiple sheets
  • Use the watch window
  • Create and use range names
  • Create and use outlines
  • Subtotal in a worksheet
  • Use paste special
  • Create, edit and format charts
  • Add drawn objects to a worksheet or chart
  • Create and use hyperlinks
  • Create, edit and use worksheet templates

What is the target audience?

  • Students who already possess a basic understanding of formulas, functions and formatting and are looking to expand their skills to include charts, collaborating and working with multiple sheets in the same workbook

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
02:37

If you would like to work along with the instructor, please download the attached .zip file, which contains all the files used throughout this course.  

Section 2: Workbooks
Navigate, Name, Color Worksheets
Preview
02:59
Naming Worksheets
Preview
01:13
Setting the Tab Color
Preview
01:55
Inserting and Deleting Worksheets
Preview
02:27
Moving and Copying Worksheet
04:16
Move Sheet to Another Workbook
02:16
Group Worksheets
02:30
Formatting Grouped Worksheets
02:34
Entering 3D Formulas
07:00
Using the Watch Window
03:52
Anchoring the Watch Window
02:00
Section 3: Range Names
Viewing Rules for Range Name
Preview
01:01
Naming a Range of Cells
Preview
01:11
Moving to a Range Name
Preview
01:47
Creating a Range Name from Headings
01:56
Name Manager
03:24
Performing Calculations with Range Names
05:10
Creating 3D Range Names
03:40
Using Range Names in 3D Formulas
01:33
Section 4: Working with Outlines and Subtotals
Applying an Outline Manually
Preview
03:20
Applying an Automatic Outline
00:41
Expanding and Collapsing an Outline
01:58
Clearing an Outline
00:50
Creating Subtotals
04:48
Changing the Function Used in Subtotals
02:27
Clearing Subtotals
00:37
Section 5: Using Paste Special
Pasting with No Borders
Preview
02:21
Transposing
02:20
Paste Values
02:30
Linking Worksheets and Workbooks
03:26
Arrange Windows Tool
03:22
Section 6: Charts
Creating an Embedded Chart
Preview
02:40
Moving a Chart to a Separate Sheet
02:10
Selecting Chart Designs and Styles
00:22
Changing the Chart Type
01:36
Switching Row/Column Data
01:15
Selecting a Chart Layout
03:24
Adding Chart Titles and Axis Labels
02:59
Creating a Chart Legend, Data Labels, and a Data Table
03:55
Formatting the Chart Axis
13:44
Section 7: Drawing Objects
Inserting a Text Box
07:50
Adding and Formatting Shapes
01:14
Using Connector Lines
01:23
Adding Shape Effects and Styles
03:23
Section 8: Creating Hyperlinks
Using Hyperlinks
Preview
01:01
Linking to a Named Range
Preview
01:40
Linking to a Specific Cell
01:05
Linking to a URL
00:47
Linking to an External File
01:53
Section 9: Working with Templates
Using an Existing Template
02:46
Modifying a Template
04:14
Saving a Template
04:14
Opening a Template
02:13
Section 10: Conclusion
Conclusion
02:16

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Intellezy Trainers, Computer Training Specialists

At Intellezy, we believe learning should be simple, engaging, and relevant. We make this possible by building innovative, short-segment eLearning videos and easy-to-use quick reference cards designed to educate and empower companies and individuals. In today’s rapidly evolving workplace it is imperative to make sure you have the skills required to succeed. Our library provides dynamic, task-focused videos right at your fingertips, right when you need them. Our goal? To educate the world, one video at a time.

Ready to start learning?
Take This Course