Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Excel 2007 Intermediate to your Wishlist.

Add to Wishlist

Excel 2007 Intermediate

Expand your Excel abilities with charts, outlines, workbooks and much more
4.0 (5 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.
114 students enrolled
Last updated 10/2016
English
$10 $30 67% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
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
View Curriculum
Requirements
  • Basic Microsoft Windows and Microsoft Excel 2007 training or equivalent experience
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.

Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 55 Lectures Collapse All 55 Lectures 02:28:14
+
Introduction
1 Lecture 02:36

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.  

Preview 02:36
+
Workbooks
11 Lectures 33:01




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
+
Range Names
8 Lectures 19:42



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
+
Working with Outlines and Subtotals
7 Lectures 14:40

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
+
Using Paste Special
5 Lectures 13:58

Transposing
02:20

Paste Values
02:30

Linking Worksheets and Workbooks
03:26

Arrange Windows Tool
03:22
+
Charts
9 Lectures 32:03

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:43
+
Drawing Objects
4 Lectures 13:49
Inserting a Text Box
07:49

Adding and Formatting Shapes
01:14

Using Connector Lines
01:23

Adding Shape Effects and Styles
03:23
+
Creating Hyperlinks
5 Lectures 06:26


Linking to a Specific Cell
01:05

Linking to a URL
00:47

Linking to an External File
01:53
+
Working with Templates
4 Lectures 09:43
Using an Existing Template
02:45

Modifying a Template
00:31

Saving a Template
04:14

Opening a Template
02:13
+
Conclusion
1 Lecture 02:16
Conclusion
02:16
About the Instructor
4.4 Average rating
2,484 Reviews
18,175 Students
127 Courses
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.
Report Abuse