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
Binary Decoder Wheel
One of the concepts not well understood by students taking computer literacy classes is the use of binary by computers and the terms bits and bytes. When I teach these courses, I like to use a number of props, and this is one prop that I recently developed to help explain this topic.