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 |
Tabla de Contenidos:
- 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