000 05334cam a2200709Ia 4500
001 ocn927159923
003 OCoLC
005 20200827105009.0
006 m o d
007 cr |n|||||||||
008 151030s2015 enk o 000 0 eng d
040 _aIDEBK
_beng
_epn
_cIDEBK
_dYDXCP
_dTEFOD
_dEBLCP
_dCOO
_dOCLCO
_dOCLCA
_dOCLCF
_dOCLCQ
_dDEBBG
_dOCLCQ
_dFEM
_dIDB
_dN$T
_dUMI
_dDEBSZ
_dOCLCQ
_dMERUC
_dOCLCQ
_dVT2
_dOCLCO
_dCEF
_dNLE
_dNTG
_dAGLDB
_dUKMGB
_dOCLCQ
_dOCLCO
_dSTF
_dUAB
_dG3B
_dUKAHL
_dRDF
_dOCLCQ
_dK6U
016 7 _a018010480
_2Uk
019 _a928432055
_a934650463
_a968011051
_a969076009
020 _a1785284037
_q(electronic bk.)
020 _a9781785284038
_q(electronic bk.)
020 _z9781785289545
020 _z1785289543
029 1 _aAU@
_b000062335023
029 1 _aDEBBG
_bBV043627499
029 1 _aDEBBG
_bBV043967935
029 1 _aDEBSZ
_b48578422X
029 1 _aGBVCP
_b882745719
029 1 _aUKMGB
_b018010480
035 _a(OCoLC)927159923
_z(OCoLC)928432055
_z(OCoLC)934650463
_z(OCoLC)968011051
_z(OCoLC)969076009
037 _a845914
_bMIL
037 _a017E8CDA-903E-4E28-83F8-E48FB8954CA9
_bOverDrive, Inc.
_nhttp://www.overdrive.com
050 4 _aHF5548.4.M523
072 7 _aCOM
_x054000
_2bisacsh
082 0 4 _a005.369
_223
049 _aMAIN
100 1 _aRojas, David,
_eauthor.
245 1 0 _aData analysis and business modeling with Excel 2013 :
_bmanage, analyze, and visualize data with Microsoft Excel 2013 to transform raw data into ready to use information /
_cDavid Rojas.
260 _aBirmingham :
_bPackt Publishing,
_c2015.
300 _a1 online resource
336 _atext
_btxt
_2rdacontent
337 _acomputer
_bc
_2rdamedia
338 _aonline resource
_bcr
_2rdacarrier
347 _atext file
_2rda
490 1 _aProfessional expertise distilled
588 0 _aOnline resource, title from PDF title page (EBSCO, viewed April 23, 2017).
505 0 _aCover ; 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 _aChapter 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 _aQuestion -- 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 _aSaving 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
590 _aeBooks on EBSCOhost
_bEBSCO eBook Subscription Academic Collection - Worldwide
630 0 0 _aMicrosoft Excel (Computer file)
_0http://id.loc.gov/authorities/names/n86025775
630 0 7 _aMicrosoft Excel (Computer file)
_2fast
_0(OCoLC)fst01366659
650 0 _aElectronic spreadsheets
_xComputer programs.
_0http://id.loc.gov/authorities/subjects/sh86007613
650 7 _aCOMPUTERS
_xDesktop Applications
_xSpreadsheets.
_2bisacsh
650 7 _aElectronic spreadsheets
_xComputer programs.
_2fast
_0(OCoLC)fst00907465
655 0 _aElectronic books.
655 4 _aElectronic books.
830 0 _aProfessional expertise distilled.
856 4 0 _uhttps://libproxy.firstcity.edu.my:8443/login?url=http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1087751
938 _aAskews and Holts Library Services
_bASKH
_nAH29479752
938 _aEBL - Ebook Library
_bEBLB
_nEBL4191156
938 _aEBSCOhost
_bEBSC
_n1087751
938 _aProQuest MyiLibrary Digital eBook Collection
_bIDEB
_ncis32993931
938 _aYBP Library Services
_bYANK
_n12675774
994 _a92
_bMYFCU
999 _c47161
_d47161