The essential components of a PivotTable are Filters, Columns, Rows and Values. Navigate larges amounts of data can take hours and even days to disseminate. Learning to properly use PivotTables will help convert data into knowledge. A big mistake I see constantly is when people run reports and they provide a spreadsheet with a lot of valuable information but when not organized properly it's actually useless. This chapter was my favorite. I was actually looking forward to learn about PivotTables way ahead of the schedule.
Subscribe to:
Post Comments (Atom)
End of the Road?
By all means reaching the end of IS101 is not the end of the road for me but is bringing me closer to the main goal which is graduating with...
-
The essential components of a PivotTable are Filters, Columns, Rows and Values. Navigate larges amounts of data can take hours and even days...
-
Learning how computers operate by using 2 digits only: one and zero was mind blowing to me. I'm still having trouble understanding the e...
Excellent choice of topic/feature from Chapter 5 Excel :-)
ReplyDeleteEven better is your blog post's title and well said about providing a lot of valuable information but it is not organized properly, it is actually useless!
Glad to hear 5.10.3 Advanced PivotTables made Excel your favorite chapter ^_^
I didn't know pivot tables existed until this lesson. It was one of those lessons that I immediately understood once I saw the lessons explanation. I plan on utilizing it on my day-to-day spreadsheet activities to make the endless rows and columns more digestible.
ReplyDeleteI enjoy learning about PivotTable are Filters, Columns, Rows and Values.
ReplyDeleteI was quite surprised when learning about PivotTable. It's such a useful way to filter out information and organize it in different ways.
ReplyDeleteI will definitely use the Pivot Table when organizing my sales at work. Instead of looking at a table and its numbers one by one I can now organize it to my liking!
ReplyDelete