DJ Dates

Excel 2007 Tutorial 4.1. Pie, Column, and Line Charts

In this video, Excel 2007 Tutorial 4.1. Pie, Column, and Line Charts

• Pie Charts
  • Data Labels & Leader Lines
  • Chart Titles & Styles
• Column Charts
  • Clustered vs. Stacked Charts
• Line Charts
  • Select Data
  • Format Axis
  • Insert Shapes

You can work along with this file:
charts.xls

The data in this video was sourced from Netcraft.com and Wikipedia.org.

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