Week 2 Learning Materials

Course Text

Chapter 2

This chapter reviews several mathematical outputs that you can produce in Excel through the construction of formulas and functions.

Excel: Intro to Formulas

In this video, you’ll get an introduction to using formulas in Excel 2019, Excel 2016, and Office 365. This video includes information on: Mathematical operators; Understanding cell references; Creating formulas; and Copying and editing formulas.

Excel: Creating More Complex Formulas

In this video, you’ll get an introduction to creating complex formulas in Excel 2019, Excel 2016, and Office 365. This video includes information on: The order of operations; Creating complex formulas; and Creating complex formulas using the order of operations

Beginner’s Guide to Excel Functions and Formulas

Learn or review the basic Excel functions that everyone needs to know: SUM, AVERAGE, MAX, MIN, COUNT, and COUNTA.

Sources:

“Beginning Excel.” Adapted by Jeffrey Barry and The American Women’s College from “Beginning Excel” by Noreen Brown, Barbara Lave, Julie Romey, Mary Schatz, Diane Shingledecker. Retrieved from: https://openoregon.pressbooks.pub/beginningexcel/. Licensed under: CC BY 4.0

GCFLearnFree.org (2016, Feb 8). Excel: Intro to formulas [Video]. Retrieved from https://youtu.be/xc14gFFyiTw?list=PLpQQipWcxwt9kEYnMTd8nBuRxC3LFmera

GCFLearnFree.org (2016, Feb 8). Excel: Creating more complex formulas [Video]. Retrieved from https://youtu.be/J-W3thqtDpQ?list=PLpQQipWcxwt9kEYnMTd8nBuRxC3LFmera

Technology for Teachers and Students. (2020, May 11). Beginner’s Guide to Excel Functions and Formulas [Video]. Retrieved from https://youtu.be/7V4xF3zCSoI?list=PL_iwD7O7FG7jzLQIYm6-9Gx3hvXVUG7C5