Spring 2024 In-Person

Professor Albert Wu

Presented 3/30/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 presentation with hands-on demonstrations will walk you through key Microsoft Excel spreadsheet and analysis concepts which will make up a significant portion of Bonus Quizzes 12 and 13. Together, they are worth an entire letter grade of IS101.