You can also expand Change Data Source, pick a different database (table), and replace the existing pivot table with a new one. Related 10 cool projects you can do with just Microsoft Excel ...

Not all sort tasks in Microsoft Excel begin with the characters to the left, ... Click anywhere inside the Table. If your data isn’t a Table object yet, Power Query will prompt you to convert it.

If you regularly work with data sets in Excel, you know how important it is to be able to quickly find the information you need.

Sorting data via cell and font colors in Microsoft Excel is much easier than one might think, and we have to thank Microsoft for not making this task a complicated mess. In fact, it is easier now ...