Spring 2024 In-Person

Professor Albert Wu

Presented 4/6/2024

 

http://FlorenceNightingale.atwebpages.com/Homepage.htm

 

1.

Title Slide

 

 

 

 

 

 

7.

Straight vs. Weighted Average

2.

Order of Precedence

 

 

 

 

 

 

8.

Which Chart Type?

3.

Common Functions

 

 

 

 

 

 

9.

Pie Chart

4.

Absolute vs. Relative Cell Reference

 

 

 

 

 

 

10.

Line Chart

5.

Using the Fill Handle to fill out a Series

 

 

 

 

 

 

11.

Column or Bar Chart

6.

Always double check wizard's assumptions

 

 

 

 

 

 

12.

Other Chart Types & Questions?

 

 

 

This concept is actually a separate walkthrough from this presentation with multiple scenarios. For the sake of slideshow publication, ‘Straight vs. Weighted Average’ is combined with this lecture presentation/walkthrough on ‘Key Excel and Spreadsheet Concepts’. The spreadsheet I used during the ‘Straight vs. Weighted Average’ walkthrough has been published in Canvas. That spreadsheet contains these four scenarios (a) what is the household raise when both spouse received different raises? (b) what is the stock portfolio’s return on investment when each of four stocks in the portfolio have return of investment already calculated, (c) what is the return on investment for a single stock when the quarterly return on investment is already calculated, and (d) how may patients did you see when you have the monthly count of patients you saw.