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

    $24.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 Advanced Course
Preview-button-95px

Excel 2010 Advanced Course

Author: Intellezy

Category: Online Software Training > Microsoft Office

This course delves into a variety of topics beyond the basics. You will learn how to use a wide range of financial, logical, text, and statistical functions; analyze data with the scenario manager; apply conditional formatting; and use the new Sparkline feature. Database management, PivotTables, ...

Keywords: Excel, Excel 2010 Advanced, Excel 2010, Microsoft Office 2010, office, Text Prep, MOS, MOS 2010Certification, Office 2010, Lisa Connors, Intellezy

Read More
Buy this course
$30.00

Per License

Enter no. of units to buy
Total Payment Required$30.00 Add to Cart
Discounted Price $30.0 $27.0 $24.0 $24.0 $7.5
# Licenses 1 5 11 26 51
Table of Contents:

1) Introduction - Introduction (00:00)

2) Using Advanced Functions Part 1
- Help with Functions (00:00)
- Logical Functions (00:10)

3) Using Advanced Functions Part 2
- Financial Functions (00:00)
- Text Functions (00:10)
- Lookup Functions (00:20)

4) Conditional Formatting and SparkLines
- Applying Conditional Formats (00:00)
- Managing Conditional Formats (00:10)
- Creating SparkLines (00:20)
- Modifying SparkLine styles (00:30)

5) Managing Data
- Data Validation (00:00)
- Working with Tables (00:10)
- Sorting a List (00:20)
- Filtering Data (00:30)

6) Using PivotTables, Pivot Charts, and Slicers
- Creating and a Pivot Table (00:00)
- Filtering and Sorting (00:10)
- Filtering with Slicers (00:20)
- Adding a PivotChart (00:30)

7) Analyzing Data
- Auditing and Error Checking (00:00)
- Using the Scenario Manager and Goal Seek (00:10)

8) Importing and Exporting Data
- Transferring between Word and Excel (00:00)
- Importing a Text File (00:10)
- Transferring between Access and Excel (00:20)

10) Conclusion - Conclusion (00:00)

Comments:

10 0 5 1
Kathy Letizio Kathy Letizio said:

I have completed the Excel 2010 Advanced Course and it was great. The software is easy to use and understand. The materials presented were very detailed and informative. I liked how I was able to stop and start as time permitted. I started the course last year and wasn’t able to complete it as I got caught up in year end. When I finally was able to resume, it took me back to where I left off. The presenter was entertaining and held my interest…sometimes online training can be a bit dry since there isn’t really any interaction. I liked how she gave helpful shortcut keys. Thanks again for the course. I will be sure to pass along information about the company.

posted over 4 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 Advanced - Introduction

    Excel 2010 Advanced - Introduction

  • Excel 2010 Advanced - Chapter 1: Using Advanced Functions output

    Excel 2010 Advanced - Chapter 1: Using Advanced Functions output

  • Excel 2010 Advanced - Chapter 2: Conditional Formatting and Sparklines output

    Excel 2010 Advanced - Chapter 2: Conditional Formatting and Sparklines output

  • Excel 2010 Advanced - Chapter 3 : Managing Data output

    Excel 2010 Advanced - Chapter 3 : Managing Data output

  • Excel 2010 Advanced - Chapter 4 :Using PivotTables, Pivot Charts, and Slicers output

    Excel 2010 Advanced - Chapter 4 :Using PivotTables, Pivot Charts, and Slicers output

  • Excel 2010 Advanced - Chapter 5 : Analyzing Data output

    Excel 2010 Advanced - Chapter 5 : Analyzing Data output

  • Excel 2010 Advanced - Chapter 6:Importing and Exporting Data output

    Excel 2010 Advanced - Chapter 6:Importing and Exporting Data output

  • Excel 2010 Advanced - Conclusion

    Excel 2010 Advanced - Conclusion

Attachments
  • Icon-pdf
  • Excel 2010 Advanced

    Please download this supplement guide to Excel 2010 Advanced course.

  • 550.36 KB