Excel 2010 Intermediate
4.6 (429 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,437 students enrolled

Excel 2010 Intermediate

Learn how to take Excel to the next level with charts, workbooks, range names and so much more
4.6 (429 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,437 students enrolled
Last updated 5/2018
English
English [Auto], Arabic, 8 more
  • French
  • German
  • Hindi
  • Japanese
  • Portuguese
  • Russian
  • Simplified Chinese
  • Spanish
Current price: $27.99 Original price: $39.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3.5 hours on-demand video
  • 2 downloadable resources
  • 1 Practice Test
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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
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.



This IAAP-certified counts for 3.5 recertification points for the CAP certification under the Technology and Information Distribution content area.

Email info@intellezy.com with proof of completion of the course to obtain your certificate.

Who this course is for:
  • 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
Course content
Expand 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