As you'll see, creating charts is very easy.ĥ Pivot Tables: Pivot tables are one of Excel's most powerful features. You can sort in ascending or descending order.Ģ Filter: Filter your Excel data if you only want to display records that meet certain criteria.ģ Conditional Formatting: Conditional formatting in Excel enables you to highlight cells with a certain color, depending on the cell's value.Ĥ Charts: A simple Excel chart can say more than a sheet full of numbers.
This section illustrates the powerful features Excel has to offer to analyze data.ġ Sort: You can sort your Excel data on one column or multiple columns.