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.
Automated data analysis using Excel / / Brian Bissett
| Automated data analysis using Excel / / Brian Bissett |
| Autore | Bissett Brian |
| Edizione | [Second edition.] |
| Pubbl/distr/stampa | Boca Raton : , : Chapman & Hall/CRC, , 2021 |
| Descrizione fisica | 1 online resource (610 pages) : illustrations |
| Disciplina | 005.1/112 |
| Collana | Chapman & hall/crc data mining & knowledge discovery series |
| Soggetto topico |
Decision making - Computer programs
Computer software - Development |
| ISBN |
1-00-305188-X
1-000-08849-9 1-003-05188-X 1-000-08847-2 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910794275103321 |
Bissett Brian
|
||
| Boca Raton : , : Chapman & Hall/CRC, , 2021 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Automated data analysis using Excel / / Brian Bissett
| Automated data analysis using Excel / / Brian Bissett |
| Autore | Bissett Brian |
| Edizione | [Second edition.] |
| Pubbl/distr/stampa | Boca Raton : , : Chapman & Hall/CRC, , 2021 |
| Descrizione fisica | 1 online resource (610 pages) : illustrations |
| Disciplina |
005.1/112
005.1 |
| Collana | Chapman & hall/crc data mining & knowledge discovery series |
| Soggetto topico |
Decision making - Computer programs
Computer software - Development |
| ISBN |
1-00-305188-X
1-000-08849-9 1-003-05188-X 1-000-08847-2 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover -- Half Title -- Series Page -- Title Page -- Copyright Page -- Dedication -- Contents -- Preface -- About the Author -- Acknowledgments -- Introduction -- It Isn't 2007 Anymore, Dorothy -- Purpose of This Text -- What Differentiates This Text from Its Competitors? -- Evolution of the Spreadsheet -- Should I Be Using Excel? What Other Options Exist? -- Scope of Coverage -- Projects Which Lead to This Text -- Before Beginning: Setting Up the Examples -- Odd Behavior in Excel to Watch Out For -- The Top Productivity Hindrances in Excel -- Final Thoughts -- Chapter 1: Customizing Excel's Ribbon Interface -- Introduction -- XML Code Structure for Creating Ribbons -- Simple Ribbon Example -- Creating an Add-In to Automatically Display Custom Ribbons When Excel Starts -- Working with Existing Ribbon Tabs, Groups, and Buttons -- Automating Code to Generate Large Complex Ribbons -- Customization of the Quick Access Toolbar -- Programming more Esoteric Ribbon Controls -- Helpful Resources for Creating Custom Ribbons -- Final Thoughts -- Chapter 2: Accessing Data in Excel: A VBA Macro Writer's Perspective -- Introduction -- The Workbook -- The Worksheet -- Ranges in Worksheets -- The Union Method for Ranges -- Using Explicit Referencing -- Rows and Columns -- Searching Worksheets - Using Find -- Finding the Next Instance of an Item -- Finding a Specific Instance of an Item -- Tokenizing an Item into an Array -- Copying, Clearing, and Deleting Data -- Sorting Data -- Sorting Data by Absolute Value -- Sorting a Range within a Worksheet -- Deleting Rows and Columns -- Deleting Hidden Rows and Columns -- Automatically Deleting Rows When a Condition is True -- Finding Duplicates -- Summary -- Chapter 3: Methods of Loading and Saving Data in Excel -- Introduction -- Processing the New File Types Present in Excel 2007 and Beyond.
Using the Standard Open File Dialog Box to Load a File -- Using the Standard Save As Dialog Box to Save a File -- Automatically Opening Files and Templates -- Importing Data to a Worksheet -- Importing a Worksheet from Another Workbook - Automatically Saving Files and Templates -- Allowing the User to Browse for a Directory -- Setting the Starting Directory for a User to Browse From -- Using the Windows Registry to Save Settings -- Determining Subfolders of a Chosen Folder -- Determining Files Within a Chosen Folder -- Practical Strategies for Dealing with Large Amounts of Data -- Creating Database "Friendly" Files -- Obtaining Drive, Directory, and File Information -- Writing Information to Excel's Status Bar -- Writing Log Files -- Summary -- Chapter 4: Control and Manipulation of Worksheet Data -- Introduction -- Scope and Use of Variables in Excel VBA -- Operating In Excel's Environment from VBA -- Utilizing Arrays to Store Data -- Passing Paramaters by Value or by Reference? -- Array Looping Structures -- Using Object Variables -- An In-Depth Look at Worksheets -- Extraction of Data Using Landmarks and Looping Structures -- Summary -- Chapter 5: Utilizing Functions in Excel -- Introduction -- Creating and Utilizing VBA Functions in Code -- Handling Errors in VBA Functions -- Adding a Function to a Worksheet Cell Using VBA Code -- Array Formulas and Overcoming the 256 Character Array Formula Limit -- Creating Additional Built in Functions for Excel -- Dynamic Formatting of Worksheets Using Functions -- Applying Dynamic Formatting using VBA -- Using the Macro Recorder to Capture Processes -- Using the Big Five Functions - Forecast, Trend, Growth, Linest, and Logest -- Creating a Linear Regression Tool Using the VBA Analysis Toolpak -- Creating a Polynomial Regression Tool Using the VBA Analysis Toolpak. Keeping VBA from Crashing During Intense Computations -- Correlation vs. Causation - Sure It Fits Well, But What Does That Mean? -- Summary -- Chapter 6: Data Mining in Excel -- Introduction -- The Terrible Truth about Colors in VBA -- Form Reuse in VBA Projects -- The Refedit Control and Its Associated Problems -- Creating a Refedit Control from a Textbox -- Highlighting and Coloring Cell Fonts and Backgrounds -- Creating a Highlight If Tool -- Creating a Color Font If Tool -- Creating a Copy If/Move If Tool -- Creating a Windowing Tool -- Linear and Nonlinear Mapping -- Using Lookup Functions - Lookup, Vlookup, Hookup, Match, Index, etc -- Automatically Loading and Extracting Data from Complex Directory Structures -- Chapter 7: Creating Custom Report Worksheets -- Introduction -- Use of Templates When Creating Custom Reports -- Preparation of Dual View Reports -- Executing Calculations Upon Changing Views -- Analysis Within Report Worksheets -- Basic Formatting Techniques -- Automatically Emailing Reports -- Summary -- Chapter 8: Introduction to Microsoft Access -- Introduction -- Elements of a Relational Database -- Connecting to an MS Access Database -- Queries: How to Retrieve Information in Database Using SQL -- Constructing a Database Query Tool -- Using Data Access Objects (DAO) to Create a New Database File from Code -- Elements in DAO Architecture -- Summary -- Chapter 9: From Excel to Access and Back Again -- Introduction -- Using Pointers in Dynamic Database Algorithms -- Concepts in Database Alteration and Management -- Creating New Tables in Access from Excel -- Adding and Removing Fields in Access Tables from Excel -- Adding Records to Specific Fields in Database Tables -- Deleting Records in Databases Using Bound Controls -- Returning the Results of a Remote Access Database Query to an Excel Worksheet -- Compacting Databases Using VBA. Summary -- Chapter 10: Analyses Via External Applications -- Introduction -- Setting Up a MATLAB Activex Server from Excel -- Matrix and Vector Building -- Defining Matrices and Vectors in MATLAB from Excel -- Using MATLAB to Perform More Advanced Forms of Regression -- The Inner Workings of the Multiple Linear Regression Example -- Interfacing Excel and Origin to Perform More Complex Analyses -- Excel to Origin DDE Example -- Interfacing Excel and Origin Using COM (Component Object Model) -- Example: Creating a COM Tool to Perform Curve Fitting Using Origin from Excel -- Opening and Plotting Excel Workbooks in Origin for Superior Graphics -- Summary -- Chapter 11: An Example ADA Application -- Introduction/Problem Definition -- A Quick Word on Six Sigma -- Dealing with the Raw Data -- Process Analysis -- The Final Report -- Saving the Final Report -- Summary of the Final Application -- Index. |
| Record Nr. | UNINA-9910814215603321 |
|
Bissett Brian
|
||
| Boca Raton : , : Chapman & Hall/CRC, , 2021 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel data analysis [[electronic resource] ] : your visual blueprint for analyzing data, charts, and pivotTables / / Paul McFedries
| Excel data analysis [[electronic resource] ] : your visual blueprint for analyzing data, charts, and pivotTables / / Paul McFedries |
| Autore | McFedries Paul |
| Edizione | [4th ed.] |
| Pubbl/distr/stampa | Indianapolis, IN, : John Wiley & Sons, c2013 |
| Descrizione fisica | 1 online resource (338 p.) |
| Disciplina | 005.54 |
| Collana | Visual Blueprint |
| Soggetto topico |
Industrial management - Statistical methods - Computer programs
Decision making - Computer programs |
| Soggetto genere / forma | Electronic books. |
| ISBN | 1-118-78193-7 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
About the Author; Table of Contents; Chapter 1: Building Formulas for Data Analysis; Introducing Data Analysis; Introducing Formulas; Understanding Formula Types; Build a Formula; Add a Range Name to a Formula; Reference Another Worksheet Range in a Formula; Move or Copy a Formula; Switc h to Absolute Cell References; Create an Array Formula; Turn On Iterative Calculations; Chapter 2: Troubleshooting Formulas; Understanding Error Values in Excel; Show Formulas Instead of Results; Use a Watch Window to Monitor a Cell Value; Step Through a Formula; Display Text Instead of Error Values
Check for Formula Errors in a WorksheetAudit a Formula to Locate Errors; Chapter 3: Enhancing Formulas with Functions; Understanding Excel Functions; Understanding Function Types; Add a Function to a Formula; Add a Row or Column of Numbers; Build an AutoSum Formula; Round a Number; Create a Conditional Formula; Calculate a Conditional Sum; Calculate a Conditional Count; Find the Square Root; Retrieve a Column or Row Number; Look Up a Value; Determine the Location of a Value; Return a Cell Value with INDEX; Perform Date and Time Calculations; Chapter 4: Analyzing Financial Data Calculate Future ValueCalculate Present Value; Determine the Loan Payments; Calculate the Principal or Interest; Find the Required Interest Rate; Determine the Internal Rate of Return; Calculate Straight-Line Depreciation; Return the Fixed-Declining Balance Depreciation; Determine the Double-Declining Balance Depreciation; Figure the Sum-of-the-Years-Digits Depreciation; Chapter 5: Analyzing Statistical Data; Calculate an Average; Calculate a Conditional Average; Determine the Median or the Mode; Find the Rank; Determine the Nth Largest or Smallest Value Create a Grouped Frequency DistributionCalculate the Variance and Standard Deviation; Find the Correlation; Chapter 6: Building Tables for Data Analysis; Understanding Tables; Introducing Table Features; Convert a Range to a Table; Select Table Data; Insert a Table Row; Insert a Table Column; Delete a Table Row; Delete a Table Column; Add a Column Subtotal; Chapter 7: Sorting and Filtering Data; Perform a Simple Sort or Filter; Perform a Multilevel Sort; Create a Custom Sort; Sort by Cell Color, Font Color, or Cell Icon; Using Quick Filters for Complex Sorting; Enter Criteria to Find Records Create an Advanced FilterDisplay Unique Records in the Filter Results; Count Filtered Records; Chapter 8: Learning Data Analysis Techniques; Highlight Cells That Meet Some Criteria; Highlight the Top or Bottom Values in a Range; Show Duplicate Values; Show Cells That Are Above or Below Average; Analyze Cell Values with Data Bars; Analyze Cell Values with Color Scales; Analyze Cell Values with Icon Sets; Create a Custom Conditional Formatting Rule; Highlight Cells Based On a Formula; Modify a Conditional Formatting Rule; Remove Conditional Formatting from a Range Remove Conditional Formatting from a Worksheet |
| Record Nr. | UNINA-9910463111403321 |
|
McFedries Paul
|
||
| Indianapolis, IN, : John Wiley & Sons, c2013 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel data analysis [[electronic resource] ] : your visual blueprint for analyzing data, charts, and pivotTables / / Paul McFedries
| Excel data analysis [[electronic resource] ] : your visual blueprint for analyzing data, charts, and pivotTables / / Paul McFedries |
| Autore | McFedries Paul |
| Edizione | [4th ed.] |
| Pubbl/distr/stampa | Indianapolis, IN, : John Wiley & Sons, c2013 |
| Descrizione fisica | 1 online resource (338 p.) |
| Disciplina | 005.54 |
| Altri autori (Persone) | EtheridgeDenise |
| Collana | Visual Blueprint |
| Soggetto topico |
Industrial management - Statistical methods - Computer programs
Decision making - Computer programs |
| ISBN | 1-118-78193-7 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
About the Author; Table of Contents; Chapter 1: Building Formulas for Data Analysis; Introducing Data Analysis; Introducing Formulas; Understanding Formula Types; Build a Formula; Add a Range Name to a Formula; Reference Another Worksheet Range in a Formula; Move or Copy a Formula; Switc h to Absolute Cell References; Create an Array Formula; Turn On Iterative Calculations; Chapter 2: Troubleshooting Formulas; Understanding Error Values in Excel; Show Formulas Instead of Results; Use a Watch Window to Monitor a Cell Value; Step Through a Formula; Display Text Instead of Error Values
Check for Formula Errors in a WorksheetAudit a Formula to Locate Errors; Chapter 3: Enhancing Formulas with Functions; Understanding Excel Functions; Understanding Function Types; Add a Function to a Formula; Add a Row or Column of Numbers; Build an AutoSum Formula; Round a Number; Create a Conditional Formula; Calculate a Conditional Sum; Calculate a Conditional Count; Find the Square Root; Retrieve a Column or Row Number; Look Up a Value; Determine the Location of a Value; Return a Cell Value with INDEX; Perform Date and Time Calculations; Chapter 4: Analyzing Financial Data Calculate Future ValueCalculate Present Value; Determine the Loan Payments; Calculate the Principal or Interest; Find the Required Interest Rate; Determine the Internal Rate of Return; Calculate Straight-Line Depreciation; Return the Fixed-Declining Balance Depreciation; Determine the Double-Declining Balance Depreciation; Figure the Sum-of-the-Years-Digits Depreciation; Chapter 5: Analyzing Statistical Data; Calculate an Average; Calculate a Conditional Average; Determine the Median or the Mode; Find the Rank; Determine the Nth Largest or Smallest Value Create a Grouped Frequency DistributionCalculate the Variance and Standard Deviation; Find the Correlation; Chapter 6: Building Tables for Data Analysis; Understanding Tables; Introducing Table Features; Convert a Range to a Table; Select Table Data; Insert a Table Row; Insert a Table Column; Delete a Table Row; Delete a Table Column; Add a Column Subtotal; Chapter 7: Sorting and Filtering Data; Perform a Simple Sort or Filter; Perform a Multilevel Sort; Create a Custom Sort; Sort by Cell Color, Font Color, or Cell Icon; Using Quick Filters for Complex Sorting; Enter Criteria to Find Records Create an Advanced FilterDisplay Unique Records in the Filter Results; Count Filtered Records; Chapter 8: Learning Data Analysis Techniques; Highlight Cells That Meet Some Criteria; Highlight the Top or Bottom Values in a Range; Show Duplicate Values; Show Cells That Are Above or Below Average; Analyze Cell Values with Data Bars; Analyze Cell Values with Color Scales; Analyze Cell Values with Icon Sets; Create a Custom Conditional Formatting Rule; Highlight Cells Based On a Formula; Modify a Conditional Formatting Rule; Remove Conditional Formatting from a Range Remove Conditional Formatting from a Worksheet |
| Record Nr. | UNINA-9910787563703321 |
|
McFedries Paul
|
||
| Indianapolis, IN, : John Wiley & Sons, c2013 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel data analysis : your visual blueprint for analyzing data, charts, and pivotTables / / Paul McFedries
| Excel data analysis : your visual blueprint for analyzing data, charts, and pivotTables / / Paul McFedries |
| Autore | McFedries Paul |
| Edizione | [4th ed.] |
| Pubbl/distr/stampa | Indianapolis, IN, : John Wiley & Sons, c2013 |
| Descrizione fisica | 1 online resource (338 p.) |
| Disciplina | 005.54 |
| Collana | Visual Blueprint |
| Soggetto topico |
Industrial management - Statistical methods - Computer programs
Decision making - Computer programs |
| ISBN | 1-118-78193-7 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
About the Author; Table of Contents; Chapter 1: Building Formulas for Data Analysis; Introducing Data Analysis; Introducing Formulas; Understanding Formula Types; Build a Formula; Add a Range Name to a Formula; Reference Another Worksheet Range in a Formula; Move or Copy a Formula; Switc h to Absolute Cell References; Create an Array Formula; Turn On Iterative Calculations; Chapter 2: Troubleshooting Formulas; Understanding Error Values in Excel; Show Formulas Instead of Results; Use a Watch Window to Monitor a Cell Value; Step Through a Formula; Display Text Instead of Error Values
Check for Formula Errors in a WorksheetAudit a Formula to Locate Errors; Chapter 3: Enhancing Formulas with Functions; Understanding Excel Functions; Understanding Function Types; Add a Function to a Formula; Add a Row or Column of Numbers; Build an AutoSum Formula; Round a Number; Create a Conditional Formula; Calculate a Conditional Sum; Calculate a Conditional Count; Find the Square Root; Retrieve a Column or Row Number; Look Up a Value; Determine the Location of a Value; Return a Cell Value with INDEX; Perform Date and Time Calculations; Chapter 4: Analyzing Financial Data Calculate Future ValueCalculate Present Value; Determine the Loan Payments; Calculate the Principal or Interest; Find the Required Interest Rate; Determine the Internal Rate of Return; Calculate Straight-Line Depreciation; Return the Fixed-Declining Balance Depreciation; Determine the Double-Declining Balance Depreciation; Figure the Sum-of-the-Years-Digits Depreciation; Chapter 5: Analyzing Statistical Data; Calculate an Average; Calculate a Conditional Average; Determine the Median or the Mode; Find the Rank; Determine the Nth Largest or Smallest Value Create a Grouped Frequency DistributionCalculate the Variance and Standard Deviation; Find the Correlation; Chapter 6: Building Tables for Data Analysis; Understanding Tables; Introducing Table Features; Convert a Range to a Table; Select Table Data; Insert a Table Row; Insert a Table Column; Delete a Table Row; Delete a Table Column; Add a Column Subtotal; Chapter 7: Sorting and Filtering Data; Perform a Simple Sort or Filter; Perform a Multilevel Sort; Create a Custom Sort; Sort by Cell Color, Font Color, or Cell Icon; Using Quick Filters for Complex Sorting; Enter Criteria to Find Records Create an Advanced FilterDisplay Unique Records in the Filter Results; Count Filtered Records; Chapter 8: Learning Data Analysis Techniques; Highlight Cells That Meet Some Criteria; Highlight the Top or Bottom Values in a Range; Show Duplicate Values; Show Cells That Are Above or Below Average; Analyze Cell Values with Data Bars; Analyze Cell Values with Color Scales; Analyze Cell Values with Icon Sets; Create a Custom Conditional Formatting Rule; Highlight Cells Based On a Formula; Modify a Conditional Formatting Rule; Remove Conditional Formatting from a Range Remove Conditional Formatting from a Worksheet |
| Record Nr. | UNINA-9910808633503321 |
|
McFedries Paul
|
||
| Indianapolis, IN, : John Wiley & Sons, c2013 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Pre-conflict management tools [[electronic resource] ] : winning the peace / / Aaron B. Frank
| Pre-conflict management tools [[electronic resource] ] : winning the peace / / Aaron B. Frank |
| Autore | Frank Aaron B |
| Pubbl/distr/stampa | [Washington, D.C.] : , : Center for Technology and National Security Policy, National Defense University, , [2005] |
| Descrizione fisica | vi, 31 pages : digital, PDF file |
| Collana | [Defense & technology papers |
| Soggetto topico |
Failed states - Computer programs
Conflict management - Computer programs Political science - Computer programs Decision making - Computer programs |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Altri titoli varianti | Pre-conflict management tools |
| Record Nr. | UNINA-9910697570203321 |
|
Frank Aaron B
|
||
| [Washington, D.C.] : , : Center for Technology and National Security Policy, National Defense University, , [2005] | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
