Class Info

Account Setup

Modules

  1. Email & Digital Communication
  2. Excel - Part 1
  3. Excel - Part 2
  4. Digital Skills
  5. Excel - Digging Deeper
  6. Make a Website
  7. Job Hunting in the Digital Age
  8. Microsoft Word
  9. Online Document Storage & Collaboration
  10. Microsoft PowerPoint
  11. What is a Computer Anyway?

Activities

Quizzes

Projects

Additional Resources

Microsoft Excel - Part 1

Outcomes

  • You will know how open and save workbooks.
  • You will know how to use cells, columns, and rows.
  • You will know how to properly format and print spreadsheets.
  • You will be introduced to formulas.
  • You will learn the difference between relative and absolute references.
  • You will be introduced to functions.

Lessons

Excel Basics

Excel is the spreadsheet application in Microsoft's Office. This tutorial will show you how to use the powerful tools in Excel for organizing, visualizing, and calculating your data.

NOTE:

The following lessons are designed around Excel 2013 but there are only minor differences to earlier versions of Excel. Almost all of the major functionality is the same. Ask your instructor for help if you encounter any issues or cannot find something in your version.

Getting Started with Excel

Begin by watching the video below. Once you are done with the video you can use the links below it to dive deeper. You may also jump straight to the activity. If there isn't one you can move on to the next subtopic.

Creating and Opening Workbooks

Begin by watching the video below. Once you are done with the video you can use the links below it to dive deeper. You may also jump straight to the activity. If there isn't one you can move on to the next subtopic.

ACTIVITY:
  1. Open Microsoft Excel and start with a blank workbook.
  2. Play around with some of the menus, toolbars, and the ribbon to get used to where things are located.
  3. Open up a new workbook using a template of your choice. Think about what you could best use your template for.
  4. Close Excel. You do not need to save any of these workbooks.

Saving and Sharing Workbooks

Begin by watching the video below. Once you are done with the video you can use the links below it to dive deeper. You may also jump straight to the activity. If there isn't one you can move on to the next subtopic.

Cell Basics

Begin by watching the video below. Once you are done with the video you can use the links below it to dive deeper. You may also jump straight to the activity. If there isn't one you can move on to the next subtopic.

Modifying Columns, Rows, & Cells

Begin by watching the video below. Once you are done with the video you can use the links below it to dive deeper. You may also jump straight to the activity. If there isn't one you can move on to the next subtopic.

ACTIVITY:
  1. Download and open this practice worksheet.
  2. Modify the width of the columns with First Name and Last Name in them so that the names and the header title all fit.
  3. Add a column between column A and column B. Add the header "Middle Name" to the newly created B2.
  4. Wrap the text in column D that contains Street Address.
  5. Merge and center the cells A1:E1 so that the the title is centered over the information.
  6. Save the file to your desktop and rename the file with the following convention: Year-Month-Day - Your Name - Modifying (Ex: "2014-09-16 - Kyle Brazil - Modifying"). You will email all of the assignments in to your instructor together at the end of this module.
NOTE:

If you do not complete this module during one class session you can always email the activity attachments to yourself until you're ready to send them to your instructor.

Formatting Cells

Begin by watching the video below. Once you are done with the video you can use the links below it to dive deeper. You may also jump straight to the activity. If there isn't one you can move on to the next subtopic.

ACTIVITY:
  1. Download and open this practice worksheet.
  2. Change the text in cell A3 to:
    • Font: Tahoma
    • Font Size: 20
    • Font Color: Green
  3. Bold the text in cells A4:H4.
  4. Align cells A4:H4 both vertically and horizontally.
  5. Add all boarders to all the cells underneath A4:G4.
  6. Change the fill color of cells A4:H4 to light gray.
  7. Format the cells in D4:H4 to long date then resize the columns to make sure the text fits.
  8. Once you're done save the file to your desktop and rename the file with the following convention: Year-Month-Day - Your Name - Formatting (Ex: "2014-09-16 - Kyle Brazil - Formatting").
NOTE:

If you do not complete this module during one class session you can always email the activity attachments to yourself until you're ready to send them to your instructor.

Worksheet Basics

Begin by watching the video below. Once you are done with the video you can use the links below it to dive deeper. You may also jump straight to the activity. If there isn't one you can move on to the next subtopic.

Page Layout

Begin by watching the video below. Once you are done with the video you can use the links below it to dive deeper. You may also jump straight to the activity. If there isn't one you can move on to the next subtopic.

ACTIVITY:
  1. Download and open this practice worksheet.
  2. Change the page orientation to landscape.
  3. Use print titles to make row 1 of the Schedule worksheet appear at the top of every page.
  4. Insert a page break between rows 19 and 20.
  5. One the Page Layout view, insert a header and footer.
  6. Once you're done save the file to your desktop and rename the file with the following convention: Year-Month-Day - Your Name - Page Layout (Ex: "2014-09-16 - Kyle Brazil - Page Layout").
NOTE:

If you do not complete this module during one class session you can always email the activity attachments to yourself until you're ready to send them to your instructor.

Printing Workbooks

Begin by watching the video below. Once you are done with the video you can use the links below it to dive deeper. You may also jump straight to the activity. If there isn't one you can move on to the next subtopic.


Formulas and Functions

Simple Formulas

Begin by watching the video below. Once you are done with the video you can use the links below it to dive deeper. You may also jump straight to the activity. If there isn't one you can move on to the next subtopic.

ACTIVITY:

Alight, let's practice a bit of what we've learned this far.

  1. Download and open this practice worksheet.
  2. In cell B4 sum the June and July budget.
  3. Once that is done, change the amount of both the June and July budgets. Notice how the total you calculated in B4 also changes.
  4. Now let's calculate the Total Cost of all of the items in the order. In cell G5 multiply the Quanity by the Price Per Unit for the napkins.
  5. Copy and paste that same formula into cells G6 and G7.
  6. Lastly, let's calculate the Total of all of the items. In cell G8 sum all of the amounts in the Total Cost column.
  7. We're almost done but something doesn't look quite right for the Total Remaining amount in B9. Change the formula in that cell so that B8 is subtracted from B7 instead of divided.
  8. Great. Everything is looking good. We know the Total Budget, the Total of all of the items in our order plus the Total Remaining from our budget.
  9. Save the file to your desktop and rename the file with the following convention: Year-Month-Day - Your Name - Simple Formulas (Ex: "2014-09-16 - Kyle Brazil - Simple Formulas"). You will email all of the assignments in to your instructor together at the end of this module.
NOTE:

If you do not complete this module during one class session you can always email the activity attachments to yourself until you're ready to send them to your instructor.

Complex Formulas

Begin by watching the video below. Once you are done with the video you can use the links below it to dive deeper. You may also jump straight to the activity. If there isn't one you can move on to the next subtopic.

ACTIVITY:
  1. Download and open this practice worksheet.
  2. In cell D6 create a complex formula that first sums the Total of all of the menu items and then multiply it by San Francisco's sales tax rate of 8.75%.
  3. Great. Now that we know the sales tax we can figure out what the entire Total will be. In cell D7 create a formula that sums the Total of all of the menu items plus the Tax amount.
  4. Perfect. Our catering invoice is now complete.
  5. Save the file to your desktop and rename the file with the following convention: Year-Month-Day - Your Name - Complex Formulas (Ex: "2014-09-16 - Kyle Brazil - Complex Formulas").
NOTE:

If you do not complete this module during one class session you can always email the activity attachments to yourself until you're ready to send them to your instructor.

Relative and Absolute Cell References

Begin by watching the video below. Once you are done with the video you can use the links below it to dive deeper. You may also jump straight to the activity. If there isn't one you can move on to the next subtopic.

ACTIVITY:
  1. Download and open this practice worksheet.
  2. Using the fill handle, copy and paste the formula in E4 all the way down to E14. If you look at the formula in those cells you will notice that they relatively reference the cells to their left to calculate the Total.
  3. Using the fill handle, copy and paste the formula in D4 all the way down to D14. Notice how that does not work an lots of errors are thrown. That is because we need to absolutely reference the Tax percentage.
  4. Under the copy and paste that you just did then change the formula in D4 to absolutely reference cell E2.
  5. Again, copy and past the formula in D4 all the way down to D14. The correct Sales Tax amount and Total should now be calculated.
  6. Lastly, go to the Catering Invoice sheet. In cell B3 reference the Total in cell E15 on the Menu Order sheet.
  7. Once everyting looks good, save the file to your desktop and rename the file with the following convention: Year-Month-Day - Your Name - Cell References (Ex: "2014-09-16 - Kyle Brazil - Cell References").
NOTE:

If you do not complete this module during one class session you can always email the activity attachments to yourself until you're ready to send them to your instructor.

Functions

Begin by watching the video below. Once you are done with the video you can use the links below it to dive deeper. You may also jump straight to the activity. If there isn't one you can move on to the next subtopic.

ACTIVITY:
  1. Download and open this practice worksheet.
  2. In cell B16 use the SUM function to calculate the Quantity of Items Ordered.
  3. In cell B23 use the MAX function to figure out the most expensive Price Per Unit by using the cell range C3:C15.
  4. In cell B24 calculate the average Delivery Time for each order. (Hint: Use the AVERAGE function.
  5. Once everyting looks good, save the file to your desktop and rename the file with the following convention: Year-Month-Day - Your Name - Functions (Ex: "2014-09-16 - Kyle Brazil - Functions").
ACTIVITY:

This is the last activity in the module so now it's time to submit your work.

  1. Attach all of the activities from this module that you saved to your desktop to an email to your instructors.
    • Subject: "Excel Activities - Part 1"
    • Write a short note explaining what is attached.
    • Tell us what was your favorite thing that you learned. If nothing, let us know what you'd rather learn about in Excel.
    • Sign your name.
  2. Once sent, make sure that you delete all of the files off of the desktop and then empty the recycle bin.

Project

No project yet but check back soon.