Excel 2021 now makes it very easy to generate a new pivot table with a custom data set selected in your worksheets with the new Quick Analysis Tool. You can then drill down into the new table to drill down to the level of the source cell or just select and move beyond to another cell or row. The newly created pivot table will display in Excel as a table with an arrow head over the name of the cell that is the source of the data. You can then select a different data set or cells to initiate a new view in Excel. To quickly preview different kinds of pivot tables which Excel can create automatically for you on the fly with the selected data in an Excel spreadsheet you open one in an Excel file.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |