Excel data analysis for dummies
(Book)

Book Cover
Average Rating
Published:
Hoboken, New Jersey : John Wiley & Sons, Inc., [2019].
ISBN:
9781119518167, 1119518164
Status:
2nd Floor- Adult Books
005.54 EXC
Description

Take Excel to the next level

Excel is the world’s leading spreadsheet application. It’s a key module in Microsoft Office—the number-one productivity suite—and it is the number-one business intelligence tool. An Excel dashboard report is a visual presentation of critical data and uses gauges, maps, charts, sliders, and other graphical elements to present complex data in an easy-to-understand format. 

Excel Data Analysis For Dummies explains in depth how to use Excel as a tool for analyzing big data sets. In no time, you’ll discover how to mine and analyze critical data in order to make more informed business decisions.

  • Work with external databases, PivotTables, and Pivot Charts
  • Use Excel for statistical and financial functions and data sharing
  • Get familiar with Solver
  • Use the Small Business Finance Manager

If you’re familiar with Excel but lack a background in the technical aspects of data analysis, this user-friendly book makes it easy to start putting it to use for you.

Also in This Series
Copies
Location
Call Number
Status
Last Check-In
2nd Floor- Adult Books
005.54 EXC
Check Shelf
Aug 10, 2019
More Like This
More Details
Format:
Book
Edition:
Fourth edition.
Physical Desc:
xi, 338 pages : illustrations, charts ; 24 cm.
Language:
English

Notes

General Note
Includes index.
Description
"If you can get data into Excel, then you have a giant basket of data analysis tools at your fingertips. This book shows you how to access and use the features and techniques for organizing, manipulating, and summarizing just about anything that resides in a worksheet. So if you're familiar with Excel but lack a background in the technical aspects of data analysis, this user-friendly book makes it easy to start putting Excel to use for you" -- Page 4 of cover.
Reviews from GoodReads
Loading GoodReads Reviews.
Tagging
Tags:

No Tags, Be the first to tag this record!


Citations
APA Citation (style guide)

McFedries, P. (2019). Excel data analysis for dummies. Fourth edition. Hoboken, New Jersey: John Wiley & Sons, Inc.

Chicago / Turabian - Author Date Citation (style guide)

McFedries, Paul. 2019. Excel Data Analysis for Dummies. Hoboken, New Jersey: John Wiley & Sons, Inc.

Chicago / Turabian - Humanities Citation (style guide)

McFedries, Paul, Excel Data Analysis for Dummies. Hoboken, New Jersey: John Wiley & Sons, Inc, 2019.

MLA Citation (style guide)

McFedries, Paul. Excel Data Analysis for Dummies. Fourth edition. Hoboken, New Jersey: John Wiley & Sons, Inc, 2019. Print.

Note! Citation formats are based on standards as of July 2010. Citations contain only title, author, edition, publisher, and year published. Citations should be used as a guideline and should be double checked for accuracy.
Staff View
Grouped Work ID:
09e1dd6e-34ad-5f67-ac2d-b4c92a79ed45
Go To GroupedWork
Last Sierra Extract TimeSep 18, 2019 04:13:05 PM
Last File Modification TimeSep 19, 2019 04:51:41 AM
Last Grouped Work Modification TimeSep 19, 2019 04:50:21 AM

MARC Record

LEADER02863cam a2200469Ii 4500
001ocm1066054950
003OCoLC
00520190213041915.0
008181112t20192019njuad  e      001 0 eng d
010 |a 2018959384
020 |a 9781119518167|q (paperback)
020 |a 1119518164|q (paperback)
035 |a (OCoLC)1066054950
040 |a FBR|b eng|e rda|c FBR|d OCLCO|d JRZ|d ZGR|d CZA|d CLE|d OCLCF|d BKL|d IMD|d JVK
049 |a JVKA
050 4|a HF5548.4.M523|b N4515 2019
08204|a 005.54|2 23
092 |a 005.54 EXC
1001 |a McFedries, Paul,|e author.
24510|a Excel data analysis for dummies /|c by Paul McFedries.
24614|a Microsoft Excel data analysis for dummies.
250 |a Fourth edition.
264 1|a Hoboken, New Jersey :|b John Wiley & Sons, Inc.,|c [2019]
264 4|c ©2019.
300 |a xi, 338 pages :|b illustrations, charts ;|c 24 cm.
336 |a text|2 rdacontent.
336 |a still image|b sti|2 rdacontent.
337 |a unmediated|2 rdamedia.
338 |a volume|2 rdacarrier.
4901 |a For dummies.
500 |a Includes index.
5050 |a Introduction -- Part 1: Getting started with data analysis -- Learning basic data-analysis techniques -- Working with data-analysis tools -- Introducing Excel tables -- Grabbing data from external sources -- Scrub-a-dub-dub: Cleaning data -- Analyzing table data with functions -- Part 2: Analyzing data with PivotTables and PivotCharts -- Creating and using PivotTables -- Performing PivotTable calculations -- Building PivotCharts -- Part 3: Discovering advanced data analysis tools -- Tracking trends an making forecasts -- Analyzing data with statistics -- Analyzing data with descriptive statistics -- Analyzing data with inferential statistics -- Part 4: The part of tens -- Ten things you ought to know about statistics -- Ten ways to analyze financial data -- Ten ways to raise your PivotTable game.
520 |a "If you can get data into Excel, then you have a giant basket of data analysis tools at your fingertips. This book shows you how to access and use the features and techniques for organizing, manipulating, and summarizing just about anything that resides in a worksheet. So if you're familiar with Excel but lack a background in the technical aspects of data analysis, this user-friendly book makes it easy to start putting Excel to use for you" -- Page 4 of cover.
63000|a Microsoft Excel (Computer file)
650 0|a Electronic spreadsheets|x Computer programs.
650 0|a Electronic spreadsheets|x Data processing.
830 0|a --For dummies.
907 |a .b22000331|b 06-17-19|c 01-16-19
998 |a an|b 02-13-19|c m|d a |e -|f eng|g nju|h 0|i 1
999 |a ss
994 |a C0|b JVK
945 |g 31338|i 1338006591181|i 31338006538174|j  - - |k 08-10-19|l anf |o -|p $29.99|q -|r -|s - |t 0|u 5|v 3|w 4|x 1|y .i14305793|z 02-13-19