Excel Project

Although I was somewhat familiar with Excel before beginning this project, I found it to be a huge learning experience for me. I frequently create spreadsheets at my office, however, I rarely use formulas and I have never created a pivot table. Becoming familiar with the use of these two items alone will greatly increase my productivity at work, and I will be able to do advanced calculations that would have taken me forever to do individually with a calculator.

 I also enjoyed listening to the lectures, and thought the Excel Scavenger Hunt was a great idea to help me focus on the critical aspects of the lectures and to create a good reference sheet to aid in the completion of my project.

Besides the above mentioned calculations that I will definitely take advantage of, another aspect that will contribute to my ease of use was the "Workbook Structure" lecture. The keyboard shortcuts and keystrokes that move you quickly and with ease from one area of your spreadsheet to another will be particularly useful when dealing with very large sheets of data.

Even though I found myself frustrated and hung up on a couple of the steps in the project, it was overall an enjoyable assignment, and possibly one of the most useful sections that we will study. I definitely learned the value of the F1 (help) key!

Hopefully I didn't miss any steps, and my calculations are correct. Please see below the required "screen capture" of my "Avgincrease" pivot table.