Excel Project

I thought this was a great project to do. I enjoyed working on it. I find excel worksheets easy to use and manipulate, so this project only took me one day to complete. I was not familiar with Pivot Tables, but as with everything else in Excel it did not take long to learn about it. I have "Excel 2007: The Missing Manual" as my trusty side kick, and not to mention you can find just about any "how to" video on youtube, this one is from the author of my book.

I wish the project dived more into formulas than the basic layout of spreadsheet. Just recently I learned how to use a new formula. For my business we just mailed out nearly 600 mailings and we wrote all the addresses in Excel and submitted it to the mailing company in that format. They came back and told me the street number and name needed to be combined into one cell. I didn't know how to combine the two without retyping all 580 addresses, so I pulled out my handy sidekicked and I learned about the function "Concatenate", this allowed me to combine the two texts into one cell. I had the file back to them in five minutes. There are so many functions to use in Excel, I wish we would have explored more of them.

I think the course needs to have more Excel projects. Excel plays a vital role in the business environment. I enjoy the lectures on networks, but covering more in Excel may be more beneficial for Business students.