![]() When you start using pivot tables frequently, you begin to realize that some of Excel's built-in tools could be a little more efficient. They have a seemingly infinite number of uses, and they are just awesome! I use pivot tables for everything from a quick list of unique values, to reconciling accounts, to creating sophisticated interactive dashboards. I love Excel! □Īnd, I have probably built thousands of pivot tables. My name is Jon, and I have been using Excel all day everyday for over 10 years. This process alone can be very time consuming. ![]() ![]() REPEAT for all the fields you want to add.Go back to the sheet that contains the pivot table.Scroll horizontally through the columns until you find the field.Find the sheet that contains the source data.If you have pivot tables with more than 20-30 fields, then just scrolling through the field list to find the field you're looking for can take a lot of time.Īnd if you don't know the name of the field you are looking for, then you probably do something like the following: If you use pivot tables frequently then you could be wasting a lot of time with some of these boring repetitive tasks, which takes time away from the fun stuff. These small tasks can be very time consuming and frustrating!ĭo You Spend Extra Time Building Pivot Tables? Do you spend extra time doing any of the following? However, we also spend a lot of time doing repetitive tasks with pivot tables. ![]() There is no doubt that pivot tables are incredibly powerful, and save us a lot of time when summarizing data. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |