>

DJ Dates

4Jul/100

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.

Filed under: Excel No Comments
22Jun/100

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

Filed under: Excel No Comments
19Jun/100

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

Filed under: Excel No Comments
17Jun/100

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

Filed under: Excel No Comments
13Jun/100

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

Filed under: Excel No Comments