Running out of ideas on how to make the most of your data? Let Excel’s data analysis tool help you out.
Excel has a handy tool to help you get work with your data quickly.
On the Home menu, click Analyse Data.
The right panel opens. You will find a proposal of pivot tables and graphs that you can insert by clicking on the + at the bottom of each proposal.
Scroll down to see the other proposals.
If you click on the gear at the top right of the panel, you can choose which fields to include and which not to include in the pivot tables and charts provided.
By default, all fields are included. Simply uncheck the fields you don‘t want to appear.
The proposals are updated. All you have to do is choose the one that suits you best.
