Week 4 Learning Materials

Course Text

Chapter 4

Excel has many features that can help you organize your data and find what you need efficiently. Setting up your data as a table from the onset will allow you to sort, filter, total, and subtotal your data. The chapter explores how to best set up Excel tables, how to edit them, and then how to work with them effectively.

Excel: Tables

In this video, you’ll learn the basics of formatting and modifying tables in Excel 2019, Excel 2016, and Office 365.

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: Tables [Video]. Retrieved from https://youtu.be/iroIA8_3soo?list=PLpQQipWcxwt9kEYnMTd8nBuRxC3LFmera