Your browser is not supported. Please download Mozilla Firefox or Google Chrome browser.

coggno-logo2
Course Information arrow

Price Discounts

  • Qty

    Price

  • 1

    $30.00

  • 5

    $27.00

  • 11

    $24.00

  • 26

    $15.00

  • 51

    $7.50

  • 51

    $7.50

Syndication Option

Resell Course
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.


Excel 2010 Intermediate Course
Preview-button-95px

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

Read More
Buy this course
$30.00

Per License

Enter no. of units to buy
Total Payment Required$30.00 Add to Cart
# Licenses 1 5 11 26 51 51
Discounted Price $30.00 $27.00 $24.00 $15.00 $7.50 $7.50
Table of Contents:

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)

Comments:

10 0 5 1
Jonathan Jackson Jonathan Jackson said:
posted over 3 years ago
Hardware and Software Requirements:

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.

Included Modules:
  • Excel 2010 Intermediate - Introduction

    Excel 2010 Intermediate - Introduction

  • Excel 2010 Intermediate - Chapter 1: Using Workbooks output

    Excel 2010 Intermediate - Chapter 1: Using Workbooks output

  • Excel 2010 Intermediate - Chapter 2: Working with Range Names output

    Excel 2010 Intermediate - Chapter 2: Working with Range Names output

  • Excel 2010 Intermediate - Chapter 3: Applying Outlines and Subtotals

    Excel 2010 Intermediate - Chapter 3: Applying Outlines and Subtotals

  • Excel 2010 Intermediate - Chapter 4: Working with Templates output

    Excel 2010 Intermediate - Chapter 4: Working with Templates output

  • Excel 2010 Intermediate - Chapter 5: Collaborating output

    Excel 2010 Intermediate - Chapter 5: Collaborating output

  • Excel 2010 Intermediate - Chapter 6: Creating Charts output

    Excel 2010 Intermediate - Chapter 6: Creating Charts output

  • Excel 2010 Intermediate - Chapter 7: Formatting a Chart output

    Excel 2010 Intermediate - Chapter 7: Formatting a Chart output

  • Excel 2010 Intermediate - Chapter 8 - Drawing Objects output

    Excel 2010 Intermediate - Chapter 8 - Drawing Objects output

  • Excel 2010 Intermediate - Conclusion

    Excel 2010 Intermediate - Conclusion

Attachments
  • Icon-pdf
  • Excel 2010 Intermediate

    Please download this supplement guide to Excel 2010 Intermediate course.

  • 472.95 KB