Week 1 Learning Materials

Course Text:

Chapter 1

This chapter introduces the fundamental skills necessary to get you started in using Excel. You will find that just a few skills can make you very productive in a short period of time.


The Beginner’s Guide to Excel – Excel Basics Tutorial

Beginner’s Guide to Excel for PC

Learn the basics of using Microsoft Excel, including the anatomy of a spreadsheet, how to enter data, how to make your data look good so it’s easier to read and use, and more. This tutorial was made using Excel 2016 for Windows PC, but is applicable to older versions of Excel and newer versions too.

Beginner’s Guide to Excel for Mac

Learn the basics of using Microsoft Excel for Mac, including the anatomy of a spreadsheet, how to enter data, how to make your data look good so it’s easier to read and use, and more.


Microsoft Support Resources – For Reference

Excel for Windows Training

For your reference, this website provided by Microsoft Support has extensive resources of articles, videos, and examples on different Excel techniques and topics. You can find information about Excel for PC and Excel for Mac. This is the current link, but can be easily searched for using “Microsoft Support” in the search field.

Office Cheat Sheets

You can find information about Excel for PC and Excel for Mac. Get up to speed in minutes, quickly refer to things you’ve learned, and master keyboard shortcuts.  Be sure to scroll down the page to find the Excel info


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

Technology for Teachers and Students. (2017, Apr 24.) The beginner’s guide to Excel – Excel basics tutorial [Video.] Retrieved from https://youtu.be/rwbho0CgEAE

Technology for Teachers and Students. (2018, Jul 2.) Beginner’s Guide to Excel for Mac [Video.] Retrieved from https://youtu.be/znqfM4ligew?list=PL_iwD7O7FG7jzLQIYm6-9Gx3hvXVUG7C5

Microsoft.com. (n.d.). Excel for Windows training. Retrieved from https://support.office.com/en-us/article/excel-for-windows-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb?wt.mc_id=otc_home

Microsoft.com. (n.d.). Office cheat sheets. Retrieved from https://support.office.com/en-us/article/office-cheat-sheets-61abfe7b-1c43-483c-b82b-3806d80e027e

License

COM112 – Fundamentals of Spreadsheets Copyright © by The American Women's College. All Rights Reserved.