Hurtig levering
Fremragende Trustpilot
Op til 20% Rabat på nye medlemsordrer
Kurv
Automated Data Analysis Using Excel
Af: Brian D. Bissett Engelsk Paperback
SPAR
kr 258
Automated Data Analysis Using Excel
Af: Brian D. Bissett Engelsk Paperback

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

Kampagne pris Velkomst pris 636 kr
Medlemspris 662 kr
Kampagnepris og medlemspris er kun for medlemmer. Du bliver automatisk medlem når du køber til medlems- og kampagnepris. Få 7 dages gratis medlemskab (herefter automatisk 89 kr/30 dage). Læs mere om fordelene
Gratis fragt
23 - 25 hverdage
10 kr
Lavt pakkegebyr
Normalpris 894 kr
Fragt: 59 kr
23 - 25 hverdage
20 kr
Pakkegebyr
Spar 258 kr
Velkommen 7,5%
God 15.773 anmeldelser på

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

Produktdetaljer
Sprog: Engelsk
Sider: 592
ISBN-13: 9781482250138
Indbinding: Paperback
Udgave:
ISBN-10: 1482250136
Kategori: Data mining
Udg. Dato: 19 aug 2020
Længde: 39mm
Bredde: 179mm
Højde: 253mm
Oplagsdato: 19 aug 2020
Forfatter(e): Brian D. Bissett
Forfatter(e) Brian D. Bissett


Kategori Data mining


Sprog Engelsk


Indbinding Paperback


Sider 592


Udgave


Længde 39mm


Bredde 179mm


Højde 253mm

MEDLEMSFORDELE
GRATIS FRAGT
SPAR OP TIL 90%
Andre har også købt
BOG (INDBUNDET)
Kampagne pris kr 199

kr 320
Normalpris
kr 211
Medlemspris
SPAR
kr 121
BOG (INDBUNDET)
Kampagne pris kr 262

kr 349
Normalpris
kr 271
Medlemspris
SPAR
kr 87
BOG (INDBUNDET)
Kampagne pris kr 148

kr 199
Normalpris
kr 153
Medlemspris
SPAR
kr 51
BOG (INDBUNDET)
Kampagne pris kr 380

kr 499
Normalpris
kr 392
Medlemspris
SPAR
kr 119
BOG (INDBUNDET)
Kampagne pris kr 29

kr 134
Normalpris
kr 40
Medlemspris
SPAR
kr 105
BOG (INDBUNDET)
Kampagne pris kr 182

kr 250
Normalpris
kr 189
Medlemspris
SPAR
kr 68
BOG (INDBUNDET)
Kampagne pris kr 919

kr 1.499
Normalpris
kr 977
Medlemspris
SPAR
kr 580
BOG (HÆFTET)
Kampagne pris kr 188

kr 269
Normalpris
kr 196
Medlemspris
SPAR
kr 81
BOG (HÆFTET)
Kampagne pris kr 27

kr 227
Normalpris
kr 47
Medlemspris
SPAR
kr 200
BOG (INDBUNDET)
Kampagne pris kr 203

kr 300
Normalpris
kr 213
Medlemspris
SPAR
kr 97
BOG (INDBUNDET)
Kampagne pris kr 211

kr 299
Normalpris
kr 220
Medlemspris
SPAR
kr 88
BOG (HÆFTET)
Kampagne pris kr 207

kr 269
Normalpris
kr 213
Medlemspris
SPAR
kr 62
BOG (INDBUNDET)
Kampagne pris kr 199

kr 300
Normalpris
kr 209
Medlemspris
SPAR
kr 101
BOG (INDBUNDET)
Kampagne pris kr 119

kr 120
Normalpris
kr 119
Medlemspris
SPAR
kr 1
BOG (HARDBACK)
Kampagne pris kr 223

kr 299
Normalpris
kr 231
Medlemspris
SPAR
kr 76
BOG (PAPERBACK)
Kampagne pris kr 165

kr 197
Normalpris
kr 168
Medlemspris
SPAR
kr 32
BOG (INDBUNDET)
Kampagne pris kr 191

kr 300
Normalpris
kr 202
Medlemspris
SPAR
kr 109
BOG (HÆFTET)
Kampagne pris kr 164

kr 199
Normalpris
kr 168
Medlemspris
SPAR
kr 35
BOG (HÆFTET)
Kampagne pris kr 211

kr 299
Normalpris
kr 220
Medlemspris
SPAR
kr 88
BOG (INDBUNDET)
Kampagne pris kr 216

kr 279
Normalpris
kr 222
Medlemspris
SPAR
kr 63
Vi anbefaler også
BOG (PAPERBACK)
Kampagne pris kr 363

kr 491
Normalpris
kr 376
Medlemspris
SPAR
kr 128
BOG (PAPERBACK)
Kampagne pris kr 260

kr 385
Normalpris
kr 273
Medlemspris
SPAR
kr 125
BOG (PAPERBACK)
Kampagne pris kr 464

kr 658
Normalpris
kr 483
Medlemspris
SPAR
kr 194
BOG (HARDBACK)
Kampagne pris kr 794

kr 1.127
Normalpris
kr 827
Medlemspris
SPAR
kr 333
BOG (HARDBACK)
Kampagne pris kr 552

kr 861
Normalpris
kr 583
Medlemspris
SPAR
kr 309
BOG (PAPERBACK)
Kampagne pris kr 483

kr 619
Normalpris
kr 497
Medlemspris
SPAR
kr 136
BOG (HARDBACK)
Kampagne pris kr 564

kr 787
Normalpris
kr 586
Medlemspris
SPAR
kr 223
BOG (PAPERBACK)
Kampagne pris kr 608

kr 675
Normalpris
kr 615
Medlemspris
SPAR
kr 67
BOG (HARDBACK)
Kampagne pris kr 704

kr 996
Normalpris
kr 733
Medlemspris
SPAR
kr 292
BOG (PAPERBACK)
Kampagne pris kr 503

kr 518
Normalpris
kr 505
Medlemspris
SPAR
kr 15
BOG (PAPERBACK)
Kampagne pris kr 522

kr 675
Normalpris
kr 537
Medlemspris
SPAR
kr 153
BOG (PAPERBACK)
Kampagne pris kr 339

kr 496
Normalpris
kr 355
Medlemspris
SPAR
kr 157
BOG (PAPERBACK)
Kampagne pris kr 916

kr 1.239
Normalpris
kr 948
Medlemspris
SPAR
kr 323
BOG (PAPERBACK)
Kampagne pris kr 320

kr 463
Normalpris
kr 334
Medlemspris
SPAR
kr 143
BOG (PAPERBACK)
Kampagne pris kr 307

kr 436
Normalpris
kr 320
Medlemspris
SPAR
kr 129
BOG (PAPERBACK)
Kampagne pris kr 464

kr 478
Normalpris
kr 465
Medlemspris
SPAR
kr 14
BOG (HARDBACK)
Kampagne pris kr 443

kr 563
Normalpris
kr 455
Medlemspris
SPAR
kr 120
BOG (PAPERBACK)
Kampagne pris kr 260

kr 360
Normalpris
kr 270
Medlemspris
SPAR
kr 100
BOG (PAPERBACK)
Kampagne pris kr 263

kr 354
Normalpris
kr 272
Medlemspris
SPAR
kr 91
BOG (PAPERBACK)
Kampagne pris kr 260

kr 360
Normalpris
kr 270
Medlemspris
SPAR
kr 100