Cargando…
Automated data analysis using Excel /
"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 v...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Boca Raton, FL :
CRC Press,
2021.
|
| Edición: | Second edition. |
| Colección: | Chapman & Hall/CRC data mining and knowledge discovery series.
|
| Temas: | |
| Acceso en línea: | Texto completo |
MARC
| LEADER | 00000cam a2200000 i 4500 | ||
|---|---|---|---|
| 001 | EBOOKCENTRAL_on1181844710 | ||
| 003 | OCoLC | ||
| 005 | 20240329122006.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 200801s2021 flua o 000 0 eng d | ||
| 040 | |a EBLCP |b eng |e rda |e pn |c EBLCP |d YDX |d OCLCF |d OCLCQ |d OCLCO |d REDDC |d OCLCL | ||
| 020 | |a 9781000088472 |q (electronic book) | ||
| 020 | |a 1000088472 |q (electronic book) | ||
| 020 | |a 9781003051886 |q (electronic book) | ||
| 020 | |a 100305188X |q (electronic book) | ||
| 035 | |a (OCoLC)1181844710 | ||
| 050 | 4 | |a QA76.76.D47 |b B575 2021 | |
| 082 | 0 | 4 | |a 005.1/112 |2 23 |
| 082 | 0 | 4 | |a 005.3 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Bissett, Brian, |e author. | |
| 245 | 1 | 0 | |a Automated data analysis using Excel / |c Brian D. Bissett. |
| 250 | |a Second edition. | ||
| 264 | 1 | |a Boca Raton, FL : |b CRC Press, |c 2021. | |
| 300 | |a 1 online resource (xviii, 591 pages) : |b illustrations | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 490 | 1 | |a Chapman & Hall/CRC data mining and knowledge discovery series | |
| 588 | 0 | |a Print version record. | |
| 505 | 0 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 500 | |a Extraction of Data Using Landmarks and Looping Structures | ||
| 588 | 0 | |a Online resource; title from digital title page (viewed on August 06, 2020). | |
| 520 | |a "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. The book allows users to analyze data and automate the preparation of custom reports and demonstrates how to assign Excel VBA code to the new "Ribbon" user interface"-- |c Provided by publisher. | ||
| 590 | |a ProQuest Ebook Central |b Ebook Central Academic Complete | ||
| 630 | 0 | 0 | |a Microsoft Excel (Computer file) |
| 630 | 0 | 7 | |a Microsoft Excel (Computer file) |2 fast |
| 650 | 0 | |a Computer software |x Development. | |
| 650 | 0 | |a Decision making |x Computer programs. | |
| 650 | 6 | |a Prise de décision |x Logiciels. | |
| 650 | 7 | |a Computer software |x Development |2 fast | |
| 650 | 7 | |a Decision making |x Computer programs |2 fast | |
| 758 | |i has work: |a Automated data analysis using Excel (Text) |1 https://id.oclc.org/worldcat/entity/E39PCFMmDjVTrrDDMD3XgVCjT3 |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version: |a Bissett, Brian D. |t Automated Data Analysis Using Excel. |d Milton : CRC Press LLC, ©2020 |z 9780367509316 |
| 830 | 0 | |a Chapman & Hall/CRC data mining and knowledge discovery series. | |
| 856 | 4 | 0 | |u https://ebookcentral.uam.elogim.com/lib/uam-ebooks/detail.action?docID=6272890 |z Texto completo |
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL6272890 | ||
| 938 | |a YBP Library Services |b YANK |n 16876315 | ||
| 994 | |a 92 |b IZTAP | ||