|
|
– Sort  
You can sort your Excel data on one column or multiple columns. You can sort in ascending or descending order.
|
23-02-2018
|
|
|
– Analysis ToolPak
The Analysis ToolPak is an Excel add-in program that provides data analysis tools for financial, statistical and engineering data analysis.
|
24-02-2018
|
|
|
– Charts
A simple Excel chart can say more than a sheet full of numbers. As you'll see, creating charts is very easy.
|
24-02-2018
|
|
|
– Conditonal Formatting
Conditional formatting in Excel enables you to highlight cells with a certain color, depending on the cell's value.
|
24-02-2018
|
|
|
– Filter
Filter your Excel data if you only want to display records that meet certain criteria.
|
23-02-2018
|
|
|
– Pivot Tables
Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract the significance from a large, detailed data set.
|
23-02-2018
|
|
|
– Solver
Excel includes a tool called solver that uses techniques from the operations research to find optimal solutions for all kind of decision problems.
|
23-02-2018
|
|
|
– Tables
Tables allow you to analyze your data in Excel quickly and easily.
|
23-02-2018
|
|
|
– What-If Analysis
What-If Analysis in Excel allows you to try out different values (scenarios) for formulas.
|
23-02-2018
|
