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 /
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Birmingham :
Packt Publishing,
2015.
|
| Schriftenreihe: | Professional expertise distilled.
|
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Beschreibung: | 1 online resource |
| ISBN: | 1785284037 9781785284038 |
Internformat
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | ZDB-4-EBU-ocn927159923 | ||
| 003 | OCoLC | ||
| 005 | 20241004212047.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 |d OCLCO |d OCLCL | ||
| 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 | ||
| 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 | 7 | |a 005.369 |2 23 | |
| 049 | |a MAIN | ||
| 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. | ||
| 630 | 0 | 0 | |a Microsoft Excel (Computer file) |0 http://id.loc.gov/authorities/names/n86025775 |
| 630 | 0 | 7 | |a Microsoft Excel (Computer file) |2 fast |
| 650 | 0 | |a Electronic spreadsheets |x Computer programs. |0 http://id.loc.gov/authorities/subjects/sh86007613 | |
| 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 | |
| 758 | |i has work: |a Data analysis and business modeling with Excel 2013 (Text) |1 https://id.oclc.org/worldcat/entity/E39PCGf9WhxXc9crKMfhMqkppq |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | |z 1-78528-954-3 | ||
| 830 | 0 | |a Professional expertise distilled. | |
| 856 | 4 | 0 | |l FWS01 |p ZDB-4-EBU |q FWS_PDA_EBU |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1087751 |3 Volltext |
| 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 GEBAY | ||
| 912 | |a ZDB-4-EBU | ||
| 049 | |a DE-863 | ||
Datensatz im Suchindex
| DE-BY-FWS_katkey | ZDB-4-EBU-ocn927159923 |
|---|---|
| _version_ | 1816796920475025408 |
| adam_text | |
| any_adam_object | |
| author | Rojas, David |
| author_facet | Rojas, David |
| author_role | aut |
| author_sort | Rojas, David |
| author_variant | d r dr |
| building | Verbundindex |
| bvnumber | localFWS |
| callnumber-first | H - Social Science |
| callnumber-label | HF5548 |
| callnumber-raw | HF5548.4.M523 |
| callnumber-search | HF5548.4.M523 |
| callnumber-sort | HF 45548.4 M523 |
| callnumber-subject | HF - Commerce |
| collection | ZDB-4-EBU |
| contents | 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 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 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 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 |
| ctrlnum | (OCoLC)927159923 |
| dewey-full | 005.369 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.369 |
| dewey-search | 005.369 |
| dewey-sort | 15.369 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>05199cam a2200637 a 4500</leader><controlfield tag="001">ZDB-4-EBU-ocn927159923</controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20241004212047.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr |n|||||||||</controlfield><controlfield tag="008">151030s2015 enk o 000 0 eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">IDEBK</subfield><subfield code="b">eng</subfield><subfield code="e">pn</subfield><subfield code="c">IDEBK</subfield><subfield code="d">YDXCP</subfield><subfield code="d">TEFOD</subfield><subfield code="d">EBLCP</subfield><subfield code="d">COO</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCA</subfield><subfield code="d">OCLCF</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">DEBBG</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">FEM</subfield><subfield code="d">IDB</subfield><subfield code="d">N$T</subfield><subfield code="d">UMI</subfield><subfield code="d">DEBSZ</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">MERUC</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">VT2</subfield><subfield code="d">OCLCO</subfield><subfield code="d">CEF</subfield><subfield code="d">NLE</subfield><subfield code="d">NTG</subfield><subfield code="d">AGLDB</subfield><subfield code="d">UKMGB</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">STF</subfield><subfield code="d">UAB</subfield><subfield code="d">G3B</subfield><subfield code="d">UKAHL</subfield><subfield code="d">RDF</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">K6U</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">QGK</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCL</subfield></datafield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">018010480</subfield><subfield code="2">Uk</subfield></datafield><datafield tag="019" ind1=" " ind2=" "><subfield code="a">928432055</subfield><subfield code="a">934650463</subfield><subfield code="a">968011051</subfield><subfield code="a">969076009</subfield><subfield code="a">1259168514</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1785284037</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781785284038</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">9781785289545</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">1785289543</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)927159923</subfield><subfield code="z">(OCoLC)928432055</subfield><subfield code="z">(OCoLC)934650463</subfield><subfield code="z">(OCoLC)968011051</subfield><subfield code="z">(OCoLC)969076009</subfield><subfield code="z">(OCoLC)1259168514</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">845914</subfield><subfield code="b">MIL</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">017E8CDA-903E-4E28-83F8-E48FB8954CA9</subfield><subfield code="b">OverDrive, Inc.</subfield><subfield code="n">http://www.overdrive.com</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">HF5548.4.M523</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">054000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">005.369</subfield><subfield code="2">23</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">MAIN</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Rojas, David,</subfield><subfield code="e">author.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Data analysis and business modeling with Excel 2013 :</subfield><subfield code="b">manage, analyze, and visualize data with Microsoft Excel 2013 to transform raw data into ready to use information /</subfield><subfield code="c">David Rojas.</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">Birmingham :</subfield><subfield code="b">Packt Publishing,</subfield><subfield code="c">2015.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="347" ind1=" " ind2=" "><subfield code="a">text file</subfield></datafield><datafield tag="490" ind1="1" ind2=" "><subfield code="a">Professional expertise distilled</subfield></datafield><datafield tag="588" ind1="0" ind2=" "><subfield code="a">Online resource, title from PDF title page (EBSCO, viewed April 23, 2017).</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="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</subfield></datafield><datafield tag="546" ind1=" " ind2=" "><subfield code="a">English.</subfield></datafield><datafield tag="630" ind1="0" ind2="0"><subfield code="a">Microsoft Excel (Computer file)</subfield><subfield code="0">http://id.loc.gov/authorities/names/n86025775</subfield></datafield><datafield tag="630" ind1="0" ind2="7"><subfield code="a">Microsoft Excel (Computer file)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Electronic spreadsheets</subfield><subfield code="x">Computer programs.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh86007613</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Tableurs</subfield><subfield code="x">Logiciels.</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Desktop Applications</subfield><subfield code="x">Spreadsheets.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Electronic spreadsheets</subfield><subfield code="x">Computer programs</subfield><subfield code="2">fast</subfield></datafield><datafield tag="758" ind1=" " ind2=" "><subfield code="i">has work:</subfield><subfield code="a">Data analysis and business modeling with Excel 2013 (Text)</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PCGf9WhxXc9crKMfhMqkppq</subfield><subfield code="4">https://id.oclc.org/worldcat/ontology/hasWork</subfield></datafield><datafield tag="776" ind1=" " ind2=" "><subfield code="z">1-78528-954-3</subfield></datafield><datafield tag="830" ind1=" " ind2="0"><subfield code="a">Professional expertise distilled.</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="l">FWS01</subfield><subfield code="p">ZDB-4-EBU</subfield><subfield code="q">FWS_PDA_EBU</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1087751</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">Askews and Holts Library Services</subfield><subfield code="b">ASKH</subfield><subfield code="n">AH29479752</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBL - Ebook Library</subfield><subfield code="b">EBLB</subfield><subfield code="n">EBL4191156</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">1087751</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ProQuest MyiLibrary Digital eBook Collection</subfield><subfield code="b">IDEB</subfield><subfield code="n">cis32993931</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">YBP Library Services</subfield><subfield code="b">YANK</subfield><subfield code="n">12675774</subfield></datafield><datafield tag="994" ind1=" " ind2=" "><subfield code="a">92</subfield><subfield code="b">GEBAY</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBU</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield></datafield></record></collection> |
| id | ZDB-4-EBU-ocn927159923 |
| illustrated | Not Illustrated |
| indexdate | 2024-11-26T14:49:21Z |
| institution | BVB |
| isbn | 1785284037 9781785284038 |
| language | English |
| oclc_num | 927159923 |
| open_access_boolean | |
| owner | MAIN DE-863 DE-BY-FWS |
| owner_facet | MAIN DE-863 DE-BY-FWS |
| physical | 1 online resource |
| psigel | ZDB-4-EBU |
| publishDate | 2015 |
| publishDateSearch | 2015 |
| publishDateSort | 2015 |
| publisher | Packt Publishing, |
| record_format | marc |
| series | Professional expertise distilled. |
| series2 | Professional expertise distilled |
| spelling | Rojas, David, author. 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 / David Rojas. Birmingham : Packt Publishing, 2015. 1 online resource text txt rdacontent computer c rdamedia online resource cr rdacarrier text file Professional expertise distilled Online resource, title from PDF title page (EBSCO, viewed April 23, 2017). 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 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 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 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 English. Microsoft Excel (Computer file) http://id.loc.gov/authorities/names/n86025775 Microsoft Excel (Computer file) fast Electronic spreadsheets Computer programs. http://id.loc.gov/authorities/subjects/sh86007613 Tableurs Logiciels. COMPUTERS Desktop Applications Spreadsheets. bisacsh Electronic spreadsheets Computer programs fast has work: Data analysis and business modeling with Excel 2013 (Text) https://id.oclc.org/worldcat/entity/E39PCGf9WhxXc9crKMfhMqkppq https://id.oclc.org/worldcat/ontology/hasWork 1-78528-954-3 Professional expertise distilled. FWS01 ZDB-4-EBU FWS_PDA_EBU https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1087751 Volltext |
| spellingShingle | Rojas, David 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 / Professional expertise distilled. 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 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 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 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 Microsoft Excel (Computer file) http://id.loc.gov/authorities/names/n86025775 Microsoft Excel (Computer file) fast Electronic spreadsheets Computer programs. http://id.loc.gov/authorities/subjects/sh86007613 Tableurs Logiciels. COMPUTERS Desktop Applications Spreadsheets. bisacsh Electronic spreadsheets Computer programs fast |
| subject_GND | http://id.loc.gov/authorities/names/n86025775 http://id.loc.gov/authorities/subjects/sh86007613 |
| title | 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 / |
| title_auth | 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 / |
| title_exact_search | 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 / |
| title_full | 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 / David Rojas. |
| title_fullStr | 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 / David Rojas. |
| title_full_unstemmed | 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 / David Rojas. |
| title_short | Data analysis and business modeling with Excel 2013 : |
| title_sort | 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 |
| title_sub | manage, analyze, and visualize data with Microsoft Excel 2013 to transform raw data into ready to use information / |
| topic | Microsoft Excel (Computer file) http://id.loc.gov/authorities/names/n86025775 Microsoft Excel (Computer file) fast Electronic spreadsheets Computer programs. http://id.loc.gov/authorities/subjects/sh86007613 Tableurs Logiciels. COMPUTERS Desktop Applications Spreadsheets. bisacsh Electronic spreadsheets Computer programs fast |
| topic_facet | Microsoft Excel (Computer file) Electronic spreadsheets Computer programs. Tableurs Logiciels. COMPUTERS Desktop Applications Spreadsheets. Electronic spreadsheets Computer programs |
| url | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1087751 |
| work_keys_str_mv | AT rojasdavid dataanalysisandbusinessmodelingwithexcel2013manageanalyzeandvisualizedatawithmicrosoftexcel2013totransformrawdataintoreadytouseinformation |