Course at a glance
| Release date | 10/1/2010 | |
| Level | Beginner | |
| Runtime | 3h 1m | |
| Closed captioning | N/A | |
| Transcript | N/A | |
| eBooks / courseware | N/A | |
| Hands-on labs | N/A | |
| Sample code | Included | |
| Exams | Included |
Course description
Microsoft Office Excel 2007 is a spreadsheet program that you use to calculate and present data. It features some significant changes from previous versions of Excel, including the Ribbon, which replaces the menus and toolbars used those earlier versions. We will show you how to use the new Ribbon as you learn to add data to worksheets, create formulas, and format worksheet appearance. With the advanced features of Excel 2007, you can create more powerful formulas, give worksheets a more professional look, and present your data with more impact. We will show you how to work with multiple worksheets, format data with Styles, add page features, and create charts. You will also see how to customize Excel to suit the way you work.
Meet the expert
Stuart Rosen is an instructional designer, writer, and trainer with more than 20 years of experience creating technical, procedural, sales, human relations, and academic training. He has provided training for a wide variety of software applications, including Microsoft Word, Excel, PowerPoint, Access, and Outlook, as well as applications for digital imaging and web design. Stuart has also provided training for numerous custom corporate applications.
Course outline
Module 1
Getting Started with Excel (06:44)
- Introduction (01:01)
- Opening Excel (01:08)
- Ribbon (00:27)
- Quick Access Tool Bar (00:11)
- Tabs (01:41)
- Help Button (01:55)
- Summary (00:17)
Entering Data (12:55)
- Introduction (00:29)
- Terminology (01:40)
- Creating a Worksheet (01:52)
- Auto Correct (00:37)
- Auto Fill (01:39)
- Clearing a Cell (00:15)
- Entering Data (02:59)
- Excel Options (01:05)
- Saving the Document (01:32)
- Summary (00:42)
Creating and Copying Formulas (17:38)
- Introduction (00:31)
- Creating a Formula (02:02)
- Sum Function (01:45)
- Coping a Formula (01:58)
- Auto Sum Button (01:25)
- Formula Auto Correct (01:03)
- Error Checking (02:32)
- Precentage Formula (02:43)
- Cut, Copy, Paste buttons (02:52)
- Summary (00:43)
UsingFormulaOptions (16:39)
- Introduction (00:54)
- Monthly Totals (02:45)
- Average Function (01:46)
- Moving Cells (01:24)
- Coping Cells (00:47)
- Absolute Reference (04:49)
- Auto Recalculation (01:59)
- Formula Auditing (01:34)
- Summary (00:36)
Working with Documents (10:19)
- Introduction (00:32)
- Opening Documents (02:42)
- Switching Documents (01:33)
- Task Bar Buttons (01:15)
- Arrange Windows (01:40)
- Blank Document (01:23)
- Closing Excel (00:53)
- Summary (00:17)
Enhancing the Worksheet (24:25)
- Introduction (00:37)
- Pin Options for Excel (00:41)
- Opening a Recent Document (00:52)
- Inserting Rows (00:49)
- Inserting a Title (03:07)
- Formatting Cells (04:31)
- Auto Fit (01:40)
- Text Alignment (00:25)
- Merging Cells (00:50)
- Indent Feature (00:44)
- Formatting Title (01:40)
- Adding Color (01:26)
- Adding Boarders (02:36)
- Removing Formatting (01:47)
- Undo Changes (00:48)
- Deleting Worksheets (00:47)
- Printing (00:29)
- Summary (00:27)
Module 2
Using Multiple Worksheets (22:31)
- Introduction (00:33)
- Changing Worksheet Names (02:26)
- Add a Worksheet (00:23)
- Move a Worksheet (00:24)
- Copy a Worksheet (04:09)
- Formula Between 2 Worksheets (03:37)
- View 2 Worksheets (02:27)
- Customize Excel (06:26)
- Status Bar (01:37)
- Summary (00:25)
LayingOut and Printing (34:16)
- Introduction (00:30)
- Date Formatting (01:26)
- Widening Columns (01:20)
- Styles (04:17)
- Text Wrapping (01:16)
- Spell Checker (01:05)
- Find and Replace (01:48)
- Moving from Cell to Cell (02:07)
- Splitting the Screen (01:43)
- Freeze Panes (01:10)
- Zoom (01:12)
- Print Preview (01:36)
- Printing (02:55)
- Print Margins (01:46)
- Orientation (01:45)
- Page Breaks (02:02)
- Headers and Footers (03:02)
- Templates (02:25)
- Summary (00:42)
Managing Data (19:59)
- Introduction (00:31)
- Database Table (00:45)
- Sorting (04:41)
- Filter (04:10)
- Hiding Columns (01:23)
- Financial Functions (08:03)
- Summary (00:22)
Using Charts (15:54)
- Introduction (00:30)
- Using Charts (05:18)
- Formatting a Chart (04:53)
- Adding a Shape (02:16)
- Printing a Chart (02:28)
- Summary (00:27)