|
|
|
|
|
|
|
|
|
|
| Description | Example demonstrated (Click to view larger image) |
|
|
1. Microsoft Excel 2007: Working with Formulas (Money) Play 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) |
|
|
|
2. Microsoft Excel 2007: Working with Formulas (Payroll) Play 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) |
|
|
|
|
||
|
3. Microsoft Excel 2007: Working with Charts Play 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) |
|
|
|
4. Microsoft Excel 2007: Working With Formulas (Age) Play 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) |
|
|
|
5. Microsoft Excel 2007: Working With Formulas (Grades) Play 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) |
|
|
|
Please help support this website |
||
|
6. Microsoft Excel 2007: Creating a Grade Spreadsheet Play 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) |
|
|
|
7. Microsoft Excel 2007: Working with Formulas (Monthly Payment) Play 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) |
|
|
|
8. Microsoft Excel 2007: Extracting Names Play 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) |
|
|