000			08645nam a22005053i 4500
001			EBC6272890
003			MiAaPQ
005			20240724114427.0
006			m o d |
007			cr cnu||||||||
008			240724s2020 xx o ||||0 eng d
020			_a9781000088472 _q(electronic bk.)
020			_z9780367509316
035			_a(MiAaPQ)EBC6272890
035			_a(Au-PeEL)EBL6272890
035			_a(OCoLC)1181844710
040			_aMiAaPQ _beng _erda _epn _cMiAaPQ _dMiAaPQ
050		4	_aQA76.76.D47 .B577 2020
082	0		_a005.3
100	1		_aBissett, Brian D.
245	1	0	_aAutomated Data Analysis Using Excel.
250			_a2nd ed.
264		1	_aMilton : _bCRC Press LLC, _c2020.
264		4	_c©2020.
300			_a1 online resource (610 pages)
336			_atext _btxt _2rdacontent
337			_acomputer _bc _2rdamedia
338			_aonline resource _bcr _2rdacarrier
490	1		_aChapman and Hall/CRC Data Mining and Knowledge Discovery Series
505	0		_aCover -- 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		_aUsing 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		_aKeeping 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		_aSummary -- 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			_aThis 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			_aDescription based on publisher supplied metadata and other sources.
590			_aElectronic 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	_aMicrosoft Excel (Computer file).
650		0	_aDecision making-Computer programs.
650		0	_aComputer software-Development.
655		4	_aElectronic books.
776	0	8	_iPrint version: _aBissett, Brian D. _tAutomated Data Analysis Using Excel _dMilton : CRC Press LLC,c2020 _z9780367509316
797	2		_aProQuest (Firm)
830		0	_aChapman and Hall/CRC Data Mining and Knowledge Discovery Series
856	4	0	_uhttps://ebookcentral.proquest.com/lib/orpp/detail.action?docID=6272890 _zClick to View
999			_c19670 _d19670