United States Microsoft Excel 2007 Training
CD Contents For This Title
All the chapters and lesson contents of Microsoft Excel 2007 are listed below.
To help you evaluate our training, we have made some of the tutorials for Microsoft Excel 2007 freely available. Click on any of the linked lesson listings below to preview FREE!
Though Microsoft Excel has been around for many years, Excel 2007 has an entirely new look and feel. Many new features have been added to improve productivity and workflow. In this in-depth VTC course, VTC Author Cheryl Brumbaugh-Duncan explores using Excel to create, manage, and analyze spreadsheet data. Users will learn to develop all the necessary worksheets and workbooks for financial and informational data, for a company that distributes healthy snacks to companies throughout a city. The course steps the participant through the various topics and skills needed to master Excel 2007 and provides a fun project for applying the new knowledge. Work Files are included. To get started learning Microsoft Excel 2007, click on one of the movie links below.
Choose your media type:
To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality.Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.
Hide This|
Introduction to Excel 2007
|
||
| Welcome to Excel 2007 | (02:26) | |
| Overview of Spreadsheets and Excel 2007 | (01:47) | |
| Overview of Course | (03:18) | |
| New in Excel 2007 pt. 1 | (05:51) | |
| New in Excel 2007 pt. 2 | (04:56) | |
| Understanding the Excel 2007 Workspace | (04:34) | |
| Introducing the New Excel 2007 Ribbon | (06:21) | |
| Using the Quick Access Toolbar | (03:58) | |
| Compatibility with Earlier Versions | (05:32) | |
|
Installing Excel 2007
|
||
| Considerations Before You Install | (02:10) | |
| Installing Excel | (03:14) | |
|
Microsoft Excel 2007 He|p
|
||
| Accessing Microsoft Excel 2007 He|p | (00:42) | |
| Using Excel 2007 He|p | (03:45) | |
| Using Microsoft Office On-line | (02:07) | |
| Accessing the Support Knowledge Base | (01:48) | |
|
Working with Worksheets and Workbooks
|
||
| Launching Excel | (03:29) | |
| Planning a Project | (02:59) | |
| Creating a New Workbook | (05:18) | |
| Adding and Deleting Data | (04:58) | |
| Importing Data into Excel | (06:30) | |
| Naming and Saving a Workbook | (03:31) | |
| Managing Multiple Worksheets | (06:04) | |
| Printing a Worksheet pt. 1 | (02:22) | |
| Printing a Worksheet pt. 2 | (06:37) | |
| Opening and Closing a Workbook | (03:42) | |
| Renaming and Deleting a Workbook | (02:49) | |
|
Editing Techniques
|
||
| Selecting Cells / Rows / Columns | (03:47) | |
| Cut / Copy / Paste | (06:10) | |
| Copy and Paste Special | (03:29) | |
| Editing or Replacing Content in a Cell | (04:13) | |
| Undo / Redo / Repeat Edits | (05:57) | |
| Adjusting Row Height | (05:07) | |
| Adjusting Column Width | (02:55) | |
| Inserting and Deleting Rows / Columns / Cells | (05:55) | |
| Merging and Splitting Cells | (03:48) | |
| Clearing a Cell | (02:39) | |
| Finding and Replacing Data | (05:07) | |
| Using AutoFill | (05:12) | |
|
Customizing Excel 2007
|
||
| Customizing the Excel Workspace | (03:59) | |
| Splitting the Screen | (06:29) | |
| Freezing and Locking Cells | (04:35) | |
| Hiding and Showing Rows / Columns / Sheets | (04:35) | |
| Using Different Views | (04:41) | |
| Arranging Multiple Workbooks | (04:41) | |
| Displaying Gridlines and Headings | (04:23) | |
| Setting a Trusted Location | (03:51) | |
| Using Excel Options | (03:45) | |
|
Changing the Appearance of a Worksheet
|
||
| Formatting Options in the Ribbon | (02:57) | |
| Formatting Text | (06:18) | |
| Formatting Numbers | (04:02) | |
| Adding Borders | (05:26) | |
| Adding Fill Colors and Patterns | (05:09) | |
| Using the Format Painter | (05:02) | |
| Using Cell Styles | (03:20) | |
| Using Document Themes | (04:04) | |
| Using Wrap Text | (02:15) | |
| AutoCorrect | (03:48) | |
| Setting Page Layout Options | (04:20) | |
| Adding Headers and Footers | (04:59) | |
| Setting Page Breaks | (05:49) | |
| Using Templates | (03:58) | |
| Using Conditional Formatting | (04:28) | |
|
Working with Formulas
|
||
| Using Formulas | (04:03) | |
| Formula Writing Made Easy | (05:12) | |
| Creating Simple Formulas | (02:20) | |
| Order of Operations | (03:36) | |
| Creating Formulas with Operators and Cell References | (05:21) | |
| Understanding Cell References | (03:21) | |
| Calculating Totals with AutoSum | (07:03) | |
| Common Functions | (06:43) | |
| Creating Formulas with Functions | (07:14) | |
| Creating Formulas with Nested Functions | (07:09) | |
| Creating and Managing Names | (06:50) | |
| Creating Formulas with Names | (02:49) | |
| Displaying and Printing Formulas | (02:15) | |
| Error Checking | (05:19) | |
| Common Errors When Creating Formulas | (02:47) | |
|
Managing Data
|
||
| Overview of Excel Data Handling Tools | (01:09) | |
| Creating an Excel Table | (05:25) | |
| Sorting an Excel Table | (02:32) | |
| Filtering an Excel Table | (03:15) | |
| Formatting Excel Table Data | (02:27) | |
| Working with Excel Table Rows and Columns | (05:48) | |
| Displaying and Calculating Table Data Totals | (03:26) | |
| Using Structured References | (02:31) | |
| Validating Data | (07:04) | |
| Linking Data Between Worksheets | (05:19) | |
| Linking Data Between Multiple Workbooks | (06:24) | |
| Exporting Data | (04:59) | |
|
Charts and Graphics
|
||
| Overview of Charts and Excel | (02:14) | |
| Understanding Chart Types | (02:56) | |
| Creating a Chart | (06:06) | |
| Changing the Chart Type of an Existing Chart | (03:55) | |
| Moving and Deleting a Chart | (02:56) | |
| Changing the Charted Data | (06:04) | |
| Editing Charts | (04:20) | |
| Formatting a Chart - Design Tab | (04:16) | |
| Formatting a Chart - Layout Tab | (07:03) | |
| Formatting a Chart - Format Tab | (04:45) | |
| Creating a Chart Template | (03:02) | |
| Applying a Chart Template | (02:15) | |
| Importing Graphics into Excel | (07:06) | |
| Modifying Imported Images | (05:02) | |
|
Excel 2007 Plays Well with Others
|
||
| Overview of Sharing and Collaborating | (01:48) | |
| Excel and Other Office Applications | (07:18) | |
| Using the Office Clipboard | (03:40) | |
| Creating PDF Files | (02:53) | |
| Opening and Saving Files in Other Formats | (03:08) | |
| Excel and Databases | (02:34) | |
| Using Queries | (04:12) | |
| Using with a Document Management Server | (02:21) | |
| Publishing an Excel Worksheet | (01:06) | |
| Excel XML Files | (02:58) | |
| Wrap Up | (01:50) | |
|
Credits
|
||
| About This Author | (02:41) | |
Email this Page
Send us FeedbackTitle Information / Pricing
| Title: | Microsoft Excel 2007 |
| Author: | Cheryl Brumbaugh Duncan |
| SKU: | 33810 |
| ISBN: | 1-934743-21-6 |
| Release Date: | 2007-10-30 |
| Price: | |
| Duration: | 8 hrs / 115 lessons |
| Work Files: |
Yes |
| Captions: | For Online University members only |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7 |
Online University Access all our Training for only 30
The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)
SIGNUP NOW
LEARN MORE » Related Titles
Select Bandwidth
Now Shipping
Client Testimonials
Geoff Blake performed superbly on introducing Acrobat forms: clear, well-organized and instructive on the basics of the process. Bravo! I would...
Brad B.