The Resource Microsoft Office Excel 2007 data analysis for dummies, by Stephen L. Nelson, (electronic resource)

Microsoft Office Excel 2007 data analysis for dummies, by Stephen L. Nelson, (electronic resource)

Label
Microsoft Office Excel 2007 data analysis for dummies
Title
Microsoft Office Excel 2007 data analysis for dummies
Statement of responsibility
by Stephen L. Nelson
Creator
Subject
Genre
Language
  • eng
  • eng
Summary
Shows ordinary users how to tap the rich data analysis functionality of Excel, make sense of their organization's critical financial and statistical information, and put together compelling data presentationsNow revised with over 30 percent new content to cover the enhancements in Excel 2007, including the completely redesigned user interface, augmented charting and PivotTable capabilities, improved security, and better data exchange through XMLProvides thorough coverage of Excel features that are critical to data analysis-working with external databases, creating PivotTables a
Member of
Cataloging source
MiAaPQ
http://library.link/vocab/creatorDate
1959-
http://library.link/vocab/creatorName
Nelson, Stephen L.
Dewey number
005.54
Illustrations
illustrations
Index
index present
Language note
English
LC call number
HF5548.4.M523
LC item number
N455 2007
Literary form
non fiction
Nature of contents
dictionaries
Series statement
For dummies
http://library.link/vocab/subjectName
Electronic spreadsheets
Label
Microsoft Office Excel 2007 data analysis for dummies, by Stephen L. Nelson, (electronic resource)
Instantiates
Publication
Note
Includes index
Carrier category
online resource
Carrier category code
cr
Content category
text
Content type code
txt
Contents
  • Excel 2007 Data Analysis For Dummies; About the Author; Author's Acknowledgments; Contents at a Glance; Table of Contents; Introduction; About This Book; What You Can Safely Ignore; What You Shouldn't Ignore (Unless You're a Masochist); Three Foolish Assumptions; How This Book Is Organized; Special Icons; Where to Next?; Part I: Where's the Beef?; Chapter 1: Introducing Excel Tables; What Is a Table and Why Do I Care?; Building Tables; Analyzing Table Information; Chapter 2: Grabbing Data from External Sources; Getting Data the Export-Import Way
  • Querying External Databases and Web Page TablesIt's Sometimes a Raw Deal; Chapter 3: Scrub-a-Dub-Dub: Cleaning Data; Editing Your Imported Workbook; Cleaning Data with Text Functions; Using Validation to Keep Data Clean; Part II: PivotTables and PivotCharts; Chapter 4: Working with PivotTables; Looking at Data from Many Angles; Getting Ready to Pivot; Running the PivotTable Wizard; Fooling Around with Your Pivot Table; Customizing How Pivot Tables Work and Look; Chapter 5: Building PivotTable Formulas; Adding Another Standard Calculation; Creating Custom Calculations
  • Using Calculated Fields and ItemsRetrieving Data from a Pivot Table; Chapter 6: Working with PivotCharts; Why Use a PivotChart?; Getting Ready to Pivot; Running the PivotTable Wizard; Fooling Around with Your Pivot Chart; Using Chart Commands to Create Pivot Charts; Chapter 7: Customizing PivotCharts; Selecting a Chart Type; Working with Chart Layouts; Working with Chart Styles; Setting Chart Options; Changing a Chart's Location; Formatting the Plot Area; Formatting the Chart Area; Formatting 3-D Charts; Part III: Advanced Tools; Chapter 8: Using the Database Functions
  • Quickly Reviewing FunctionsUsing the DAVERAGE Function; Using the DCOUNT and DCOUNTA Functions; Using the DGET Function; Using the DMAX and DMAX Functions; Using the DPRODUCT Function; Using the DSTDEV and DSTDEVP Functions; Using the DSUM Function; Using the DVAR and DVARP Functions; Chapter 9: Using the Statistics Functions; Counting Items in a Data Set; Means, Modes, and Medians; Finding Values, Ranks, and Percentiles; Standard Deviations and Variances; Normal Distributions; t-distributions; f-distributions; Binomial Distributions; Chi-Square Distributions; Regression Analysis; Correlation
  • Some Really Esoteric Probability DistributionsChapter 10: Descriptive Statistics; Using the Descriptive Statistics Tool; Creating a Histogram; Ranking by Percentile; Calculating Moving Averages; Exponential Smoothing; Generating Random Numbers; Sampling Data; Chapter 11: Inferential Statistics; Using the t-test Data Analysis Tool; Performing z-test Calculations; Creating a Scatter Plot; Using the Regression Data Analysis Tool; Using the Correlation Analysis Tool; Using the Covariance Analysis Tool; Using the ANOVA Data Analysis Tools; Creating an f-test Analysis; Using Fourier Analysis
  • Chapter 12: Optimization Modeling with Solver
Dimensions
unknown
Extent
1 online resource (386 p.)
Form of item
online
Isbn
9780470136782
Media category
computer
Media type code
c
Specific material designation
remote
System control number
  • (CKB)1000000000356896
  • (EBL)285163
  • (OCoLC)85854533
  • (SSID)ssj0000151681
  • (PQKBManifestationID)11159853
  • (PQKBTitleCode)TC0000151681
  • (PQKBWorkID)10318144
  • (PQKB)10815002
  • (MiAaPQ)EBC285163
  • (EXLCZ)991000000000356896
Label
Microsoft Office Excel 2007 data analysis for dummies, by Stephen L. Nelson, (electronic resource)
Publication
Note
Includes index
Carrier category
online resource
Carrier category code
cr
Content category
text
Content type code
txt
Contents
  • Excel 2007 Data Analysis For Dummies; About the Author; Author's Acknowledgments; Contents at a Glance; Table of Contents; Introduction; About This Book; What You Can Safely Ignore; What You Shouldn't Ignore (Unless You're a Masochist); Three Foolish Assumptions; How This Book Is Organized; Special Icons; Where to Next?; Part I: Where's the Beef?; Chapter 1: Introducing Excel Tables; What Is a Table and Why Do I Care?; Building Tables; Analyzing Table Information; Chapter 2: Grabbing Data from External Sources; Getting Data the Export-Import Way
  • Querying External Databases and Web Page TablesIt's Sometimes a Raw Deal; Chapter 3: Scrub-a-Dub-Dub: Cleaning Data; Editing Your Imported Workbook; Cleaning Data with Text Functions; Using Validation to Keep Data Clean; Part II: PivotTables and PivotCharts; Chapter 4: Working with PivotTables; Looking at Data from Many Angles; Getting Ready to Pivot; Running the PivotTable Wizard; Fooling Around with Your Pivot Table; Customizing How Pivot Tables Work and Look; Chapter 5: Building PivotTable Formulas; Adding Another Standard Calculation; Creating Custom Calculations
  • Using Calculated Fields and ItemsRetrieving Data from a Pivot Table; Chapter 6: Working with PivotCharts; Why Use a PivotChart?; Getting Ready to Pivot; Running the PivotTable Wizard; Fooling Around with Your Pivot Chart; Using Chart Commands to Create Pivot Charts; Chapter 7: Customizing PivotCharts; Selecting a Chart Type; Working with Chart Layouts; Working with Chart Styles; Setting Chart Options; Changing a Chart's Location; Formatting the Plot Area; Formatting the Chart Area; Formatting 3-D Charts; Part III: Advanced Tools; Chapter 8: Using the Database Functions
  • Quickly Reviewing FunctionsUsing the DAVERAGE Function; Using the DCOUNT and DCOUNTA Functions; Using the DGET Function; Using the DMAX and DMAX Functions; Using the DPRODUCT Function; Using the DSTDEV and DSTDEVP Functions; Using the DSUM Function; Using the DVAR and DVARP Functions; Chapter 9: Using the Statistics Functions; Counting Items in a Data Set; Means, Modes, and Medians; Finding Values, Ranks, and Percentiles; Standard Deviations and Variances; Normal Distributions; t-distributions; f-distributions; Binomial Distributions; Chi-Square Distributions; Regression Analysis; Correlation
  • Some Really Esoteric Probability DistributionsChapter 10: Descriptive Statistics; Using the Descriptive Statistics Tool; Creating a Histogram; Ranking by Percentile; Calculating Moving Averages; Exponential Smoothing; Generating Random Numbers; Sampling Data; Chapter 11: Inferential Statistics; Using the t-test Data Analysis Tool; Performing z-test Calculations; Creating a Scatter Plot; Using the Regression Data Analysis Tool; Using the Correlation Analysis Tool; Using the Covariance Analysis Tool; Using the ANOVA Data Analysis Tools; Creating an f-test Analysis; Using Fourier Analysis
  • Chapter 12: Optimization Modeling with Solver
Dimensions
unknown
Extent
1 online resource (386 p.)
Form of item
online
Isbn
9780470136782
Media category
computer
Media type code
c
Specific material designation
remote
System control number
  • (CKB)1000000000356896
  • (EBL)285163
  • (OCoLC)85854533
  • (SSID)ssj0000151681
  • (PQKBManifestationID)11159853
  • (PQKBTitleCode)TC0000151681
  • (PQKBWorkID)10318144
  • (PQKB)10815002
  • (MiAaPQ)EBC285163
  • (EXLCZ)991000000000356896

Library Locations

  • Albert D. Cohen Management LibraryBorrow it
    181 Freedman Crescent, Winnipeg, MB, R3T 5V4, CA
    49.807878 -97.129961
  • Architecture/Fine Arts LibraryBorrow it
    84 Curry Place, Winnipeg, MB, CA
    49.807716 -97.136226
  • Archives and Special CollectionsBorrow it
    25 Chancellors Circle (Elizabeth Dafoe Library), Room 330, Winnipeg, MB, R3T 2N2, CA
    49.809961 -97.131878
  • Bibliothèque Alfred-Monnin (Université de Saint-Boniface)Borrow it
    200, avenue de la Cathédrale, Local 2110, Winnipeg, MB, R2H 0H7, CA
    49.888861 -97.119735
  • Bill Larson Library (Grace Hospital)Borrow it
    300 Booth Drive, G-227, Winnipeg, MB, R3J 3M7, CA
    49.882400 -97.276436
  • Carolyn Sifton - Helene Fuld Library (St. Boniface General Hospital)Borrow it
    409 Tache Avenue, Winnipeg, MB, R2H 2A6, CA
    49.883388 -97.126050
  • Concordia Hospital LibraryBorrow it
    1095 Concordia Avenue, Winnipeg, MB, R2K 3S8, CA
    49.913252 -97.064683
  • Donald W. Craik Engineering LibraryBorrow it
    75B Chancellors Circle (Engineering Building E3), Room 361, Winnipeg, MB, R3T 2N2, CA
    49.809053 -97.133292
  • E.K. Williams Law LibraryBorrow it
    224 Dysart Road, Winnipeg, MB, R3T 5V4, CA
    49.811829 -97.131017
  • Eckhardt-Gramatté Music LibraryBorrow it
    136 Dafoe Road (Taché Arts Complex), Room 257, Winnipeg, MB, R3T 2N2, CA
    49.807964 -97.132222
  • Elizabeth Dafoe LibraryBorrow it
    25 Chancellors Circle, Winnipeg, MB, R3T 2N2, CA
    49.809961 -97.131878
  • Fr. H. Drake Library (St. Paul's College)Borrow it
    70 Dysart Road, Winnipeg, MB, R3T 2M6, CA
    49.810605 -97.138184
  • J.W. Crane Memorial Library (Deer Lodge Centre)Borrow it
    2109 Portage Avenue, Winnipeg, MB, R3J 0L3, CA
    49.878000 -97.235520
  • Libraries Annex (not open to the public; please see web page for details)Borrow it
    25 Chancellors Circle (in the Elizabeth Dafoe Library), Winnipeg, MB, R3T 2N2, CA
    49.809961 -97.131878
  • Neil John Maclean Health Sciences LibraryBorrow it
    727 McDermot Avenue (Brodie Centre), 200 Level, Winnipeg, MB, R3E 3P5, CA
    49.903563 -97.160554
  • Sciences and Technology LibraryBorrow it
    186 Dysart Road, Winnipeg, MB, R3T 2M8, CA
    49.811526 -97.133257
  • Seven Oaks General Hospital LibraryBorrow it
    2300 McPhillips Street, Winnipeg, MB, R2V 3M3, CA
    49.955177 -97.148865
  • Sister St. Odilon Library (Misericordia Health Centre)Borrow it
    99 Cornish Avenue, Winnipeg, MB, R3C 1A2, CA
    49.879592 -97.160425
  • St. John's College LibraryBorrow it
    92 Dysart Road, Winnipeg, MB, R3T 2M5, CA
    49.811242 -97.137156
  • Victoria General Hospital LibraryBorrow it
    2340 Pembina Highway, Winnipeg, MB, R3T 2E8, CA
    49.806755 -97.152739
  • William R Newman Library (Agriculture)Borrow it
    66 Dafoe Road, Winnipeg, MB, R3T 2R3, CA
    49.806936 -97.135525
Processing Feedback ...