Bøker av Alan Murray

Enhance and upgrade your Excel knowledge with this comprehensive guide to formulas in Excel. Over 150 of the most useful Excel functions are covered with numerous practical examples of their use. This book is fully updated and includes examples of the most recently released functions in 2022. It is written in a manner that you can read it cover-to-cover or pick it up and learn something new in just 5 minutes.The book begins with a primer on Excel formulas and functions. Starting from a basic level, but diving into intricate detail and building a solid understanding of the fundamentals. It may not always be sexy, but learning why, in addition to how, is important to truly understanding Excel formulas. Having strong fundamentals is the most advanced skill.The book covers all the most popular functions in Excel including VLOOKUP, SUMPRODUCT, COUNTIFS, MATCH, SORT and so much more. You will learn how to return multiple results with a single formula. Harness the power of the dynamic array engine and functions such as SEQUENCE, SORTBY, UNIQUE, XLOOKUP and FILTER to create top N Lists, models and reports that would seem impossible without array formulas. In the final chapter, we discover the amazing LAMBDA function in Excel. Create your own Excel functions to simplify future Excel formulas and share them with others. In this book, the formulas are not only written to return values to the grid, but also for use with other Excel features such as charts and Conditional Formatting, to take them to another level. Practice files are provided to follow all examples shown in the book.What Will You Learn Gain intimate knowledge of Excel formulas Understand efficient and practical use of Defined Names and TablesMaster the most popular functions of Excel - VLOOKUP, COUNTIFS, MATCH, SUMPRODUCT, and so much moreLearn to return multiple results from a single formula with the magical array formulas. Know the best lookup functions for dynamic spreadsheetsKnow true power of classic Excel functions such as IF, SUM, and INDEXUse new Excel functions including XLOOKUP, VSTACK, LET, and LAMBDA Who Is This Book ForExcel users who are familiar with formulas but want to improve their current skill level

The core tenets of a capitalist system that dominated the world for more than a century are being challenged as never before. Narratives about the failures of capitalism, the greed of the 1 percent, and the blindness of corporations to public need have made their mark and are driving change. These aren't the superficial cosmetic fixes that generated so much cynicism in the past, but a revolution in the way corporations are imagined and run. Tomorrow's Capitalist reveals how corporate CEOs-the ultimate pragmatists-realized that they could lose their "operating license" unless they tackle the fundamental issues of our time: climate, diversity and inclusion, and inequality and workforce opportunity. Responding to their employees and customers who are demanding corporate change, they have taken the lead in establishing the bold new principles of stakeholder capitalism, ensuring that for the first time in more than a half a century it is not just shareholders who have a say in how corporations are run.Alan Murray vividly captures the zeitgeist of the real and compelling dynamic that is transforming much of the corporate world.

Advanced

A handbook with wide potential usage for both undergraduate and postgraduate students, as well as practitioners, presenting current thinking on sustainability. It explores the ecological models which underpin economic sustainability theory and re-examines the consequences of modern ecological thought on business strategies relating to sustainability.

This book provides a thoughtful and rigorous guide to coverage modeling, reviewing essential models, solution approaches, and related applications.

Focuses on classic and contemporary works that have resonated with the broadest audiences and that have been recommended by members of the "Wall Street Journal" CEO Council - a group of chief executives of large and successful global companies, who have learned a good deal about leadership and management on their way to the top.