Advertisement
excel for management consulting: Say It with Presentations: How to Design and Deliver Successful Business Presentations Gene Zelazny, 2000-01-11 Organize a powerful, effective business presentation and deliver it with style! Say it with Presentations helps you define why you're giving the presentation and the audience you need to convince. This compelling, comprehensive presentation toolkit tells you when, why, and how to use humor, and, yes, silence to get your points across...howto make the most of visuals...set up facilities and equipment...and rehearse to communicate your confidence, conviction and enthusiasm, and much, much more. |
excel for management consulting: The McKinsey Way Ethan M. Rasiel, 1999-02-22 If more business books were as useful, concise, and just plain fun to read as THE MCKINSEY WAY, the business world would be a better place. --Julie Bick, best-selling author of ALL I REALLY NEED TO KNOW IN BUSINESS I LEARNED AT MICROSOFT. Enlivened by witty anecdotes, THE MCKINSEY WAY contains valuable lessons on widely diverse topics such as marketing, interviewing, team-building, and brainstorming. --Paul H. Zipkin, Vice-Dean, The Fuqua School of Business It's been called a breeding ground for gurus. McKinsey & Company is the gold-standard consulting firm whose alumni include titans such as In Search of Excellence author Tom Peters, Harvey Golub of American Express, and Japan's Kenichi Ohmae. When Fortune 100 corporations are stymied, it's the McKinsey-ites whom they call for help. In THE MCKINSEY WAY, former McKinsey associate Ethan Rasiel lifts the veil to show you how the secretive McKinsey works its magic, and helps you emulate the firm's well-honed practices in problem solving, communication, and management. He shows you how McKinsey-ites think about business problems and how they work at solving them, explaining the way McKinsey approaches every aspect of a task: How McKinsey recruits and molds its elite consultants; How to sell without selling; How to use facts, not fear them; Techniques to jump-start research and make brainstorming more productive; How to build and keep a team at the top its game; Powerful presentation methods, including the famous waterfall chart, rarely seen outside McKinsey; How to get ultimate buy-in to your findings; Survival tips for working in high-pressure organizations. Both a behind-the-scenes look at one of the most admired and secretive companies in the business world and a toolkit of problem-solving techniques without peer, THE MCKINSEY WAY is fascinating reading that empowers every business decision maker to become a better strategic player in any organization. |
excel for management consulting: Using Excel for Business Analysis Danielle Stein Fairhurst, 2015-05-18 This is a guide to building financial models for business proposals, to evaluate opportunities, or to craft financial reports. It covers the principles and best practices of financial modelling, including the Excel tools, formulas, and functions to master, and the techniques and strategies necessary to eliminate errors. |
excel for management consulting: Excel University Jeff Lenning, Jeff Lenning Cpa, 2017-03-11 During live CPE training sessions, and through Excel articles featured in magazines such as the Journal of Accountancy and California CPA Magazine, Jeff Lenning, founder of Excel University, Inc., has shown thousands of CPAs and accounting professionals across the country how to use Excel more effectively. Drawing on his experience as an auditor, a financial analyst in industry, an accounting manager at a public company, and a consultant, he has demonstrated how to leverage Excel in order to improve efficiency by reducing the time it takes to complete job tasks. Written to reach those he won't have the opportunity to meet in one of his CPE sessions, Lenning's series, Excel University: Microsoft Excel Training for CPAs and Accounting Professionals, offers a comprehensive collection of the features, functions, and techniques that are of direct benefit to accountants working in industry, public practice, consulting, or not-for-profit. Concentrating on Excel for Windows, his books offer a hands-on approach to learning and include narrative, screenshots, video content, Excel practice files, and exercises that demonstrate the practical application of the items presented in each chapter. Visit http: //www.excel-university.com to access the Excel University video library and to download the practice files. Features, functions and techniques are presented in a sequential and progressive manner, so the books are best read in order. In Volume 1, the author presents material and information that will prove useful to every accountant, regardless of the type of work they do. Blown away by the power of Excel, readers are sure to find this series relevant, enlightening, and extremely easy-to-follow. |
excel for management consulting: Management Consulting Today and Tomorrow Larry E. Greiner, Flemming Poulfelt, 2010-04-02 This book provides a thorough examination of a variety of specialties within the broad range of management consulting. A book of such scope and depth could only be written by a large number of experts, each from one of the many specialties related to management consulting. Together, all 27 contributors take the reader through an industry that is currently undergoing significant change. While covering all the major practice areas of consulting, the book also offers new insights into change processes and addresses compelling management issues now facing consulting firms. |
excel for management consulting: The Health Care Handbook Elisabeth T. Askin, Nathan Moore, 2022-11-21 Described in the New York Times as “an astonishingly clear ‘user’s manual’ that explains our health care system and the policies that will change it,” The Health Care Handbook, by Drs. Elisabeth Askin and Nathan Moore, offers a practical, neutral, and readable overview of the U.S. health care system in a compact, convenient format. The fully revised third edition provides concise coverage on health care delivery, insurance and economics, policy, and reform—all critical components of the system in which health care professionals work. Written in a conversational and accessible tone, this popular, highly regarded handbook serves as a “one stop shop” for essential facts, systems, concepts, and analysis of the U.S. health care system, providing the tools you need to confidently evaluate current health care policy and controversies. |
excel for management consulting: Microsoft Business Intelligence Tools for Excel Analysts Michael Alexander, Jared Decker, Bernard Wehbe, 2014-05-05 Bridge the big data gap with Microsoft Business Intelligence Tools for Excel Analysts The distinction between departmental reporting done by business analysts with Excel and the enterprise reporting done by IT departments with SQL Server and SharePoint tools is more blurry now than ever before. With the introduction of robust new features like PowerPivot and Power View, it is essential for business analysts to get up to speed with big data tools that in the past have been reserved for IT professionals. Written by a team of Business Intelligence experts, Microsoft Business Intelligence Tools for Excel Analysts introduces business analysts to the rich toolset and reporting capabilities that can be leveraged to more effectively source and incorporate large datasets in their analytics while saving them time and simplifying the reporting process. Walks you step-by-step through important BI tools like PowerPivot, SQL Server, and SharePoint and shows you how to move data back and forth between these tools and Excel Shows you how to leverage relational databases, slice data into various views to gain different visibility perspectives, create eye-catching visualizations and dashboards, automate SQL Server data retrieval and integration, and publish dashboards and reports to the web Details how you can use SQL Server’s built-in functions to analyze large amounts of data, Excel pivot tables to access and report OLAP data, and PowerPivot to create powerful reporting mechanisms You’ll get on top of the Microsoft BI stack and all it can do to enhance Excel data analysis with this one-of-a-kind guide written for Excel analysts just like you. |
excel for management consulting: Excel for Marketing Managers Ivana Taylor, Bill Jelen, 2006-01-01 The most powerful Microsoft Excel features that can be used to sort through data to produce meaningful marketing analyses are outlined in this manual. Marketing managers will learn the math functions to produce budgets and forecasts, and how to use survey analysis to quickly spot trends using pivot tables and other analysis tools. Ideas for launch schedules, life cycle management, and other date-related information are also presented. |
excel for management consulting: Excel Sales Forecasting For Dummies Conrad Carlberg, 2016-06-23 Excel at predicting sales and forecasting trends using Microsoft Excel! If you're a sales or marketing professional, you know that forecasting sales is one of the biggest challenges you face on the job. Unlike other books on the subject, Excel Sales Forecasting For Dummies, 2nd Edition leaves arcane business school terms and complex algebraic equations at the door, focusing instead on what you can do right now to utilize the world's most popular spreadsheet program to produce forecasts you can rely on. Loaded with confidence boosters for anyone who succumbs to sweaty palms when sales predictions are mentioned, this trusted guide show you how to use the many tools Excel provides to arrange your past data, set up lists and pivot tables, use moving averages, and so much more. Before you know it, you'll become a forecaster par excellence—even if numbers aren't your jam. Choose the right forecasting method Find relationships in your data Predict seasonal sales Filter lists or turn them into charts Consider this guide your crystal ball—and start predicting the future with confidence and ease! |
excel for management consulting: Financial Modeling in Excel For Dummies Danielle Stein Fairhurst, 2017-04-24 Make informed business decisions with the beginner's guide to financial modeling using Microsoft Excel Financial Modeling in Excel For Dummies is your comprehensive guide to learning how to create informative, enlightening financial models today. Not a math whiz or an Excel power-user? No problem! All you need is a basic understanding of Excel to start building simple models with practical hands-on exercises and before you know it, you'll be modeling your way to optimized profits for your business in no time. Excel is powerful, user-friendly, and is most likely already installed on your computer—which is why it has so readily become the most popular financial modeling software. This book shows you how to harness Excel's capabilities to determine profitability, develop budgetary projections, model depreciation, project costs, value assets and more. You'll learn the fundamental best practices and know-how of financial modeling, and how to put them to work for your business and your clients. You'll learn the tools and techniques that bring insight out of the numbers, and make better business decisions based on quantitative evidence. You'll discover that financial modeling is an invaluable resource for your business, and you'll wonder why you've waited this long to learn how! Companies around the world use financial modeling for decision making, to steer strategy, and to develop solutions. This book walks you through the process with clear, expert guidance that assumes little prior knowledge. Learn the six crucial rules to follow when building a successful financial model Discover how to review and edit an inherited financial model and align it with your business and financial strategy Solve client problems, identify market projections, and develop business strategies based on scenario analysis Create valuable customized templates models that can become a source of competitive advantage From multinational corporations to the mom-and-pop corner store, there isn't a business around that wouldn't benefit from financial modeling. No need to buy expensive specialized software—the tools you need are right there in Excel. Financial Modeling in Excel For Dummies gets you up to speed quickly so you can start reaping the benefits today! |
excel for management consulting: Guidelines for Management Consulting Programs for Small-scale Enterprise Gary L. Vaughan, 1981 |
excel for management consulting: Excel Charts John Walkenbach, 2002-11-29 * One of the world's best-known Excel experts shows how to master the charting features in Excel 2000 and 2002 to create compelling graphic representations of data * Covers basic and advanced features, focusing on the new charting featuresprovided in version 2002 * Explains how to select charts for different categories of data, modify data in a chart, deal with missing data, format charts, customize shapes, and give charts a professional look |
excel for management consulting: Predictive Analytics Conrad Carlberg, 2017-07-13 EXCEL 2016 PREDICTIVE ANALYTICS FOR SERIOUS DATA CRUNCHERS! Now, you can apply cutting-edge predictive analytics techniques to help your business win–and you don’t need multimillion-dollar software to do it. All the tools you need are available in Microsoft Excel 2016, and all the knowledge and skills are right here, in this book! Microsoft Excel MVP Conrad Carlberg shows you how to use Excel predictive analytics to solve real problems in areas ranging from sales and marketing to operations. Carlberg offers unprecedented insight into building powerful, credible, and reliable forecasts, helping you gain deep insights from Excel that would be difficult to uncover with costly tools such as SAS or SPSS. Fully updated for Excel 2016, this guide contains valuable new coverage of accounting for seasonality and managing complex consumer choice scenarios. Throughout, Carlberg provides downloadable Excel 2016 workbooks you can easily adapt to your own needs, plus VBA code–much of it open-source–to streamline especially complex techniques. Step by step, you’ll build on Excel skills you already have, learning advanced techniques that can help you increase revenue, reduce costs, and improve productivity. By mastering predictive analytics, you’ll gain a powerful competitive advantage for your company and yourself. Learn the “how” and “why” of using data to make better decisions, and choose the right technique for each problem Capture live real-time data from diverse sources, including third-party websites Use logistic regression to predict behaviors such as “will buy” versus “won’t buy” Distinguish random data bounces from real, fundamental changes Forecast time series with smoothing and regression Account for trends and seasonality via Holt-Winters smoothing Prevent trends from running out of control over long time horizons Construct more accurate predictions by using Solver Manage large numbers of variables and unwieldy datasets with principal components analysis and Varimax factor rotation Apply ARIMA (Box-Jenkins) techniques to build better forecasts and clarify their meaning Handle complex consumer choice problems with advanced logistic regression Benchmark Excel results against R results |
excel for management consulting: Essential Tools for Management Consulting Simon Burtonshaw-Gunn, 2010-03-01 The second book in the Essential Tools For series... on the topic of Management Consulting Based on Simon Burtonshaw-Gunn's successful The Essential Management Toolbox, this book focuses in greater depth on the topic of Management Consulting. This second book looks at how a management consultant needs to think, view and analyse the workings of an existing organisation in order to efficiently and effectively work to improve the issues facing a business. Check out the new series website featuring sample chapters, tool of the month and solve your management problems by talking direct to the author www.essentialtoolsseries.com Second title in a new series that expands on the information in Simon Burtonshaw-Gunn’s The Essential Toolbox This volume includes 30% new material in the form of new tools and techniques for guiding consultants Covers: Development of Management Consultancy; Problem resolution and Decision Making; Top 10 Tools for Consultancy Interventions; Consultancy delivery and Facilitation; Consultancy Governance and Ethics Active author, Simon Burtonshaw-Gunn speaks regularly Easy to use practical tools and techniques guiding the consultant and business person through their organisational conflicts About the Author: Simon Burtonshaw-Gunn is a practising management consultant with over 30 years experience in both the public and private sectors and covering a range of organizations and industries. He holds two Master's degrees and a PhD in various Strategic Management topics. This second book includes a forward by Malik Salameh. |
excel for management consulting: Next Generation Excel Isaac Gottlieb, 2013-02-04 Take Excel to the next level in accounting and financial modeling In this new Second Edition of Next Generation Excel, Isaac Gottlieb shows financial analysts how to harness the full power of Excel to move forward into the new world of accounting and finance. Companies of all sizes use financial models to analyze their finances and plan business operations, as well as to create financial accounting reports like balance sheets, income statements, and statements of cash flows. While many businesspeople are quite familiar with the reports created with financial models, most are not as familiar with the creation of the models themselves. This book shows them how to build an accurate and effective financial model using the solid functionality and easy usability of Excel. Fully updated and revised to include support for Apple users Written by a professor of management and statistics who has taught the discipline for fifteen years Appropriate for professional financial analysts, as well as MBA students For professionals and students whose responsibilities or studies include a full understanding of financial modeling, Next Generation Excel, Second Edition offers comprehensive training. |
excel for management consulting: Say it with Charts Gene Zelazny, 1996 In this third edition, Gene Zelazny provides a portolio of over 80 complete charts, including pie, bar, column, line and dot charts, plus a new dictionary of 150 visual images that can be used to visualize non-quantitative ideas such as forces at work, interaction, leverage, and barriers. Other convey flow structure and process. Say It With Charts will help you choose the chart form that will work best and translate data and ideas into visual concepts. 4-color insert. |
excel for management consulting: Data Analysis Using SQL and Excel Gordon S. Linoff, 2010-09-16 Useful business analysis requires you to effectively transform data into actionable information. This book helps you use SQL and Excel to extract business information from relational databases and use that data to define business dimensions, store transactions about customers, produce results, and more. Each chapter explains when and why to perform a particular type of business analysis in order to obtain useful results, how to design and perform the analysis using SQL and Excel, and what the results should look like. |
excel for management consulting: 101 Best Excel Tips & Tricks Bryan Hong, John Michaloudis, 2021-03-19 Learn the Best Excel Tips & Tricks Ever: FORMULAS, MACROS, PIVOT TABLES, FORMATTING, DATA, MICROSOFT OFFICE 365 plus Many More! With this book, you'll learn to apply the must know Excel features and tricks to make your data analysis & reporting easier and will save time in the process. With this book you get the following: ✔ 101 Best Excel Tips & Tricks To Advance Your Excel Skills & Save You Hours ✔ New Excel Tips & Tricks for Microsoft Office 365 ✔ Easy to Read Step by Step Guide with Screenshots ✔ Downloadable Practice Excel Workbooks for each Tip & Trick ✔ You also get a FREE BONUS downloadable PDF version of this book! This book is a MUST-HAVE for Beginner to Intermediate Excel users who want to learn Microsoft Excel FAST & stand out from the crowd! |
excel for management consulting: Excel VBA 24-Hour Trainer Tom Urtis, 2015-03-12 Master VBA automation quickly and easily to get more out of Excel Excel VBA 24-Hour Trainer, 2nd Edition is the quick-start guide to getting more out of Excel, using Visual Basic for Applications. This unique book/video package has been updated with fifteen new advanced video lessons, providing a total of eleven hours of video training and 45 total lessons to teach you the basics and beyond. This self-paced tutorial explains Excel VBA from the ground up, demonstrating with each advancing lesson how you can increase your productivity. Clear, concise, step-by-step instructions are combined with illustrations, code examples, and downloadable workbooks to give you a practical, in-depth learning experience and results that apply to real-world scenarios. This is your comprehensive guide to becoming a true Excel power user, with multimedia instruction and plenty of hands-on practice. Program Excel's newest chart and pivot table object models Manipulate the user interface to customize the look and feel of a project Utilize message boxes, input boxes, and loops to yield customized logical results Interact with and manipulate Word, Access, PowerPoint, and Outlook from Excel If you're ready to get more out of this incredibly functional program, Excel VBA 24-Hour Trainer, 2nd Edition provides the expert instruction and fast, hands-on learning you need. |
excel for management consulting: Excel Power Pivot & Power Query For Dummies Michael Alexander, 2016-03-18 A guide to PowerPivot and Power Query no data cruncher should be without! Want to familiarize yourself with the rich set of Microsoft Excel tools and reporting capabilities available from PowerPivot and Power Query? Look no further! Excel PowerPivot & Power Query For Dummies shows you how this powerful new set of tools can be leveraged to more effectively source and incorporate 'big data' Business Intelligence and Dashboard reports. You'll discover how PowerPivot and Power Query not only allow you to save time and simplify your processes, but also enable you to substantially enhance your data analysis and reporting capabilities. Gone are the days of relatively small amounts of data—today's data environment demands more from business analysts than ever before. Now, with the help of this friendly, hands-on guide, you'll learn to use PowerPivot and Power Query to expand your skill-set from the one-dimensional spreadsheet to new territories, like relational databases, data integration, and multi-dimensional reporting. Demonstrates how Power Query is used to discover, connect to, and import your data Shows you how to use PowerPivot to model data once it's been imported Offers guidance on using these tools to make analyzing data easier Written by a Microsoft MVP in the lighthearted, fun style you've come to expect from the For Dummies brand If you spend your days analyzing data, Excel PowerPivot & Power Query For Dummies will get you up and running with the rich set of Excel tools and reporting capabilities that will make your life—and work—easier. |
excel for management consulting: Lords of Strategy Walter Kiechel, 2010-03-03 Imagine, if you can, the world of business - without corporate strategy. Remarkably, fifty years ago that's the way it was. Businesses made plans, certainly, but without understanding the underlying dynamics of competition, costs, and customers. It was like trying to design a large-scale engineering project without knowing the laws of physics. But in the 1960s, four mavericks and their posses instigated a profound shift in thinking that turbocharged business as never before, with implications far beyond what even they imagined. In The Lords of Strategy, renowned business journalist and editor Walter Kiechel tells, for the first time, the story of the four men who invented corporate strategy as we know it and set in motion the modern, multibillion-dollar consulting industry: Bruce Henderson, founder of Boston Consulting Group Bill Bain, creator of Bain & Company Fred Gluck, longtime Managing Director of McKinsey & Company Michael Porter, Harvard Business School professor Providing a window into how to think about strategy today, Kiechel tells their story with novelistic flair. At times inspiring, at times nearly terrifying, this book is a revealing account of how these iconoclasts and the organizations they led revolutionized the way we think about business, changed the very soul of the corporation, and transformed the way we work. |
excel for management consulting: Using Excel for Business and Financial Modelling Danielle Stein Fairhurst, 2019-03-25 A hands-on guide to using Excel in the business context First published in 2012, Using Excel for Business and Financial Modelling contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates, a list of shortcuts and tons of practical tips and techniques you can apply straight away. Whilst there are many hundreds of tools, features and functions in Excel, this book focuses on the topics most relevant to finance professionals. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. Learn to create financial models to help make business decisions whilst applying modelling best practice methodology, tools and techniques. • Provides the perfect mix of practice and theory • Helps you become a DIY Excel modelling specialist • Includes updates for Excel 2019/365 and Excel for Mac • May be used as an accompaniment to the author’s online and face-to-face training courses Many people are often overwhelmed by the hundreds of tools in Excel, and this book gives clarity to the ones you need to know in order to perform your job more efficiently. This book also demystifies the technical, design, logic and financial skills you need for business and financial modelling. |
excel for management consulting: The Boston Consulting Group on Strategy Carl W. Stern, Michael S. Deimler, 2012-06-14 A collection of the best thinking from one of the most innovative management consulting firms in the world For more than forty years, The Boston Consulting Group has been shaping strategic thinking in business. The Boston Consulting Group on Strategy offers a broad and up-to-date selection of the firm's best ideas on strategy with fresh ideas, insights, and practical lessons for managers, executives, and entrepreneurs in every industry. Here's a sampling of the provocative thinking you'll find inside: You have to be the scientist of your own life and be astonished four times:at what is, what always has been, what once was, and what could be. The majority of products in most companies are cash traps . . . .[They] are not only worthless, but a perpetual drain on corporate resources. Use more debt than your competition or get out of the business. When information flows freely, reputation, more than reciprocity,becomes the basis for trust. As a strategic weapon, time is the equivalent of money, productivity,quality, even innovation. When brands become business systems, brand management becomes far too important to leave to the marketing department. The winning organization of the future will look more like a collection ofjazz ensembles than a symphony orchestra. Most of our organizations today derive from a model whose original purpose was to control creativity. Rather than being an obstacle, uncertainty is the very engine of transformation in a business, a continuous source of new opportunities. IP assets lack clear property lines. Every bit of intellectual property you can own comes with connections to other valuable innovations. |
excel for management consulting: MrExcel 2021 Bill Jelen, 2021-04-01 MrExcel 2021 is designed to make the reader far more efficient in their use of Microsoft Excel. Originally designed for Bill Jelen's live Power Excel seminars, the target audience already uses Excel 40 hours a week. These tips are the aha tips that uncover secret methods in Excel. The book covers general Excel functions, pivot tables, formulas such as VLOOKUP and the new XLOOKUP. It introduces elements of modern Excel such as the Power Pivot Data Model and cleaning data with Power Query. Updated annually, this edition for 2021 adds information on LET and LAMBDA functions, amazing new data types, dynamic array formulas, and more. |
excel for management consulting: Business Chemistry Kim Christfort, Suzanne Vickberg, 2018-05-22 A guide to putting cognitive diversity to work Ever wonder what it is that makes two people click or clash? Or why some groups excel while others fumble? Or how you, as a leader, can make or break team potential? Business Chemistry holds the answers. Based on extensive research and analytics, plus years of proven success in the field, the Business Chemistry framework provides a simple yet powerful way to identify meaningful differences between people’s working styles. Who seeks possibilities and who seeks stability? Who values challenge and who values connection? Business Chemistry will help you grasp where others are coming from, appreciate the value they bring, and determine what they need in order to excel. It offers practical ways to be more effective as an individual and as a leader. Imagine you had a more in-depth understanding of yourself and why you thrive in some work environments and flounder in others. Suppose you had a clearer view on what to do about it so that you could always perform at your best. Imagine you had more insight into what makes people tick and what ticks them off, how some interactions unlock potential while others shut people down. Suppose you could gain people’s trust, influence them, motivate them, and get the very most out of your work relationships. Imagine you knew how to create a work environment where all types of people excel, even if they have conflicting perspectives, preferences and needs. Suppose you could activate the potential benefits of diversity on your teams and in your organizations, improving collaboration to achieve the group’s collective potential. Business Chemistry offers all of this--you don’t have to leave it up to chance, and you shouldn’t. Let this book guide you in creating great chemistry! |
excel for management consulting: Valuation McKinsey & Company Inc., Tim Koller, Marc Goedhart, David Wessels, 2010-07-16 The number one guide to corporate valuation is back and better than ever Thoroughly revised and expanded to reflect business conditions in today's volatile global economy, Valuation, Fifth Edition continues the tradition of its bestselling predecessors by providing up-to-date insights and practical advice on how to create, manage, and measure the value of an organization. Along with all new case studies that illustrate how valuation techniques and principles are applied in real-world situations, this comprehensive guide has been updated to reflect new developments in corporate finance, changes in accounting rules, and an enhanced global perspective. Valuation, Fifth Edition is filled with expert guidance that managers at all levels, investors, and students can use to enhance their understanding of this important discipline. Contains strategies for multi-business valuation and valuation for corporate restructuring, mergers, and acquisitions Addresses how you can interpret the results of a valuation in light of a company's competitive situation Also available: a book plus CD-ROM package (978-0-470-42469-8) as well as a stand-alone CD-ROM (978-0-470-42457-7) containing an interactive valuation DCF model Valuation, Fifth Edition stands alone in this field with its reputation of quality and consistency. If you want to hone your valuation skills today and improve them for years to come, look no further than this book. |
excel for management consulting: M Is for (Data) Monkey Ken Puls, Miguel Escobar, 2015-06-01 Power Query is one component of the Power BI (Business Intelligence) product from Microsoft, and M is the name of the programming language created by it. As more business intelligence pros begin using Power Pivot, they find that they do not have the Excel skills to clean the data in Excel; Power Query solves this problem. This book shows how to use the Power Query tool to get difficult data sets into both Excel and Power Pivot, and is solely devoted to Power Query dashboarding and reporting. |
excel for management consulting: 20 Keys to Workplace Improvement Iwao Kobayashi, 2018-02-06 20 Keys has helped many manufacturing companies integrate the top manufacturing improvement methods into a coordinated system for drastic and continual improvement in involvement, quality, and productivity. This program provides the strategies necessary to achieve ambitious goals through a five-level scoring system. The revised edition is improved with upgraded criteria for the five-level scoring system to guide your company to world-class status. New material and updated layout make implementation even easier. Two valuable case studies demonstrate effective use by both a Japanese company and an American manufacturer. |
excel for management consulting: Ask a Manager Alison Green, 2018-05-01 From the creator of the popular website Ask a Manager and New York’s work-advice columnist comes a witty, practical guide to 200 difficult professional conversations—featuring all-new advice! There’s a reason Alison Green has been called “the Dear Abby of the work world.” Ten years as a workplace-advice columnist have taught her that people avoid awkward conversations in the office because they simply don’t know what to say. Thankfully, Green does—and in this incredibly helpful book, she tackles the tough discussions you may need to have during your career. You’ll learn what to say when • coworkers push their work on you—then take credit for it • you accidentally trash-talk someone in an email then hit “reply all” • you’re being micromanaged—or not being managed at all • you catch a colleague in a lie • your boss seems unhappy with your work • your cubemate’s loud speakerphone is making you homicidal • you got drunk at the holiday party Praise for Ask a Manager “A must-read for anyone who works . . . [Alison Green’s] advice boils down to the idea that you should be professional (even when others are not) and that communicating in a straightforward manner with candor and kindness will get you far, no matter where you work.”—Booklist (starred review) “The author’s friendly, warm, no-nonsense writing is a pleasure to read, and her advice can be widely applied to relationships in all areas of readers’ lives. Ideal for anyone new to the job market or new to management, or anyone hoping to improve their work experience.”—Library Journal (starred review) “I am a huge fan of Alison Green’s Ask a Manager column. This book is even better. It teaches us how to deal with many of the most vexing big and little problems in our workplaces—and to do so with grace, confidence, and a sense of humor.”—Robert Sutton, Stanford professor and author of The No Asshole Rule and The Asshole Survival Guide “Ask a Manager is the ultimate playbook for navigating the traditional workforce in a diplomatic but firm way.”—Erin Lowry, author of Broke Millennial: Stop Scraping By and Get Your Financial Life Together |
excel for management consulting: Grit Angela Duckworth, 2016-05-03 In this instant New York Times bestseller, Angela Duckworth shows anyone striving to succeed that the secret to outstanding achievement is not talent, but a special blend of passion and persistence she calls “grit.” “Inspiration for non-geniuses everywhere” (People). The daughter of a scientist who frequently noted her lack of “genius,” Angela Duckworth is now a celebrated researcher and professor. It was her early eye-opening stints in teaching, business consulting, and neuroscience that led to her hypothesis about what really drives success: not genius, but a unique combination of passion and long-term perseverance. In Grit, she takes us into the field to visit cadets struggling through their first days at West Point, teachers working in some of the toughest schools, and young finalists in the National Spelling Bee. She also mines fascinating insights from history and shows what can be gleaned from modern experiments in peak performance. Finally, she shares what she’s learned from interviewing dozens of high achievers—from JP Morgan CEO Jamie Dimon to New Yorker cartoon editor Bob Mankoff to Seattle Seahawks Coach Pete Carroll. “Duckworth’s ideas about the cultivation of tenacity have clearly changed some lives for the better” (The New York Times Book Review). Among Grit’s most valuable insights: any effort you make ultimately counts twice toward your goal; grit can be learned, regardless of IQ or circumstances; when it comes to child-rearing, neither a warm embrace nor high standards will work by themselves; how to trigger lifelong interest; the magic of the Hard Thing Rule; and so much more. Winningly personal, insightful, and even life-changing, Grit is a book about what goes through your head when you fall down, and how that—not talent or luck—makes all the difference. This is “a fascinating tour of the psychological research on success” (The Wall Street Journal). |
excel for management consulting: Management Consulting in the Era of the Digital Organization David Brian Szabla, 2023-07-01 The 4th Industrial Revolution is well underway. Our lives are changing at an exponential rate, resulting in a multi-faceted, deeply interconnected world. The digital revolution is integrating multiple technologies, which is leading to unprecedented paradigm shifts in the economy, management, and society. Entire systems across countries, industries, and societies are being transformed, triggering a transformation that is unlike anything humankind has ever experienced. Given the confluence of dramatic changes in organizational life, triggering emerging technology breakthroughs such as robotics, the internet of things, biotechnology, materials science, data science and big data, and quantum computing, this volume of the Research in Management Consulting series explores how the research and practice of management consulting is unfolding in a new era of profound shifts in the way researchers and consultants sense, think, and act. The authors of this volume bring both to scholars and practitioners the latest discussions of efforts to understand consulting in organizations amplified by the fusion of technologies across physical, digital, and biological worlds. They also bring to light a movement from human supervised artificial intelligence systems to fully autonomous artificial intelligence systems that have the potential to demonstrate intelligence beyond uman capabilities. |
excel for management consulting: Succeeding As a Management Consultant Kristina Safarova, 2020-04-10 Written for business leaders and consultants who are trying to solve significant problems and create measurable value. Readers can view the templates used in consulting studies and how they are used. All the foundational strategy and business analyses tools are taught along with the soft skills and practical tools to solve any business problem. This is the only book of its kind walking the reader step-by-step through a complete consulting study.This book follows an engagement team as they assist a large company in diagnosing and fixing deep and persistent organizational issues over an 8-week assignment. Readers will learn how they successfully navigate a challenging client environment, frame the problem and limit the scope, develop hypotheses, build the analyses and provide the final recommendations. We have placed the explanation of management consulting techniques within a lively and engaging storyline, which allows the reader to truly understand the challenges faced on consulting engagements, connect with the characters, and understand both how and why they debated elements of the study.It is written so that the reader may follow, understand, and replicate a strategic engagement using the same techniques used by the leading firms, such as McKinsey, Bain, and BCG. To make the story realistic and useful, we have worked with one client engagement throughout the book. Using different examples and different clients to explain concepts would have made it difficult for readers to see the data linkages and development of the final recommendations. The client and engagement are fictitious. The data presented are also fictitious, but they are based on actual consulting engagements and the experiences of the author and the contributing McKinsey, BCG, et. al. partners at FIRMSconsulting.com & StrategyTraining.com.RESERVE YOUR SPOT FOR FREE EPISODES FROM EX-MCK ET AL. PARTNERS AT FIRMSCONSULTING . COM/PROMOFREE EPISODE FROM THIS BOOKS COMPANION COURSE AT FIRMSCONSULTING . COM/SAAMC |
excel for management consulting: The Essentials of Financial Modeling in Excel Michael Rees, 2023-02-02 A concise and practical guide to financial modeling in Excel In The Essentials of Financial Modeling in Excel: A Concise Guide to Concepts and Methods, veteran quantitative modeling and business analysis expert Dr. Michael Rees delivers a practical and hands-on introduction to financial modeling in Excel. The author offers readers a well-structured and strategic toolkit to learn modeling from scratch, focusing on the core economic concepts and the structures commonly required within Excel models. Divided into six parts, the book discusses the use of models and the factors to consider when designing and building models so that they can be as powerful as possible, yet simple. . Readers will also find: The foundational structures and calculations most frequently used in modeling, including growth- and ratio-based methods, corkscrews, and waterfall analysis Walkthroughs of economic modeling, measurement, and evaluation, and the linking of these to the decision criteria. These include breakeven and payback analysis, compounding, discounting, calculation of returns, loan calculations, and others Structured approaches for modeling in corporate finance, including financial statement modeling, cash flow valuation, cost of capital, and ratio analysis Techniques to implement sensitivity and scenario analysis Core aspects of statistical analysis, including data preparation, manipulation, and integration The use of approximately 100 Excel functions within example modeling contexts Further Topics Sections, which introduce advanced aspects of many areas, in order to provide further benefit to more advance readers, whilst presenting the truly essential topics separately. Examples of these include introductions to PowerQuery and PowerPivot, as well as advanced waterfall structures An invaluable, all-in-one blueprint for learning financial modeling in Excel, this book is ideal for beginning and intermediate financial professionals and students seeking to build and reinforce essential topics in financial modeling. |
excel for management consulting: Business Analysis with Microsoft Excel Conrad George Carlberg, 2002 Take control of the bottom line using expert techniques and Excel's powerful financial capabilities! Whether you own a small business or work for a large corporation; whether you are looking for help making financial and business decisions -- this book is for you. Business Analysis with Microsoft Excel, Second Editionprovides in-depth information that will maximize your use of the tools within Excel. Professional advice and guidance from an experienced author provide the answers to your most pressing questions. |
excel for management consulting: R for Microsoft® Excel Users Conrad Carlberg, 2016-11-11 This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book. Microsoft Excel can perform many statistical analyses, but thousands of business users and analysts are now reaching its limits. R, in contrast, can perform virtually any imaginable analysis–if you can get over its learning curve. In R for Microsoft® Excel Users, Conrad Carlberg shows exactly how to get the most from both programs. Drawing on his immense experience helping organizations apply statistical methods, Carlberg reviews how to perform key tasks in Excel, and then guides you through reaching the same outcome in R–including which packages to install and how to access them. Carlberg offers expert advice on when and how to use Excel, when and how to use R instead, and the strengths and weaknesses of each tool. Writing in clear, understandable English, Carlberg combines essential statistical theory with hands-on examples reflecting real-world challenges. By the time you’ve finished, you’ll be comfortable using R to solve a wide spectrum of problems–including many you just couldn’t handle with Excel. • Smoothly transition to R and its radically different user interface • Leverage the R community’s immense library of packages • Efficiently move data between Excel and R • Use R’s DescTools for descriptive statistics, including bivariate analyses • Perform regression analysis and statistical inference in R and Excel • Analyze variance and covariance, including single-factor and factorial ANOVA • Use R’s mlogit package and glm function for Solver-style logistic regression • Analyze time series and principal components with R and Excel |
excel for management consulting: Inside Nudging Steve Shu, 2016-07-14 Inside Nudging is written for management professionals and scientists to feed their thinking and discussions about implementing behavioral science initiatives (which includes behavioral economics and finance) in business settings. Situations include the incubation of innovation centers, behavioral science overlay capabilities, and advancement of existing organizations. Companies need to develop grit - the ability and fortitude to succeed. The book introduces the Behavioral GRITTM framework and covers key takeaways in leading an organization that implements behavioral science. Behavioral GRITTM stands for the business functions related to Goals, Research, Innovation, and Testing. The chapters are complemented by an appendix which covers ideas to introduce behavioral science initiatives. I argue that first a company needs to identify its goals and identify what type of predominant organization model it wants to pursue. There are five predominant organizational models I've seen. I also offer that a company should consider a number of implementation elements that may play a role during execution. Example elements include an advisory board and a behavioral science officer. Note that the purpose of this book is not to teach people about behavioral science; there are many other books out there for those purposes. That said, Inside Nudging introduces some behavioral science concepts to provide context and help develop a common language between management professionals and scientists. I see the application of behavioral science as still being in the early adoption phase. Many companies will benefit if they take time to develop the right approach. I hope Inside Nudging helps you with your journey. Stephen Shu Praise for Inside Nudging - More at www.InsideNudging.com Steve Shu's thoughtful and very readable book Inside Nudging provides a unique opportunity to understand how the research from behavioral science can be best exploited by business. While many popular books on behavioral science make a strong case for the value of the research, none have addressed how to exploit it in such a helpful and practical manner. A rarely mentioned secret brought into full view here is the fact that using behavioral science effectively is not so straightforward. Written specifically for business people and consultants Steve Shu shares his wide experience of consulting to explain the challenges and pitfalls of translating the ideas and findings of academic research into actionable solutions for real business problems. This book shows you how by giving examples of how real consultancy projects were shaped to deliver valuable results for working businesses. Inside Nudging acts as an intelligent interface between the ideas of the nerds in academia and the needs of real business people and offers tremendous potential for any business that needs to understand how people respond to their actions. - Peter Ayton, Professor, Associate Dean of Research and Deputy Dean, Social Sciences, City University London Steve Shu has written an excellent book for companies looking to get started with behavioral economics. Through his use of case studies and actionable takeaways, he does a great job showing how decades of research can be combined with other business elements to accomplish amazing results. Inside Nudging is like an executive guidebook for practitioners. - Dilip Soman, Professor and Corus Chair in Communications Strategy, Co-Director, Behavioural Economics in Action at Rotman (BEAR), Rotman School of Management, University of Toronto; Author of The Last Mile This may be a CEO or manager's first glimpse into how they can utilize behavioral science initiatives within their own company or life. - Jenna Gould, San Francisco Book Review |
excel for management consulting: ADKAR Jeff Hiatt, 2006 In his first complete text on the ADKAR model, Jeff Hiatt explains the origin of the model and explores what drives each building block of ADKAR. Learn how to build awareness, create desire, develop knowledge, foster ability and reinforce changes in your organization. The ADKAR Model is changing how we think about managing the people side of change, and provides a powerful foundation to help you succeed at change. |
excel for management consulting: The Pyramid Principle Barbara Minto, 2021 This book reveals that the mind automatically sorts information into distinctive pyramidal groupings. However, if any group of ideas are arranged into a pyramid structure in the first place, not only will it save valuable time and effort to write, it will take even less effort to read and comprehend it |
excel for management consulting: Principles of Finance with Excel Simon Benninga, 2011 Finance is a topic that requires much computation, and in todayâe(tm)s business world that computation is almost entirely done using Microsoft Excel. Despite this, existing finance textbooks continue to rely heavily on hand calculators, and business school students find that when they leave the academic environment they have to relearn finance using Excel. Addressing this issue, Principles of Finance with Excel is the only introductory finance text that comprehensively integrates Excel into the teaching and practice of finance. The second edition covers the same topics as standard financial textbooks, including portfolios, capital asset pricing models, stock and bond valuation, capital structure, and dividend and optional policy, and can therefore be used in any introductory course. However, this text also introduces Excel as it applies to finance students, demonstrating and explaining the implementation of finance concepts with Excel, and providing thorough coverage of all Excel topics including graphs, function data tables, dates in Excel, Goal Seek, and Solver. Combining classroom-tested pedagogy with the powerful functions of Excel, Simon Benninga, one of the most recognised names in financial modelling, shows students how spreadsheets can provide new and deeper insights into financial decision making. |
excel for management consulting: Management Consulting Today and Tomorrow Flemming Poulfelt, Thomas H. Olson, 2017-09-01 This new edition gathers more than 22 experts to outline the theory behind consulting, providing insight into change processes and management issues in the field. The business of consulting has grown faster than most other businesses, due not only to increased demand by clients, but also to the innovative capabilities of numerous consulting firms as they develop new services. Divided into six parts, the book introduces readers to the consulting industry, addressing the major practice areas, contexts, and implementations of the field. Significant updates detail the effect of the economic troubles between 2004 and 2010 and then 2010 and now; analyze the market response to consulting in recent years; and provide a more thorough understanding of how consulting is applied in the different areas of a business, such as operations, marketing, and finance. Introductions written by the editors offer further insight into the themes and learning goals of each section, helping readers to recognize the elements of a successful consultation, and utilize their new skill set. The text concludes with a look at the future of consulting with regards to ethics standards and how strong manager-client relationships contribute to financial growth. Readers will also learn how the developing field of entrepreneurship creates new economic structures and job opportunities. Practitioners, consultants, clients, faculty, and students of business and management will learn not only how to consult, but also gain the skills needed to adapt to and lead organizational change, giving them a competitive edge when they enter the field. |
What does the "@" symbol mean in Excel formula (outside a table)
Oct 24, 2021 · Excel has recently introduced a huge feature called Dynamic arrays. And along with that, Excel also started to make a " substantial upgrade " to their formula language. One …
excel - How to show current user name in a cell? - Stack Overflow
if you don't want to create a UDF in VBA or you can't, this could be an alternative. =Cell("Filename",A1) this will give you the full file name, and from this you could get the user …
How to represent a DateTime in Excel - Stack Overflow
The underlying data type of a datetime in Excel is a 64-bit floating point number where the length of a day equals 1 and 1st Jan 1900 00:00 equals 1. So 11th June 2009 17:30 is about …
excel - Check whether a cell contains a substring - Stack Overflow
Sep 4, 2013 · Is there an in-built function to check if a cell contains a given character/substring? It would mean you can apply textual functions like Left/Right/Mid on a conditional basis without …
How to keep one variable constant with other one changing with …
The $ tells excel not to adjust that address while pasting the formula into new cells. Since you are dragging across rows, you really only need to freeze the row part: =(B0+4)/A$0
Excel: Searching for multiple terms in a cell - Stack Overflow
Feb 11, 2013 · In addition to the answer of @teylyn, I would like to add that you can put the string of multiple search terms inside a SINGLE cell (as opposed to using a different cell for each …
How to freeze the =today() function once data has been entered
Aug 2, 2015 · Excel's default format handling doesn't know to format this as date - so you would need to do this separately. More work than Ctrl + ; , but there might be some other use-cases …
excel - Return values from the row above to the current row
Jun 15, 2012 · To solve this problem in Excel, usually I would just type in the literal row number of the cell above, e.g., if I'm typing in Cell A7, I would use the formula =A6. Then if I copied that …
Assign a value to a cell depending on content of another cell
Jan 16, 2020 · I am trying to use the IF function to assign a value to a cell depending on another cells value So, if the value in column 'E' is 1, then the value in column G should be the same …
excel - Remove leading or trailing spaces in an entire column of …
Mar 6, 2012 · I've found that the best (and easiest) way to delete leading, trailing (and excessive) spaces in Excel is to use a third-party plugin. I've been using ASAP Utilities for Excel and it …
What does the "@" symbol mean in Excel formula (outside a table)
Oct 24, 2021 · Excel has recently introduced a huge feature called Dynamic arrays. And along with that, Excel also started to make a " substantial upgrade " to their formula language. One …
excel - How to show current user name in a cell? - Stack Overflow
if you don't want to create a UDF in VBA or you can't, this could be an alternative. =Cell("Filename",A1) this will give you the full file name, and from this you could get the user …
How to represent a DateTime in Excel - Stack Overflow
The underlying data type of a datetime in Excel is a 64-bit floating point number where the length of a day equals 1 and 1st Jan 1900 00:00 equals 1. So 11th June 2009 17:30 is about …
excel - Check whether a cell contains a substring - Stack Overflow
Sep 4, 2013 · Is there an in-built function to check if a cell contains a given character/substring? It would mean you can apply textual functions like Left/Right/Mid on a conditional basis without …
How to keep one variable constant with other one changing with …
The $ tells excel not to adjust that address while pasting the formula into new cells. Since you are dragging across rows, you really only need to freeze the row part: =(B0+4)/A$0
Excel: Searching for multiple terms in a cell - Stack Overflow
Feb 11, 2013 · In addition to the answer of @teylyn, I would like to add that you can put the string of multiple search terms inside a SINGLE cell (as opposed to using a different cell for each …
How to freeze the =today() function once data has been entered
Aug 2, 2015 · Excel's default format handling doesn't know to format this as date - so you would need to do this separately. More work than Ctrl + ; , but there might be some other use-cases …
excel - Return values from the row above to the current row
Jun 15, 2012 · To solve this problem in Excel, usually I would just type in the literal row number of the cell above, e.g., if I'm typing in Cell A7, I would use the formula =A6. Then if I copied that …
Assign a value to a cell depending on content of another cell
Jan 16, 2020 · I am trying to use the IF function to assign a value to a cell depending on another cells value So, if the value in column 'E' is 1, then the value in column G should be the same …
excel - Remove leading or trailing spaces in an entire column of …
Mar 6, 2012 · I've found that the best (and easiest) way to delete leading, trailing (and excessive) spaces in Excel is to use a third-party plugin. I've been using ASAP Utilities for Excel and it …