In this section we will learn about the powerful features of Excel through which one can easily analyze the data
1.
Sort: Short
function in Excel provide a facility to sort data in ascending or descending
order
2.
Filter: Filter is
used to display the certain criteria of records
3.
Conditional Formatting: We can
highlight cells with a specific colors by using conditional formatting,
depending on the cell's value.
4.
Charts: "A
picture is worth a thousand words" A simple Excel chart can easily be understandable
more than a sheet full of numbers.
5.
Pivot Tables: the most
powerful feature of Excel is Pivot tables. We can extract the significance from
large and detailed data set.
6.
Tables: Master Excel
tables can analyzes your data quickly and easily.
7.
What-If Analysis: What-If
Analysis in Excel allows us to try out different values for formulas.
8.
Solver: Excel
includes a tool called solver that uses techniques from the operations research
to find optimal solutions for all kind of decision problems.
9.
Analysis ToolPak: The Analysis
ToolPak is an Excel add-in program that provides data analysis tools for
financial, statistical and engineering data analysis.
Data Analysis +
To become an expert in Microsoft
Excel you can find related examples and features on the right side of each
chapter. For an overview you can read the following
1. Sort: Custom Sort Order | Sort by Color | Reverse List | Randomize List | SORT function
2. Filter: Number and Text Filters | Date Filters | Advanced Filter | Data Form | Remove Duplicates | Outlining Data | Subtotal | Unique Values | FILTER function
3. Conditional Formatting: Manage Rules | Data Bars | Color Scales | Icon Sets | Find Duplicates | Shade Alternate Rows | Compare Two Lists | Conflicting Rules | Heat Map
4. Charts: Column Chart | Line Chart | Pie Chart | Bar Chart | Area Chart | Scatter Plot | Data Series | Axes | Chart Sheet | Trendline | Error Bars | Sparklines | Combination Chart | Gauge Chart | Thermometer Chart | Gantt Chart | Pareto Chart
5. Pivot Tables: Group Pivot Table Items | Multi-level Pivot Table | Frequency Distribution | Pivot Chart | Slicers | Update Pivot Table | Calculated Field/Item | GetPivotData
6. Tables: Structured References | Table Styles | Quick Analysis | Merge Tables
7. What-If Analysis: Data Tables | Goal Seek | Quadratic Equation
8. Solver: Transportation Problem | Assignment Problem | Capital Investment | Shortest Path Problem | Maximum Flow Problem | Sensitivity Analysis | System of Linear Equations
9. Analysis ToolPak: Histogram | Descriptive Statistics | Anova | F-Test | t-Test | Moving Average | Exponential Smoothing | Correlation | Regression
Check out all 300 examples.
No comments:
Post a Comment