In this video, Susan Mershon, Technology Coach & Trainer shows you how to sort and filter data in Microsoft Excel 2011 for MAC. This step by step video includes detailed instructions along with. PivotTables are one of the most powerful data analysis tools in Microsoft Excel. Learn how to use PivotTables to summarize, sort, count, and chart your organization's data in Excel for Mac 2011. Author Curt Frye shows you how to navigate the complexity of PivotTables while taking advantage of their power. He shows how to build PivotTables from single or multiple data sources (including external spreadsheets and text files), add calculated fields, filter your results, and format your layout to make it more readable. Plus, learn how to share your work by printing PivotTables and saving them as PDFs. Instructor •. Curt Frye is a freelance course developer and writer. He has developed more than 50 online courses on topics including Microsoft Excel, Tableau, Mathematica, and social network analysis. He has also written more than 40 books, with recent titles including Microsoft Excel 2016 Step by Step and Microsoft OneNote 2016 Step by Step, both for Microsoft Press. In addition to his writing and course development, Curt is a popular conference speaker and entertainer. His programs include his Improspectives® approach to teamwork and creativity, analyzing and presenting data in Microsoft Excel, and his interactive Magic of the Mind show. By: Dennis Taylor course • 4h 18m 56s • 11,170 viewers • Course Transcript - [Voiceover] Whenever you add a field to a pivot table's column area or row area, you change the pivot table's structure by adding a layer of detail. ![]() But suppose you have a great pivot table layout and want to filter the pivot table using the values in a field that doesn't appear within that arrangement. For example, you might want to filter monthly sales data by quarter but without having the quarter field change the pivot table's layout. If you want to create a filter, without changing the layout of your pivot table, you can do so by moving a field to the report filter area. I'll show you how to do that in this movie. My sample file is the Report Filter Excel workbook which you can find in the Chapter three folder of your exercise files collection. I have displayed a pivot table and it's monthly sales for 2014 and 2015 for four different room types. Macbook air 2017 sale. And let's suppose that I only want to display values for a particular quarter, such as quarter #2. To do that, rather than adding quarter to the row labels area between the year and month, which would change the organization of the pivot table, I can drag it from the field list to the report filter area and you can see that the field has been added in cell A1 and in cell B1, there a control that I can click to control which values appear. If you have data in cell A1 or B1, then Excel displays an indicator dialog box asking if you want to delete the data. If you click yes, then it deletes the data and displays the field as you see it here. If not, it leaves the data and moves the quarter field from the report filter area back up to the field list. But in this case, I didn't have any data there so that didn't happen. I'll click the report filter header button here and you see that I can create a filter. I can create a search filter if I want, but what I want to do now is create a selection filter. So I will clear the select all check box; that removes all the data and if I want to show only those values for quarter #2, I can click 2 and move quarter over to the side. You can see those values appear there: April, May, and June.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |