Back To Shop

Excel 2010 - Intermediate Course

Author: Intellezy

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.

Instructor: Pam Conway

Prerequisites: Excel 2010 Introduction or Equivalent Experience

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

Please email info@intellezy.com with proof of completion to obtain your certificate.

Keywords: Excel, Excel 2010 Intermediate, Excel 2010, Microsoft Office 2010, office, Text Prep, MOS, MOS 2007 Certification, Office 2010, Pam Conway, Intellezy, microsoft office, Microsoft Office 365, excel 2010 intermediate training pdf, excel 2010 intermediate tutorial, microsoft excel 2010 intermediate tutorial, microsoft excel 2010 tutorial pdf, what is intermediate in excel?, IAAP, IAAP Approved, CAP Certification, IAAP CAP Certification

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)

Related Courses

Excel 2010 - Beginner Course

by Intellezy

Visited 3,555 times

$30.00

Excel 2007 - Intermediate Course

by Intellezy

Visited 2,467 times

$30.00

Excel 2010 - Intermediate Course

Excel 2010 - Intermediate

Attachments:

Excel 2010 Intermediate   (472.95 KB)
Please download this supplement guide to Excel 2010 Intermediate course.

Buy This Course

Price :

$30.00 ( Per License )

Visited: 2456 Times

Difficulty: Normal

# Licenses Discounted Price
1 $30.00
51 $21.00
101 $18.00
251 $15.00
501 $10.50
1001 $7.50

Resold modules appear on your website. You earn syndication share from each purchase. Contact Coggno to learn more on how to embed your own Portable Webshop in your website.

Syndication FAQs