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.

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.

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.

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.

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.

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.

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.

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.

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.