Advanced Excel Reporting for Management Accountants

DOWNLOAD NOW »

Author: Neale Blackwood

Publisher: John Wiley & Sons

ISBN: 1118658183

Category: Business & Economics

Page: 448

View: 2289

The advanced tools accountants need to build automated, reliable, and scalable reports using Excel Learn about the functions that work together to automate many of the processes involved in Management Reporting. See how to take advantage of the many new features of Excel 2007 and 2010. Find out how to build validation structures into your spreadsheet reports. Discover how to identify missing or new codes, either in the creation process or in the day-to-day running of the reports. Do it all with Advanced Excel Reporting for Management Accountants. Explore the structures that simplify the report creation process and make the reports more maintainable Learn techniques to "cleanse" data so that it is ready for use in Pivot Tables and formula-based reports Find out the tips and tricks that can make the creation process quicker and easier Discover all you need to know about Excel's summing functions and how versatile they can be Written in a hands-on style that works towards the completion of two reporting case studies, Advanced Excel Reporting for Management Accountants explains and demonstrates techniques so that Management Accountants can learn how to automate many aspects of the reporting process.

Forensic Analytics

Methods and Techniques for Forensic Accounting Investigations

DOWNLOAD NOW »

Author: Mark Nigrini

Publisher: John Wiley & Sons

ISBN: 9781118087633

Category: Business & Economics

Page: 480

View: 9306

Discover how to detect fraud, biases, or errors in your data using Access or Excel With over 300 images, Forensic Analytics reviews and shows how twenty substantive and rigorous tests can be used to detect fraud, errors, estimates, or biases in your data. For each test, the original data is shown with the steps needed to get to the final result. The tests range from high-level data overviews to assess the reasonableness of data, to highly focused tests that give small samples of highly suspicious transactions. These tests are relevant to your organization, whether small or large, for profit, nonprofit, or government-related. Demonstrates how to use Access, Excel, and PowerPoint in a forensic setting Explores use of statistical techniques such as Benford's Law, descriptive statistics, correlation, and time-series analysis to detect fraud and errors Discusses the detection of financial statement fraud using various statistical approaches Explains how to score locations, agents, customers, or employees for fraud risk Shows you how to become the data analytics expert in your organization Forensic Analytics shows how you can use Microsoft Access and Excel as your primary data interrogation tools to find exceptional, irregular, and anomalous records.

Excel 2013 All-in-One For Dummies

DOWNLOAD NOW »

Author: Greg Harvey

Publisher: John Wiley & Sons

ISBN: 1118550218

Category: Computers

Page: 792

View: 3140

The comprehensive reference, now completely up-to-date for Excel 2013! As the standard for spreadsheet applications, Excel is used worldwide - but it's not always user-friendly. However, in the hands of veteran bestselling author Greg Harvey, Excel gets a whole lot easier to understand! This handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more. The featured minibooks address Excel basics, worksheet design, formulas and functions, worksheet collaboration and review, charts and graphics, data management, data analysis, and Excel and VBA. Covers the changes in the newest version as well as familiar tasks, such as creating and editing worksheets, setting up formulas, and performing statistical functions Walks you through the new analysis tools that help make it easier to visualize data with the click of a mouse Details new ways to explore your data more intuitively and then analyze and display your results with a single click Whether you're an Excel newbie or a veteran user to wants to get familiar with the latest version, Excel 2013 All-in-One For Dummies has everything you need to know.

Accounting Best Practices

DOWNLOAD NOW »

Author: Steven M. Bragg

Publisher: John Wiley & Sons

ISBN: 1118417801

Category: Business & Economics

Page: 496

View: 7173

Praise for previous editions of Accounting Best Practices "For a comprehensive, yet easy-to-read guide to fixing those all-too-common shortcomings in your accounting department, look no further than this excellent book. Steve Bragg provides hundreds of fixes, many of them requiring surprisingly little time or cost while providing a handy guide to common implementation pitfalls. . . . I would recommend this invaluable book to anyone who is looking to enhance their existing processes, whether due to growth in their business, compliance with Sarbanes-Oxley, or just as part of their ongoing improvement process." —Martyn Webster, CPA, Director of Finance, XenoPort, Inc. "This book is critical to running an efficient and accurate accounting department. The use of RFID technology to track documents is one of many valuable tools in this latest edition. A required read for the demanding accounting manager's role." —Jason Charet, CPA "I've used Steve Bragg's Accounting Best Practices books for years as a source of ideas for improvement. Like previous editions, this edition has a number of new, actionable best practices as well as refinements of those ideas reported in previous editions. The books are broad enough in their perspective so that nearly any organization could find ideas that could pay back the cost of the book many times over." —John Temmerman, Controller, Evangelical Lutheran Church in America "What a great resource! I have been in the accounting field for over twenty years, and I was still able to gain insight into improving processes within my office. Thanks for putting it all in one book!" —Tina M. Thomas, CPA, CTP, Controller, Goodman & Company, LLP

Data Analysis Using SQL and Excel

DOWNLOAD NOW »

Author: Gordon S. Linoff

Publisher: John Wiley & Sons

ISBN: 1119021448

Category: Computers

Page: 792

View: 612

A practical guide to data mining using SQL and Excel Data Analysis Using SQL and Excel, 2nd Edition shows you how to leverage the two most popular tools for data query and analysis—SQL and Excel—to perform sophisticated data analysis without the need for complex and expensive data mining tools. Written by a leading expert on business data mining, this book shows you how to extract useful business information from relational databases. You'll learn the fundamental techniques before moving into the "where" and "why" of each analysis, and then learn how to design and perform these analyses using SQL and Excel. Examples include SQL and Excel code, and the appendix shows how non-standard constructs are implemented in other major databases, including Oracle and IBM DB2/UDB. The companion website includes datasets and Excel spreadsheets, and the book provides hints, warnings, and technical asides to help you every step of the way. Data Analysis Using SQL and Excel, 2nd Edition shows you how to perform a wide range of sophisticated analyses using these simple tools, sparing you the significant expense of proprietary data mining tools like SAS. Understand core analytic techniques that work with SQL and Excel Ensure your analytic approach gets you the results you need Design and perform your analysis using SQL and Excel Data Analysis Using SQL and Excel, 2nd Edition shows you how to best use the tools you already know to achieve expert results.

Budgeting Basics and Beyond

DOWNLOAD NOW »

Author: Jae K. Shim,Joel G. Siegel,Allison I. Shim

Publisher: John Wiley & Sons

ISBN: 1118127978

Category: Business & Economics

Page: 560

View: 4693

A convenient and up-to-date reference tool for today's financial and nonfinancial managers in public practice and private industry If the very thought of budgets pushes your sanity over the limit, then this practical, easy-to-use guide is just what you need. Budgeting Basics and Beyond, Fourth Edition equips you with an all-in-one resource guaranteed to make the budgeting process easier, less stressful, and more effective. The new edition covers rolling budgets (forecasts), activity-based budgeting, life-cycle budgeting. Cloud computing, Balanced Scorecard, budgeting for nonprofit organizations, business simulations for executive and management training, and much more! Includes several new software packages, computer-based models and spreadsheet applications, including Value Chain Management software, Financial Planning and Performance software, Web 2.0, Cloud computing, and capital budgeting software Features case studies, illustrations, exhibits, forms, checklists, graphs, samples, and worked-out solutions to a wide variety of budgeting, planning, and control problems Offers financial planning and new types of financial modeling, variance analysis, Web-based budgeting, active budgeting illuminating "what-if" analyses throughout, spreadsheet applications, break-even analysis, project analysis, and capital budgeting Budgeting Basics and Beyond, Fourth Edition is a practical, easy-to-use problem-solver and up-to-date reference tool for today's financial and nonfinancial managers in public practice and private industry.

IT (Information Technology) Portfolio Management Step-by-Step

Unlocking the Business Value of Technology

DOWNLOAD NOW »

Author: Bryan Maizlish,Robert Handler

Publisher: John Wiley & Sons

ISBN: 1118005058

Category: Business & Economics

Page: 400

View: 5271

Praise for IT Portfolio Management Step-by-Step "Bryan Maizlish and Robert Handler bring their deep experience in IT 'value realization' to one of the most absent of all IT management practices--portfolio management. They capture the essence of universally proven investment practices and apply them to the most difficult of challenges--returning high strategic and dollar payoffs from an enterprise's IT department. The reader will find many new and rewarding insights to making their IT investments finally return market leading results." --John C. Reece, Chairman and CEO, John C. Reece & Associates, LLC Former deputy commissioner for modernization and CIO of the IRS "IT Portfolio Management describes in great detail the critical aspects, know-how, practical examples, key insights, and best practices to improve operational efficiency, corporate agility, and business competitiveness. It eloquently illustrates the methods of building and integrating a portfolio of IT investments to ensure the realization of maximum value and benefit, and to fully leverage the value of all IT assets. Whether you are getting started or building on your initial success in IT portfolio management, this book will provide you information on how to build and implement an effective IT portfolio management strategy." --David Mitchell, President and CEO, webMethods, Inc. "I found IT Portfolio Management very easy to read, and it highlights many of the seminal aspects and best practices from financial portfolio management. It is an important book for executive, business, and IT managers." --Michael J. Montgomery, President, Montgomery & Co. "IT Portfolio Management details a comprehensive framework and process showing how to align business and IT for superior value. Maizlish and Handler have the depth of experience, knowledge, and insight needed to tackle the challenges and opportunities companies face in optimizing their IT investment portfolios. This is an exceptionally important book for executive leadership and IT business managers, especially those wanting to build a process-managed enterprise." --Peter Fingar, Executive Partner Greystone Group, coauthor of The Real-Time Enterprise and Business Process Management (BPM): The Third Wave "A must-read for the non-IT manager who needs to understand the complexity and challenges of managing an IT portfolio. The portfolio management techniques, analysis tools, and planning can be applied to any project or function." --Richard "Max" Maksimoski, Senior Director R&D, The Scotts Company "This book provides an excellent framework and real-world based approach for implementing IT portfolio management. It is a must-read for every CIO staff considering how to strategically and operationally impact their company's bottom line." --Donavan R. Hardenbrook, New Product Development Professional, Intel Corporation

Using Excel for Business Analysis

A Guide to Financial Modelling Fundamentals

DOWNLOAD NOW »

Author: Danielle Stein Fairhurst

Publisher: John Wiley & Sons

ISBN: 1119062446

Category: Business & Economics

Page: 300

View: 988

Utilise Excel 2013 capabilities to build effective financial models Using Excel for Business Analysis, Revised Edition provides practical guidance for anyone looking to build financial models. Whether for business proposals, opportunity evaluation, financial reports, or any other business finance application, this book shows you how to design, create, and test your model, then present your results effectively using Excel 2013. The book opens with a general guide to financial modelling, with each subsequent chapter building skill upon skill until you have a real, working model of your own. Financial tools, features, and functions are covered in detail from a practical perspective, and put in context with application to real-world examples. Each chapter focuses on a different aspect of Excel modelling, including step-by-step instructions that walk you through each feature, and the companion website provides live model worksheets that give you the real hands-on practice you need to start doing your job faster, more efficiently, and with fewer errors. Financial modelling is an invaluable business tool, and Excel 2013 is capable of supporting the most common and useful models most businesses need. This book shows you how to dig deeper into Excel's functionality to craft effective financial models and provide important information that informs good decision-making. Learn financial modelling techniques and best practice Master the formulas and functions that bring your model to life Apply stress testing and sensitivity analysis with advanced conditionals Present your results effectively, whether graphically, orally, or written A deceptively powerful application, Excel supports many hundreds of tools, features, and functions; Using Excel for Business Analysis eliminates the irrelevant to focus on those that are most useful to business finance users, with detailed guidance toward utilisation and best practice.

Valuation

Measuring and Managing the Value of Companies

DOWNLOAD NOW »

Author: McKinsey & Company Inc.,Tim Koller,Marc Goedhart,David Wessels

Publisher: John Wiley & Sons

ISBN: 1118874137

Category: Business & Economics

Page: 848

View: 3456

McKinsey & Company's #1 best-selling guide to corporate valuation, now in its sixth edition Valuation is the single best guide of its kind, helping financial professionals worldwide excel at measuring, managing, and maximizing shareholder and company value. This new sixth edition provides insights on the strategic advantages of value-based management, complete detailed instruction, and nuances managers should know about valuation and valuation techniques as applied to different industries, emerging markets, and other special situations. Valuation lies at the crossroads of corporate strategy and finance. In today's economy, it has become an essential role — and one that requires excellence at all points. This guide shows you everything you need to know, and gives you the understanding you need to be effective. Estimate the value of business strategies to drive better decision making Understand which business units a corporate parent is best positioned to own Assess major transactions, including acquisitions, divestitures, and restructurings Design a capital structure that supports strategy and minimizes risk As the valuation function becomes ever more central to long- and short-term strategy, analysts and managers need an authoritative reference to turn to for answers to challenging situations. Valuation stands ahead of the field for its reputation, quality, and prestige, putting the solutions you need right at your fingertips.

Excel for Accountants

DOWNLOAD NOW »

Author: Conrad Carlberg

Publisher: CPA911 Publishing

ISBN: 9781932925012

Category: Business & Economics

Page: 274

View: 4926

Accounting professionals learn how to get the information they need fast with this guide to Excel features that manipulate and sort financial data. Comprehensive but concise chapters explain how to automate the entry of common business formulas; how to use pivot tables to extract details; how to develop inventory, depreciation, and financial summaries; and how to set up other standard financial calculations.

Business Ratios and Formulas

A Comprehensive Guide

DOWNLOAD NOW »

Author: Steven M. Bragg

Publisher: John Wiley & Sons

ISBN: 1118169964

Category: Business & Economics

Page: 355

View: 3650

"Business ratios, formulas, and statistics are used by controllers, business managers, and analyst to evaluate company operations and performance. This book presents a comprehensive resource of nearly 250 operational criteria, allowing managers to pick and choose the tools they need to best assess their organization's performance. The measurements contain not only financial matters but also those related to efficiency, effectiveness, capacity, and market share. In addition, measurements related to asset utilization, operating performance, cash flows, liquidity, capital structure, return on investment, and market performance.Each measurement includes a description, an explanation of the calculation, an example, and cautions regarding its use. There is also a description of an electronic spreadsheet to compile a standard set of measurements using Excel as the template.This new edition will include over 20 new measurements"--

How to Read a Financial Report

Wringing Vital Signs Out of the Numbers

DOWNLOAD NOW »

Author: John A. Tracy

Publisher: John Wiley & Sons

ISBN: 0471646938

Category: Business & Economics

Page: 192

View: 9305

Hidden somewhere among all the numbers in a financial report is vitally important information about where a company has been and where it is going. This is especially relevant in light of the current corporate scandals. The sixth edition of this bestselling book is designed to help anyone who works with financial reports--but has neither the time nor the need for an in-depth knowledge of accounting--cut through the maze of accounting information to find out what those numbers really mean.

Big Data For Dummies

DOWNLOAD NOW »

Author: Judith Hurwitz,Alan Nugent,Fern Halper,Marcia Kaufman

Publisher: John Wiley & Sons

ISBN: 1118644174

Category: Computers

Page: 336

View: 6253

Find the right big data solution for your business or organization Big data management is one of the major challenges facing business, industry, and not-for-profit organizations. Data sets such as customer transactions for a mega-retailer, weather patterns monitored by meteorologists, or social network activity can quickly outpace the capacity of traditional data management tools. If you need to develop or manage big data solutions, you'll appreciate how these four experts define, explain, and guide you through this new and often confusing concept. You'll learn what it is, why it matters, and how to choose and implement solutions that work. Effectively managing big data is an issue of growing importance to businesses, not-for-profit organizations, government, and IT professionals Authors are experts in information management, big data, and a variety of solutions Explains big data in detail and discusses how to select and implement a solution, security concerns to consider, data storage and presentation issues, analytics, and much more Provides essential information in a no-nonsense, easy-to-understand style that is empowering Big Data For Dummies cuts through the confusion and helps you take charge of big data solutions for your organization.

Financial Reporting and Analysis

DOWNLOAD NOW »

Author: Charles Gibson

Publisher: Cengage Learning

ISBN: 1133188796

Category: Business & Economics

Page: 688

View: 7107

Now you can teach financial accounting from both a user’s and preparer’s perspective with a wealth of actual examples, cases, and real financial statements found in Gibson’s FINANCIAL REPORTING & ANALYSIS: USING FINANCIAL ACCOUNTING INFORMATION, 13e. This effective text emphasizes the analysis and interpretation of the end result of financial reporting--financial statements. The author focuses on the language and preparation of financial statements throughout. Students analyze real financial reports, 10Ks, proxy statements, other exhibits, and cases drawn from actual companies. Nike, used as a continuing focus company throughout the text, provides the opportunity for students to become familiar with a single organization and better understand the meaning of its statements within a competitive context. In addition to a wide variety of problems, questions, cases, and Web references for practice and application, students also have access to the robust Thomson ONE: Business School Edition--the same online financial analysis tool used by Wall Street professionals every day. With the book’s well-organized framework for learning and emphasis on numerous industries, your students leave the course prepared for success, no matter what area of business they pursue. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

Treasury Management

The Practitioner's Guide

DOWNLOAD NOW »

Author: Steven M. Bragg

Publisher: John Wiley & Sons

ISBN: 0470497084

Category: Business & Economics

Page: 304

View: 8349

Praise for Treasury Management The Practitioner's Guide "Steven Bragg has written a broad-based look at the treasurer's function that is as timely as it is complete. This book is an excellent choice for experienced treasury personnel, those new to the area, or the small business CFO needing to develop additional expertise." ?Matthew Boutte, Asset/Liability Manager, AVP, Sterling Bank "Cash is king! Steven Bragg's Treasury Management: The Practitioner's Guide peels back the onion on the most pressing topics facing today's treasurer?cash management, financing, risk management, and treasury systems." ?Geoffrey Garland, Controller, Staco Systems "This book gives an insight into the various intricacies, augmented with examples and flowcharts, involved in a treasury role. It gives a practical and detailed approach to cash management. A must-read for accounting heads of small businesses who have the additional responsibility of being a treasurer." ?Priya K Srinivasan, Owner, Priya K Srinivasan CPA Treasury Management: The Practitioner's Guide describes all aspects of the treasury function. This comprehensive book includes chapters covering the treasury department, cash transfer methods, cash forecasting, cash concentration, working capital management, debt management, equity management, investment management, foreign exchange risk management, interest risk management, clearing and settlement systems, and treasury systems. If you are a treasurer, CFO, cash manager, or controller, Treasury Management: The Practitioner's Guide allows you to quickly grasp the real world of treasury management and the many practical and strategic issues faced by treasurers and financial professionals today.

Excel Advanced Report Development

DOWNLOAD NOW »

Author: Timothy Zapawa

Publisher: John Wiley & Sons

ISBN: 0470368292

Category: Computers

Page: 504

View: 7739

If you're a SQL programmer or an experienced Excel user, here at last is the ultimate resource on developing reporting solutions with Excel. Focused on report development using OLTP databases, this book is packed with comprehensive information on both technical and strategic aspects. You'll thoroughly examine the main features of Excel's reporting technology-PivotTable reports, Spreadsheet reports, parameter queries, and web components. With notes, tips, warnings, and real-world examples in each chapter, you'll be able to put your knowledge to work immediately. This book includes: Single-source coverage of Excel's report development features Extensive and in-depth information on PivotTable and Spreadsheet report features, functions, and capabilities Thorough documentation of the Microsoft Query program included with Excel Comprehensive information on Excel's client-based OLAP cube tools for processing very large datasets from OLTP data sources Detailed information on creating and working with web-enabled Excel reports

Financial Modeling Using Excel and VBA

DOWNLOAD NOW »

Author: Chandan Sengupta

Publisher: John Wiley & Sons

ISBN: 9780471267683

Category: Business & Economics

Page: 857

View: 2145

"Reviews all the necessary financial theory and concepts, and walks you through a wide range of real-world financial models" - cover.

Balanced Scorecard Evolution

A Dynamic Approach to Strategy Execution

DOWNLOAD NOW »

Author: Paul R. Niven

Publisher: John Wiley & Sons

ISBN: 111893900X

Category: Business & Economics

Page: 368

View: 5149

The best plan is useless without effective execution The future of business has become so unpredictable that your five-year plan may be irrelevant next week. To succeed in the modern market, you must constantly assess your progress and adapt on the fly. Agility, flexibility, continual learning, and adaptation are the new rules of business success. A differentiating strategy is crucial, but it will only lead to competitive advantage if you execute it flawlessly. You'll succeed only if you have the right insight for strategic planning and the agility to execute your plan. Balanced Scorecard Evolution: A Dynamic Approach to Strategy Execution provides the latest theory and practice from strategic planning, change management, and strategy execution to ensure your business is flexible, future ready, and primed for exceptional execution. Author Paul R. Niven guides you through the new principles of The Balanced Scorecard and shows you how to apply them to your planning and strategy execution endeavors. Read case studies that illustrate the theory and practice of strategic agility and execution Learn how to create the objectives, measures, targets, and strategic initiatives that can make your plan a reality Use the latest change management techniques to boost strategy execution success Gain the knowledge and tools you need to face your challenges head-on Motivate your employees to change behaviors toward plan accommodation Making a plan isn't enough. You must actually take steps to implement your plan, and this requires excellent leadership skills. Change can be hard, and your organization may be resistant. Balanced Scorecard Evolution: A Dynamic Approach to Strategy Execution provides everything you need to make things happen.

Excel Dashboards and Reports

DOWNLOAD NOW »

Author: Michael Alexander,John Walkenbach

Publisher: John Wiley & Sons

ISBN: 9780470920732

Category: Computers

Page: 456

View: 7299