Microsoft Excel Inside Out (Office 2021 and Microsoft 365)
Master proven processes for improving development with Scrum and Azure DevOps

This guide can help any development team plan, track, and manage work far more effectively, by combining today's leading agile framework (Scrum) and Microsoft's ALM/DevOps toolset (Azure DevOps). Renowned Scrum expert Richard Hundhausen thoroughly covers team formation, backlogs, Sprints, test plans, collaboration, flow, continuous improvement, Azure Boards, Azure Test Plans, and the real-world tradeoffs associated with DevOps. Throughout, you'll find practical, in-the-trenches tips from experienced Professional Scrum Developers. To make this guide even more valuable, Hundhausen has organized it to complement Scrum.org's popular Professional Scrum Developer (PSD) program, which he created with Scrum.org's Ken Schwaber, author of this book's Foreword.


Professional Scrum Trainer Richard Hundhausen shows how to:
  •  Deepen your understanding of the Scrum framework and Professional Scrum as based on the 2020 Scrum Guide.
  • Provide proven work item planning and tracking, and quickly drive value from Azure Boards
  • Improve your Scrum “pre-game”: the tasks you'll perform before your first Sprint
  • Use Azure DevOps to create and manage backlogs, plan Sprints, and collaborate throughout them
  • Improve at scale with Scaled Professional Scrum and the Nexus scaled Scrum framework
  • Recognize which practices are still most efficiently performed without tools
  • Define and optimize team flow, overcome common dysfunctions, and evolve into a high-performance Professional Scrum Team

About This Book

  • For everyone who works with or relies on Scrum, including developers, designers, architects, testers, business analysts, Product Owners, Scrum Masters, managers, and other stakeholders
  • Focuses primarily on using Scrum for software products, but can support development of adaptive solutions for any complex problem performance Professional Scrum Team

1139452833
Microsoft Excel Inside Out (Office 2021 and Microsoft 365)
Master proven processes for improving development with Scrum and Azure DevOps

This guide can help any development team plan, track, and manage work far more effectively, by combining today's leading agile framework (Scrum) and Microsoft's ALM/DevOps toolset (Azure DevOps). Renowned Scrum expert Richard Hundhausen thoroughly covers team formation, backlogs, Sprints, test plans, collaboration, flow, continuous improvement, Azure Boards, Azure Test Plans, and the real-world tradeoffs associated with DevOps. Throughout, you'll find practical, in-the-trenches tips from experienced Professional Scrum Developers. To make this guide even more valuable, Hundhausen has organized it to complement Scrum.org's popular Professional Scrum Developer (PSD) program, which he created with Scrum.org's Ken Schwaber, author of this book's Foreword.


Professional Scrum Trainer Richard Hundhausen shows how to:
  •  Deepen your understanding of the Scrum framework and Professional Scrum as based on the 2020 Scrum Guide.
  • Provide proven work item planning and tracking, and quickly drive value from Azure Boards
  • Improve your Scrum “pre-game”: the tasks you'll perform before your first Sprint
  • Use Azure DevOps to create and manage backlogs, plan Sprints, and collaborate throughout them
  • Improve at scale with Scaled Professional Scrum and the Nexus scaled Scrum framework
  • Recognize which practices are still most efficiently performed without tools
  • Define and optimize team flow, overcome common dysfunctions, and evolve into a high-performance Professional Scrum Team

About This Book

  • For everyone who works with or relies on Scrum, including developers, designers, architects, testers, business analysts, Product Owners, Scrum Masters, managers, and other stakeholders
  • Focuses primarily on using Scrum for software products, but can support development of adaptive solutions for any complex problem performance Professional Scrum Team

39.99 In Stock
Microsoft Excel Inside Out (Office 2021 and Microsoft 365)

Microsoft Excel Inside Out (Office 2021 and Microsoft 365)

by Bill Jelen
Microsoft Excel Inside Out (Office 2021 and Microsoft 365)

Microsoft Excel Inside Out (Office 2021 and Microsoft 365)

by Bill Jelen

eBook

$39.99  $52.99 Save 25% Current price is $39.99, Original price is $52.99. You Save 25%.

Available on Compatible NOOK devices, the free NOOK App and in My Digital Library.
WANT A NOOK?  Explore Now

Related collections and offers


Overview

Master proven processes for improving development with Scrum and Azure DevOps

This guide can help any development team plan, track, and manage work far more effectively, by combining today's leading agile framework (Scrum) and Microsoft's ALM/DevOps toolset (Azure DevOps). Renowned Scrum expert Richard Hundhausen thoroughly covers team formation, backlogs, Sprints, test plans, collaboration, flow, continuous improvement, Azure Boards, Azure Test Plans, and the real-world tradeoffs associated with DevOps. Throughout, you'll find practical, in-the-trenches tips from experienced Professional Scrum Developers. To make this guide even more valuable, Hundhausen has organized it to complement Scrum.org's popular Professional Scrum Developer (PSD) program, which he created with Scrum.org's Ken Schwaber, author of this book's Foreword.


Professional Scrum Trainer Richard Hundhausen shows how to:
  •  Deepen your understanding of the Scrum framework and Professional Scrum as based on the 2020 Scrum Guide.
  • Provide proven work item planning and tracking, and quickly drive value from Azure Boards
  • Improve your Scrum “pre-game”: the tasks you'll perform before your first Sprint
  • Use Azure DevOps to create and manage backlogs, plan Sprints, and collaborate throughout them
  • Improve at scale with Scaled Professional Scrum and the Nexus scaled Scrum framework
  • Recognize which practices are still most efficiently performed without tools
  • Define and optimize team flow, overcome common dysfunctions, and evolve into a high-performance Professional Scrum Team

About This Book

  • For everyone who works with or relies on Scrum, including developers, designers, architects, testers, business analysts, Product Owners, Scrum Masters, managers, and other stakeholders
  • Focuses primarily on using Scrum for software products, but can support development of adaptive solutions for any complex problem performance Professional Scrum Team


Product Details

ISBN-13: 9780137559565
Publisher: Pearson Education
Publication date: 12/22/2021
Series: Inside Out
Sold by: Barnes & Noble
Format: eBook
Pages: 848
Sales rank: 884,738
File size: 88 MB
Note: This product may take a few minutes to download.
Age Range: 18 Years

Table of Contents

Part I   The Excel interface

Chapter 1        What's new in Microsoft 365 Excel

Chapter 2        Using the Excel interface

Chapter 3        Customizing Excel

Chapter 4        Keyboard shortcuts

 

Part II  Calculating with Excel

Chapter 5        Understanding formulas

Chapter 6        Controlling formulas

Chapter 7        Understanding functions

Chapter 8        Using everyday functions: math, date and time, and text functions

Chapter 9        Using powerful functions: logical, lookup, and database functions

Chapter 10      Using names, LET, LAMBDA, and Data Types in Excel

Chapter 11      Connecting worksheets and workbooks

Chapter 12      Dynamic array formulas and names in Excel


Part III Data analysis with Excel

Chapter 13      Transforming data with Power Query

Chapter 14      Summarizing data using subtotals or filter

Chapter 15      Using pivot tables to analyze data

Chapter 16      Using slicers and filtering a pivot table

Chapter 17      Mashing up data with Power Pivot

Chapter 18      Using What-If, Scenario Manager, Goal Seek, and Solver

Chapter 19      Automating repetitive functions using VBA macros

Chapter 20      More tips and tricks for Excel

 

Part IV Excel visuals

Chapter 21      Formatting worksheets

Chapter 22      Using data visualizations and conditional formatting

Chapter 23      Graphing data using Excel charts

Chapter 24      Using 3D Maps

Chapter 25      Using sparklines

Chapter 26      Formatting spreadsheets for presentation

Chapter 27      Printing

Chapter 28      Collaborating in Excel

 

Part V  Appendixes

Appendix A     Excel functions

Appendix B      Excel functions with DAX or Power Query equivalents

Appendix C      Adding functionality to Excel with add-ins

Index

From the B&N Reads Blog

Customer Reviews