Microsoft Excel offers unmatched data analysis features with which you can pinpoint sales trends, track customers, create invoices, chart progress, make calculations, and even decide future business plans based on data analysis. And that sparse list only scratches the surface of what Excel can do
The Excel Data Handbook: Quick Tips & Techniques for Formatting, Sorting & Countingis a new manual developed by the staff of Inside Microsoft Excel and authored by Excel expert Dennis Taylor.
The Excel Data Handbook will teach you to:
· Use conditional formatting to compare data in seconds
· Simplify data set work with the Table feature
· Apply Data Validation to keep data entry accurate
· Sort data three ways and use advanced filtering techniques
· Perform calculations on data subsets using the Subtotals feature
· Find data automatically based on a reference table using VLOOKUP
· Use MATCH and INDEX functions to do what VLOOKUP can't
· Alter PivotTable layouts for different data views
· Get a flexible view of your PivotTable data with PivotCharts