Week 5 Learning Materials

Course Text:

Chapter 5

Excel workbooks often contain a large amount of data, and worksheets can quickly become overwhelming. Chapter 6 shows how to set up a workbook to make multi-sheet formulas quick and easy.

Excel 365/2016 – How to Group Worksheets in Excel

Grouping Worksheets in Excel allows you to carry out multiple actions, on multiple sheets.

Excel: Working with Multiple Worksheets

In this video, you’ll learn the basics of working with multiple worksheets 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

Knowledge Market (2019, Feb 12). Excel 365/2016 – how to group worksheets in Excel [Video]. Retrieved from https://youtu.be/3YNr0jqA2nM

GCFLearnFree.org (2016, Feb 8). Excel: working with multiple worksheets [Video]. Retrieved from https://youtu.be/qRShQc-v3LI