The Analysis ToolPak is an Excel add-in program that provides data analysis tools for financial, statistical and engineering data analysis. To load the Analysis ToolPak add-in, execute the following steps. 1. On the File tab, click Options. 2. Under Add-ins, select Analysis ToolPak and click on the Go button. 3. Check Analysis ToolPak and click […]
Load the Solver Add-in | Formulate the Model | Trial and Error | Solve the Model Excel includes a tool called solver that uses techniques from the operations research to find optimal solutions for all kind of decision problems. Load the Solver Add-in To load the solver add-in, execute the following steps. 1. On the […]
Create Different Scenarios | Scenario Summary | Goal Seek What-If Analysis in Excel allows you to try out different values (scenarios) for formulas. The following example helps you master what-if analysis quickly and easily. Assume you own a book store and have 100 books in storage. You sell a certain % for the highest price […]
Insert a Table | Sort a Table | Filter a Table | Total Row Tables allow you to analyze your data in Excel quickly and easily. Learn how to insert, sort and filter a table, and how to display a total row at the end of a table. Insert a Table To insert a table, […]
Insert a Pivot Table | Drag fields | Sort | Filter | Change Summary Calculation | Two-dimensional Pivot Table 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. Our data set consists of 213 records and 6 fields. Order ID, […]
A simple chart in Excel can say more than a sheet full of numbers. As you’ll see, creating charts is very easy. Creating chart in MS Excel Combination Chart Error Bars Chart Sheet Data Series Gantt Chart Gauge Chart Sparklines Trendline Axes Pareto Chart Thermometer Chart Scatter Chart Area Chart Bar Chart Pie Chart Line […]
Highlight Cells Rules | Clear Rules | Top/Bottom Rules Conditional formatting in Excel enables you to highlight cells with a certain color, depending on the cell’s value. the following are some conditions by which a user can effectively manage his data. Highlight Cells Rules Color Scales Manage Rules Conflicting Rules Shade Alternate Rows New Rule […]
Number and Text Filters | Date Filters | Advanced Filter | Data Form | Remove Duplicates | Outlining Data Filter your Excel data if you only want to display records that meet certain criteria. 1. Click any single cell inside a data set. 2. On the Data tab, in the Sort & Filter group, click Filter. Arrows in the column […]
One Column | Multiple Columns You can sort your Excel data on one column or multiple columns. You can sort in ascending or descending order. One Column To sort on one column, execute the following steps. 1. Click any cell in the column you want to sort. 2. To sort in ascending order, on the […]
