
Microsoft Excel 2007
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.
Course content
Introduction to Excel 20079 lessons
- Welcome to Excel 20072:26Free
- Overview of Spreadsheets and Excel 20071:47Free
- Overview of Course3:18Free
- New in Excel 2007 pt. 15:51Free
- New in Excel 2007 pt. 24:56Free
- Understanding the Excel 2007 Workspace4:34Free
- Introducing the New Excel 2007 Ribbon6:21Free
- Using the Quick Access Toolbar3:58Free
- Compatibility with Earlier Versions5:32Free
Installing Excel 20072 lessons
Microsoft Excel 2007 He|p4 lessons
Working with Worksheets and Workbooks11 lessons
- Launching Excel3:291 credit or ad
- Planning a Project2:591 credit or ad
- Creating a New Workbook5:181 credit or ad
- Adding and Deleting Data4:581 credit or ad
- Importing Data into Excel6:301 credit or ad
- Naming and Saving a Workbook3:311 credit or ad
- Managing Multiple Worksheets6:041 credit or ad
- Printing a Worksheet pt. 12:221 credit or ad
- Printing a Worksheet pt. 26:371 credit or ad
- Opening and Closing a Workbook3:421 credit or ad
- Renaming and Deleting a Workbook2:491 credit or ad
Editing Techniques12 lessons
- Selecting Cells / Rows / Columns3:471 credit or ad
- Cut / Copy / Paste6:101 credit or ad
- Copy and Paste Special3:291 credit or ad
- Editing or Replacing Content in a Cell4:131 credit or ad
- Undo / Redo / Repeat Edits5:571 credit or ad
- Adjusting Row Height5:071 credit or ad
- Adjusting Column Width2:551 credit or ad
- Inserting and Deleting Rows / Columns / Cells5:551 credit or ad
- Merging and Splitting Cells3:481 credit or ad
- Clearing a Cell2:391 credit or ad
- Finding and Replacing Data5:071 credit or ad
- Using AutoFill5:121 credit or ad
Customizing Excel 20079 lessons
- Customizing the Excel Workspace3:591 credit or ad
- Splitting the Screen6:291 credit or ad
- Freezing and Locking Cells4:351 credit or ad
- Hiding and Showing Rows / Columns / Sheets4:351 credit or ad
- Using Different Views4:411 credit or ad
- Arranging Multiple Workbooks4:411 credit or ad
- Displaying Gridlines and Headings4:231 credit or ad
- Setting a Trusted Location3:511 credit or ad
- Using Excel Options3:451 credit or ad
Changing the Appearance of a Worksheet15 lessons
- Formatting Options in the Ribbon2:571 credit or ad
- Formatting Text6:181 credit or ad
- Formatting Numbers4:021 credit or ad
- Adding Borders5:261 credit or ad
- Adding Fill Colors and Patterns5:091 credit or ad
- Using the Format Painter5:021 credit or ad
- Using Cell Styles3:201 credit or ad
- Using Document Themes4:041 credit or ad
- Using Wrap Text2:151 credit or ad
- AutoCorrect3:481 credit or ad
- Setting Page Layout Options4:201 credit or ad
- Adding Headers and Footers4:591 credit or ad
- Setting Page Breaks5:491 credit or ad
- Using Templates3:581 credit or ad
- Using Conditional Formatting4:281 credit or ad
Working with Formulas15 lessons
- Using Formulas4:031 credit or ad
- Formula Writing Made Easy5:121 credit or ad
- Creating Simple Formulas2:201 credit or ad
- Order of Operations3:361 credit or ad
- Creating Formulas with Operators and Cell References5:211 credit or ad
- Understanding Cell References3:211 credit or ad
- Calculating Totals with AutoSum7:031 credit or ad
- Common Functions6:431 credit or ad
- Creating Formulas with Functions7:141 credit or ad
- Creating Formulas with Nested Functions7:091 credit or ad
- Creating and Managing Names6:501 credit or ad
- Creating Formulas with Names2:491 credit or ad
- Displaying and Printing Formulas2:151 credit or ad
- Error Checking5:191 credit or ad
- Common Errors When Creating Formulas2:471 credit or ad
Managing Data12 lessons
- Overview of Excel Data Handling Tools1:091 credit or ad
- Creating an Excel Table5:251 credit or ad
- Sorting an Excel Table2:321 credit or ad
- Filtering an Excel Table3:151 credit or ad
- Formatting Excel Table Data2:271 credit or ad
- Working with Excel Table Rows and Columns5:481 credit or ad
- Displaying and Calculating Table Data Totals3:261 credit or ad
- Using Structured References2:311 credit or ad
- Validating Data7:041 credit or ad
- Linking Data Between Worksheets5:191 credit or ad
- Linking Data Between Multiple Workbooks6:241 credit or ad
- Exporting Data4:591 credit or ad
Charts and Graphics14 lessons
- Overview of Charts and Excel2:141 credit or ad
- Understanding Chart Types2:561 credit or ad
- Creating a Chart6:061 credit or ad
- Changing the Chart Type of an Existing Chart3:551 credit or ad
- Moving and Deleting a Chart2:561 credit or ad
- Changing the Charted Data6:041 credit or ad
- Editing Charts4:201 credit or ad
- Formatting a Chart - Design Tab4:161 credit or ad
- Formatting a Chart - Layout Tab7:031 credit or ad
- Formatting a Chart - Format Tab4:451 credit or ad
- Creating a Chart Template3:021 credit or ad
- Applying a Chart Template2:151 credit or ad
- Importing Graphics into Excel7:061 credit or ad
- Modifying Imported Images5:021 credit or ad
Excel 2007 Plays Well with Others11 lessons
- Overview of Sharing and Collaborating1:481 credit or ad
- Excel and Other Office Applications7:181 credit or ad
- Using the Office Clipboard3:401 credit or ad
- Creating PDF Files2:531 credit or ad
- Opening and Saving Files in Other Formats3:081 credit or ad
- Excel and Databases2:341 credit or ad
- Using Queries4:121 credit or ad
- Using with a Document Management Server2:211 credit or ad
- Publishing an Excel Worksheet1:061 credit or ad
- Excel XML Files2:581 credit or ad
- Wrap Up1:501 credit or ad