- Table View
- List View
Excel 2010: The Missing Manual (The\missing Manual Ser.)
by Matthew MacDonaldExcel, the world's most popular spreadsheet program, has the muscle to analyze heaps of data. Beyond basic number-crunching, Excel 2010 has many impressive features that are hard to find, much less master -- especially from online help pages. This Missing Manual clearly explains how everything works with a unique and witty style to help you learn quickly.Navigate with ease. Master Excel's tabbed toolbar and its new backstage viewPerform a variety of calculations. Write formulas for rounding numbers, calculating mortgage payments, and moreOrganize your data. Search, sort, and filter huge amounts of informationIllustrate trends. Bring your data to life with charts and graphics -- including miniature charts called SparklinesExamine your data. Summarize information and find hidden patterns with pivot tables and slicersShare your spreadsheets. Use the Excel Web App to collaborate with colleagues onlineRescue lost data. Restore old versions of data and find spreadsheets you forgot to save
Excel 2013 for Human Resource Management Statistics
by Thomas J. Quirk Julie Palmer-SchuylerThis book shows how Microsoft Excel is able to teach humanresource management statistics effectively. Similar to the previously published Excel 2010 for Human Resource Management Statistics, it is a step-by-step exercise-driven guide for students andpractitioners who need to master Excel to solve practical human resourcemanagement problems. If understanding statistics isn't your strongest suit, youare not especially mathematically-inclined, or if you are wary of computers,this is the right book for you. Excel,a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in humanresource management courses. Its powerful computational ability and graphicalfunctions make learning statistics much easier than in years past. Excel 2013 for Human Resource ManagementStatistics: A Guide to Solving Practical Problems is the next book to capitalizeon these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work. Each chapter explains statisticalformulas and directs the reader to use Excel commands to solve specific,easy-to-understand human resource management problems. Practice problems areprovided at the end of each chapter with their solutions in an Appendix. Separately, there is a full Practice Test (with answers in an Appendix) thatallows readers to test what they have learned.
Excel 2013: The Missing Manual (The\missing Manual Ser.)
by Matthew MacDonaldThe world’s most popular spreadsheet program is now more powerful than ever, but it’s also more complex. That’s where this Missing Manual comes in. With crystal-clear explanations and hands-on examples, Excel 2013: The Missing Manual shows you how to master Excel so you can easily track, analyze, and chart your data. You’ll be using new features like PowerPivot and Flash Fill in no time.The important stuff you need to know:Go from novice to ace. Learn how to analyze your data, from writing your first formula to charting your results.Illustrate trends. Discover the clearest way to present your data using Excel’s new Quick Analysis feature.Broaden your analysis. Use pivot tables, slicers, and timelines to examine your data from different perspectives.Import data. Pull data from a variety of sources, including website data feeds and corporate databases.Work from the Web. Launch and manage your workbooks on the road, using the new Excel Web App.Share your worksheets. Store Excel files on SkyDrive and collaborate with colleagues on Facebook, Twitter, and LinkedIn.Master the new data model. Use PowerPivot to work with millions of rows of data.Make calculations. Review financial data, use math and scientific formulas, and perform statistical analyses.
Excel 2016 for Business Statistics
by Thomas J. QuirkThis book shows the capabilities of Microsoft Excel in teaching business statistics effectively. Similar to the previously published Excel 2010 for Business Statistics, this book is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical business problems. If understanding statistics isn't your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you. Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in business courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Excel 2016 for Business Statistics: A Guide to Solving Practical Problems is the first book to capitalize on these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work. Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand business problems. Practice problems are provided at the end of each chapter with their solutions in an appendix. Separately, there is a full Practice Test (with answers in an Appendix) that allows readers to test what they have learned.
Excel 2019 for Advertising Statistics: A Guide to Solving Practical Problems (Excel for Statistics)
by Thomas J. Quirk Eric RhineyNewly revised for Excel 2019, this text is a step-by-step guide for students taking a first course in statistics for advertising and for advertising managers and practitioners who want to learn how to use Excel to solve practical statistics problems in the workplace, whether or not they have taken a course in statistics.Excel 2019 for Advertising Statistics explains statistical formulas and offers practical examples for how students can solve real-world advertising statistics problems. Each chapter offers a concise overview of a topic, and then demonstrates how to use Excel commands and formulas to solve specific advertising statistics problems. This book demonstrates how to use Excel 2019 in two different ways: (1) writing formulas (e.g., confidence interval about the mean, one-group t-test, two-group t-test, correlation) and (2) using Excel’s drop-down formula menus (e.g., simple linear regression, multiple correlation and multiple regression, and one-way ANOVA). Three practice problems are provided at the end of each chapter, along with their solutions in an appendix. An additional practice test allows readers to test their understanding of each chapter by attempting to solve a specific practical advertising statistics problem using Excel; the solution to each of these problems is also given in an appendix. This latest edition features a wealth of new end-of-chapter problems and an update of the chapter content throughout.
Excel 2019 for Business Statistics: A Guide to Solving Practical Problems (Excel for Statistics)
by Thomas J. QuirkNewly revised to specifically provide demonstration in Excel 2019, this volume shows the capabilities of Microsoft Excel in business statistics. Similar to its predecessor, Excel 2016 for Business Statistics, it is a step-by-step, exercise-driven guide for students and practitioners who are looking to master Excel to solve practical business problems. Excel, a widely available computer program for students and professionals, is also an effective teaching and learning tool for quantitative analyses in business courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. Excel 2019 for Business Statistics: A Guide to Solving Practical Problems capitalizes on these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work.Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand business problems. Practice problems are provided at the end of each chapter with their solutions in an appendix. Separately, there is a full practice test (with answers in an appendix) that allows readers to test what they have learned. This new edition offers a wealth of new sample problems, as well as updated chapter content throughout.
Excel 2019 for Human Resource Management Statistics: A Guide to Solving Practical Problems (Excel for Statistics)
by Thomas J. Quirk Julie Palmer-SchuylerThis book shows the capabilities of Microsoft Excel in teaching human resource management statistics effectively. Similar to the previously published Excel 2016 for Human Resource Management Statistics, this book is a step-by-step, exercise-driven guide for students and practitioners who need to master Excel to solve practical human resource management problems. If understanding statistics isn’t your strongest suit, you are not especially mathematically inclined, or if you are wary of computers, this is the right book for you. Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in human resource management courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Excel 2019 for Human Resource Management Statistics: A Guide to Solving Practical Problems, 2nd Edition, capitalizes on these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work. Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand human resource management problems. Practice problems are provided at the end of each chapter with their solutions in an appendix. Separately, there is a full practice test (with answers in an appendix) that allows readers to test what they have learned.
Excel 2019 for Marketing Statistics: A Guide to Solving Practical Problems (Excel for Statistics)
by Thomas J. Quirk Eric RhineyThis book shows the capabilities of Microsoft Excel in teaching marketing statistics effectively. It is a step-by-step, exercise-driven guide for students and practitioners who need to master Excel to solve practical marketing problems. If understanding statistics isn’t your strongest suit, you are not especially mathematically inclined, or if you are wary of computers, this is the right book for you.Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in marketing courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. Excel 2019 for Marketing Statistics: A Guide to Solving Practical Problems capitalizes on these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work.In this new edition, each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand marketing problems. Practice problems are provided at the end of each chapter with their solutions in an appendix. Separately, there is a full practice test (with answers in an appendix) that allows readers to test what they have learned.
Excel Basics to Blackbelt: An Accelerated Guide to Decision Support Designs
by Elliot BendolyThis third edition capitalizes on the success of the previous editions and leverages the important advancements in visualization, data analysis, and sharing capabilities that have emerged in recent years. It serves as an accelerated guide to decision support designs for consultants, service professionals and students. This 'fast track' enables a ramping up of skills in Excel for those who may have never used it to reach a level of mastery that will allow them to integrate Excel with widely available associated applications, make use of intelligent data visualization and analysis techniques, automate activity through basic VBA designs, and develop easy-to-use interfaces for customizing use. The content of this edition has been completely restructured and revised, with updates that correspond with the latest versions of software and references to contemporary add-in development across platforms. It also features best practices in design and analytical consideration, including methodical discussions of problem structuring and evaluation, as well as numerous case examples from practice.
Excel Best Practices for Business
by Loren AbdulezerHow to create, manage, and validate spreadsheets that will stand up to scrutiny and provide a clear and accurate picture of your enterprise.
Excel Cookbook: Recipes for Mastering Microsoft Excel
by Dawn GriffithsFilled with tips, tricks, and techniques, this easy-to-use book is the perfect resource for intermediate to advanced users of Excel. You'll find complete recipes for more than a dozen topics covering formulas, PivotTables, charts, Power Query, and more. Each recipe poses a particular problem and outlines a solution that you can put to use right away—without having to comb through tutorial pages. Whether you're a data analyst, project manager, or financial analyst, author Dawn Griffiths directs you straight to the answers you need. Ideal as a quick reference, Excel Cookbook is also perfect for learning how to work in a more efficient way, leading to greater productivity on the job. With this book, you'll jump in and get answers to your questions—fast. This cookbook shows you how to: Build compelling charts and use Sparklines, 3D Maps, and other visualizations Use PivotTables to slice, dice, and summarize datasets Perform statistical and financial analyses using formulas, Forecast Sheets, the Analysis ToolPak, and more Master dynamic array functions such as SEQUENCE, TEXTSPLIT, and FILTER Use Power Query to import, shape, and combine datasets Create custom functions using LAMBDA formulas Use developer options to write VBA code and create custom UserForms
Excel Data Analysis
by Hector GuerreroThis book is written for the students and practitioners who are looking for a single introductory Excel-based resource that covers three essential business and analytical skills--Data Analysis, Business Modeling, and Simulation of Complex Problems. The focus of the book is clearly on analysis of problems for decision making, yet detailed explanations regarding how to use Excel tools are provided. After many years of teaching and consulting, it is abundantly clear to me that for most students, a good example is worth its weight in gold. This book contains many excellent examples in each chapter, some simple and others more complex, and there is an abundance of exhibits to guide the student through the maze of steps necessary for each analysis. The content is quite diverse: * data presentation -- the Feng Shui of spreadsheets, effective communication and collaboration * data preparation -- import, scrub, manipulate data * data analysis -- statistical methods: descriptive, inferential, and predictive, Design of Experiments * modeling -- deterministic, probabilistic, What-if, Scenarios * simulation -- quantifying uncertainty, Monte Carlo Simulation * optimization -- constrained, Linear Programming, non-linear models, Goal Seek * Couple these features with detailed discussions of how to realistically organize and extract insight from complex problems, and I believe you have a unique educational combination in one book.
Excel Data Analysis: Modeling And Simulation
by Hector GuerreroThis book offers a comprehensive and readable introduction to modern business and data analytics. It is based on the use of Excel, a tool that virtually all students and professionals have access to. The explanations are focused on understanding the techniques and their proper application, and are supplemented by a wealth of in-chapter and end-of-chapter exercises. In addition to the general statistical methods, the book also includes Monte Carlo simulation and optimization. The second edition has been thoroughly revised: new topics, exercises and examples have been added, and the readability has been further improved. The book is primarily intended for students in business, economics and government, as well as professionals, who need a more rigorous introduction to business and data analytics – yet also need to learn the topic quickly and without overly academic explanations.
Excel im Controlling für Dummies (Für Dummies)
by Karsten OehlerWenn Sie Controller sind, verbringen Sie mit Excel viele, viele Stunden. Dieses Buch zeigt Ihnen, wie Sie Excel professionell einsetzen. Lernen Sie, wie Sie Pivot-Tabellen und -Charts erstellen, wie Sie Daten importieren oder exportieren, wie Sie Diagramme erstellen und wie Sie wichtige Excel-Formeln anwenden. Mit diesem Buch sind Planung, Budgetierung und Vorschaurechnung viel leichter und schneller erledigt. Sie werden Excel lieben!
Excel-Based Business Analysis
by Ali Anari James W. Kolari"The trend is your friend"is a practical principle often used by business managers, who seek to forecast future sales, expenditures, and profitability in order to make production and other operational decisions. The problem is how best to identify and discover business trends and utilize trend information for attaining objectives of firms.This book contains an Excel-based solution to this problem, applying principles of the authors' "profit system model" of the firm that enables forecasts of trends in sales, expenditures, profits and other business variables. The program, called FIRM, which runs on Windows with Microsoft Excel 2010, useshistorical time series of total sales, total costs, and total assets of the firm from its financial statements (income statements and balance sheets), estimates relationships among these variables, and then employs the estimated relationships to forecasts trends in these vital business variables. Featuring step-by-step case examples, the goal is to equip business managers and students with easy-to-use tools for understanding and forecasting trends in important business variables, thereby empowering them to make better business decisions.
Excellence Beyond Compliance: Establishing a Medical Device Quality System
by William I. WhiteMany companies limp along from day-to-day treating the quality side of the business as a necessary evil, and doing only what is minimally necessary for compliance to regulations. This kind of approach to compliance almost always results in inefficiencies and sometimes can result in a curious kind of noncompliance. Documentation created with compliance as the sole consideration often ends up confusing the employees who must use the documentation. This book looks beyond what is necessary for compliance alone to address what makes a quality management system (QMS) both effective and efficient. This book also never forgets that real people must make any QMS work; the book provides a blueprint for creating a QMS that real people will find useful. After a review of the challenges that any medical device company faces in the world of today—the multiple sources of QMS requirements—the book poses a question: are we satisfied with the QMS we have now, or could we do better? If we want to do better, this book can help. This book offers: Advice that will lead to an effective and efficient QMS. Detailed guidance on the key decisions to be made regarding the quality system being established. Detailed ideas on how to execute those decisions. Up-to-date information on compliance to current regulations and standards and guidance on staying up to date. Specific examples of procedures. Information regarding requirements for combination products, such as a drug + device combination. Advice on incorporating risk management in the QMS.
Excellence Wins: A No-Nonsense Guide to Becoming the Best in a World of Compromise
by Horst Schulze"Horst Schulze created a culture of service that should be a role model for all of us. By committing to the highest standards of professionalism - and creating the right systems to achieve them - he inspired thousands of people to embrace and embody the core ideal of sheer unadulterated excellence. With this profoundly useful book, Schulze now shares his story, and his methods, so that the rest of us can be uplifted and taught by the master himself."-Jim Collins, author of Good to Great, co-author of Built to Last"Horst Schulze's influence on my family and our business is undeniable. His approach to customer service revolutionized the hotel industry and set a high bar for all of us. His new book, Excellence Wins, weaves Horst's personal story with the practical wisdom he's gleaned from an incredible career of servant leadership. It's a must read for leaders and anyone passionate about serving people."-Dan Cathy, chairman and CEO, Chick-fil-A***CEOs. Leaders without titles. Startups. Corporations. For-profits. Nonprofits.It doesn't matter who you are or what you do - you want to become the best. You want to win, every time.Horst Schulze knows how to win. In Excellence Wins, Schulze, in his absolute no-nonsense approach, shares the visionary and disruptive principles that have produced immense global successes over the course of his still-prolific fifty-year career.As the co-founder and former president of Ritz-Carlton Hotel Co., Schulze fearlessly led the company to unprecedented multi-billion dollar growth, setting the business vision and people-focused standards that made the Ritz-Carlton brand globally elite.Schulze's principles are both versatile and utterly practical to leaders of every age, career stage, and industry. You don't need a powerful title or a line of direct reports - you have everything you need to use them right now.If you're searching for the blueprint to beating the competition and out-performing everyone around you, look no further than Excellence Wins. Schulze pulls no punches as a masterful guide to becoming the very best in a world of routine compromise.Unleash the disruptive power of your true potential, own your career trajectory, and experience the game-changing proof firsthand: Excellence Wins.
Excellence im Management-Reporting: Transparenz für die Unternehmenssteuerung (Advanced Controlling)
by Jürgen Weber Thomas Lührmann Regina MalzEin zielgerichtetes und aktiv verwendetes Management Reporting ist Eckpfeiler einer erfolgreichen Unternehmenssteuerung. Konzeption und Umsetzung dieses Reportings sind Kernaufgaben des Controllings und erweisen sich in der Praxis häufig als überaus anspruchsvoll. Jürgen Weber, Regina Malz und Thomas Lührmann zeigen auf, welche Spannungsfelder beim Aufbau eines Management Reportings zu beachten sind und wie man die dabei auftretenden Herausforderungen erfolgreich bewältigt.
Excellence in Advertising
by Leslie ButterfieldWhile many books on advertising are written by people whose experience of the industry is either limited or else rather distant in time, Excellence in Advertising, has been created by a group of people who are directly involved in the business currently and are at the very top of their profession. The first edition of this book, published in 1997, proved to be a huge success both in the UK and internationally. This new edition is substantially updated and enlarged - with new authors added and new subjects covered.The cast list of authors, headed by Leslie Butterfield as editor and contributor, reads like a veritable Who's Who of advertising and marketing: John Bartle, Steve Henry, Professor Peter Doyle, Mike Sommers and now also Richard Hytner, Tim Broadbent, Tim Pile and others.Together their contributions present an authoritative view on what constitutes best practice in a wide range of key areas that are the context for the creation of effective advertising:Building successful brandsStrategy developmentThe analysis and interpretation of qualitative research Creative briefing Media strategyAND NEW IN THIS EDITION:Managing relationshipsEvaluating advertisingLoyaltyShareholder valueTotal communication strategyCombining state-of-the-art thinking and practical advice, this book will be of value to those who use advertising to build brands, those who study advertising and its role and to those actively engaged in producing excellence in advertising on a daily basis.Leslie Butterfield is Chairman of Partners BDDH, the agency he founded in 1987. He is one of the UK advertising industry's most respected strategists, and a regular contributor to advertising conferences and publications. He was Chairman of the IPA's Training and Development Committee from 1989 to 1997 and is now a Council Member and Fellow of the IPA.
Excellence in Coaching
by Jonathan PassmoreExcellence in Coaching presents cutting-edge thinking in the field of workplace coaching. This comprehensive industry guide enables coaches to achieve personal excellence in a rapidly evolving profession through a collection of best-practice material from some of the biggest names in the profession including Carol Wilson, Peter Hawkins and Cary Cooper. Part One covers the business of coaching, telling practitioners everything they need to know about setting up a coaching practice, defining the coaching requirements, building a business case and embedding best practice in workplace coaching. Part Two covers models and approaches including NLP, appreciative coaching, cognitive behavioural coaching and solution-focused coaching. Part Three considers issues around coaching including evaluating coaching programmes, ethics, and coaching supervision. This latest edition has been updated to reflect recent developments in the industry and includes a new chapter on team coaching. Excellence in Coaching is essential reading for practising coaches as well as for anyone studying coaching through the ILM, coaching training, a Master's course, or more generally as part of a psychology or business degree.
Excellence in Coaching: Theory, Tools and Techniques to Achieve Outstanding Coaching Performance
by Jonathan PassmoreHow can you achieve coaching excellence? Use the latest research and insights from some of the biggest industry names in this fully revised fourth edition, which provides a diverse range of theory, tools and models for students and practicing coaches alike.Excellence in Coaching is a comprehensive guide presenting the latest cutting-edge thinking in the field of workplace coaching. Published with the Association for Coaching, this book covers all key components of the coaching process, and examines a diverse range of coaching models including behavioural and transpersonal coaching, enabling coaches and trainers to adapt their approach and excel in their professional practice.With updates to incorporate the latest thinking and insights, this revised fourth edition of Excellence in Coaching also contains a wealth of fresh material, including new chapters on establishing a coaching business, neuroscience coaching, psychodynamic coaching and understanding the coaching relationship. Featuring tips, checklists and tools, and a collection of best-practice material from some of the biggest names in the profession including Sir John Whitmore, Peter Hawkins and David Clutterbuck. This remains essential reading for practising coaches as well as for students.
Excellence in It: Achieving Success in an Information Technology Career
by Warren C. ZabloudilExcellence in IT reminds you that IT is an all or nothing career with too many people depending on you for the job to not be done well at all times. Everyone working in IT should rise to the occasion and seek to deliver the highest quality workmanship possible. The book covers all those things that keep IT professionals awake at night and offers advice on how to work around stress, work easier and faster, deal with problematic personalities, keep up with the never-ending chase for new knowledge, and, ultimately, how to stay competitive in your career for a long, long time. Excellence in IT provides answers to virtually everything a computer career involves and outlines how to rise to the top of your field while looking after your personal happiness too. It's not just another bone dry technical guide, but an easily readable book that explains what you're going through every day on the job and how to make your career work better for you.
Excellence in Managing Worldwide Customer Relationships (The Global Warrior Series #5)
by Thomas A. CookEvery company is recognizing the critical importance of protecting its customer base by raising the bar of its customer service prowess. Excellence in Managing Worldwide Customer Relationships identifies the risks companies face when expanding their business model in both domestic and overseas markets and offers solutions, strategies, and a structure to minimize obstacles when selling to domestic and foreign markets while satisfying customers and developing new business. This fifth book in the Global Warrior Series looks at the obstacles in customer service management and provides a 10-step process for developing a best-practices approach that offers the best opportunity for excellence, world class initiatives, and high client satisfaction and retention levels. It focuses on technology, along with other measures and how it can be utilized in customer service relationships that will enhance the customers’ loyalty. As companies grow within their North American markets and internationally, the book will also look at customer service in home markets, as well as in global operations, cultural issues, and expanding into world markets.
Excellence in Operational Resilience: How to Lead, Follow and Guide the Way
by Michael W. JankoProviding essential guidance to thrive in a complex environment, this book showcases tools to take the leadership role in the process of building resilience in any organization in a timely, effective, and practical way for today’s risks and tomorrow’s challenges.All organizations seek to be resilient, yet most do not have a clear definition of what that means for them, or a plan to manage the journey to attain it. This resilience playbook includes the right combination of technical knowledge, team structure, leadership support, and behavioral competencies, all based on a clear “Lead, Follow, Guide” framework. Based on the author’s three decades of successfully implementing resilience-based strategies at Goodyear and other major firms, this book offers road-tested advice and techniques to bring quick wins and long-term success in organizational resilience.With this book to assist, risk-savvy executive leaders and professionals working in business continuity, risk management, security, IT, supply chain, operations management, and process improvement will maintain a constant pulse on their journey towards resilience, keep the right people engaged, and create a team-based approach to reach their goals.