TechVideos
  Home     About           Free Videos           FAQ     Contact  
Stay Informed Tell A Friend Bookmark this site
Microsoft Office Excel 2007: Training Videos

Terms of Use
About the presenter

Be patient! It may take 10-30 seconds for the videos to start streaming (playing).


Description Example demonstrated
(Click to view larger image)
1. Microsoft Excel 2007: Working with Formulas (Money)
Play WMV video  or  Play FLV video
In this video, you will learn how to: change the formatting of a cell, sum the numbers in a range, and add data of various currencies. (Running time - 2:51)

Money Calculator

2. Microsoft Excel 2007: Working with Formulas (Payroll)
Play WMV video  or  Play FLV video
In this video, you will learn how to create a simple payroll. Formulas taught include: average (arithmetic mean), min (smallest number), max (largest number), countif (number of cells that meet the criteria), if (condition), multiply, and subtract. (Running time - 12:21)

Payroll




3. Microsoft Excel 2007: Working with Charts
Play WMV video  or  Play FLV video
In this video, you will learn how to create a chart using Microsoft Excel. Skills taught include: adding a title, removing gridlines, adding a legend, changing the scale, and inserting a gradient fill. (Running time - 4:32)

Sales Profit

4. Microsoft Excel 2007: Working With Formulas (Age)
Play WMV video  or  Play FLV video
In this video, you will learn how to create formulas in Microsoft Excel. Formulas taught include: int (number rounded down to an integer), today (current date), average (arithmetic mean), min (smallest number), max (largest number), countif (number of cells that meet the criteria), and if (condition). (Running time - 9:09)

Calculate Age

5. Microsoft Excel 2007: Working With Formulas (Grades)
Play WMV video  or  Play FLV video
In this video, you will learn how to create formulas in Microsoft Excel. Other skills taught include: freezing panes, copying and pasting formulas, modifying borders, inserting the Microsoft Excel forumlas. (Running time - 5:47)

Compute Grades

6. Microsoft Excel 2007: Creating a Grade Spreadsheet
Play WMV video  or  Play FLV video
In this video, you will learn how to create formulas in Microsoft Excel. Formulas taught include: average (arithmetic mean), min (smallest number), max (largest number), and countif (number of cells meeting the criteria). (Running time - 13:41)

Grades

7. Microsoft Excel 2007: Working with Formulas (Monthly Payment)
Play WMV video  or  Play FLV video
In this video, you will learn how to compute monthly payments and count values in a range based on a criteria. Formulas taught include: countif (number of cells meeting the criteria), and pmt (calculates the payment for a loan). (Running time - 4:35)

Monthly payment

8. Microsoft Excel 2007: Extracting Names
Play WMV video  or  Play FLV video
In this video, you will learn how to extract values by integrating Visual Basic with Microsoft Excel. Other skills taught include: showing the developer tab in the ribbon, inserting a command button, changing the design view, changing the caption, using the following Visual Basic commands: left, instr, and mid. (Running time - 10:31)

Extract Names




Powered by Sphider