![]() You can adjust filters using the Sort & Filter command in the Editing group on the Home tab. ![]() Filters can be created within the pivot table. ![]() While some data will repeat (for example, products in a sales report), you do not want duplicate entries for a single event. Repeating data will produce incorrect results. It will automatically move you to the next blank cell in the column. An easy way to find blank cells is Shift + Down Arrow. Use “not available” or “n/a” to remove blank cells. If you have any blank cells in the source data, it will show an error messages in the results. Pivot tables will do a much better job with creating calculations. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |