Intermediate Spreadsheets-Functions and Formulas

**This is an intermediate course, and assumes students have a basic knowledge of and comfortability with spreadsheets. If you student is a beginner, or needs a refresher, please first check out my other course “Spreadsheets For Beginners”. 

For those that want to take spreadsheets to the next level, we will be diving into formulas and functions. Spreadsheets are powerful tools when we employ more than the simple functions and formulas (ie. sum, product, etc.).

Students will have a project to design and apply the concepts taught.

The general schedule will be:

Day 1
-Review of the basics
-Math functions (sum, product, quotient, round, average, and count)
-Combining math functions for complex computations
-Converting from one measure to another

Day 2
-Ranking values- finding the smallest, largest, and values in between
-Dates and times - finding the various parts and using in calculations
-Using dates and times in formulas

Day 3
-Logic formulas- using the IF function and it’s related functions
-Nested IF formulas
-Conditional formatting

Day 4
-Linking data
-Looking up data (various methods)

Day 5
-Creative solutions 
-Project presentations (See Assessment, for more information.)

**I will cover how to do the above tasks in Microsoft Excel, Google Sheets, and Apple Numbers. Depending on the makeup of the class, I will focus of the software(s) that the students are using.