What-If Analysis: What-If Analysis in Excel allows the user to try out different values using formulas and can be used in a conditional manner.

Tables: Tables allow you to examine and inspect your data in Excel quickly and effortlessly.A pivot table allows you to extract the significance from a large and detailed data set and view information more concisely. Pivot Tables: Pivot table is one of Excel’s most sublime and interactive features for representing data.As you’ll see, creating charts in Excel is very easy and user-friendly, and is also used to make the data more colorful, presentable and interactive with user. Charts: A simple Excel chart can say more than a big sheet full of information.Conditonal Formatting: Conditional formatting in Excel enables you to highlight cells with a certain color, depending on the cell’s value, depending upon the user’s criteria.Filter: Filter your Excel data if you only want to display records that meet certain criteria, and can be used to conditionally view specific cells, on the application of a condition.You can sort in ascending or descending order, depending upon the objective of the operation. Sort: You can sort your Excel data on one column or multiple columns.This section illustrates the extensively useful and diverse features that Excel has to offer for analyzing data. Data analysis has multiple facets, constituting a variety of diverse approaches under a variety of names, in different domains of life, that help to perform a variety of operations and validate the decision making process. By Harshita Srivastava on Decemin Advanced Excel Functions and Formulasĭata analysis, also known as analysis of data or data analytics, is a method to clean, inspect, transform, model and introspect data with the aim to discover and decipher new information, form suitable conclusions, edit and format data accordingly as well as to validate the decision making process in a suitable and efficient manner.

Excel solver function also known as