Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables

Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables

by Paul McFedries
     
 

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

See more details below

Overview

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

Product Details

ISBN-13:
9781118517147
Publisher:
Wiley
Publication date:
07/29/2013
Series:
Visual Blueprint Series
Edition description:
4th Edition
Pages:
336
Product dimensions:
7.40(w) x 9.10(h) x 0.70(d)

Related Subjects

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >