EXCEL Homework #3
Homework #3 is about basic tables. Tables allows Excel to hold large amounts of data and then as the user you can analyze that data assist for us in decision making.
Today, in class, we will study this powerful excel option because knowledge of this is valuable in the workplace. Understanding tables will assist in your understanding of the next three assignments (Pivot Tables and Google Fusion Tables).
Ask any of your fellow students, whom have had an internship, the importance of understanding pivot tables in the workplace. So understanding this assignment is a must.
Here is what you need to do:
- The two videos below will assist you with your homework assignment
- Click Here to download the excel file for this assignment and the exam.
- The exam will open on Thursday March 6, 2014 and will close on Sunday March 9, 2014 at midnight. Remember the exam is at www.classmarker.com.
This was a really interesting class. After you showed us the Property records site, I jumped on and started messing around with it. I searched some familiar names and was able to pull their property data up. I've always known this information was public's knowledge, but never knew where it could be found. Since I am from the US Virgin Islands, I googled "VI Property Records." Surely enough, they came up. I pulled up my own residence and saw the value, and how much my family was taxed prior years. It's amazing the amount of things that are out there, you only need to be pointed in the right direction to know where to discover it.
ReplyDeleteI am happy that we are finally learning these excel shortcuts. Personally, I think it would be even more valuable as a freshmen to have a class like this for exposure purposes. Nevertheless, I can't wait to intern next summer because I know I'll be a lot more efficient this go round.
ReplyDeleteThese videos were actually really good and very useful! They were easy to understand and it's cool to see how practical this skill is.
ReplyDeleteI thought that this was an interesting class. I have personally used excel when working at my summer internships so I understand the importance of using tables. These tricks shown in the youtube videos made it a lot easier to navigate through the different spreadsheets and locate individual information that would otherwise take hours to find. I felt that this was an extremely effective class and exam, and more practice would be excellent.
ReplyDeleteIts amazing how essential a tool such as excel is in business today. I was reading 'Why should white guys have all the fun' and it struck me that they had whole floors of accountants that would not have even been necessary if they had some of the tools that we have with excel today.
Delete