This is Real Life Sale
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Original Essays | March 11, 2015

    Mark Adams: IMG All Signs Point to Atlantis



    When I tell people I've spent the last three years working on a book about Atlantis, they usually have two questions. The first almost always goes... Continue »
    1. $19.57 Sale Hardcover add to wish list

    spacer

Excel Data Analysis for Dummies

by

Excel Data Analysis for Dummies Cover

 

Synopses & Reviews

Publisher Comments:

So here’s a funny deal: You know how to use Excel. You know how to create simple workbooks. And how to print stuff. And you can even, with just a little bit of fiddling, create cool-looking charts. But sometimes you wish that you could do more with Excel, such as how to use Excel to really gain insights into information, the data, that you work with in your job.

Using Excel for this kind of stuff is what Excel Data Analysis For Dummies is all about. This is a book that assumes that you want to use Excel to learn new stuff, discover new secrets, and gain new insights into the information you’re already working with in Excel.

Ready to take Excel to the next level? This plain-English guide covers all of these concepts, and more, to ensure that you’re using Excel to its fullest capacity:

  • Harnessing information in lists
  • Querying external databases and Web pages tables
  • Cleaning data with text functions
  • Building and working with PivotTables
  • Customizing PivotCharts
  • Using the statistics functions
  • Understanding Optimization Modeling

If all this talk of statistics and advanced tools makes you light-headed, don’t worry. Excel Data Analysis For Dummies distills the most important fundamentals into everyday language. You’ll find just enough information to help you get your work done – without leaving you gasping for air in a sea of technobabble. It’d be a real shame if you didn’t at least know what bells and whistles Excel has to offer and the basic steps that you need to use them.

Synopsis:

This title is for readers who want to move beyond building simple worksheets and want to begin using Excel to gain valuable insight from their data. It focuses on the features of Excel that are important to businesses and researchers.

Synopsis:

Get tips on PivotTables, statistics functions, Solver, and more!

Advanced Excel tools and techniques – explained in plain English!

The fun and easy way™ to take Excel to the next level and tame your data

Excel spreadsheets are a fact of life. But if you’re like most people, you probably don’t take full advantage of Excel’s data analysis tools. That’s where this book comes in. From grabbing external data to working with PivotCharts, database functions, and regression analysis, it shows you step by step how Excel can turn raw data into intelligible information.

The Dummies Way

  • Explanations in plain English
  • "Get in, get out" information
  • Icons and other navigational aids
  • Tear-out cheat sheet
  • Top ten lists
  • A dash of humor and fun

Get smart! @www.dummies.com

  • Find listings of all our books
  • Choose from many different subject categories
  • Sign up for daily eTips at www.dummiesdaily.com

Synopsis:

Excel Data Analysis For Dummies is for readers who want to move beyond building simple worksheets and want to begin using Excel to gain valuable insight from their data. Focuses on the features of Excel that are important to businesses and researchers including: working with external databases, PivotTables and Pivot Charts, using Excel for statistical and financial functions, data sharing, working with Solver, and using the Small Business Finance Manager. Provides detailed step-by-step instructions on the use of Excel to perform statistical analysis.

About the Author

Stephen L. Nelson (Redmond, WA) writes about business application software and using technology in business. Nelson, the author of Quicken For Dummies, QuickBooks For Dummies, and more than 100 other titles is an M.B.A. and C.P.A. A Wall Street Journal article called Nelson "The Louis L' Amour of computer book writers."

Table of Contents

Introduction.

Part I: Where's the Beef?

Chapter 1: Introducing Excel Lists.

Chapter 2: Grabbing Data from External Sources.

Chapter 3: Scrub-a-Dub-Dub: Cleaning Data.

Part II: PivotTables and PivotCharts.

Chapter 4: Working with PivotTables.

Chapter 5: Building PivotTable Formulas.

Chapter 6: Working with PivotCharts.

Chapter 7: Customizing PivotCharts.

Part III: Advanced Tools.

Chapter 8: Using the Database Functions.

Chapter 9: Using the Statistics Functions.

Chapter 10: Descriptive Statistics.

Chapter 11: Inferential Statistics.

Chapter 12: Optimization Modeling with Solver.

Part IV: The Part of Tens.

Chapter 13: Almost Ten Things You Ought to Know about Statistics.

Chapter 14: Almost Ten Tips for Presenting List Results and Analyzing Data.

Chapter 15: Ten Tips for Visually Analyzing and Presenting Data.

Part V: Appendix.

Appendix: Glossary of Data Analysis and Excel Terms.

Index.

Product Details

ISBN:
9780764516610
Author:
Nelson, Stephen L.
Publisher:
For Dummies
Location:
New York
Subject:
Spreadsheets - Excel
Subject:
Database Management - General
Subject:
Electronic spreadsheets
Subject:
Microsoft Excel
Subject:
Data Processing - General
Subject:
Data processing
Subject:
Personal Computers-Applications
Subject:
Spreadsheets - General
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Subject:
Microsof
Subject:
t Excel
Copyright:
Edition Description:
Computers
Series:
For Dummies (Computers)
Series Volume:
5
Publication Date:
20020809
Binding:
TRADE PAPER
Language:
English
Illustrations:
Yes
Pages:
384
Dimensions:
9.18x7.40x.84 in. 1.28 lbs.

Related Subjects

Computers and Internet » Computers Reference » General
Computers and Internet » Database » Design
Computers and Internet » Networking » General
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets
Computers and Internet » Software Engineering » Software Management

Excel Data Analysis for Dummies
0 stars - 0 reviews
$ In Stock
Product details 384 pages For Dummies - English 9780764516610 Reviews:
"Synopsis" by , This title is for readers who want to move beyond building simple worksheets and want to begin using Excel to gain valuable insight from their data. It focuses on the features of Excel that are important to businesses and researchers.
"Synopsis" by , Get tips on PivotTables, statistics functions, Solver, and more!

Advanced Excel tools and techniques – explained in plain English!

The fun and easy way™ to take Excel to the next level and tame your data

Excel spreadsheets are a fact of life. But if you’re like most people, you probably don’t take full advantage of Excel’s data analysis tools. That’s where this book comes in. From grabbing external data to working with PivotCharts, database functions, and regression analysis, it shows you step by step how Excel can turn raw data into intelligible information.

The Dummies Way

  • Explanations in plain English
  • "Get in, get out" information
  • Icons and other navigational aids
  • Tear-out cheat sheet
  • Top ten lists
  • A dash of humor and fun

Get smart! @www.dummies.com

  • Find listings of all our books
  • Choose from many different subject categories
  • Sign up for daily eTips at www.dummiesdaily.com
"Synopsis" by , Excel Data Analysis For Dummies is for readers who want to move beyond building simple worksheets and want to begin using Excel to gain valuable insight from their data. Focuses on the features of Excel that are important to businesses and researchers including: working with external databases, PivotTables and Pivot Charts, using Excel for statistical and financial functions, data sharing, working with Solver, and using the Small Business Finance Manager. Provides detailed step-by-step instructions on the use of Excel to perform statistical analysis.
spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.