Excel 2010 Intermediate
4.9 (41 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.
557 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

Excel 2010 Intermediate

Learn how to take Excel to the next level with charts, workbooks, range names and so much more
4.9 (41 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.
557 students enrolled
Last updated 10/2016
English
Learn Fest Sale
Current price: $10 Original price: $30 Discount: 67% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Effectively use workbooks
  • Understand the benefits of range names
  • Apply outlines and work with subtotals
  • Automate Excel with templates
  • Turn numeric data into charts
View Curriculum
Requirements
  • Introductory Excel training or equivalent knowledge
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.

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 51 Lectures Collapse All 51 Lectures 03:34:08
+
Course Overview
1 Lecture 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.  
Preview 03:41
+
Using Workbooks
9 Lectures 41:59



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
+
Working with Range Names
5 Lectures 18:08


Moving to and Deleting Range Names
04:34

Creating 3D Range Names
05:00

Inserting Hyperlinks to Range Names
02:26
+
Applying Outlines and Subtotals
7 Lectures 13:31
Applying an Outline Manually
03:35

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:04
+
Working with Templates
3 Lectures 15:59
Using an Existing Template
09:18

Creating and Saving a Template
04:02

Opening and Modifying a Template
02:39
+
Collaborating
7 Lectures 22:35


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:17
+
Creating Charts
7 Lectures 15:05

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
+
Formatting a Chart
5 Lectures 57:46

Adding Chart Elements
18:53

Formatting Chart Elements
28:03

Customizing 3D Effects on a Chart
03:36

Creating a Picture Chart
03:05
+
Drawing Objects
6 Lectures 23:35
Adding a Text Box
04:40

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:06
+
Conclusion
1 Lecture 01:49
Conclusion
01:49
About the Instructor
Intellezy Trainers
4.4 Average rating
3,342 Reviews
22,033 Students
134 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.