Report, plan, and analyze SAP data in Excel, step by step!

SAP Analysis for Microsoft Office—Practical Guide

written by
$74.99

Available

$79.95

Available

$89.99

Available

Print edition E-book Bundle
569 pages, , Print edition hardcover
ISBN 978-1-4932-2004-5
569 pages,
E-book formats: EPUB, PDF, online
ISBN 978-1-4932-2005-2
569 pages, , Print edition hardcover
E-book formats: EPUB, PDF, online
ISBN 978-1-4932-2006-9
Managing your SAP data in Microsoft Excel? This is your guide to using SAP Analysis for Microsoft Office! Get started with the basics, from creating your first workbook to navigating through reports. Then, follow step-by-step instructions to process data, analyze data, develop planning applications, customize reports, and work with tools such as formulas and macros. Including details on troubleshooting, UI customization, and more, this book is your all-in-one resource!
  • Use SAP Analysis for Microsoft Office for reporting and planning
  • Work with prompts, organize data, apply calculations, and format reports
  • Conduct advanced data analysis with formulas and macros
About the Book About the E-book 569 pages, hardcover, 1.34 inch. Reference book format 7 x 10 in. Printed black and white on 60# offset paper from sustainable sources. Casebound for durability. Reader-friendly serif font (TheAntiquaB 9.5 Pt.). One-column layout. E-book in full color. PDF (12 MB), EPUB (11 MB) file for download, DRM-free with personalized digital watermark. Copy and paste, bookmarks, and print-out permitted. Table of contents, in-text references, and index fully linked. Including online book edition in dedicated reader application.

In this book, you’ll learn about:

  1. Reporting and Data Analysis

    Learn to work with reports in SAP Analysis for Microsoft Office: define parameters with prompts, adjust formatting and styles, and extend reports with local data. Filter, sort, and display your data using hierarchies, and refine data analysis with simple and advanced calculations.

  2. Planning

    Use your SAP data to develop planning workbooks. Plan your data both manually and with functions and sequences. Understand key settings for cell locking, the planning model, and more.

  3. Advanced Features

    Take your skills to the next level. Write formulas to use in your reports, and create and use macros in your workbooks, including steps to use API methods, callbacks, and design rules.

Highlights include:

  • Workbook creation
  • Report navigation
  • Prompts
  • Data processing, organization, and analysis
  • Planning applications
  • Report customization and formatting
  • Formulas
  • Macros
  • Configuration
  • Troubleshooting

Denis Reis is a business intelligence consultant at PwC. As an author, this Zürich-born family man hopes to pass on his knowledge of everyday SAP projects in a concise, approachable manner.

more >

Product supplements

Here you can find downloadable supplements for the product.

Supplements list >

You may also like:

  • Cover of SAP BW/4HANA 2.0

    SAP BW/4HANA 2.0
    The Comprehensive Guide

    Thorsten Lüdtke, Marina Lüdtke

    663 pages, hardcover

    Ready for SAP BW/4HANA 2.0? Whether you're an architect, administrator, or developer, this comprehensive guide is for you. Start with a new installation or migrate from an existing SAP BW system. Then walk through major administration, security, and data management More about the book

    from $84.99

    Available

    E-book | Print edition | Bundle
  • Cover of Group Reporting with SAP S/4HANA

    Group Reporting with SAP S/4HANA
    Financial Consolidation Guide

    Eric Ryan, Thiagu Bala, Satyendra Raghav, Azharuddin Mohammed

    375 pages, hardcover

    Perform financial consolidation in your SAP S/4HANA system! With this guide to SAP S/4HANA Finance for group reporting, learn about the new group reporting architecture and data model. Configure your master data and integrate transactional data for consolidation using the More about the book

    from $84.99

    Available

    E-book | Print edition | Bundle
  • Cover of SAP S/4HANA Embedded Analytics

    SAP S/4HANA Embedded Analytics
    The Comprehensive Guide

    Jürgen Butsmann, Thomas Fleckenstein, Anirban Kundu

    432 pages, hardcover

    Meet your BI needs with SAP S/4HANA embedded analytics! Explore the system architecture and data model and learn how to perform analytics on live transactional data. Business user? Walk step-by-step through SAP Smart Business KPIs, dashboards, and multidimensional reporting. Analytics More about the book

    from $84.99

    Available

    E-book | Print edition | Bundle