MS Excel

If you are a CA student do not do the following Excel tutorials, instead do the Google Spreadsheet tutorials.

  1. Tutorial 1
    1. Shortcuts (30min)
    2. Use MS Excel and practice the shortcuts and tools along with the video tutorial. Don't forget to take notes! Excel can be tough at times. Also check out the shortcut list. Take a screenshot of your Excel sheet showing that you practiced along with the video in Excel and post it with the Excel file to WordPress and the link to the spreadsheet. Remember the tag is tutExcel. Name the file using the format like the example: ca2joe14 Excel Tutorials
  2. Tutorial 2
    1. If Then (Grades) (25min)
    2. Using the same workbook from tutorial one, add a new sheet tab and name it Tut 2. Move it so it is before the Tut 1 sheet. Name the previous work from tutorial one, Tut 1. Follow the video tutorial directions to learn how to use the If Then equation to calculate a pass/fail gradesheet. Take a screenshot and post it to WordPress with the Excel Workbook which should include Tutorial 1 as the previous sheet.
  3. Tutorial 3
    1. Lists (Salaries) (35min)
    2. Follow the directions to learn how to work with lists.
  4. Tutorial 4
    1. Choose (IceCream)
    2. Using your same Excel workbook, add a new tab (IceCream) and follow the instructions in the video tutorial; post a screenshot of your work along with your Excel Workbook which should have all your tutorials in it.
  5. Tutorial 5
    1. Charts (Poll) Do this tutorial in class but summer students do it all online
    2. Open and use the same Excel workbook and follow the directions from the video tutorial to make a chart. Take a screenshot of your chart and the voting information and post it along with your Excel Workbook which should have all your tutorials in it.
  6. Tutorial 6
  7. V-Lookup (Letter Grades)
    1. Use the video tutorial to create a vLookup table to show your letter grades in a previous Excel assignment. Take a screenshot and post it along with your Excel Workbook which should have all your tutorials in it.
  8. Tutorial 7
    1. Review

Complete the Excel Review & review Tut 5, which will help you prepare for a future quiz lab. Take a screenshot and post the file to posterous and the link to the spreadsheet.

Previously finished, (ignore)

& Battleship

Then in the same workbook but a different sheet tab, create a "battleship board" by following the instructions in the video tutorial. Make sure you place three ships. Take a screenshot of your "battleship board." We will use it later in class. If you are taking the class online only, video chat with a friend and play battleship.

Send both screenshots and your file (name it "ClassID Excel Tutorials") to posterous and paste the link. For summer students, send a screenshot of the finished battleship game with your friend on the video screen window.

tut4

if you want, you can use the old video tutorial if you already started with it.

Optional: Click the links below to briefly look at the resources available to you if you need additional help with Excel: [link][link][vlookup][help]

SUMMER STUDENTS:

While you complete all of the Excel tutorials required on the calendar, use Screenflow on your Macbook to record your screen and yourself so that I can ensure that you worked on them. When finished export each to your desktop and I will ask you to show me them at a later time.