Excel 2010 Intermediate
4.8 (46 ratings)
598 students enrolled
Wishlisted Wishlist

# Excel 2010 Intermediate

Learn how to take Excel to the next level with charts, workbooks, range names and so much more
4.8 (46 ratings)
598 students enrolled
Last updated 10/2016
English
Current price: \$10 Original price: \$30 Discount: 67% off
30-Day Money-Back Guarantee
Includes:
• 3.5 hours on-demand video
• 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
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
Preview 05:26

Preview 01:05

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

Preview 01:36

Moving to and Deleting Range Names
04:34

Creating 3D Range Names
05:00

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
Preview 05:09

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

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
Preview 04:09

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