| CE EN 270 - Virtual Lecture | |
| Norm Jones | Brigham Young University |
| Introduction to Excel | |
Instructions: Click on each of the links below, in order. You will need a Shockwave-enabled browser in order to view the lectures. As you view the lecture, use the controls at the bottom of the image to pause, stop, fast-forward, and rewind the lecture. These lectures contain audio. If you are viewing the lectures in a CAEDM lab, you will need to use a set of headphones to avoid disturbing your fellow students. |
|
Sections
|
Description |
| Intro | Introduction to Excel. Building a simple spreadsheet to compute the area and circumference of a circle. Introduction to formulas and relative vs. absolute addresses. |
| Introduction to basic formatting options using a grading spreadsheet. | |
| Formulas-a | Entering formulas to compute the total grades. More on relative and absolute addresses. |
| Formulas-b | Entering formulas to compute the min, max, average scores. Using Excel functions. |
| Sorting | Sorting data in a table using different sort keys. |
| Conditional Formatting | Using conditional formatting to highlight selected cells automatically. |