Guerrilla Data Analysis Using Microsoft Excel: Overcoming Crap Data and Excel Skirmishes
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Chicago
Holy Macro! Books
2022
|
| Ausgabe: | 1st ed |
| Schlagworte: | |
| Online-Zugang: | DE-2070s |
| Beschreibung: | Description based on publisher supplied metadata and other sources |
| Beschreibung: | 1 Online-Ressource (277 Seiten) |
| ISBN: | 9781615471607 |
Internformat
MARC
| LEADER | 00000nmm a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV049872748 | ||
| 003 | DE-604 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 240919s2022 |||| o||u| ||||||eng d | ||
| 020 | |a 9781615471607 |9 978-1-61547-160-7 | ||
| 035 | |a (ZDB-30-PQE)EBC7011210 | ||
| 035 | |a (ZDB-30-PAD)EBC7011210 | ||
| 035 | |a (ZDB-89-EBL)EBL7011210 | ||
| 035 | |a (OCoLC)1328133484 | ||
| 035 | |a (DE-599)BVBBV049872748 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-2070s | ||
| 082 | 0 | |a 005.369 | |
| 100 | 1 | |a Jelen, Bill |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Guerrilla Data Analysis Using Microsoft Excel |b Overcoming Crap Data and Excel Skirmishes |
| 250 | |a 1st ed | ||
| 264 | 1 | |a Chicago |b Holy Macro! Books |c 2022 | |
| 264 | 4 | |c ©2022 | |
| 300 | |a 1 Online-Ressource (277 Seiten) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 500 | |a Description based on publisher supplied metadata and other sources | ||
| 505 | 8 | |a Intro -- Introduction: Welcome to the World of Guerrilla Data Analysis! -- About This Book -- Blindsided by Data -- Small, Stupid Stuff and Big, Complicated Stuff -- Chapter 1: Reviewing the Basics -- Overview of Excel Functions and Formulas -- Relative, Absolute, and Mixed References -- Text Manipulation Functions -- IF Statements -- Developing Dynamic Spreadsheets -- Concatenating Names and Changing Formulas to Values -- Linking Worksheets and Workbooks -- Helper Columns -- Sorting and Filtering -- Chapter 2: Excel Tables: The Glue in Dynamic Spreadsheet Development -- Converting a Data Range to a Table -- Using a Total Row -- Naming a Table -- Using Tables to Make Dynamic Dropdown Lists -- Tables Functions and Cell References -- Some Warnings About Working with Tables -- Excel Tables Conclusion -- Chapter 3: Collaboration Tools -- How to Share a Workbook -- The Awesome Part of Collaboration: Sheet Views -- Chapter 4: Summing and Counting with Criteria -- Chapter 5: VLOOKUP and XLOOKUP -- VLOOKUP: What Does It Do? -- XLOOKUP -- Chapter 6: Pivot Tables: The Turning Point! -- What Is a Pivot Table, and What Can It Do? -- Getting to Know the Pivot Table Interface -- Building a Pivot Table to Sum and Count Values -- Summing and Counting Side-by-Side ... and a Filter -- Filtering with the Pivot Table -- Grouping Dates in the Pivot Table -- Using the Pivot Table to Get the Percentage of the Total -- Pivot Table Percentages Without Totals -- Using the Pivot Table to Drill Down for Isolated Details -- Deleting a Pivot Table -- Saving Your Favorite Pivot Table Settings Using Pivot Table Defaults -- Creating a Year-over-Year Report in a Pivot Table -- Counting Distinct Values in a Pivot Table -- Pivot Table Conclusions -- Chapter 7: Power Query -- Power Query: A Little Background -- Filling Down and Splitting Columns by Delimiter | |
| 505 | 8 | |a Splitting Column into Rows, Grouping By, and Duplicating a Query -- Data Types and Power Query -- Sorting in Power Query -- The Query Settings Pane -- Adding More Source Data -- Unpivoting and Filtering -- Blanks, Nulls, and Zeros: They Aren't the Same in Power Query -- Joins and Merges in Power Query -- Appending (aka Stacking Stuff Up) -- Importing from a File or from a Folder -- Transformation Tables -- Fuzzy Matching -- Chapter 8: Conditional Formatting -- Using Conditional Formatting to Find Duplicates -- Using Icons with Conditional Formatting -- Chapter 9: De-duping in Excel -- De-duping with Advanced Filter -- De-duping Gets Ugly! -- Using IF to "LOOK" -- De-duping with an Assembled ID -- Chapter 10: Dynamic Arrays -- SORT -- FILTER -- RANDARRAY -- UNIQUE -- The @ Operator, Briefly Known as SINGLE -- The Spill Indicator -- Chapter 11: Data Is Never 100% Clean (Not for Very Long) -- Chapter 12: Data Validation: Controlling Inputs and Maintaining Data Integrity -- Data Validation Overview -- Implementing Dropdown Lists -- New in 2022: AutoComplete in Validation Dropdown Lists -- Controlling Dates -- Reasonable Numbers -- Data Validation Cautions -- Data Validation Conclusions -- Chapter 13: Protecting Sheets and Cells -- Locking Down an Entire Sheet -- Locking and Unlocking Cells -- Unprotecting a Sheet -- Chapter 14: Octopus Spreadsheets -- Chapter 15: INDIRECT -- Chapter 16: OFFSET -- Using OFFSET to Sum a Range -- Chapter 17: Recognizing Patterns -- Chapter 18: Data Types and Stock History -- Original Release Data Types -- Second Release Data Types: Wolfram -- Data Types: Navigating the Data Card -- Custom Data Types: Features Needed -- Custom Data Types: The Choices Available Today -- Chapter 19: Graphing -- Graphing a Histogram Using the FREQUENCY Function -- Using Chart Features -- Chapter 20: The Dangers of Just Diving In | |
| 505 | 8 | |a Chapter 21: The LET Function -- LET for Reusing Parts of Formulas -- LET for Easier Readability -- Chapter 22: Warnings About Machine Learning-Driven Features in Excel and Power Query -- Chapter 23: Avoid Working on Your Source Data -- Chapter 24: Using Slicers -- Using Slicers with Tables -- Pivot Tables and Slicers -- Chapter 25: Data Models and Relationships -- Foreign and Primary Keys -- Why a Data Model vs. Power Query? -- Chapter 26: People, Processes, and Tools -- Chapter 27: Keeping Your Data in as Few Places as Possible -- Chapter 28: Rough-and-Tumble Tips and Insights -- Unhiding Column A -- Formula Triggers -- Adding Emojis to Cells and Formulas -- Hiding Unnecessary Zeros -- Forcing a Report to Fit on One Page -- Setting the Print Area to Print a Section of a Worksheet -- Alt+Enter for an Extra Line in a Cell -- Handling Dates -- Connecting Cell Values to Shapes or Objects -- Useful Excel Functions -- Integrity Checks and Troubleshooting -- Error-Handling Functions: IFNA vs. IFERROR -- Row Counts -- Chapter 29: Spreadsheet Layout and Development -- A Final Word About Spreadsheet Layout and Development -- Index | |
| 650 | 4 | |a Microsoft Excel (Computer file) | |
| 700 | 1 | |a du Soleil, Oz |e Sonstige |4 oth | |
| 700 | 1 | |a du Soleil, Oz |e Sonstige |4 oth | |
| 700 | 1 | |a du Soleil, Oz |e Sonstige |4 oth | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |a Jelen, Bill |t Guerrilla Data Analysis Using Microsoft Excel |d Chicago : Holy Macro! Books,c2022 |
| 912 | |a ZDB-30-PQE | ||
| 943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-035212206 | |
| 966 | e | |u https://ebookcentral.proquest.com/lib/hwr/detail.action?docID=7011210 |l DE-2070s |p ZDB-30-PQE |q HWR_PDA_PQE |x Aggregator |3 Volltext | |
Datensatz im Suchindex
| _version_ | 1810600617908895744 |
|---|---|
| adam_text | |
| any_adam_object | |
| author | Jelen, Bill |
| author_facet | Jelen, Bill |
| author_role | aut |
| author_sort | Jelen, Bill |
| author_variant | b j bj |
| building | Verbundindex |
| bvnumber | BV049872748 |
| collection | ZDB-30-PQE |
| contents | Intro -- Introduction: Welcome to the World of Guerrilla Data Analysis! -- About This Book -- Blindsided by Data -- Small, Stupid Stuff and Big, Complicated Stuff -- Chapter 1: Reviewing the Basics -- Overview of Excel Functions and Formulas -- Relative, Absolute, and Mixed References -- Text Manipulation Functions -- IF Statements -- Developing Dynamic Spreadsheets -- Concatenating Names and Changing Formulas to Values -- Linking Worksheets and Workbooks -- Helper Columns -- Sorting and Filtering -- Chapter 2: Excel Tables: The Glue in Dynamic Spreadsheet Development -- Converting a Data Range to a Table -- Using a Total Row -- Naming a Table -- Using Tables to Make Dynamic Dropdown Lists -- Tables Functions and Cell References -- Some Warnings About Working with Tables -- Excel Tables Conclusion -- Chapter 3: Collaboration Tools -- How to Share a Workbook -- The Awesome Part of Collaboration: Sheet Views -- Chapter 4: Summing and Counting with Criteria -- Chapter 5: VLOOKUP and XLOOKUP -- VLOOKUP: What Does It Do? -- XLOOKUP -- Chapter 6: Pivot Tables: The Turning Point! -- What Is a Pivot Table, and What Can It Do? -- Getting to Know the Pivot Table Interface -- Building a Pivot Table to Sum and Count Values -- Summing and Counting Side-by-Side ... and a Filter -- Filtering with the Pivot Table -- Grouping Dates in the Pivot Table -- Using the Pivot Table to Get the Percentage of the Total -- Pivot Table Percentages Without Totals -- Using the Pivot Table to Drill Down for Isolated Details -- Deleting a Pivot Table -- Saving Your Favorite Pivot Table Settings Using Pivot Table Defaults -- Creating a Year-over-Year Report in a Pivot Table -- Counting Distinct Values in a Pivot Table -- Pivot Table Conclusions -- Chapter 7: Power Query -- Power Query: A Little Background -- Filling Down and Splitting Columns by Delimiter Splitting Column into Rows, Grouping By, and Duplicating a Query -- Data Types and Power Query -- Sorting in Power Query -- The Query Settings Pane -- Adding More Source Data -- Unpivoting and Filtering -- Blanks, Nulls, and Zeros: They Aren't the Same in Power Query -- Joins and Merges in Power Query -- Appending (aka Stacking Stuff Up) -- Importing from a File or from a Folder -- Transformation Tables -- Fuzzy Matching -- Chapter 8: Conditional Formatting -- Using Conditional Formatting to Find Duplicates -- Using Icons with Conditional Formatting -- Chapter 9: De-duping in Excel -- De-duping with Advanced Filter -- De-duping Gets Ugly! -- Using IF to "LOOK" -- De-duping with an Assembled ID -- Chapter 10: Dynamic Arrays -- SORT -- FILTER -- RANDARRAY -- UNIQUE -- The @ Operator, Briefly Known as SINGLE -- The Spill Indicator -- Chapter 11: Data Is Never 100% Clean (Not for Very Long) -- Chapter 12: Data Validation: Controlling Inputs and Maintaining Data Integrity -- Data Validation Overview -- Implementing Dropdown Lists -- New in 2022: AutoComplete in Validation Dropdown Lists -- Controlling Dates -- Reasonable Numbers -- Data Validation Cautions -- Data Validation Conclusions -- Chapter 13: Protecting Sheets and Cells -- Locking Down an Entire Sheet -- Locking and Unlocking Cells -- Unprotecting a Sheet -- Chapter 14: Octopus Spreadsheets -- Chapter 15: INDIRECT -- Chapter 16: OFFSET -- Using OFFSET to Sum a Range -- Chapter 17: Recognizing Patterns -- Chapter 18: Data Types and Stock History -- Original Release Data Types -- Second Release Data Types: Wolfram -- Data Types: Navigating the Data Card -- Custom Data Types: Features Needed -- Custom Data Types: The Choices Available Today -- Chapter 19: Graphing -- Graphing a Histogram Using the FREQUENCY Function -- Using Chart Features -- Chapter 20: The Dangers of Just Diving In Chapter 21: The LET Function -- LET for Reusing Parts of Formulas -- LET for Easier Readability -- Chapter 22: Warnings About Machine Learning-Driven Features in Excel and Power Query -- Chapter 23: Avoid Working on Your Source Data -- Chapter 24: Using Slicers -- Using Slicers with Tables -- Pivot Tables and Slicers -- Chapter 25: Data Models and Relationships -- Foreign and Primary Keys -- Why a Data Model vs. Power Query? -- Chapter 26: People, Processes, and Tools -- Chapter 27: Keeping Your Data in as Few Places as Possible -- Chapter 28: Rough-and-Tumble Tips and Insights -- Unhiding Column A -- Formula Triggers -- Adding Emojis to Cells and Formulas -- Hiding Unnecessary Zeros -- Forcing a Report to Fit on One Page -- Setting the Print Area to Print a Section of a Worksheet -- Alt+Enter for an Extra Line in a Cell -- Handling Dates -- Connecting Cell Values to Shapes or Objects -- Useful Excel Functions -- Integrity Checks and Troubleshooting -- Error-Handling Functions: IFNA vs. IFERROR -- Row Counts -- Chapter 29: Spreadsheet Layout and Development -- A Final Word About Spreadsheet Layout and Development -- Index |
| ctrlnum | (ZDB-30-PQE)EBC7011210 (ZDB-30-PAD)EBC7011210 (ZDB-89-EBL)EBL7011210 (OCoLC)1328133484 (DE-599)BVBBV049872748 |
| 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 |
| edition | 1st ed |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>00000nmm a2200000zc 4500</leader><controlfield tag="001">BV049872748</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">240919s2022 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781615471607</subfield><subfield code="9">978-1-61547-160-7</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-30-PQE)EBC7011210</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-30-PAD)EBC7011210</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-89-EBL)EBL7011210</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1328133484</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV049872748</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-2070s</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.369</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Jelen, Bill</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Guerrilla Data Analysis Using Microsoft Excel</subfield><subfield code="b">Overcoming Crap Data and Excel Skirmishes</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">1st ed</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Chicago</subfield><subfield code="b">Holy Macro! Books</subfield><subfield code="c">2022</subfield></datafield><datafield tag="264" ind1=" " ind2="4"><subfield code="c">©2022</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (277 Seiten)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Description based on publisher supplied metadata and other sources</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Intro -- Introduction: Welcome to the World of Guerrilla Data Analysis! -- About This Book -- Blindsided by Data -- Small, Stupid Stuff and Big, Complicated Stuff -- Chapter 1: Reviewing the Basics -- Overview of Excel Functions and Formulas -- Relative, Absolute, and Mixed References -- Text Manipulation Functions -- IF Statements -- Developing Dynamic Spreadsheets -- Concatenating Names and Changing Formulas to Values -- Linking Worksheets and Workbooks -- Helper Columns -- Sorting and Filtering -- Chapter 2: Excel Tables: The Glue in Dynamic Spreadsheet Development -- Converting a Data Range to a Table -- Using a Total Row -- Naming a Table -- Using Tables to Make Dynamic Dropdown Lists -- Tables Functions and Cell References -- Some Warnings About Working with Tables -- Excel Tables Conclusion -- Chapter 3: Collaboration Tools -- How to Share a Workbook -- The Awesome Part of Collaboration: Sheet Views -- Chapter 4: Summing and Counting with Criteria -- Chapter 5: VLOOKUP and XLOOKUP -- VLOOKUP: What Does It Do? -- XLOOKUP -- Chapter 6: Pivot Tables: The Turning Point! -- What Is a Pivot Table, and What Can It Do? -- Getting to Know the Pivot Table Interface -- Building a Pivot Table to Sum and Count Values -- Summing and Counting Side-by-Side ... and a Filter -- Filtering with the Pivot Table -- Grouping Dates in the Pivot Table -- Using the Pivot Table to Get the Percentage of the Total -- Pivot Table Percentages Without Totals -- Using the Pivot Table to Drill Down for Isolated Details -- Deleting a Pivot Table -- Saving Your Favorite Pivot Table Settings Using Pivot Table Defaults -- Creating a Year-over-Year Report in a Pivot Table -- Counting Distinct Values in a Pivot Table -- Pivot Table Conclusions -- Chapter 7: Power Query -- Power Query: A Little Background -- Filling Down and Splitting Columns by Delimiter</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Splitting Column into Rows, Grouping By, and Duplicating a Query -- Data Types and Power Query -- Sorting in Power Query -- The Query Settings Pane -- Adding More Source Data -- Unpivoting and Filtering -- Blanks, Nulls, and Zeros: They Aren't the Same in Power Query -- Joins and Merges in Power Query -- Appending (aka Stacking Stuff Up) -- Importing from a File or from a Folder -- Transformation Tables -- Fuzzy Matching -- Chapter 8: Conditional Formatting -- Using Conditional Formatting to Find Duplicates -- Using Icons with Conditional Formatting -- Chapter 9: De-duping in Excel -- De-duping with Advanced Filter -- De-duping Gets Ugly! -- Using IF to "LOOK" -- De-duping with an Assembled ID -- Chapter 10: Dynamic Arrays -- SORT -- FILTER -- RANDARRAY -- UNIQUE -- The @ Operator, Briefly Known as SINGLE -- The Spill Indicator -- Chapter 11: Data Is Never 100% Clean (Not for Very Long) -- Chapter 12: Data Validation: Controlling Inputs and Maintaining Data Integrity -- Data Validation Overview -- Implementing Dropdown Lists -- New in 2022: AutoComplete in Validation Dropdown Lists -- Controlling Dates -- Reasonable Numbers -- Data Validation Cautions -- Data Validation Conclusions -- Chapter 13: Protecting Sheets and Cells -- Locking Down an Entire Sheet -- Locking and Unlocking Cells -- Unprotecting a Sheet -- Chapter 14: Octopus Spreadsheets -- Chapter 15: INDIRECT -- Chapter 16: OFFSET -- Using OFFSET to Sum a Range -- Chapter 17: Recognizing Patterns -- Chapter 18: Data Types and Stock History -- Original Release Data Types -- Second Release Data Types: Wolfram -- Data Types: Navigating the Data Card -- Custom Data Types: Features Needed -- Custom Data Types: The Choices Available Today -- Chapter 19: Graphing -- Graphing a Histogram Using the FREQUENCY Function -- Using Chart Features -- Chapter 20: The Dangers of Just Diving In</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Chapter 21: The LET Function -- LET for Reusing Parts of Formulas -- LET for Easier Readability -- Chapter 22: Warnings About Machine Learning-Driven Features in Excel and Power Query -- Chapter 23: Avoid Working on Your Source Data -- Chapter 24: Using Slicers -- Using Slicers with Tables -- Pivot Tables and Slicers -- Chapter 25: Data Models and Relationships -- Foreign and Primary Keys -- Why a Data Model vs. Power Query? -- Chapter 26: People, Processes, and Tools -- Chapter 27: Keeping Your Data in as Few Places as Possible -- Chapter 28: Rough-and-Tumble Tips and Insights -- Unhiding Column A -- Formula Triggers -- Adding Emojis to Cells and Formulas -- Hiding Unnecessary Zeros -- Forcing a Report to Fit on One Page -- Setting the Print Area to Print a Section of a Worksheet -- Alt+Enter for an Extra Line in a Cell -- Handling Dates -- Connecting Cell Values to Shapes or Objects -- Useful Excel Functions -- Integrity Checks and Troubleshooting -- Error-Handling Functions: IFNA vs. IFERROR -- Row Counts -- Chapter 29: Spreadsheet Layout and Development -- A Final Word About Spreadsheet Layout and Development -- Index</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">du Soleil, Oz</subfield><subfield code="e">Sonstige</subfield><subfield code="4">oth</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">du Soleil, Oz</subfield><subfield code="e">Sonstige</subfield><subfield code="4">oth</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">du Soleil, Oz</subfield><subfield code="e">Sonstige</subfield><subfield code="4">oth</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="a">Jelen, Bill</subfield><subfield code="t">Guerrilla Data Analysis Using Microsoft Excel</subfield><subfield code="d">Chicago : Holy Macro! Books,c2022</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-PQE</subfield></datafield><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-035212206</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://ebookcentral.proquest.com/lib/hwr/detail.action?docID=7011210</subfield><subfield code="l">DE-2070s</subfield><subfield code="p">ZDB-30-PQE</subfield><subfield code="q">HWR_PDA_PQE</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield></record></collection> |
| id | DE-604.BV049872748 |
| illustrated | Not Illustrated |
| indexdate | 2024-09-19T05:21:46Z |
| institution | BVB |
| isbn | 9781615471607 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-035212206 |
| oclc_num | 1328133484 |
| open_access_boolean | |
| owner | DE-2070s |
| owner_facet | DE-2070s |
| physical | 1 Online-Ressource (277 Seiten) |
| psigel | ZDB-30-PQE ZDB-30-PQE HWR_PDA_PQE |
| publishDate | 2022 |
| publishDateSearch | 2022 |
| publishDateSort | 2022 |
| publisher | Holy Macro! Books |
| record_format | marc |
| spelling | Jelen, Bill Verfasser aut Guerrilla Data Analysis Using Microsoft Excel Overcoming Crap Data and Excel Skirmishes 1st ed Chicago Holy Macro! Books 2022 ©2022 1 Online-Ressource (277 Seiten) txt rdacontent c rdamedia cr rdacarrier Description based on publisher supplied metadata and other sources Intro -- Introduction: Welcome to the World of Guerrilla Data Analysis! -- About This Book -- Blindsided by Data -- Small, Stupid Stuff and Big, Complicated Stuff -- Chapter 1: Reviewing the Basics -- Overview of Excel Functions and Formulas -- Relative, Absolute, and Mixed References -- Text Manipulation Functions -- IF Statements -- Developing Dynamic Spreadsheets -- Concatenating Names and Changing Formulas to Values -- Linking Worksheets and Workbooks -- Helper Columns -- Sorting and Filtering -- Chapter 2: Excel Tables: The Glue in Dynamic Spreadsheet Development -- Converting a Data Range to a Table -- Using a Total Row -- Naming a Table -- Using Tables to Make Dynamic Dropdown Lists -- Tables Functions and Cell References -- Some Warnings About Working with Tables -- Excel Tables Conclusion -- Chapter 3: Collaboration Tools -- How to Share a Workbook -- The Awesome Part of Collaboration: Sheet Views -- Chapter 4: Summing and Counting with Criteria -- Chapter 5: VLOOKUP and XLOOKUP -- VLOOKUP: What Does It Do? -- XLOOKUP -- Chapter 6: Pivot Tables: The Turning Point! -- What Is a Pivot Table, and What Can It Do? -- Getting to Know the Pivot Table Interface -- Building a Pivot Table to Sum and Count Values -- Summing and Counting Side-by-Side ... and a Filter -- Filtering with the Pivot Table -- Grouping Dates in the Pivot Table -- Using the Pivot Table to Get the Percentage of the Total -- Pivot Table Percentages Without Totals -- Using the Pivot Table to Drill Down for Isolated Details -- Deleting a Pivot Table -- Saving Your Favorite Pivot Table Settings Using Pivot Table Defaults -- Creating a Year-over-Year Report in a Pivot Table -- Counting Distinct Values in a Pivot Table -- Pivot Table Conclusions -- Chapter 7: Power Query -- Power Query: A Little Background -- Filling Down and Splitting Columns by Delimiter Splitting Column into Rows, Grouping By, and Duplicating a Query -- Data Types and Power Query -- Sorting in Power Query -- The Query Settings Pane -- Adding More Source Data -- Unpivoting and Filtering -- Blanks, Nulls, and Zeros: They Aren't the Same in Power Query -- Joins and Merges in Power Query -- Appending (aka Stacking Stuff Up) -- Importing from a File or from a Folder -- Transformation Tables -- Fuzzy Matching -- Chapter 8: Conditional Formatting -- Using Conditional Formatting to Find Duplicates -- Using Icons with Conditional Formatting -- Chapter 9: De-duping in Excel -- De-duping with Advanced Filter -- De-duping Gets Ugly! -- Using IF to "LOOK" -- De-duping with an Assembled ID -- Chapter 10: Dynamic Arrays -- SORT -- FILTER -- RANDARRAY -- UNIQUE -- The @ Operator, Briefly Known as SINGLE -- The Spill Indicator -- Chapter 11: Data Is Never 100% Clean (Not for Very Long) -- Chapter 12: Data Validation: Controlling Inputs and Maintaining Data Integrity -- Data Validation Overview -- Implementing Dropdown Lists -- New in 2022: AutoComplete in Validation Dropdown Lists -- Controlling Dates -- Reasonable Numbers -- Data Validation Cautions -- Data Validation Conclusions -- Chapter 13: Protecting Sheets and Cells -- Locking Down an Entire Sheet -- Locking and Unlocking Cells -- Unprotecting a Sheet -- Chapter 14: Octopus Spreadsheets -- Chapter 15: INDIRECT -- Chapter 16: OFFSET -- Using OFFSET to Sum a Range -- Chapter 17: Recognizing Patterns -- Chapter 18: Data Types and Stock History -- Original Release Data Types -- Second Release Data Types: Wolfram -- Data Types: Navigating the Data Card -- Custom Data Types: Features Needed -- Custom Data Types: The Choices Available Today -- Chapter 19: Graphing -- Graphing a Histogram Using the FREQUENCY Function -- Using Chart Features -- Chapter 20: The Dangers of Just Diving In Chapter 21: The LET Function -- LET for Reusing Parts of Formulas -- LET for Easier Readability -- Chapter 22: Warnings About Machine Learning-Driven Features in Excel and Power Query -- Chapter 23: Avoid Working on Your Source Data -- Chapter 24: Using Slicers -- Using Slicers with Tables -- Pivot Tables and Slicers -- Chapter 25: Data Models and Relationships -- Foreign and Primary Keys -- Why a Data Model vs. Power Query? -- Chapter 26: People, Processes, and Tools -- Chapter 27: Keeping Your Data in as Few Places as Possible -- Chapter 28: Rough-and-Tumble Tips and Insights -- Unhiding Column A -- Formula Triggers -- Adding Emojis to Cells and Formulas -- Hiding Unnecessary Zeros -- Forcing a Report to Fit on One Page -- Setting the Print Area to Print a Section of a Worksheet -- Alt+Enter for an Extra Line in a Cell -- Handling Dates -- Connecting Cell Values to Shapes or Objects -- Useful Excel Functions -- Integrity Checks and Troubleshooting -- Error-Handling Functions: IFNA vs. IFERROR -- Row Counts -- Chapter 29: Spreadsheet Layout and Development -- A Final Word About Spreadsheet Layout and Development -- Index Microsoft Excel (Computer file) du Soleil, Oz Sonstige oth Erscheint auch als Druck-Ausgabe Jelen, Bill Guerrilla Data Analysis Using Microsoft Excel Chicago : Holy Macro! Books,c2022 |
| spellingShingle | Jelen, Bill Guerrilla Data Analysis Using Microsoft Excel Overcoming Crap Data and Excel Skirmishes Intro -- Introduction: Welcome to the World of Guerrilla Data Analysis! -- About This Book -- Blindsided by Data -- Small, Stupid Stuff and Big, Complicated Stuff -- Chapter 1: Reviewing the Basics -- Overview of Excel Functions and Formulas -- Relative, Absolute, and Mixed References -- Text Manipulation Functions -- IF Statements -- Developing Dynamic Spreadsheets -- Concatenating Names and Changing Formulas to Values -- Linking Worksheets and Workbooks -- Helper Columns -- Sorting and Filtering -- Chapter 2: Excel Tables: The Glue in Dynamic Spreadsheet Development -- Converting a Data Range to a Table -- Using a Total Row -- Naming a Table -- Using Tables to Make Dynamic Dropdown Lists -- Tables Functions and Cell References -- Some Warnings About Working with Tables -- Excel Tables Conclusion -- Chapter 3: Collaboration Tools -- How to Share a Workbook -- The Awesome Part of Collaboration: Sheet Views -- Chapter 4: Summing and Counting with Criteria -- Chapter 5: VLOOKUP and XLOOKUP -- VLOOKUP: What Does It Do? -- XLOOKUP -- Chapter 6: Pivot Tables: The Turning Point! -- What Is a Pivot Table, and What Can It Do? -- Getting to Know the Pivot Table Interface -- Building a Pivot Table to Sum and Count Values -- Summing and Counting Side-by-Side ... and a Filter -- Filtering with the Pivot Table -- Grouping Dates in the Pivot Table -- Using the Pivot Table to Get the Percentage of the Total -- Pivot Table Percentages Without Totals -- Using the Pivot Table to Drill Down for Isolated Details -- Deleting a Pivot Table -- Saving Your Favorite Pivot Table Settings Using Pivot Table Defaults -- Creating a Year-over-Year Report in a Pivot Table -- Counting Distinct Values in a Pivot Table -- Pivot Table Conclusions -- Chapter 7: Power Query -- Power Query: A Little Background -- Filling Down and Splitting Columns by Delimiter Splitting Column into Rows, Grouping By, and Duplicating a Query -- Data Types and Power Query -- Sorting in Power Query -- The Query Settings Pane -- Adding More Source Data -- Unpivoting and Filtering -- Blanks, Nulls, and Zeros: They Aren't the Same in Power Query -- Joins and Merges in Power Query -- Appending (aka Stacking Stuff Up) -- Importing from a File or from a Folder -- Transformation Tables -- Fuzzy Matching -- Chapter 8: Conditional Formatting -- Using Conditional Formatting to Find Duplicates -- Using Icons with Conditional Formatting -- Chapter 9: De-duping in Excel -- De-duping with Advanced Filter -- De-duping Gets Ugly! -- Using IF to "LOOK" -- De-duping with an Assembled ID -- Chapter 10: Dynamic Arrays -- SORT -- FILTER -- RANDARRAY -- UNIQUE -- The @ Operator, Briefly Known as SINGLE -- The Spill Indicator -- Chapter 11: Data Is Never 100% Clean (Not for Very Long) -- Chapter 12: Data Validation: Controlling Inputs and Maintaining Data Integrity -- Data Validation Overview -- Implementing Dropdown Lists -- New in 2022: AutoComplete in Validation Dropdown Lists -- Controlling Dates -- Reasonable Numbers -- Data Validation Cautions -- Data Validation Conclusions -- Chapter 13: Protecting Sheets and Cells -- Locking Down an Entire Sheet -- Locking and Unlocking Cells -- Unprotecting a Sheet -- Chapter 14: Octopus Spreadsheets -- Chapter 15: INDIRECT -- Chapter 16: OFFSET -- Using OFFSET to Sum a Range -- Chapter 17: Recognizing Patterns -- Chapter 18: Data Types and Stock History -- Original Release Data Types -- Second Release Data Types: Wolfram -- Data Types: Navigating the Data Card -- Custom Data Types: Features Needed -- Custom Data Types: The Choices Available Today -- Chapter 19: Graphing -- Graphing a Histogram Using the FREQUENCY Function -- Using Chart Features -- Chapter 20: The Dangers of Just Diving In Chapter 21: The LET Function -- LET for Reusing Parts of Formulas -- LET for Easier Readability -- Chapter 22: Warnings About Machine Learning-Driven Features in Excel and Power Query -- Chapter 23: Avoid Working on Your Source Data -- Chapter 24: Using Slicers -- Using Slicers with Tables -- Pivot Tables and Slicers -- Chapter 25: Data Models and Relationships -- Foreign and Primary Keys -- Why a Data Model vs. Power Query? -- Chapter 26: People, Processes, and Tools -- Chapter 27: Keeping Your Data in as Few Places as Possible -- Chapter 28: Rough-and-Tumble Tips and Insights -- Unhiding Column A -- Formula Triggers -- Adding Emojis to Cells and Formulas -- Hiding Unnecessary Zeros -- Forcing a Report to Fit on One Page -- Setting the Print Area to Print a Section of a Worksheet -- Alt+Enter for an Extra Line in a Cell -- Handling Dates -- Connecting Cell Values to Shapes or Objects -- Useful Excel Functions -- Integrity Checks and Troubleshooting -- Error-Handling Functions: IFNA vs. IFERROR -- Row Counts -- Chapter 29: Spreadsheet Layout and Development -- A Final Word About Spreadsheet Layout and Development -- Index Microsoft Excel (Computer file) |
| title | Guerrilla Data Analysis Using Microsoft Excel Overcoming Crap Data and Excel Skirmishes |
| title_auth | Guerrilla Data Analysis Using Microsoft Excel Overcoming Crap Data and Excel Skirmishes |
| title_exact_search | Guerrilla Data Analysis Using Microsoft Excel Overcoming Crap Data and Excel Skirmishes |
| title_full | Guerrilla Data Analysis Using Microsoft Excel Overcoming Crap Data and Excel Skirmishes |
| title_fullStr | Guerrilla Data Analysis Using Microsoft Excel Overcoming Crap Data and Excel Skirmishes |
| title_full_unstemmed | Guerrilla Data Analysis Using Microsoft Excel Overcoming Crap Data and Excel Skirmishes |
| title_short | Guerrilla Data Analysis Using Microsoft Excel |
| title_sort | guerrilla data analysis using microsoft excel overcoming crap data and excel skirmishes |
| title_sub | Overcoming Crap Data and Excel Skirmishes |
| topic | Microsoft Excel (Computer file) |
| topic_facet | Microsoft Excel (Computer file) |
| work_keys_str_mv | AT jelenbill guerrilladataanalysisusingmicrosoftexcelovercomingcrapdataandexcelskirmishes AT dusoleiloz guerrilladataanalysisusingmicrosoftexcelovercomingcrapdataandexcelskirmishes |