Picture 1 of 5




Gallery
Picture 1 of 5





Have one to sell?
Automated Data Analysis Using Excel by Brian D. Bissett. SEALED FREE SHIPPING
US $107.96
Was US $119.95 (10% off)
as low as $36.83/mo with
Condition:
Oops! Looks like we're having trouble connecting to our server.
Refresh your browser window to try again.
Shipping:
Free USPS Media MailTM.
Located in: Lakeland, Florida, United States
Delivery:
Estimated between Thu, Dec 11 and Tue, Dec 16 to 94104
Returns:
30 days returns. Buyer pays for return shipping. If you use an eBay shipping label, it will be deducted from your refund amount.
Payments:
.
Special financing available. See terms and apply now- for PayPal Credit, opens in a new window or tab
Earn up to 5x points when you use your eBay Mastercard®. Learn moreabout earning points with eBay Mastercard
Shop with confidence
About this item
Seller assumes all responsibility for this listing.
eBay item number:316817846626
Item specifics
- Condition
- Publication Date
- 2020-08-19
- Book Title
- Automated Data Analysis Using Excel
- Edition Number
- 2
- ISBN
- 9780367509316
- Subject Area
- Computers, Education, Business & Economics
- Publication Name
- Automated Data Analysis Using Excel
- Publisher
- CRC Press LLC
- Item Length
- 10 in
- Subject
- Programming / Games, Computer Graphics, Software Development & Engineering / General, Decision-Making & Problem Solving, Desktop Applications / Spreadsheets, Statistics
- Publication Year
- 2020
- Series
- Chapman and Hall/Crc Data Mining and Knowledge Discovery Ser.
- Type
- Textbook
- Format
- Hardcover
- Language
- English
- Item Weight
- 45.7 Oz
- Item Width
- 7 in
- Number of Pages
- 592 Pages
About this product
Product Identifiers
Publisher
CRC Press LLC
ISBN-10
0367509318
ISBN-13
9780367509316
eBay Product ID (ePID)
16050064644
Product Key Features
Number of Pages
592 Pages
Publication Name
Automated Data Analysis Using Excel
Language
English
Subject
Programming / Games, Computer Graphics, Software Development & Engineering / General, Decision-Making & Problem Solving, Desktop Applications / Spreadsheets, Statistics
Publication Year
2020
Type
Textbook
Subject Area
Computers, Education, Business & Economics
Series
Chapman and Hall/Crc Data Mining and Knowledge Discovery Ser.
Format
Hardcover
Dimensions
Item Weight
45.7 Oz
Item Length
10 in
Item Width
7 in
Additional Product Features
Edition Number
2
Intended Audience
Scholarly & Professional
LCCN
2020-014153
Dewey Edition
22
Illustrated
Yes
Dewey Decimal
005.3
Table Of Content
Preface. About the Author. Acknowledgments. Introduction . Chapter 1 Customizing Excel's Ribbon Interface. Chapter 2 Accessing Data in Excel: A VBA Macro Writer's Perspective. Chapter 3 Methods of Loading and Saving Data in Excel. Chapter 4 Control and Manipulation of Worksheet Data. Chapter 5 Utilizing Functions in Excel. Chapter 6 Data Mining in Excel. Chapter 7 Creating Custom Report Worksheets. Chapter 8 Introduction to Microsoft Access. Chapter 9 From Excel to Access and Back Again. Chapter 10 Analyses Via External Applications. Chapter 11 An Example ADA Application. Index.
Synopsis
This new edition covers some of the key topics relating to the latest version of MS Office through Excel 2019, including the creation of custom ribbons by injecting XML code into Excel Workbooks and how to link Excel VBA macros to customize ribbon objects. It now also provides examples in using ADO, DAO, and SQL queries to retrieve data from databases for analysis. Operations such as fully automated linear and non-linear curve fitting, linear and non-linear mapping, charting, plotting, sorting, and filtering of data have been updated to leverage the newest Excel VBA object models. The text provides examples on automated data analysis and the preparation of custom reports suitable for legal archiving and dissemination. Functionality Demonstrated in This Edition Includes: Find and extract information raw data files Format data in color (conditional formatting) Perform non-linear and linear regressions on data Create custom functions for specific applications Generate datasets for regressions and functions Create custom reports for regulatory agencies Leverage email to send generated reports Return data to Excel using ADO, DAO, and SQL queries Create database files for processed data Create tables, records, and fields in databases Add data to databases in fields or records Leverage external computational engines Call functions in MATLAB(R) and Origin(R) from Excel, This new edition covers some of the key topics relating to the latest version of MS Office through Excel 2019, including the creation of custom ribbons by injecting XML code into Excel Workbooks and how to link Excel VBA macros to customize ribbon objects. It now also provides examples in using ADO, DAO, and SQL queries to retrieve data from databases for analysis. Operations such as fully automated linear and non-linear curve fitting, linear and non-linear mapping, charting, plotting, sorting, and filtering of data have been updated to leverage the newest Excel VBA object models. The text provides examples on automated data analysis and the preparation of custom reports suitable for legal archiving and dissemination. Functionality Demonstrated in This Edition Includes: Find and extract information raw data files Format data in color (conditional formatting) Perform non-linear and linear regressions on data Create custom functions for specific applications Generate datasets for regressions and functions Create custom reports for regulatory agencies Leverage email to send generated reports Return data to Excel using ADO, DAO, and SQL queries Create database files for processed data Create tables, records, and fields in databases Add data to databases in fields or records Leverage external computational engines Call functions in MATLAB® and Origin® from 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 variety of sources.
LC Classification Number
QA76.76.D47B575 2020
Item description from the seller
Popular categories from this store
Seller feedback (3,039)
- 0***1 (252)- Feedback left by buyer.Past 6 monthsVerified purchaseProduct was exactly as described. Item arrived quickly and was packaged with care. Great communication, answered questions quickly. Would recommend this seller.
- p***4 (444)- Feedback left by buyer.Past 6 monthsVerified purchaseAs described. Great price. Well-packed and speedy delivery. Thanks.
- 4***u (99)- Feedback left by buyer.Past 6 monthsVerified purchaseGreat seller! Would recommend and will be a return buyer! Item arrived pretty quick, it’s exactly as advertised, and was packaged very well.YU-GI-OH! KAIRYU-SHIN 2" Figure Series 8 With Holo Tile MATTEL. BOX DAMAGE (#315770333393)
More to explore :
- Nonfiction Books Fiction & Ships,
- History Nonfiction Books & Fiction Ships,
- Nonfiction Ships Paperbacks Books,
- Transportation Nonfiction Books Fiction & Ships,
- Fiction Books & Brian Jacques Fiction,
- Fiction Books & Brian Herbert Fiction,
- Brian Jacques Hardcover Illustrated Fiction Books,
- Brian Jacques Fantasy Fiction Fiction & Books,
- US Weekly Magazines,
- Brian Herbert Science Fiction Fiction Fiction & Books


