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

SAP Analysis for Microsoft Office—Practical Guide

ca. € 79,95

Lieferbar ab 18.02.2021

ca. € 74,95

Verfügbar ab 18.02.2021

650 Seiten, , gebunden
SAP PRESS, ISBN 978-1-4932-2004-5
650 Seiten,
E-Book-Formate: PDF, EPUB, MOBI, Online
SAP PRESS, ISBN 978-1-4932-2005-2

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
650 pages, hardcover, 1.6 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 (32 MB), EPUB (23 MB), and MOBI (61 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 Dahlbeer and, as an author, passes on his knowledge of everyday SAP projects.

ca. € 79,95 inkl. MwSt.

Lieferbar ab 18.02.2021

Kostenloser Versand nach Deutschland, Österreich und in die Schweiz

DSAG Mitglieder
Der Rabatt wird im Warenkorb sichtbar


ca. € 74,95 inkl. MwSt.

Verfügbar ab 18.02.2021

DSAG Mitglieder
Der Rabatt wird im Warenkorb sichtbar

Kostenloser Versand
nach Deutschland, Österreich und in die Schweiz
Bequem zahlen
Kreditkarte, Rechnung oder Bankeinzug
Schnelle Lieferung
Auch per Express
Wir sind gerne für Sie da
Hilfe zur Bestellung

Montag bis Freitag,
09:00 bis 17:30 Uhr
+49 228 42150-0