This week we focused on Excel, which is a program that has always fascinated me. To me it is mind boggling to think about all of the different functions which are available within the software. The part of the discussions which I was able to grasp the best was Pivot Tables. Pivot Tables is a great function which allows the user to select a large group of data and import it into specialized tables. This allows the user to analyze data very quickly and with very little effort.
Pivot tables would be very useful for businesses because it would allow them to sort large amounts of data down to a very specific report. This would allow them to focus on certain areas of the business and to know how to improve with out commiting large amounts of time. In addition it helps reduce errors which could be made when trying to manually input formulas.
Microsoft Office website has some good tutorials on how to use Pivot Tables. One which I found very helpful is PivotTable Reports 101 located at http://office.microsoft.com/en-us/excel/HA010346321033.aspx . In addition to the written version, I also found a video tutorial of PivotTable Reports 101 which I have attached for your viewing pleasure.
Excel 2003 Pivot Table 101 - Click here for more amazing videos
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment