Excel data analysis for dummies / / by Stephen L. Nelson and E. C. Nelson |
Autore | Nelson Stephen L. |
Edizione | [Second edition.] |
Pubbl/distr/stampa | Hoboken, New Jersey : , : John Wiley & Sons, , 2014 |
Descrizione fisica | 1 online resource (363 p.) |
Disciplina | 005.54 |
Collana | For Dummies |
Soggetto topico |
Statistics - Data processing
Statistics - Computer programs |
Soggetto genere / forma | Electronic books. |
ISBN | 1-118-89810-9 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Title Page; Copyright Page; 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); Foolish Assumptions; How This Book Is Organized; Icons Used in This Book; Beyond the Book; Where to Go from Here; 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 Tables
It's Sometimes a Raw DealChapter 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 Items; Retrieving Data from a Pivot Table Chapter 6: Working with PivotChartsWhy Use a Pivot Chart?; 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 Styles; Changing Chart Layout; 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 Functions; Using the DAVERAGE Function; Using the DCOUNT and DCOUNTA Functions Using the DGET FunctionUsing 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 Distributions; Chapter 10: Descriptive Statistics Using the Descriptive Statistics ToolCreating 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; Understanding Optimization Modeling Setting Up a Solver Worksheet |
Record Nr. | UNINA-9910453567003321 |
Nelson Stephen L. | ||
Hoboken, New Jersey : , : John Wiley & Sons, , 2014 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Excel data analysis for dummies / / by Stephen L. Nelson and E. C. Nelson |
Autore | Nelson Stephen L. |
Edizione | [Second edition.] |
Pubbl/distr/stampa | Hoboken, New Jersey : , : John Wiley & Sons, , 2014 |
Descrizione fisica | 1 online resource (363 p.) |
Disciplina | 005.54 |
Collana | For Dummies |
Soggetto topico |
Statistics - Data processing
Statistics - Computer programs |
ISBN | 1-118-89810-9 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Title Page; Copyright Page; 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); Foolish Assumptions; How This Book Is Organized; Icons Used in This Book; Beyond the Book; Where to Go from Here; 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 Tables
It's Sometimes a Raw DealChapter 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 Items; Retrieving Data from a Pivot Table Chapter 6: Working with PivotChartsWhy Use a Pivot Chart?; 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 Styles; Changing Chart Layout; 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 Functions; Using the DAVERAGE Function; Using the DCOUNT and DCOUNTA Functions Using the DGET FunctionUsing 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 Distributions; Chapter 10: Descriptive Statistics Using the Descriptive Statistics ToolCreating 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; Understanding Optimization Modeling Setting Up a Solver Worksheet |
Record Nr. | UNINA-9910790926503321 |
Nelson Stephen L. | ||
Hoboken, New Jersey : , : John Wiley & Sons, , 2014 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Excel data analysis for dummies / / by Stephen L. Nelson and E. C. Nelson |
Autore | Nelson Stephen L. |
Edizione | [Second edition.] |
Pubbl/distr/stampa | Hoboken, New Jersey : , : John Wiley & Sons, , 2014 |
Descrizione fisica | 1 online resource (363 p.) |
Disciplina | 005.54 |
Collana | For Dummies |
Soggetto topico |
Statistics - Data processing
Statistics - Computer programs |
ISBN | 1-118-89810-9 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Title Page; Copyright Page; 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); Foolish Assumptions; How This Book Is Organized; Icons Used in This Book; Beyond the Book; Where to Go from Here; 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 Tables
It's Sometimes a Raw DealChapter 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 Items; Retrieving Data from a Pivot Table Chapter 6: Working with PivotChartsWhy Use a Pivot Chart?; 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 Styles; Changing Chart Layout; 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 Functions; Using the DAVERAGE Function; Using the DCOUNT and DCOUNTA Functions Using the DGET FunctionUsing 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 Distributions; Chapter 10: Descriptive Statistics Using the Descriptive Statistics ToolCreating 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; Understanding Optimization Modeling Setting Up a Solver Worksheet |
Record Nr. | UNINA-9910809370903321 |
Nelson Stephen L. | ||
Hoboken, New Jersey : , : John Wiley & Sons, , 2014 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
QuickBooks 2017 : all-in-one / / by Stephen L. Nelson, MBA, CPA, MS |
Autore | Nelson Stephen L. |
Edizione | [1st edition] |
Pubbl/distr/stampa | Hoboken, New Jersey : , : John Wiley & Sons, Ltd, , 2017 |
Descrizione fisica | 1 online resource (627 pages) : illustrations |
Disciplina | 657.904202855369 |
Collana | For Dummies |
Soggetto topico |
Small business - Accounting - Computer programs
Small business - Finance - Computer programs |
ISBN |
1-119-28136-9
1-119-28135-0 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | Introduction -- An Accounting Primer -- Getting Ready to Use QuickBooks -- Bookkeeping Chores -- Accounting Chores -- Financial Management -- Business Plans -- Care and Maintenance -- Appendixes -- Index. |
Record Nr. | UNINA-9910150331203321 |
Nelson Stephen L. | ||
Hoboken, New Jersey : , : John Wiley & Sons, Ltd, , 2017 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|