Excel 2010 Intermediate

Learn how to take Excel to the next level with charts, workbooks, range names and so much more
4.3 (25 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.
378 students enrolled
$30
Take This Course
  • Lectures 51
  • Contents Video: 3.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

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

What are the requirements?

  • Introductory Excel training or equivalent knowledge

What am I going to get from this course?

  • Effectively use workbooks
  • Understand the benefits of range names
  • Apply outlines and work with subtotals
  • Automate Excel with templates
  • Turn numeric data into charts

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: Course Overview
03:41
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: Using Workbooks
Navigating a Workbook
Preview
05:27
Renaming Sheets
Preview
01:05
Applying Tab Color
Preview
02:17
Inserting and Deleting Sheets
03:41
Moving and Copying Sheets
03:29
Moving a Sheet to another Workbook
03:00
Grouping Worksheets
06:40
Creating Formulas between Worksheets
07:30
Using the Watch Window
08:51
Section 3: Working with Range Names
Assigning a Range Name
Preview
04:32
Creating a Range Name from Headings
Preview
01:36
Moving to and Deleting Range Names
04:35
Creating 3D Range Names
05:00
Inserting Hyperlinks to Range Names
02:26
Section 4: Applying Outlines and Subtotals
Applying an Outline Manually
03:36
Expanding and Collapsing an Outline
01:47
Applying an Automatic Outline
02:22
Modifying Outline Settings
01:03
Creating Subtotals
02:51
Clearing Subtotals
00:49
Changing the Function Used in Subtotals
01:05
Section 5: Working with Templates
Using an Existing Template
09:19
Creating and Saving a Template
04:02
Opening and Modifying a Template
02:39
Section 6: Collaborating
Adding Comments
Preview
05:10
Sharing a Workbook
Preview
01:52
Tracking Changes in a Workbook
05:38
Comparing and Merging Workbooks
03:20
Using the Document Inspector
03:33
Saving a Workbook as a PDF
01:46
Emailing a Workbook
01:18
Section 7: Creating Charts
Creating an Embedded Chart
Preview
03:42
Creating a Chart on a Separate Sheet
02:13
Moving and Resizing a Chart
01:37
Switching Row/Column Data
01:04
Changing the Chart Range
03:03
Changing the Chart Type
01:23
Printing a Chart
02:04
Section 8: Formatting a Chart
Applying Quick Layouts and Quick Styles
Preview
04:10
Adding Chart Elements
18:53
Formatting Chart Elements
28:03
Customizing 3D Effects on a Chart
03:36
Creating a Picture Chart
03:05
Section 9: Drawing Objects
Adding a Text Box
04:41
Drawing a Line or Arrow
01:53
Drawing a Rectangle or Oval
02:20
Modifying Objects
06:53
Formatting Objects
01:43
Inserting SmartArt
06:07
Section 10: Conclusion
Conclusion
01:49

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