ASL MEDIA

  • Home
  • Teach Me Microsoft Excel 2010 in ASL - HOME-STUDY DVD

Teach Me Microsoft Excel 2010 in ASL - HOME-STUDY DVD

199.95
Home-Excel-front.jpg
Home-Excel-back.jpg

Teach Me Microsoft Excel 2010 in ASL - HOME-STUDY DVD

199.95

Product Description

Learn Microsoft Excel 2010 in American Sign Language. Become an expert quickly!

Are you ready to be an expert on Microsoft Excel 2010? Excel is the one of popular applications in the Microsoft Office suite, and Excel has some exciting new features. If you learn best when you can see how something is done, you'll find 262 step-by-step instructions and stunning full-color, full-motion recordings of a running application make it quick and easy to learn Excel in order to prepare yourself in your transition into the working world, or higher academic or vocational training.

As a beginner, intermediate user or advanced user, you'll learn to:

  • Customize the Ribbon
  • Enter and edit cell data
  • Build formulas and functions
  • Format a range or chart
  • Analyze Excel data
  • Insert worksheet graphics
  • Handle practical tips and tricks

When you've completed your Microsoft Excel training, you'll know how to use all the time-saving tips, tricks and troubleshooting techniques that help you get up and running on Excel right away.

This package consists of 129 lessons on 4 discs.

Video Demo

Watch the demo on YouTube: https://youtu.be/TjaIyWxBQ4o

Product Information

Instructor: James Kittell
Format: Color, Widescreen, NTSC, HD
Language: English and ASL
Aspect Ratio: 16:9
Number of Discs: 4
Number of Lessons: 129
Studio: ASL MEDIA
DVD Release Date: August 28, 2012
Run Time: 253 minutes (4 discs)

More Info

Quantity:
Add To Cart

Product Description

Learn Microsoft Excel 2010 in American Sign Language. Become an expert quickly!

Are you ready to be an expert on Microsoft Excel 2010? Excel is the one of popular applications in the Microsoft Office suite, and Excel has some exciting new features. If you learn best when you can see how something is done, you'll find 262 step-by-step instructions and stunning full-color, full-motion recordings of a running application make it quick and easy to learn Excel in order to prepare yourself in your transition into the working world, or higher academic or vocational training.

As a beginner, intermediate user or advanced user, you'll learn to:

  • Customize the Ribbon
  • Enter and edit cell data
  • Build formulas and functions
  • Format a range or chart
  • Analyze Excel data
  • Insert worksheet graphics
  • Handle practical tips and tricks

When you've completed your Microsoft Excel training, you'll know how to use all the time-saving tips, tricks and troubleshooting techniques that help you get up and running on Excel right away.

This package consists of 129 lessons on 4 discs.

Video Demo

Watch the demo on YouTube: https://youtu.be/TjaIyWxBQ4o

Product Information

Instructor: James Kittell
Format: Color, Widescreen, NTSC, HD
Language: English and ASL
Aspect Ratio: 16:9
Number of Discs: 4
Number of Lessons: 129
Studio: ASL MEDIA
DVD Release Date: August 28, 2012
Run Time: 253 minutes (4 discs)

Getting Started - 12 minutes

Lesson 1  Start Excel
Lesson 2  Work with Excel’s Ribbon
Lesson 3  Work with Excel’s Galleries
Lesson 4  Customize the Quick Access Toolbar
Lesson 5  Customize the Ribbon
Lesson 6  Work with Smart Tags
Lesson 7  Change the View
Lesson 8  Add Excel to the Taskbar (1)
Lesson 9  Add Excel to the Taskbar (2)
Lesson 10  Quit Excel

Entering and Editing Excel Data - 9 minutes

Lesson 11  Learning the Layout of a Worksheet
Lesson 12  Enter Text into a Cell
Lesson 13  Enter a Number into a Cell
Lesson 14  Enter a Date or Time into a Cell
Lesson 15  Insert a Symbol
Lesson 16  Edit Cell Data
Lesson 17  Delete Data from a Cell

Working with Excel Ranges - 24 minutes

Lesson 18  Select a Range
Lesson 19  Fill a Range with the Same Data
Lesson 20  Fill a Range with a Series of Values
Lesson 21  Move or Copy a Range
Lesson 22  Insert a Row or Column
Lesson 23  Insert a Cell or Range
Lesson 24  Delete Data from a Range
Lesson 25  Delete a Range
Lesson 26  Hide a Row or Column
Lesson 27  Freeze Rows or Columns
Lesson 28  Merge Two or More Cells
Lesson 29  Transpose Rows and Columns

Working with Range Names - 11 minutes

Lesson 30  Define a Range Name
Lesson 31  Use Worksheet Text to Define a Range Name
Lesson 32  Navigate a Workbook Using Range Names
Lesson 33  Change a Range Name
Lesson 34  Delete a Range Name

Formatting Excel Ranges - 25 minutes

Lesson 35  Change the Font and Font Size
Lesson 36  Apply Font Effects
Lesson 37  Change the Font Color
Lesson 38  Align Text Within a Cell
Lesson 39  Center Text Across Multiple Columns
Lesson 40  Rotate Text Within a Cell
Lesson 41  Add a Background Color to a Range
Lesson 42  Apply a Number Format
Lesson 43  Change the Number of Decimal Places Displayed
Lesson 44  Apply an AutoFormat to a Range
Lesson 45  Apply a Conditional Format to a Range
Lesson 46  Apply a Style to a Range
Lesson 47  Change the Column Width
Lesson 48  Change the Row Height
Lesson 49  Wrap Text Within a Cell
Lesson 50  Add Borders to a Range
Lesson 51  Copy Formatting from One Cell to Another

Building Formulas and Functions  - 14 minutes

Lesson 52  Build a Formula
Lesson 53  Add a Function to a Formula
Lesson 54  Add a Row or Column of Numbers
Lesson 55  Build an AutoSum Formula
Lesson 56  Move or Copy a Formula
Lesson 57  Toggle the Formula Bar On and Off

Manipulating Excel Worksheets - 23 minutes

Lesson 58  Navigate a Worksheet
Lesson 59  Rename a Worksheet
Lesson 60  Create a New Worksheet
Lesson 61  Move a Worksheet
Lesson 62  Copy a Worksheet
Lesson 63  Delete a Worksheet
Lesson 64  Change the Gridline Color
Lesson 65  Toggle Worksheet Gridlines On and Off
Lesson 66  Toggle Worksheet Headings On and Off
Lesson 67  Set the Worksheet Tab Color
Lesson 68  Set the Worksheet Background
Lesson 69  Zoom In On or Out of a Worksheet
Lesson 70  Split a Worksheet into Two Panes
Lesson 71  Hide and Unhide a Worksheet

Dealing with Excel Workbooks - 16 minutes

Lesson 72  Create a New Blank Workbook
Lesson 73  Create a New Workbook from a Template
Lesson 74  Save a Workbook
Lesson 75  Open a Workbook
Lesson 76  Arrange Workbook Windows
Lesson 77  Find Text in a Workbook
Lesson 78  Replace Text in a Workbook
Lesson 79  Check Spelling and Grammar
Lesson 80  Close a Workbook

Formatting Excel Workbooks - 5 minutes

Lesson 81  Modify the Workbook Colors
Lesson 82  Set the Workbook Fonts
Lesson 83  Apply a Workbook Theme
Lesson 84  Add a Workbook Header
Lesson 85  Add a Workbook Footer

Printing Excel Workbooks - 20 minutes

Lesson 86  Adjust the Workbook Margins
Lesson 87  Change the Page Orientation
Lesson 88  Insert a Page Break
Lesson 89  Choose a Paper Size
Lesson 90  Set the Print Area
Lesson 91  Configure Titles to Print on Each Page
Lesson 92  Preview the Printout
Lesson 93  Print a Workbook

Analyzing Excel Data - 35 minutes

Lesson 94  Sort a Range
Lesson 95  Filter a Range
Lesson 96  Set Data Validation Rules
Lesson 97  Convert a Range to a Table
Lesson 98  Create a Data Table
Lesson 99  Summarize Data with Subtotals
Lesson 100  Group Related Data
Lesson 101  Analyze Data with Goal Seek

Visualizing Data with Excel Charts - 22 minutes

Lesson 102  Create a Chart
Lesson 103  Add Chart Titles
Lesson 104  Add Data Labels
Lesson 105  Position the Chart Legend
Lesson 106  Display Chart Gridlines
Lesson 107  Display a Data Table
Lesson 108  Change the Chart Layout and Style
Lesson 109  Change the Chart Source Data
Lesson 110  Resize a Chart
Lesson 111  Add a Sparkline to a Cell

Formatting Excel Charts  - 17 minutes

Lesson 112  Format Chart Elements
Lesson 113  Customize a Chart Element Background
Lesson 114  Set a Chart Element’s Outline
Lesson 115  Add Effects to a Chart Element
Lesson 116  Apply a Style to a Chart Element
Lesson 117  Apply a WordArt Style to Chart Text

Adding and Editing Worksheet Graphics - 20 minutes

Lesson 118  Draw a Shape
Lesson 119  Insert a Clip Art Image
Lesson 120  Insert a Photo
Lesson 121  Insert a WordArt Image
Lesson 122  Insert a SmartArt Graphic
Lesson 123  Move or Resize a Graphic
Lesson 124  Crop a Picture
Lesson 125  Format a Picture
Lesson 126  Add a Shadow or Glow to a Picture
Lesson 127  Add a Reflection or 3-D Effect to a Picture
Lesson 128  Add ab Artistic Effect to a Photo
Lesson 129  Recolor an Image