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?

 

 

 

The first five are the most commonly used functions in Microsoft Excel. The sixth is the most profound as it is allows decision making and appears in computer programming languages old and new. There are a plethora of functions available in Microsoft Excel, but I would say a typical user of Excel would have most of his/her needs met with these six functions.