excel tutorialData Analysis
This section illustrates the powerful features Excel has to offer to analyze data.
1 Sort in Excel: You can sort your data in descending and ascending order. You can sort on one column and sort on several criteria at once.
2 Filter in Excel: Filter your data if you only want to display records that meet certain criteria.
3 Hide Columns or Rows: This chapter teaches you how to hide columns or rows in Excel.
4 Freeze Panes in Excel: If you have a large table of data in Excel, it can be useful to freeze rows or columns. This way you can keep rows or columns visible while scrolling through the rest of the worksheet.
5 Conditional Formatting: Conditional formatting in Excel enables you to highlight cells with a certain color, depending on the cell's value.
6 Excel Charts: A simple chart can say more than a sheet full of numbers. As you'll see, creating Excel charts is very easy.
7 Excel Pivot Tables: Pivot tables in Excel are very powerful when you need to extract the significance from a large, detailed data set.
8 Excel Pivot Charts: A pivot chart is the visual representation of your pivot table. Learn more about Excel pivot charts in this chapter.
9 Working with Excel Tables: One important note before you start with Excel tables is to tell that you can do everything with Excel without using tables. Why using Excel tables then? Because tables allow you to analyze your data in Excel very easily.
10 Text to Columns: To separate the contents of one Excel cell into separate columns, you can use the 'Convert Text to Columns' Wizard.
11 Remove Excel Duplicates: This Excel tutorial teaches you how to remove duplicate rows from a sheet.
12 Excel What-If Analysis: What-If Analysis in Excel allows you to try out different values (scenarios) for formulas.
13 Excel Solver: Excel includes a tool called solver that uses techniques from the operations research to find optimal solutions for all kind of decision problems.
14 Excel 2010 Sparklines: Excel 2010 makes it possible to insert sparklines. Sparklines are graphs that fit in one cell and give you information about the data.
15 Analysis ToolPak: The Analysis ToolPak is an Excel add-in program that provides data analysis tools for financial, statistical and engineering data analysis.