Automated Data Analysis Using Excel. (Record no. 19670)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 08645nam a22005053i 4500 |
| 001 - CONTROL NUMBER | |
| control field | EBC6272890 |
| 003 - CONTROL NUMBER IDENTIFIER | |
| control field | MiAaPQ |
| 005 - DATE AND TIME OF LATEST TRANSACTION | |
| control field | 20240724114427.0 |
| 006 - FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS | |
| fixed length control field | m o d | |
| 007 - PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION | |
| fixed length control field | cr cnu|||||||| |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 240724s2020 xx o ||||0 eng d |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9781000088472 |
| Qualifying information | (electronic bk.) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| Canceled/invalid ISBN | 9780367509316 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (MiAaPQ)EBC6272890 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (Au-PeEL)EBL6272890 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (OCoLC)1181844710 |
| 040 ## - CATALOGING SOURCE | |
| Original cataloging agency | MiAaPQ |
| Language of cataloging | eng |
| Description conventions | rda |
| -- | pn |
| Transcribing agency | MiAaPQ |
| Modifying agency | MiAaPQ |
| 050 #4 - LIBRARY OF CONGRESS CALL NUMBER | |
| Classification number | QA76.76.D47 .B577 2020 |
| 082 0# - DEWEY DECIMAL CLASSIFICATION NUMBER | |
| Classification number | 005.3 |
| 100 1# - MAIN ENTRY--PERSONAL NAME | |
| Personal name | Bissett, Brian D. |
| 245 10 - TITLE STATEMENT | |
| Title | Automated Data Analysis Using Excel. |
| 250 ## - EDITION STATEMENT | |
| Edition statement | 2nd ed. |
| 264 #1 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE | |
| Place of production, publication, distribution, manufacture | Milton : |
| Name of producer, publisher, distributor, manufacturer | CRC Press LLC, |
| Date of production, publication, distribution, manufacture, or copyright notice | 2020. |
| 264 #4 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE | |
| Date of production, publication, distribution, manufacture, or copyright notice | ©2020. |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | 1 online resource (610 pages) |
| 336 ## - CONTENT TYPE | |
| Content type term | text |
| Content type code | txt |
| Source | rdacontent |
| 337 ## - MEDIA TYPE | |
| Media type term | computer |
| Media type code | c |
| Source | rdamedia |
| 338 ## - CARRIER TYPE | |
| Carrier type term | online resource |
| Carrier type code | cr |
| Source | rdacarrier |
| 490 1# - SERIES STATEMENT | |
| Series statement | Chapman and Hall/CRC Data Mining and Knowledge Discovery Series |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | 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. |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | 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. |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | 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. |
| 505 8# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | 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. |
| 520 ## - SUMMARY, ETC. | |
| Summary, etc. | This new edition includes some key topics relating to the latest version of MS Office, including use of the ribbon, current Excel file types, Dashboard, and basic Sharepoint integration. It shows how to automate operations, such as curve fitting, sorting, filtering, and analyzing data from a variety of sources. |
| 588 ## - SOURCE OF DESCRIPTION NOTE | |
| Source of description note | Description based on publisher supplied metadata and other sources. |
| 590 ## - LOCAL NOTE (RLIN) | |
| Local note | Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2024. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Microsoft Excel (Computer file). |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Decision making-Computer programs. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Computer software-Development. |
| 655 #4 - INDEX TERM--GENRE/FORM | |
| Genre/form data or focus term | Electronic books. |
| 776 08 - ADDITIONAL PHYSICAL FORM ENTRY | |
| Relationship information | Print version: |
| Main entry heading | Bissett, Brian D. |
| Title | Automated Data Analysis Using Excel |
| Place, publisher, and date of publication | Milton : CRC Press LLC,c2020 |
| International Standard Book Number | 9780367509316 |
| 797 2# - LOCAL ADDED ENTRY--CORPORATE NAME (RLIN) | |
| Corporate name or jurisdiction name as entry element | ProQuest (Firm) |
| 830 #0 - SERIES ADDED ENTRY--UNIFORM TITLE | |
| Uniform title | Chapman and Hall/CRC Data Mining and Knowledge Discovery Series |
| 856 40 - ELECTRONIC LOCATION AND ACCESS | |
| Uniform Resource Identifier | <a href="https://ebookcentral.proquest.com/lib/orpp/detail.action?docID=6272890">https://ebookcentral.proquest.com/lib/orpp/detail.action?docID=6272890</a> |
| Public note | Click to View |
No items available.