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

  • 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.


Similar Courses arrow
excel-2010-intermediate-course Excel 2010 Intermediate Course
Tuesday Jun 04 2013

excel-2010-advanced-course Excel 2010 Advanced Course
Tuesday Jun 04 2013

excel-2010-vba-course Excel 2010 VBA Course
Tuesday Jun 04 2013

excel-2007-advanced-course Excel 2007 Advanced Course
Tuesday Jun 04 2013

excel-2007-intermediate-course Excel 2007 Intermediate Course
Tuesday Jun 04 2013

excel-2007-introduction-course Excel 2007 Introduction Course
Tuesday Jun 04 2013

Excel 2010 Introduction Course
Preview-button-95px

Excel 2010 Introduction Course

Author: Intellezy

Category: Online Software Training > Microsoft Office

This course is designed to teach students the fundamentals of Excel. Specifically you will understand how to create, save, enter data and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to format spreadsheets, manipulat...

Keywords: Excel, Excel 2010 Introduction, 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
Discounted Price $30.0 $27.0 $24.0 $15.0 $7.5
# Licenses 1 5 11 26 51
Table of Contents:

1) Introduction - Introduction (00:00)

2) Getting Started
- Three primary functions of Excel (00:00)
- Spreadsheet terminology (00:10)
- Overview of the Excel screen (00:20)
- Navigating a worksheet (00:30)
- Using zoom (00:40)

3) Basic Worksheet Skills
- Creating a new workbook (00:00)
- Entering data (00:10)
- Selecting a range (00:20)
- Selecting columns, rows and non-contiguous cells (00:30)
- Using worksheets (00:40)
- Using AutoFill (00:50)
- Deleting a worksheet (01:00)
- Saving a workbook (01:10)

4) Creating Formulas
- Entering a simple formula (00:00)
- Using cell addresses in a formula (00:10)
- Using simple functions: SUM (00:20)
- Using Autofill with formulas (00:30)
- Using AutoSum (00:40)
- Inserting Functions: AVERAGE, MAX, MIN, COUNT (00:50)
- Working with date arithmetic (01:00)
- Date and currency formatting (01:10)
- Using Clear All (01:20)
- Relative v. absolute cell addressing (01:30)
- AutoCalculate (01:40)

5) Editing a Workbook
- Deleting a range (00:00)
- Using undo and redo (00:10)
- Using cut, copy and paste (00:20)
- Using paste options (00:30)
- Using the Clipboard Task Pane (00:40)
- Using find and replace (00:50)

6) Formatting the Worksheet
- Inserting and deleting columns and rows (00:00)
- Adjusting column widths and row heights (00:10)
- Hiding rows and columns (00:20)
- Changing numeric formats (00:30)
- Using the format cells dialog box (00:40)
- Changing text formats (00:50)
- Aligning data (01:00)
- Using borders and shading (01:10)
- Using the format painter (01:20)
- Using cell styles (01:30)
- Creating new cell styles (01:40)
- Modifying cell styles (01:50)
- Using themes (02:00)

7) Working with Large Worksheets or Multiple Workbooks
- Using the zoom feature (00:00)
- Splitting the window (00:10)
- Freeze and unfreeze panes (00:20)
- Tiling multiple workbooks (00:30)
- Synchronous scrolling (00:40)
- Hiding, maximizing, and closing windows (00:50)

8) Using Protection and Comment Boxes
- Adding, hiding, and deleting comments (00:00)
- Locking and unlocking cell ranges (00:10)

9) Printing and Page Setup
- Using Page Break Preview (00:00)
- Using Print Preview (00:10)
- Changing the orientation (00:20)
- Changing the margins (00:30)
- Adding headers and footers (00:40)
- Setting sheet options (00:50)
- Setting print titles (01:00)
- Working with print areas (01:10)
Using the Page Layout tab (01:20)

10) Conclusion - Conclusion (00:00)

Comments:

20 0 5 3
Kirsten Thompson Kirsten Thompson said:
posted over 3 years ago
Manoucheka Joseph Manoucheka Joseph said:

Pam was great, I really enjoyed the course!

posted almost 4 years ago
Sharri Miner Sharri Miner said:

Pam did a nice job. She instructs in a way that is casual yet professional.

posted over 5 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 Introduction - Introduction

    Excel 2010 Introduction - Introduction

  • Excel 2010 Introduction - Chapter 1: Getting Started output

    Excel 2010 Introduction - Chapter 1: Getting Started output

  • Excel 2010 Introduction - Chapter 2: Basic Worksheet Skills output

    Excel 2010 Introduction - Chapter 2: Basic Worksheet Skills output

  • Excel 2010 Introduction - Chapter 3: Creating Formulas output

    Excel 2010 Introduction - Chapter 3: Creating Formulas output

  • Excel 2010 Introduction - Chapter 4: Editing a Workbook output

    Excel 2010 Introduction - Chapter 4: Editing a Workbook output

  • Excel 2010 Introduction  - Chapter 5:Formatting the Worksheet output

    Excel 2010 Introduction - Chapter 5:Formatting the Worksheet output

  • Excel 2010 Introduction  - Chapter 6: Working with Large Worksheets or Multiple Workbooks output

    Excel 2010 Introduction - Chapter 6: Working with Large Worksheets or Multiple Workbooks output

  • Excel 2010 Introduction - Chapter 7:Using Protection and Comment Boxes output

    Excel 2010 Introduction - Chapter 7:Using Protection and Comment Boxes output

  • Excel 2010 Introduction - Chapter 8 : Printing and Page Setup output

    Excel 2010 Introduction - Chapter 8 : Printing and Page Setup output

  • Excel 2010 Introduction - Conclusion

    Excel 2010 Introduction - Conclusion

Attachments
  • Icon-pdf
  • Excel 2010 Introduction

    Please download this supplement guide to Excel 2010 Introduction course.

  • 441.79 KB