Microsoft Excel is a handy and effective for data analytics. One of its top functionalities is sort which lets you sort data from largest or smallest, smallest to largest, or other conditions, to help you extract useful information.
For example, you can use sort to see which Google Ads campaigns have the most number of clicks and highest click-through rate (CTR). Conversely, you can sort and see which campaigns have lowest number of clicks and CTR. Gaining this information helps you decide how you want to adjust the campaigns (e.g. pause certain campaigns or allocate budgets accordingly).
To sort data, first select your entire dataset and turn it into a table by clicking on Home, select Format as a Table, and choose a table format.
Then, check the box “My table has headers”
Click anywhere on the table and click on Data and Sort.
Once you have clicked on Sort, a dialog will appear and you can choose conditions on how you want to filter the data.
To add conditions, click on the + button at the bottom left of the dialog.
We are here to help you 7 days a week. If you have any questions or want to say ‘hi’, please feel free to get in touch!
Technology. Data. Creativity.
Connecting Dots In A Digital Labyrinth.