A pivot table allows you to extract the significance from a large, detailed data set.Ħ Tables: Master Excel tables and analyze your data quickly and easily.ħ What-If Analysis: What-If Analysis in Excel allows you to try out different values (scenarios) for formulas.Ĩ Solver: Excel includes a tool called solver that uses techniques from the operations research to find optimal solutions for all kind of decision problems.ĩ Analysis ToolPak: The Analysis ToolPak is an Excel add-in program that provides data analysis tools for financial, statistical and engineering data analysis.ġ Sort: Custom Sort Order | Sort by Color | Reverse List | Randomize List | SORT functionĢ Filter: Number and Text Filters | Date Filters | Advanced Filter | Data Form | Remove Duplicates | Outlining Data | Subtotal | Unique Values | FILTER functionģ Conditional Formatting: Manage Rules | Data Bars | Color Scales | Icon Sets | Find Duplicates | Shade Alternate Rows | Compare Two Lists | Conflicting Rules | Heat MapĤ 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ĥ Pivot Tables: Group Pivot Table Items | Multi-level Pivot Table | Frequency Distribution | Pivot Chart | Slicers | Update Pivot Table | Calculated Field/Item | GetPivotDataĦ Tables: Structured References | Table Styles | Merge Tables | Table as Source Data | Quick Analysisħ What-If Analysis: Data Tables | Goal Seek | Quadratic EquationĨ Solver: Transportation Problem | Assignment Problem | Capital Investment | Shortest Path Problem | Maximum Flow Problem | Sensitivity Analysis | System of Linear Equationsĩ Analysis ToolPak: Histogram | Descriptive Statistics | Anova | F-Test | t-Test | Moving Average | Exponential Smoothing | Correlation | Regressionīelow you can find 25 popular pages. 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.
0 kommentar(er)
