Publisher's Synopsis
Welcome to the only guidebook series that takes a visual approach to professional–level computer topics. Open the book and you′ll discover step–by–step screen shots that demonstrate over 150 Excel Data Analysis techniques, including:
- Creating array formulas
- Checking for formula errors
- Determining the location of a value
- Calculating straight–line depreciation
- Creating a grouped frequency distribution
- Converting a range to a table
- Analyzing cell values
- Plotting a logarithmic trendline
- Running a regression analysis
- Building PivotTables and charts
Features
- High–resolution screen shots demonstrate each task
- Succinct explanations walk you through step by step
- Two–page lessons break big topics into bite–sized modules
- "Apply It" and "Extra" sidebars highlight useful tips