Detailed item view

The Fastest, Easiest Way to Learn Microsoft Excel 2010!
Professor Teaches courses use real-world settings and accurate simulations to help you apply your new knowledge directly to daily tasks and the knowledge you gain becomes an asset for life.

Chapter 1: Office Workspace Basics
Approximate Time 80 minutes - 77 lessons - 7 Topics

• Basic Window Elements
• Exploring Office Backstage
• Working with the Ribbon
• Customizing the Quick Access Toolbar
• Working with KeyTips
• Using the Status Bar
• Getting Help

Chapter 2: Introduction to Excel
Approximate Time 70 minutes - 66 Lessons - 9 Topics

•  What is Excel?
• Getting to Know the Excel Window
• Moving the Cell Selector
• Opening a Workbook
• Navigating a Workbook
• Selecting Cells
• Creating Workbooks
• Saving a Workbook
• Closing a Workbook

Chapter 3: Entering and Editing Data
Approximate Time 70 minutes - 72 Lessons - 7 Topics

•  Entering Text, Numbers, and Dates
• Editing Data
• Using AutoComplete and Auto Fill
• Copying Data
• Moving and Clearing Data
• Using Undo and Redo
• Finding and Replacing Data

Chapter 4: Introduction to Formulas and Functions
Approximate Time 60 minutes - 63 Lessons - 6 Topics

• What are Formulas and Functions?
• Entering Formulas
• Entering Functions
• Using the Insert Function Tool
• Using AutoSum
• Copying and Moving Formulas

Chapter 5: Working with Functions
Approximate Time 70 minutes - 66 Lessons - 7 Topics

• Using Statistical Functions
• Using Financial Functions
• Testing Conditions with IF
• Using Date and Time Functions
• Using Linked Values in Formulas
• Copying Formula Values
• Controlling Automatic Calculations

Chapter 6: Formatting Data
Approximate Time 70 minutes - 69 Lessons - 8 Topics

• Introduction to Formatting
• Applying Number Formats
• Applying Font Formats
• Changing Cell Alignment
• Applying Cell Styles
• Copying Formats
• Clearing Formats
• Finding and Replacing Formats

Chapter 7: Formatting Worksheets
Approximate Time 70 minutes - 70 Lessons - 8 Topics

• Inserting and Deleting Rows and Columns
• Inserting and Deleting Cells
• Adjusting Column and Row Sizes
• Hiding Worksheet Components
• Inserting and Deleting Worksheets
• Copying and Moving Worksheets
• Customizing Sheet Tabs
• Adding a Worksheet Background

Chapter 8: Adding Charts and Graphics
Approximate Time 70 minutes - 70 Lessons - 7 Topics

• Creating a Chart
• Enhancing a Chart
• Modifying Chart Data
• Changing Chart Types
• Drawing Shapes
• Inserting Pictures
• Creating SmartArt

Chapter 9: Viewing and Printing Workbooks
Approximate Time 80 minutes - 73 Lessons - 7 Topics

• Changing View Options
• Splitting and Freezing a Worksheet
• Sorting and Filtering Data
• Customizing the Page Layout
• Adding Headers and Footers
• Modifying Page Breaks
• Previewing and Printing the Worksheet

Chapter 10: Managing Workbooks
Approximate Time 70 minutes - 72 Lessons - 7 Topics

• Arranging Multiple Workbooks
• Adding Hyperlinks
• Working with Comments
• Saving Workbooks in Different Formats
• Saving a Workbook as a Web Page
• Creating Folders
• E-Mailing a Workbook

OPERATING SYSTEM Windows™ 7/Vista/XP/2000

SYSTEM REQUIREMENTS Pentium™ PC or Higher 150 MB Hard Disk Space per application Sound Card CD-ROM Drive 1024 x 768 16 Bit colour display or higher Speakers or Headphones