Homework #4 - Pivot Tables
Excel data for HW #4. Click here to download.
The exam must be completed by midnight March 23, 2014. The exam will open Thursday March 20, 2014 by noon.
Below are some videos to help you with learning how pivot tables work. Both Windows and Apple OS versions.
WINDOWS EXCEL 2010
APPLE EXCEL 2011
APPLE EXCEL 2008
Could not find videos for pivot tables in Excel 2008
Is anyone else having problems with the excel homework, using mac? I am trying very hard but can never seem to get anything close to the answers that are displayed in the test. Thank you inn advance for any advice/input on the subject.
ReplyDeleteThere were actually two questions on PC where I felt like I was doing it right, but I wasn't getting the right answers.
ReplyDeleteI also had some issues with this assignment as well but I thought it was an isolated incident. Glad to know I'm not the only one however, this issue should be looked into further. Also the youtube videos crash a lot
ReplyDeleteThe Pivot Table is apparently very efficient at turning disparate pieces of data into coherent and informative information. The convenience at being able to do this process from any computer with Microsoft Excel makes it all the more novel.
ReplyDeleteThis video was helpful in many ways. It also helped that I payed attention in class.
ReplyDeleteIf it wasn't for these excel homeworks I wouldn't have my internship!
ReplyDeleteI have been talking to a lot of people and the lessons we are gaining in excel are really essential for this new business market.
ReplyDeleteI have used slicers quite often at my current internship. I love how they simplify PivotTables, which are already a great function to visually simplify your data. I hate that it is not added into 2011 Mac Excel.
ReplyDelete