|
Books > Computing & IT > Applications of computing > Databases > Data capture & analysis
|
Buy Now
Automated Data Analysis Using Excel (Hardcover, 2nd edition)
Loot Price: R5,134
Discovery Miles 51 340
|
|
|
Automated Data Analysis Using Excel (Hardcover, 2nd edition)
Series: Chapman & Hall/CRC Data Mining and Knowledge Discovery Series
Expected to ship within 12 - 19 working days
|
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
General
Is the information for this product incomplete, wrong or inappropriate?
Let us know about it.
Does this product have an incorrect or missing image?
Send us a new image.
Is this product missing categories?
Add more categories.
Review This Product
No reviews yet - be the first to create one!
|
You might also like..
|
Email address subscribed successfully.
A activation email has been sent to you.
Please click the link in that email to activate your subscription.
Welcome to Loot.co.za!
Sign in / Register |Wishlists & Gift Vouchers |Help | Advanced search
