Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
Excel data analysis for dummies / / by Paul McFedries
| Excel data analysis for dummies / / by Paul McFedries |
| Autore | McFedries Paul |
| Edizione | [5th ed] |
| Pubbl/distr/stampa | Hoboken, N.J., : John Wiley & Sons, c2022 |
| Descrizione fisica | 1 online resource (346 pages) |
| Disciplina | 005.369 |
| Collana | --For dummies |
| Soggetto topico | Electronic spreadsheets -- Computer programs |
| ISBN |
1-119-84447-9
1-119-84446-0 9781119844464 |
| Classificazione |
007.63
005.54 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9911096732803321 |
McFedries Paul
|
||
| Hoboken, N.J., : John Wiley & Sons, c2022 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel data analysis for dummies / / by Paul McFedries
| Excel data analysis for dummies / / by Paul McFedries |
| Autore | McFedries Paul |
| Edizione | [5th ed] |
| Pubbl/distr/stampa | Wiley, 2022 |
| Descrizione fisica | 1 online resource (346 pages) |
| Disciplina | 005.369 |
| Collana | --For dummies |
| Soggetto topico | Electronic spreadsheets -- Computer programs |
| ISBN |
1-119-84447-9
1-119-84446-0 9781119844464 |
| Classificazione |
007.63
005.54 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Introduction Part 1: Getting Started with Data Analysis Part 2: Analyzing Data Using PivotTables and PivotCharts Part 3: Discovering Advanced Data-Analysis Tools Part 4: The Part of Tens Author Bio Advertisement Page Connect with Dummies End User License Agreement |
| Record Nr. | UNINA-9911152588203321 |
|
McFedries Paul
|
||
| Wiley, 2022 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel data analysis for dummies / / by Stephen L. Nelson and E.C. Nelson
| Excel data analysis for dummies / / by Stephen L. Nelson and E.C. Nelson |
| Edizione | [2nd ed] |
| Pubbl/distr/stampa | Hoboken, N.J., : Wiley, c2014 |
| Descrizione fisica | 1 online resource (363 p.) |
| Disciplina | 005.54 |
| Collana | --For dummies |
| Soggetto topico | Electronic spreadsheets -- Computer programs |
| ISBN |
1-118-89810-9
9781118898109 |
| Classificazione |
007.63
005.54 |
| 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-9911095562103321 |
| Hoboken, N.J., : Wiley, c2014 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel data analysis for dummies / / by Stephen L. Nelson and E.C. Nelson
| Excel data analysis for dummies / / by Stephen L. Nelson and E.C. Nelson |
| Edizione | [2nd ed] |
| Pubbl/distr/stampa | Hoboken, N.J., : Wiley, c2014 |
| Descrizione fisica | 1 online resource (363 p.) |
| Disciplina | 005.54 |
| Collana | --For dummies |
| Soggetto topico | Electronic spreadsheets -- Computer programs |
| ISBN |
1-118-89810-9
9781118898109 |
| Classificazione |
007.63
005.54 |
| 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-9911134336603321 |
| Hoboken, N.J., : Wiley, c2014 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel formulas & functions for dummies / / by Ken Bluttman
| Excel formulas & functions for dummies / / by Ken Bluttman |
| Edizione | [6th ed] |
| Pubbl/distr/stampa | Hoboken, N.J., : John Wiley & Sons, c2022 |
| Descrizione fisica | 1 online resource (419 pages) |
| Disciplina | 005.369 |
| Collana | --For dummies |
| Soggetto topico | Electronic spreadsheets -- Computer programs |
| ISBN |
1-119-83913-0
1-119-83912-2 9781119839125 |
| Classificazione |
007.63
005.54 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9911104176603321 |
| Hoboken, N.J., : John Wiley & Sons, c2022 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel formulas & functions for dummies / / by Ken Bluttman
| Excel formulas & functions for dummies / / by Ken Bluttman |
| Edizione | [6th ed] |
| Pubbl/distr/stampa | Hoboken, N.J., : John Wiley & Sons, c2022 |
| Descrizione fisica | 1 online resource (419 pages) |
| Disciplina | 005.369 |
| Collana | --For dummies |
| Soggetto topico | Electronic spreadsheets -- Computer programs |
| ISBN |
1-119-83913-0
1-119-83912-2 9781119839125 |
| Classificazione |
007.63
005.54 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9911152957003321 |
| Hoboken, N.J., : John Wiley & Sons, c2022 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel macros for dummies / / by Dick Kusleika
| Excel macros for dummies / / by Dick Kusleika |
| Autore | Kusleika Dick |
| Edizione | [3rd ed] |
| Pubbl/distr/stampa | Wiley, 2022 |
| Descrizione fisica | 1 online resource (307 pages) |
| Disciplina | 005.369 |
| Collana | --For dummies |
| Soggetto topico |
Electronic spreadsheets -- Computer programs
Macro instructions (Electronic computers) |
| ISBN |
1-119-84445-2
1-119-84444-4 9781119844440 |
| Classificazione |
007.63
005.54 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Macro fundamentals -- Getting cozy with the Visual Basic editor -- The anatomy of macros -- Working with workbooks -- Working with worksheets -- Feeling at home on the range -- Manipulating data with macros -- Automating common reporting tasks -- Sending emails from Excel -- Wrangling external data with macros -- Ten handy Visual Basic editor tips -- Ten places to turn for macro help -- Ten ways to speed up your macros. |
| Record Nr. | UNINA-9911153886803321 |
|
Kusleika Dick
|
||
| Wiley, 2022 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel macros for dummies / / by Dick Kusleika
| Excel macros for dummies / / by Dick Kusleika |
| Edizione | [3rd ed] |
| Pubbl/distr/stampa | Hoboken, N.J., : John Wiley & Sons, c2022 |
| Descrizione fisica | 1 online resource (307 pages) |
| Disciplina | 005.369 |
| Collana | --For dummies |
| Soggetto topico |
Electronic spreadsheets -- Computer programs
Macro instructions (Electronic computers) |
| ISBN |
1-119-84445-2
1-119-84444-4 9781119844440 |
| Classificazione |
007.63
005.54 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Macro fundamentals -- Getting cozy with the Visual Basic editor -- The anatomy of macros -- Working with workbooks -- Working with worksheets -- Feeling at home on the range -- Manipulating data with macros -- Automating common reporting tasks -- Sending emails from Excel -- Wrangling external data with macros -- Ten handy Visual Basic editor tips -- Ten places to turn for macro help -- Ten ways to speed up your macros. |
| Record Nr. | UNINA-9911095317703321 |
| Hoboken, N.J., : John Wiley & Sons, c2022 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel VBA programming for dummies / / by Dick Kusleika
| Excel VBA programming for dummies / / by Dick Kusleika |
| Edizione | [6th ed] |
| Pubbl/distr/stampa | Hoboken, N.J., : John Wiley & Sons, c2022 |
| Descrizione fisica | 1 online resource (435 pages) |
| Disciplina | 005.369 |
| Collana | --For dummies |
| Soggetto topico |
Visual Basic for Applications (Computer program language)
Electronic spreadsheets -- Computer programs |
| ISBN |
1-119-84308-1
1-119-84309-X 9781119843085 |
| Classificazione |
007.64
005.369 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9911098484003321 |
| Hoboken, N.J., : John Wiley & Sons, c2022 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel VBA programming for dummies / / by Dick Kusleika
| Excel VBA programming for dummies / / by Dick Kusleika |
| Edizione | [6th ed] |
| Pubbl/distr/stampa | Hoboken, N.J., : John Wiley & Sons, c2022 |
| Descrizione fisica | 1 online resource (435 pages) |
| Disciplina | 005.369 |
| Collana | --For dummies |
| Soggetto topico |
Visual Basic for Applications (Computer program language)
Electronic spreadsheets -- Computer programs |
| ISBN |
1-119-84308-1
1-119-84309-X 9781119843085 |
| Classificazione |
007.64
005.369 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9911152479103321 |
| Hoboken, N.J., : John Wiley & Sons, c2022 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
