DJ Dates

Excel 2007 Tutorial 3.2. Absolute and Mixed Cell References

In this video, Excel 2007 Tutorial 3.2. Absolute and Mixed Cell References

• Relative Cell References
• Absolute Cell References
• Mixed Cell References

Work along with this file:

references.xls

Excel 2007 Tutorial 3.1. Using Functions

In this video, Excel 2007 Tutorial 3.1. Using Functions

• Autosum Icon
• Sum, Average, Count, Max, Min
• Abs, Now Functions
• Insert Function Icon
• Pmt Function
• Order of Operations
• Using Functions inside Functions

Excel 2007 Tutorial 2.1. Formatting Spreadsheets

In this video, Excel 2007 Tutorial 2.1. Formatting Spreadsheets:

• Text vs. Numbers
• Currency vs. Accounting Format
• Resizing and Merging Cells
• Conditional Formatting
• Clear Formatting

File used in this video: textbooks.xls

Excel 2007 Tutorial 1.1. Calculating your GPA

In this video, Excel 2007 Tutorial 1.1. Calculating your GPA:

• Introduction to Excel
• Formulas
• Functions
• Copy and Pasting Formulas
• Fill Handle
• Manipulating Worksheets

File used in this video: gpa.xls