using excel for data analysis about dementia interventions

Solver: Excel includes a tool called Solver that uses diverse methods from the operations research to find optimal solutions for all kind of decision problems and thus, makes the data more practical and usable for user.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.

Using excel for data analysis about dementia interventions