Cargando…

Data analysis and business modeling with Excel 2013 : manage, analyze, and visualize data with Microsoft Excel 2013 to transform raw data into ready to use information /

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Rojas, David (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Birmingham : Packt Publishing, 2015.
Colección:Professional expertise distilled.
Temas:
Acceso en línea:Texto completo

MARC

LEADER 00000cam a2200000 a 4500
001 EBSCO_ocn927159923
003 OCoLC
005 20231017213018.0
006 m o d
007 cr |n|||||||||
008 151030s2015 enk o 000 0 eng d
040 |a IDEBK  |b eng  |e pn  |c IDEBK  |d YDXCP  |d TEFOD  |d EBLCP  |d COO  |d OCLCO  |d OCLCA  |d OCLCF  |d OCLCQ  |d DEBBG  |d OCLCQ  |d FEM  |d IDB  |d N$T  |d UMI  |d DEBSZ  |d OCLCQ  |d MERUC  |d OCLCQ  |d VT2  |d OCLCO  |d CEF  |d NLE  |d NTG  |d AGLDB  |d UKMGB  |d OCLCQ  |d OCLCO  |d STF  |d UAB  |d G3B  |d UKAHL  |d RDF  |d OCLCQ  |d K6U  |d OCLCO  |d OCLCQ  |d QGK 
016 7 |a 018010480  |2 Uk 
019 |a 928432055  |a 934650463  |a 968011051  |a 969076009  |a 1259168514 
020 |a 1785284037  |q (electronic bk.) 
020 |a 9781785284038  |q (electronic bk.) 
020 |z 9781785289545 
020 |z 1785289543 
029 1 |a AU@  |b 000062335023 
029 1 |a DEBBG  |b BV043627499 
029 1 |a DEBBG  |b BV043967935 
029 1 |a DEBSZ  |b 48578422X 
029 1 |a GBVCP  |b 882745719 
029 1 |a UKMGB  |b 018010480 
035 |a (OCoLC)927159923  |z (OCoLC)928432055  |z (OCoLC)934650463  |z (OCoLC)968011051  |z (OCoLC)969076009  |z (OCoLC)1259168514 
037 |a 845914  |b MIL 
037 |a 017E8CDA-903E-4E28-83F8-E48FB8954CA9  |b OverDrive, Inc.  |n http://www.overdrive.com 
050 4 |a HF5548.4.M523 
072 7 |a COM  |x 054000  |2 bisacsh 
082 0 4 |a 005.369  |2 23 
049 |a UAMI 
100 1 |a Rojas, David,  |e author. 
245 1 0 |a Data analysis and business modeling with Excel 2013 :  |b manage, analyze, and visualize data with Microsoft Excel 2013 to transform raw data into ready to use information /  |c David Rojas. 
260 |a Birmingham :  |b Packt Publishing,  |c 2015. 
300 |a 1 online resource 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
347 |a text file 
490 1 |a Professional expertise distilled 
588 0 |a Online resource, title from PDF title page (EBSCO, viewed April 23, 2017). 
505 0 |a Cover ; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Getting Data into Excel ; Getting started with data; Gathering data; Preparing data; Analyzing data; Presenting data; Manually creating data; Importing data from various sources; Importing data from a text file; Importing a CSV file; Importing other Excel files; Importing data from the Web; Summary; Chapter 2: Connecting to Databases ; Reading a table from MSSQL -- the Microsoft SQL Server database; Reading multiple tables from MSSQL; Reading from MSSQL using SQL; Summary 
505 8 |a Chapter 3: How to Clean Texts, Numbers, and Dates Leading/trailing/in between spaces; Capitalization; Duplicates; Text to Columns; Combine data from multiple columns into one column ; Fixing similar words; Text to dates; Text to numbers; Summary; Chapter 4: Using Formulas to Prepare Your Data for Analysis ; How to create formulas; Combining strings and numbers; Using built-in functions; If/else/then statements; Comparing columns; Summary; Chapter 5: Analyzing Your Data Using Descriptive Statistics and Charts ; Gathering data; Preparing the data for analysis; Analyzing our data 
505 8 |a Question -- how many applications were processed in the year 2014?Summary; Chapter 6: Link Your Data Using Data Models ; Gathering data; Preparing data; Analyzing data; Data models; Summary; Chapter 7: A Primer on Using the Excel Solver ; Activating the Excel Solver; Modeling our linear programming problem; Using the Excel Solver; Summary; Chapter 8: Learning VBA -- Excel's Scripting Language ; What is VBA?; What is a macro?; Opening the VBA Editor; Your very first ""Hello World"" VBA script; Declaring variables; Conditional statements; Loops; Creating macros without any code 
505 8 |a Saving macro-powered spreadsheets Summary; Chapter 9: How to Build and Style Your Charts ; Quick analysis charts; Charting options; Chart elements; Chart styles; Chart filters; Additional design options ; Summary; Chapter 10: Creating Interactive Spreadsheets Using Tables and Slicers ; What are slicers?; How to create slicers; Styling slicers; Adding multiple slicers; Clearing filters; Final tweaks; Summary; Appendix: Tips, Tricks, and Shortcuts ; Shortcuts; Tips and tricks; Index 
546 |a English. 
590 |a eBooks on EBSCOhost  |b EBSCO eBook Subscription Academic Collection - Worldwide 
630 0 0 |a Microsoft Excel (Computer file) 
630 0 7 |a Microsoft Excel (Computer file)  |2 fast  |0 (OCoLC)fst01366659 
650 0 |a Electronic spreadsheets  |x Computer programs. 
650 6 |a Tableurs  |x Logiciels. 
650 7 |a COMPUTERS  |x Desktop Applications  |x Spreadsheets.  |2 bisacsh 
650 7 |a Electronic spreadsheets  |x Computer programs.  |2 fast  |0 (OCoLC)fst00907465 
776 |z 1-78528-954-3 
830 0 |a Professional expertise distilled. 
856 4 0 |u https://ebsco.uam.elogim.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1087751  |z Texto completo 
938 |a Askews and Holts Library Services  |b ASKH  |n AH29479752 
938 |a EBL - Ebook Library  |b EBLB  |n EBL4191156 
938 |a EBSCOhost  |b EBSC  |n 1087751 
938 |a ProQuest MyiLibrary Digital eBook Collection  |b IDEB  |n cis32993931 
938 |a YBP Library Services  |b YANK  |n 12675774 
994 |a 92  |b IZTAP