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

Excel - Digging Deeper

Outcomes

  • You will become more familiar with using Excel formulas.
  • You will practice solving real world problems with Excel.
  • You will build an advanced order invoice.

Lessons

Solving Real World Problems

Formula Refresher

Before we jump into practice exercises lets do a bit of a refresher on formulas. Click the button below to start the interactive exercise. Once you are done return back to this page to begin the practice activities.

Over-Budget Items

ACTIVITY:
  1. Download and open this practice worksheet.
  2. Follow these step by step instructions to determine which expenses are over-budget.
  3. Once everyting looks good, save the file to your desktop and rename the file with the following convention: Year-Month-Day - Your Name - Over Budget (Ex: "2014-09-16 - Kyle Brazil - Over Budget").

Percent-Off Sale

ACTIVITY:
  1. Download and open this practice worksheet.
  2. Follow these step by step instructions to figure out how much we'll save on the bike accessories and what the cost will be after the discount.
  3. Once everyting looks good, save the file to your desktop and rename the file with the following convention: Year-Month-Day - Your Name - Percent Off Sale (Ex: "2014-09-16 - Kyle Brazil - Percent Off Sale").

Basketball Team: Player Statistics

ACTIVITY:
  1. Download and open this practice worksheet.
  2. Follow these step by step instructions to help this mom figure out who scored the most points on her daughter's basketball team.
  3. Once everyting looks good, save the file to your desktop and rename the file with the following convention: Year-Month-Day - Your Name - Player Stats (Ex: "2014-09-16 - Kyle Brazil - Player Stats").

Movie Tickets

ACTIVITY:
  1. Download and open this practice worksheet.
  2. Follow these step by step instructions to determine how much money will be left over after buying four movie tickets.
  3. Once everyting looks good, save the file to your desktop and rename the file with the following convention: Year-Month-Day - Your Name - Movie Tickets (Ex: "2014-09-16 - Kyle Brazil - Movie Tickets").

Pizza Party Picnic

Let's help this company figure out how many pizzas they will need for their upcoming pizza party. Click the button below to being the interactive exercise. Once you are done return to this page and continue on to the next lesson.

Birthday Budget Blues

Since you did such a good job with the pizza party you've been enlisted to help figure out the cost of a kid's birthday party. Click the button below to being the interactive exercise. Once you are done return to this page and continue on to the next lesson.

Using the IF Function

ACTIVITY:
  1. Download and open this practice worksheet.
  2. Follow these step by step instructions to figure out which donors should get a free gift.
  3. Once everyting looks good, save the file to your desktop and rename the file with the following convention: Year-Month-Day - Your Name - IF Function (Ex: "2014-09-16 - Kyle Brazil - IF Function").

Using CONCATENATE to Combine Names

ACTIVITY:
  1. Download and open this practice worksheet.
  2. Follow these step by step instructions to combine first and last names in the contact info database.
  3. Once everyting looks good, save the file to your desktop and rename the file with the following convention: Year-Month-Day - Your Name - Concatenate (Ex: "2014-09-16 - Kyle Brazil - Concatenate").

Buying a Printer: Cost Comparison

ACTIVITY:
  1. Download and open this practice worksheet.
  2. Follow these step by step instructions to figure out which printer is cheaper to own in the long run.
  3. Once everyting looks good, save the file to your desktop and rename the file with the following convention: Year-Month-Day - Your Name - Buying a Printer (Ex: "2014-09-16 - Kyle Brazil - Buying a Printer").

Project

Building an Invoice

Part 1: Free Shipping

  1. Download and open the invoice.
  2. Follow the step by step instructions to calculate shipping cost if an order is greater or less than $100.
  3. Once done with this part, save the file to your desktop and rename the file with the following convention: Year-Month-Day - Your Name - Invoice Free Shipping (Ex: "2014-09-16 - Kyle Brazil = Invoice Free Shipping") then move on to Part 2.

Part 2: Using VLOOKUP

  1. Download and open the invoice.
  2. Follow the step by step instructions to create a formula to look up the product price and name.
  3. Once done with this part, save the file to your desktop and rename the file with the following convention: Year-Month-Day - Your Name - Invoice VLOOKUP (Ex: "2014-09-16 - Kyle Brazil = Invoice VLOOKUP") then move on to Part 3.

Part 3: Fixing Broken VLOOKUP

  1. Download and open the invoice.
  2. Follow the step by step instructions to help fix the VLOOKUP that was broken when new products were added.
  3. Once done with this part, save the file to your desktop and rename the file with the following convention: Year-Month-Day - Your Name - Invoice VLOOKUP Fix (Ex: "2014-09-16 - Kyle Brazil = Invoice VLOOKUP Fix") then move on to Part 4.

Part 4: More Shipping Options

  1. Download and open the invoice.
  2. Follow the step by step instructions to add new shipping options to the invoice.
  3. Once done with this part, save the file to your desktop and rename the file with the following convention: Year-Month-Day - Your Name - Invoice Shipping Options (Ex: "2014-09-16 - Kyle Brazil = Invoice VLOOKUP Shipping Options") then move on to Part 5.

Part 5: Data Validation

  1. Download and open the invoice.
  2. Follow the step by step instructions to create a drop down list for selecting the shipping option.
  3. Once done with this part, save the file to your desktop and rename the file with the following convention: Year-Month-Day - Your Name - Invoice Shipping List (Ex: "2014-09-16 - Kyle Brazil = Invoice Shipping List").
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 - Digging Deeper"
    • 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.