Boards That Excel

Boards That Excel PDF

Author: B. Joseph White

Publisher: Berrett-Koehler Publishers

Published: 2014-08-18

Total Pages: 273

ISBN-13: 1626562237

DOWNLOAD EBOOK →

"Having served on numerous corporate and nonprofit boards, former business school dean and university president White has a surprising message--many directors don't understand their roles as stewards. Rather than seeing boards as mere vehicles for oversight and basic monitoring, he shows, in detail and with hundreds of real-world anecdotes, how boards can do better"--

Boards That Lead

Boards That Lead PDF

Author: Ram

Publisher: Harvard Business Review Press

Published: 2013-11-19

Total Pages: 305

ISBN-13: 1422144070

DOWNLOAD EBOOK →

Is your firm’s board creating value—or destroying it? Change is coming. Leadership at the top is being redefined as boards take a more active role in decisions that once belonged solely to the CEO. But for all the advantages of increased board engagement, it can create debilitating questions of authority and dangerous meddling in day-to-day operations. Directors need a new road map—for when to lead, when to partner, and when to stay out of the way. Boardroom veterans Ram Charan, Dennis Carey, and Michael Useem advocate this new governance model—a sharp departure from what has been demanded by governance activists, raters, and regulators—and reveal the emerging practices that are defining shared leadership of directors and executives. Based on personal interviews and the authors’ broad and deep experience working with executives and directors from dozens of the world’s largest firms, including Apple, Boeing, Ford, Infosys, and Lenovo, Boards That Lead tells the inside story behind the successes and pitfalls of this new leadership model and explains how to: • Define the central idea of the company • Ensure that the right CEO is in place and potential successors are identified • Recruit directors who add value • Root out board dysfunction • Select a board leader who deftly bridges the divide between management and the board • Set a high bar on ethics and risk With a total of eighteen checklists that will transform board directors from monitors to leaders, Charan, Carey, and Useem provide a smart and practical guide for businesspeople everywhere—whether they occupy the boardroom or the C-suite.

VBA and Macros

VBA and Macros PDF

Author: Bill Jelen

Publisher: Pearson Education

Published: 2010

Total Pages: 654

ISBN-13: 0789743140

DOWNLOAD EBOOK →

Provides a step-by-step guide to using Visual Basic for Applications (VBA) and macros to import data and produce reports in Microsoft Excel 2010.

Don't Fear the Spreadsheet

Don't Fear the Spreadsheet PDF

Author: Tyler Nash

Publisher: Tickling Keys, Inc.

Published: 2012-07-01

Total Pages: 224

ISBN-13: 1615473262

DOWNLOAD EBOOK →

Written in a question-and-answer format, this lowest-level beginner book covers the extreme basics of using spreadsheets in Excel. Instead of delving into advanced topics that scare most Excel novices away, the guide starts at a much more basic level, quickly providing a passable knowledge of the program and allowing users to overcome their fears and frustrations. It answers hundreds of common questions, including Can I delete data from a spreadsheet without changing the formatting? How can I merge two cells, columns, or rows? How do I use text-wrapping? How do I create custom functions? and What is a Macro and how do I go about creating it? Intended for the roughly 40 percent Excel users who have never even entered a formula, this book will demystify the problems and confusion that prevent them from using the program to its potential.

Microsoft Excel 2019 Pivot Table Data Crunching

Microsoft Excel 2019 Pivot Table Data Crunching PDF

Author: Bill Jelen

Publisher: Microsoft Press

Published: 2018-12-27

Total Pages: 975

ISBN-13: 1509308229

DOWNLOAD EBOOK →

Renowned Excel experts Bill Jelen (MrExcel) and Michael Alexander help you crunch data from any source with Excel 2019 pivot tables. Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you’ve never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power–including valuable improvements in Excel 2019 and Excel in Office 365. Drawing on more than 45 combined years of Excel experience, Bill Jelen and Michael Alexander offer practical “recipes” for solving real business problems, help you avoid common mistakes, and present tips and tricks you’ll find nowhere else. By reading this book, you will: • Master easy, powerful ways to create, customize, change, and control pivot tables • Control all future pivot tables using new pivot table defaults • Transform huge data sets into clear summary reports • Instantly highlight your most profitable customers, products, or regions • Use Power Query to quickly import, clean, shape, and analyze disparate data sources • Build geographical pivot tables with 3D Map • Construct and share state-of-the-art dynamic dashboards • Revamp analyses on the fly by dragging and dropping fields • Build dynamic self-service reporting systems • Share your pivot tables with colleagues • Create data mashups using the full Power Pivot capabilities of Excel 2019 and Excel in Office 365 • Automate pivot tables with macros and VBA • Save time by adapting reports with GetPivotData • Discover today’s most useful pivot table tips and shortcuts

Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)

Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365) PDF

Author: Bill Jelen

Publisher: Microsoft Press

Published: 2021-12-21

Total Pages: 935

ISBN-13: 0137521782

DOWNLOAD EBOOK →

Use Microsoft 365 Excel and Excel 2021 pivot tables and pivot charts to produce powerful, dynamic reports in minutes: take control of your data and your business! Even if you've never created a pivot table before, this book will help you leverage all their flexibility and analytical power— including important recent improvements in Microsoft 365 Excel. Drawing on more than 30 years of cutting-edge Excel experience, MVP Bill Jelen (“MrExcel”) shares practical “recipes” for solving real business problems, expert insights for avoiding mistakes, and advanced tips and tricks you'll find nowhere else. By reading this book, you will: Master easy, powerful ways to create, customize, change, and control pivot tables Transform huge datasets into clear summary reports Instantly highlight your most profitable customers, products, or regions Use the data model and Power Query to quickly analyze disparate data sources Create powerful crosstab reports with new dynamic arrays and Power Query Build geographical pivot tables with 3D Maps Construct and share state-of-the-art dynamic dashboards Revamp analyses on the fly by dragging and dropping fi elds Build dynamic self-service reporting systems Share your pivot tables with colleagues Create data mashups using the full Power Pivot capabilities in modern Excel versions Generate pivot tables using either VBA on the Desktop or Typescript in Excel Online Save time and avoid formatting problems by adapting reports with GetPivotData Unpivot source data so it's easier to work with Use new Analyze Data artificial intelligence to create pivot tables

Leadership and School Boards

Leadership and School Boards PDF

Author: Laura E. Reimer

Publisher: Rowman & Littlefield

Published: 2015-10-02

Total Pages: 169

ISBN-13: 1475815085

DOWNLOAD EBOOK →

School boards shape society through systems of education. They choose who leads the system and how educators are selected to lead classrooms. They approve the allocation of millions of dollars every year. As leaders, the school board determines how their community defines the values, resources, and belief systems that together form the democratic mosaic of our times. Embedded within this knowledge are timeless foundations that have carried us from the origins of school boards to our current systems; these are the keys to community engagement, and these are the keys to empowered and strong school systems. This book is about the remarkable and unique purpose of school boards. It is not a book about abolition, or drastic reform. It explains clearly that school boards were established as part of the foundation for a strong democratic society and encourages everyone involved with school systems to guard that foundation. School boards embody the most immediate principles of democracy. This is an exciting book, appropriate for our times, focused on the powerful leadership necessary in the school board, and the potential to deliver ever-improving results through consistent and deliberate governance.

Guerilla Data Analysis Using Microsoft Excel

Guerilla Data Analysis Using Microsoft Excel PDF

Author: Bill Jelen

Publisher: Tickling Keys, Inc.

Published: 2002-09-30

Total Pages: 156

ISBN-13: 161547319X

DOWNLOAD EBOOK →

This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These are tips honed by Bill Jelen, &“MrExcel,&” during his 10-year run as a financial analyst charged with taking mainframe data and turning it into useful information quickly. Topics include perfectly sorting with one click every time, matching lists of data, data consolidation, data subtotals, pivot tables, and much more.

Excel 2019 Project Book

Excel 2019 Project Book PDF

Author: Gary Bronson

Publisher: Stylus Publishing, LLC

Published: 2021-09-29

Total Pages: 175

ISBN-13: 1683927672

DOWNLOAD EBOOK →

Designed as a project and case-oriented approach to learning Excel, the emphasis of this book is on learning by doing. The book presents a series of progressively reinforcing problem sets, which allow the exploration of real-life business problems. First, the background, theory, formulas, and calculations are discussed, followed by the design of Excel spreadsheets, which support the creation of effective spreadsheets for these applications. Finally, the proper solution and other related aspects are discussed, forming a cohesive set of practical application problems. Some of the topics explored include amortization tables, weighted averages, cash flows, payroll calculations, break even analysis, and spreadsheet databases. Excel techniques include formulas and functions, cell addressing, conditional and lookup functions, graphs, sorting, and filtering. FEATURES: Provides 30 projects, several How-to Guides, and Application Types to learn Excel skills using problems, applications, and case studies featuring practical business problems Explores formulas and functions, financial functions, cell addressing, conditional functions, lookup functions, graphs, sorting, and filtering, amortization tables, future values of an investment, weighted averages, cash flows, payroll calculations, break even analysis, economic order quantity, spreadsheet databases, and more Instructor resources available with four Excel video tutorials and images from the text.