Power Pivot alchemy : patterns and techniques for Excel / / Rob Collie and Bill Jelen ; cover design, Jocelyn Hellyer ; indexing, Nellie J. Liwam |
Autore | Collie Rob |
Pubbl/distr/stampa | Uniontown, Ohio : , : Holy Macro! Books, , 2014 |
Descrizione fisica | 1 online resource (257 p.) |
Disciplina | 005.54 |
Soggetto topico | Electronic spreadsheets - Computer programs |
Soggetto genere / forma | Electronic books. |
ISBN | 1-61547-214-2 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Title page; Copyright; Table of Contents; Dedications; A Note on Hyperlinks; Acknowledgements; Foreword; Introduction; Chapter 1: Dashboard Tricks and Visualization Techniques; Adding a "Last Refreshed Date" Readout; Normalizing Your Measures to First/Average/Max Values for Charts; Bubbling Up Exceptions with "Sarah Problem"; Ranks and Exceptions That Bubble Up to Subtotals; Chapter 2: Slicers: The Gateway to Interactivity; "Initializing" Slicers That Contain Too Many Values to Scroll; Wingdings and Other Symbolic Fonts in Slicers; Using Macros to Change Slicer Fonts
A Simple Trick for Combatting "Stale" SlicersUser-Friendly Report Sorting with Slicers; Adding State Alpha Sorting to the Sort-by-Slicer Trick; Conditional Formatting Controlled via Slicers; Catching Slicer Selections in a Formula; Chapter 3: Conquering Common Calculated Column Conundrums; An Excel Pro's Primer on Calculated Columns; Subtotaling Calc Columns and the EARLIER() Function; Referencing the Previous Row and Similar Calcs; Referencing Rows "Within Range" of the Current Row; Totaling Data Table Values in Lookup Tables; CONTAINSX: Finding Matching Values in Two Tables CONTAINSX Revisited: What Is the Match?Common Calendar Conundrums; Custom Calendar Conundrums; Chapter 4: Modeling and Portable Formulas; Integrating Data of Different "Grains"; A Mystifying and Awesome Solution for the Many-to-Many Problem; Calculating Same-Store Sales in Power Pivot; Same-Store Sales Continued: Using Store Open/Close Dates; Campaign Analysis: Seasonally Adjusted Measures; A/B Campaign Analysis with Start and End Date Slicers; Customers and Website Visitors: Percentage Who Return; Calculating Average Customer Age; Moving Averages, Sums, etc Moving Averages Controlled by a SlicerChapter 5: Power Query; Combining Multiple Worksheets or Workbooks into a Single Power Pivot Table; Using Power Query to Merge CSV Files; Using Power Query to "Unpivot" a Table; Using Power Query to Create a Lookup Table from a Data Table; Creating a Calendar Table: Advanced Usage of Power Query; Chapter 6: Power View; How to Use Power View; Chapter 7: Power Map; Thank you; Index; More from Holy Macro! Books |
Record Nr. | UNINA-9910458278803321 |
Collie Rob
![]() |
||
Uniontown, Ohio : , : Holy Macro! Books, , 2014 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Power Pivot alchemy : patterns and techniques for Excel / / Rob Collie and Bill Jelen ; cover design, Jocelyn Hellyer ; indexing, Nellie J. Liwam |
Autore | Collie Rob |
Pubbl/distr/stampa | Uniontown, Ohio : , : Holy Macro! Books, , 2014 |
Descrizione fisica | 1 online resource (257 p.) |
Disciplina | 005.54 |
Soggetto topico | Electronic spreadsheets - Computer programs |
ISBN | 1-61547-214-2 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Title page; Copyright; Table of Contents; Dedications; A Note on Hyperlinks; Acknowledgements; Foreword; Introduction; Chapter 1: Dashboard Tricks and Visualization Techniques; Adding a "Last Refreshed Date" Readout; Normalizing Your Measures to First/Average/Max Values for Charts; Bubbling Up Exceptions with "Sarah Problem"; Ranks and Exceptions That Bubble Up to Subtotals; Chapter 2: Slicers: The Gateway to Interactivity; "Initializing" Slicers That Contain Too Many Values to Scroll; Wingdings and Other Symbolic Fonts in Slicers; Using Macros to Change Slicer Fonts
A Simple Trick for Combatting "Stale" SlicersUser-Friendly Report Sorting with Slicers; Adding State Alpha Sorting to the Sort-by-Slicer Trick; Conditional Formatting Controlled via Slicers; Catching Slicer Selections in a Formula; Chapter 3: Conquering Common Calculated Column Conundrums; An Excel Pro's Primer on Calculated Columns; Subtotaling Calc Columns and the EARLIER() Function; Referencing the Previous Row and Similar Calcs; Referencing Rows "Within Range" of the Current Row; Totaling Data Table Values in Lookup Tables; CONTAINSX: Finding Matching Values in Two Tables CONTAINSX Revisited: What Is the Match?Common Calendar Conundrums; Custom Calendar Conundrums; Chapter 4: Modeling and Portable Formulas; Integrating Data of Different "Grains"; A Mystifying and Awesome Solution for the Many-to-Many Problem; Calculating Same-Store Sales in Power Pivot; Same-Store Sales Continued: Using Store Open/Close Dates; Campaign Analysis: Seasonally Adjusted Measures; A/B Campaign Analysis with Start and End Date Slicers; Customers and Website Visitors: Percentage Who Return; Calculating Average Customer Age; Moving Averages, Sums, etc Moving Averages Controlled by a SlicerChapter 5: Power Query; Combining Multiple Worksheets or Workbooks into a Single Power Pivot Table; Using Power Query to Merge CSV Files; Using Power Query to "Unpivot" a Table; Using Power Query to Create a Lookup Table from a Data Table; Creating a Calendar Table: Advanced Usage of Power Query; Chapter 6: Power View; How to Use Power View; Chapter 7: Power Map; Thank you; Index; More from Holy Macro! Books |
Record Nr. | UNINA-9910791025603321 |
Collie Rob
![]() |
||
Uniontown, Ohio : , : Holy Macro! Books, , 2014 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Power Pivot alchemy : patterns and techniques for Excel / / Rob Collie and Bill Jelen ; cover design, Jocelyn Hellyer ; indexing, Nellie J. Liwam |
Autore | Collie Rob |
Pubbl/distr/stampa | Uniontown, Ohio : , : Holy Macro! Books, , 2014 |
Descrizione fisica | 1 online resource (257 p.) |
Disciplina | 005.54 |
Soggetto topico | Electronic spreadsheets - Computer programs |
ISBN | 1-61547-214-2 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Title page; Copyright; Table of Contents; Dedications; A Note on Hyperlinks; Acknowledgements; Foreword; Introduction; Chapter 1: Dashboard Tricks and Visualization Techniques; Adding a "Last Refreshed Date" Readout; Normalizing Your Measures to First/Average/Max Values for Charts; Bubbling Up Exceptions with "Sarah Problem"; Ranks and Exceptions That Bubble Up to Subtotals; Chapter 2: Slicers: The Gateway to Interactivity; "Initializing" Slicers That Contain Too Many Values to Scroll; Wingdings and Other Symbolic Fonts in Slicers; Using Macros to Change Slicer Fonts
A Simple Trick for Combatting "Stale" SlicersUser-Friendly Report Sorting with Slicers; Adding State Alpha Sorting to the Sort-by-Slicer Trick; Conditional Formatting Controlled via Slicers; Catching Slicer Selections in a Formula; Chapter 3: Conquering Common Calculated Column Conundrums; An Excel Pro's Primer on Calculated Columns; Subtotaling Calc Columns and the EARLIER() Function; Referencing the Previous Row and Similar Calcs; Referencing Rows "Within Range" of the Current Row; Totaling Data Table Values in Lookup Tables; CONTAINSX: Finding Matching Values in Two Tables CONTAINSX Revisited: What Is the Match?Common Calendar Conundrums; Custom Calendar Conundrums; Chapter 4: Modeling and Portable Formulas; Integrating Data of Different "Grains"; A Mystifying and Awesome Solution for the Many-to-Many Problem; Calculating Same-Store Sales in Power Pivot; Same-Store Sales Continued: Using Store Open/Close Dates; Campaign Analysis: Seasonally Adjusted Measures; A/B Campaign Analysis with Start and End Date Slicers; Customers and Website Visitors: Percentage Who Return; Calculating Average Customer Age; Moving Averages, Sums, etc Moving Averages Controlled by a SlicerChapter 5: Power Query; Combining Multiple Worksheets or Workbooks into a Single Power Pivot Table; Using Power Query to Merge CSV Files; Using Power Query to "Unpivot" a Table; Using Power Query to Create a Lookup Table from a Data Table; Creating a Calendar Table: Advanced Usage of Power Query; Chapter 6: Power View; How to Use Power View; Chapter 7: Power Map; Thank you; Index; More from Holy Macro! Books |
Record Nr. | UNINA-9910814810603321 |
Collie Rob
![]() |
||
Uniontown, Ohio : , : Holy Macro! Books, , 2014 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
The spreadsheet at 25 [[electronic resource] ] : 25 amazing Excel examples that evolved from the invention that changed the world! / / [Bill Jelen] |
Autore | Jelen Bill |
Pubbl/distr/stampa | Uniontown, OH, : Holy Macro! Books, c2005 |
Descrizione fisica | 1 online resource (131 p.) |
Disciplina |
005.36
005.369 005.54 |
Soggetto topico |
Computer software - Development - History
Electronic spreadsheets |
Soggetto genere / forma | Electronic books. |
ISBN | 1-932802-52-5 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | Cover; Table of Contents; Chapter1; Chapter2; Chapter3; Chapter4; Chapter5; Afterword; Back Cover |
Record Nr. | UNINA-9910453929503321 |
Jelen Bill
![]() |
||
Uniontown, OH, : Holy Macro! Books, c2005 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
The spreadsheet at 25 [[electronic resource] ] : 25 amazing Excel examples that evolved from the invention that changed the world! / / [Bill Jelen] |
Autore | Jelen Bill |
Pubbl/distr/stampa | Uniontown, OH, : Holy Macro! Books, c2005 |
Descrizione fisica | 1 online resource (131 p.) |
Disciplina |
005.36
005.369 005.54 |
Soggetto topico |
Computer software - Development - History
Electronic spreadsheets |
ISBN | 1-932802-52-5 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | Cover; Table of Contents; Chapter1; Chapter2; Chapter3; Chapter4; Chapter5; Afterword; Back Cover |
Record Nr. | UNINA-9910782140303321 |
Jelen Bill
![]() |
||
Uniontown, OH, : Holy Macro! Books, c2005 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
The spreadsheet at 25 [[electronic resource] ] : 25 amazing Excel examples that evolved from the invention that changed the world! / / [Bill Jelen] |
Autore | Jelen Bill |
Pubbl/distr/stampa | Uniontown, OH, : Holy Macro! Books, c2005 |
Descrizione fisica | 1 online resource (131 p.) |
Disciplina |
005.36
005.369 005.54 |
Soggetto topico |
Computer software - Development - History
Electronic spreadsheets |
ISBN | 1-932802-52-5 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | Cover; Table of Contents; Chapter1; Chapter2; Chapter3; Chapter4; Chapter5; Afterword; Back Cover |
Record Nr. | UNINA-9910824749603321 |
Jelen Bill
![]() |
||
Uniontown, OH, : Holy Macro! Books, c2005 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
TypeScript revealed / / Dan Maharry |
Autore | Maharry Dan |
Edizione | [1st ed. 2013.] |
Pubbl/distr/stampa | New York : , : Apress, , 2013 |
Descrizione fisica | 1 online resource (xix, 83 pages) : color illustrations |
Disciplina | 005.54 |
Collana | The expert's voice in .NET TypeScript revealed |
Soggetto topico |
TypeScript (Computer program language)
JavaScript (Computer program language) Scripting languages (Computer science) Application software - Development |
Soggetto non controllato | Computer science |
ISBN | 1-4302-5726-1 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Title Page; Copyright Page; Contents at a Glance; Table of Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; Who Is This Book For?; What Do You Need to Know Before You Read This Book?; What Software Do You Need for This Book?; What Is the Structure of the Book?; CHAPTER 1 Getting Up to Speed with TypeScript; The Development of TypeScript; What TypeScript Is, Does, and Does Not Do; TypeScript vs. JavaScript Gotchas; Type Coercion Issues; Block Scope; Optional Semicolons and Bracket Placement; TypeScript vs. Other Compile-to-JavaScript Languages
TypeScript vs. ECMAScriptInstallation; Visual Studio 2012; Installing the Compiler and TLS Extension; Using Web Essentials; Other Visual Studio Editions; Visual Studio 2012 Express Editions; Visual Studio 2010 Professional and Higher; WebMatrix; On Node.js; Sublime Text; From JavaScript to TypeScript; A Simple HTML+JS Page; TypeScript and IntelliSense; Errors and Declaration Files; jQuery, Ambient Declarations, and Reference Hints; A Little Code Structure with Classes and Modules; Summary; CHAPTER 2 The New Syntax; The Story So Far; The Type System; Primitive Types; The Any Type; Arrays Arrays of ArraysCasts; Ambient Declarations; Functions; Variations on a Signature; Positional Parameters; Optional Parameters; Rest Parameter; Function Overloads; Classes; Class Members; Properties and Fields; Methods; Arrow Functions; Constructors; Events; Access Modifiers; Instantiating Classes; Static Classes and Members; Object Literals vs. Anonymous Types; Inheritance; Overriding Methods from the Base Class; Interfaces; Using Interfaces as Function Types; Using Interfaces as Object Types; Combining Interfaces; Modules; Summary; CHAPTER 3 Working with TypeScript; The Compiler The File ListDeclaration Files; Has Someone Else Written It?; Substitute with an Ambient Declaration; Use the Compiler to Generate a Declaration File; Roll Your Own; TypeScript in Your Projects; In Your MSBuild File; The TypeScript Files and Their Dependencies; Compiler Instructions; Tweaking Your Existing Project File; The Web Site Project; In Your Web Sites; In the Development Life Cycle; Summary; APPENDIX A Webliography; Core Links; GitHub Projects; Notable Bugs and Discussions; Miscellaneous; Index |
Record Nr. | UNINA-9910735382603321 |
Maharry Dan
![]() |
||
New York : , : Apress, , 2013 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
The Ultimate Guide to Functions in Power Query : Turn Raw Data into Actionable Insights / / Omid Motamedisedeh |
Autore | Motamedisedeh Omid |
Edizione | [First edition.] |
Pubbl/distr/stampa | New York, NY : , : Apress Media LLC, , [2024] |
Descrizione fisica | 1 online resource (410 pages) |
Disciplina | 005.54 |
Soggetto topico | Database management - Computer programs |
ISBN | 1-4842-9754-7 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | Chapter 1: Introduction to Power Query -- Chapter 2: Data Types -- Chapter 3: Number Functions -- Chapter 4: Text Functions -- Chapter 5: Date and Time Functions -- Chapter 6: List Functions -- Chapter 7: Record Functions -- Chapter 8: Table Functions -- Chapter 9: Extracting from Data Sources -- Chapter 10: Other Functions. |
Record Nr. | UNINA-9910767566303321 |
Motamedisedeh Omid
![]() |
||
New York, NY : , : Apress Media LLC, , [2024] | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Up Up and Array! [[electronic resource] ] : Dynamic Array Formulas for Excel 365 and Beyond / / by Abbott Ira Katz |
Autore | Katz Abbott Ira |
Edizione | [1st ed. 2023.] |
Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2023 |
Descrizione fisica | 1 online resource (235 pages) |
Disciplina | 005.54 |
Soggetto topico |
Microsoft software
Microsoft .NET Framework Accounting Microsoft |
ISBN | 1-4842-8966-8 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | Chapter 1: What’s an Array, Anyway? -- Chapter 2: Array Formula Basics.– Chapter 3: Dynamic Arrays -- Time for Some Heavy Lifting -- Chapter 4: The SEQUENCE Function: Made to Order -- Chapter 5: UNIQUE -- A Singular Function -- Chapter 6: SORT and SORTBY: The ABCs (and the CBAs) -- Chapter 7: The FILTER Function: Cutting the Data Down to Size -- Chapter 8: RANDARRAY: Unpredictably Useful -- Chapter 9: The Implicit Intersection Operator: The Function You'll Probably Never Use -- Chapter 10: TEXTSPLIT, TEXTBEFORE, and TEXTAFTER: Putting Words in Their Places -- Chapter 11: TOCOL and TOROW -- Straightening Out the Data -- Chapter 12: WRAPCOLS and WRAPROWS: Giving Some Direction to the Data -- Chapter 13: VSTACK and HSTACK: What They're About -- Chapter 14: CHOOSECOLS and CHOOSEROWS: Less is More -- Chapter 15: TAKE and DROP: Selecting and Rejecting the Data -- Chapter 16: EXPAND: Bulking Up the Data. |
Record Nr. | UNINA-9910633922403321 |
Katz Abbott Ira
![]() |
||
Berkeley, CA : , : Apress : , : Imprint : Apress, , 2023 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|