
- PRICE:
- $30.00per unit
- Visited: 2,166 times
- Author: Intellezy
- About The Subject Matter Expert
- Rating:
- Difficulty: Normal
-
Preview
Redeem Coupon
Device Compatibility
Certificate Available
Bookmarking Capability
Unlimited Access
Price Discounts
|
Syndication Option
Resell Course
|
Excel 2010 Intermediate Course
Author: Intellezy
Category: Online Software Training > Microsoft Office
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 too...
Keywords: Excel, Excel 2010 Intermediate, Excel 2010, Microsoft Office 2010, office, Text Prep, MOS, MOS 2007 Certification, Office 2010, Pam Conway, Intellezy
# Licenses | 1 | 5 | 11 | 26 | 51 | 51 |
---|---|---|---|---|---|---|
Discounted Price | $30.00 | $27.00 | $24.00 | $15.00 | $7.50 | $7.50 |
1) Introduction - Introduction (00:00)
2) Using Workbooks
- Navigating a workbook (00:00)
- Renaming sheets (00:10)
- Applying tab color (00:20)
- Inserting and deleting sheets (00:30)
- Moving and copying sheets (00:40)
- Moving a sheet to another workbook (00:50)
- Grouping worksheets (01:00)
- Creating Formulas Between Worksheets (01:10)
- Using the Watch Window (01:20)
3) Working with Range Names
- Assigning a Range Name (00:00)
- Creating a Range Name from headings (00:10)
- Moving to and deleting Range Names (00:20)
- Creating 3D Range Names (00:30)
- Inserting hyperlinks to Range Names (00:40)
4) Applying Outlines and Subtotals
- Applying an outline manually (00:00)
- Expanding and collapsing an outline (00:10)
- Applying an automatic outline (00:20)
- Modifying outline settings (00:30)
- Creating subtotals (00:40)
- Clearing subtotals (00:50)
- Changing the function used in subtotals (01:00)
5) Working with Templates
- Using an existing template (00:00)
- Creating and saving a template (00:10)
- Opening and modifying a template (00:20)
6) Collaborating
- Adding comments (00:00)
- Sharing a workbook (00:10)
- Tracking changes in a workbook (00:20)
- Comparing and merging workbooks (00:30)
- Using the document inspector (00:40)
- Saving a workbook as a PDF (00:50)
- Emailing a workbook (01:00)
7) Creating Charts
- Creating an embedded chart (00:00)
- Creating a chart on a separate sheet (00:10)
- Moving and resizing a chart (00:20)
- Switching row/column data (00:30)
- Changing the chart range (00:40)
- Changing the chart type (00:50)
- Printing a chart (01:00)
8) Formatting a Chart
- Applying Quick Layouts and Quick Styles (00:00)
- Adding chart elements (00:10)
- Formatting chart elements (00:20)
- Customizing 3D effects on a chart (00:30)
- Creating a picture chart (00:40)
9) Drawing Objects
- Adding a text box (00:00)
- Drawing a line or arrow (00:10)
- Drawing a rectangle or oval (00:20)
- Modifying objects (00:30)
- Formatting objects (00:40)
- Inserting SmartArt (00:50)
10) Conclusion - Conclusion (00:00)
|
The courses work well with Internet Explorer (v 8 - higher), Firefox, and Google Chrome. Please make sure you have Adobe Flash Player installed and that you are running the latest version of Flash Player, go to http://www.adobe.com/software/flash/about to check your version or get Flash http://www.adobe.com/go/getflash. We highly recommend at least 2-3 Mbps connection speed.
-
Excel 2010 Intermediate - Introduction
-
Excel 2010 Intermediate - Chapter 1: Using Workbooks output
-
Excel 2010 Intermediate - Chapter 2: Working with Range Names output
-
Excel 2010 Intermediate - Chapter 3: Applying Outlines and Subtotals
-
Excel 2010 Intermediate - Chapter 4: Working with Templates output
-
Excel 2010 Intermediate - Chapter 5: Collaborating output
-
Excel 2010 Intermediate - Chapter 6: Creating Charts output
-
Excel 2010 Intermediate - Chapter 7: Formatting a Chart output
-
Excel 2010 Intermediate - Chapter 8 - Drawing Objects output
-
Excel 2010 Intermediate - Conclusion
-
Excel 2010 Intermediate
Please download this supplement guide to Excel 2010 Intermediate course.
- 472.95 KB
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.