Description
- ISBN-10: 1482250136
- ISBN-13: 978-1482250138
- Edition: 2nd
- Publication date: 19 August 2020
- Part of series: Chapman & Hall/CRC Data Mining and Knowledge Discovery
- Language: English
- Dimensions: 17.78 x 3.51 x 25.4 cm
- Print length: 592 pages
Original price was: ₹8,182.60.₹7,364.34Current price is: ₹7,364.34.
Unlock the power of Excel for advanced data analysis with AUTOMATED DATA ANALYSIS USING EXCEL, 2ND EDITION. This essential guide, from The Bookish Owl, covers Excel 2019 features, including custom ribbon creation with XML and VBA, and robust database connectivity using ADO, DAO, and SQL. Discover how to automate complex operations like linear and non-linear curve fitting, mapping, charting, sorting, and filtering with the latest Excel VBA object models. This book provides practical examples for finding and extracting information from raw data, formatting data with conditional formatting, creating custom functions, generating datasets, and preparing custom reports for archiving and dissemination. Enhance your data processing capabilities and streamline reporting for legal and regulatory needs.
5 in stock