Site Loader

We can arrange data on one column or multiple columns. We can arrange in ascending or descending order.
To arrange data in ascending order, click ‘AZ’ in the sort & filter tab.
To arrange in descending order, select ‘ZA’.
We can filter out our data only if we want to display records which satisfy particular condition.
select any single cell the,click ‘filter’ in the sort & filter tab.
What-If Analysis in the Excel allows us to test out various types of values or scenarios for different formulas.
A sparkline is a outline (/chart) show in a cell which represents our selected data. Sparklines allows us to quickly and easily understand collecting information.

Post Author: admin