by Pam Conway | Released October 2012 | ISBN: 00010CWORKS

This class teaches the basic functions and features of Excel 2007. After an introduction to spreadsheet terminology and Excel's window components, students will learn how to use the Help system and navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks in various formats. Students will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, and printing. Finally, students will create and modify charts, and learn how to manage large workbooks. Show and hide more

1. Introduction
   • Introduction 00:01:10
2. Getting Started
   • Understanding the Three Primary Functions of Excel 00:01:45
   • Understanding Spreadsheet Terminology 00:03:23
   • Launching Excel 00:01:20
   • Exploring the Excel Interface 00:03:57
   • Opening a Workbook 00:01:42
   • Examining Formulas 00:01:08
   • Understanding Worksheets 00:01:35
   • Using Zoom 00:01:27
   • Changing Views 00:01:40
   • Navigating Spreadsheets 00:04:20
3. Basic Worksheet Skills
   • Creating a New Workbook 00:02:18
   • Entering Data 00:05:26
   • Selecting Parts of a Workbook 00:01:21
   • Using Multiple Worksheets 00:02:20
   • Using AutoFill 00:09:27
   • Deleting Ranges 00:03:53
   • Using Undo/Redo 00:01:25
   • Deleting a Worksheet 00:00:58
   • Saving a Workbook 00:04:36
4. Creating Formulas
   • Understanding Order of Operations 00:02:22
   • Entering Simple Formulas 00:02:22
   • Using SUM, MAX, and MIN 00:08:38
   • Using AutoSum 00:03:10
   • Using AVERAGE 00:03:07
   • Creating a Formula 00:03:53
   • Working with Date Arithmetic 00:02:46
   • Using AutoCalculate 00:02:11
   • Relative vs. Absolute Cell Adressing 00:04:45
5. Formatting the Worksheet
   • Adjusting Column Width and Row Height 00:05:57
   • Inserting and Deleting Rows and Columns 00:02:15
   • Hiding Rows and Columns 00:01:58
   • Changing Number Formatting 00:04:03
   • Changing Character Formatting 00:03:03
   • Aligning Data 00:05:59
   • Adding Borders and Shading 00:06:00
   • Using Format Painter 00:05:31
   • Using Cell Styles 00:03:19
   • Using Themes 00:01:36
6. Working with Large Worksheets
   • Using Zoom 00:02:17
   • Freezing and Unfreezing Panes 00:03:41
   • Splitting a Window 00:03:13
   • Tiling Multiple Workbooks 00:03:56
   • Using Synchronous Scrolling 00:03:22
7. Using Protection and Comment Boxes
   • Adding and Deleting Comments 00:04:54
   • Locking and Unlocking Cell Ranges 00:08:34
8. Using Page Setup and Printing
   • Using Spell Check 00:03:55
   • Inserting Page Breaks 00:02:37
   • Using Page Break Preview 00:01:40
   • Using Print Preview 00:02:23
   • Changing the Orientation and Margins 00:02:45
   • Working With Print Areas 00:02:19
   • Setting Print Titles 00:01:58
   • Adding Headers and Footers 00:02:56
   • Printing Gridlines and Comments 00:00:58
   • Using the Print Dialog Box 00:01:28
9. Conclusion
   • Conclusion 00:01:19
Show and hide more