Reporting with SAP and Excel

What are charts and formulas used for?

A chart is a group of basic shapes put together in a meaningful way: rectangles for columns and bars, lines for curves and axes, etc. In other words, charts are applied geometry.

Microsoft Excel contains many functions for representing values and texts in tabular form and for evaluating the information that these contain in different ways. In particular, the formulas that can be used offer added value, as they enable users to create statistics, financial and mathematical analyses as well as other formula-based calculations.

 

What do charts and Excel have to do with Sparks?

It can prove to be challenging if a uniform layout or an exact representation of the relationship between numbers and data is required for reporting in Excel. This is difficult to achieve and requires a lot of work.

The Sparks Excel add-in offers an intuitive solution, as it cleverly combines the calculation and reporting functions of Excel, while at the same time overcoming the challenges of ensuring a uniform layout and presenting charts. . Sparks creates a chart from a list of figures and an Excel formula, which uses this data to calculate the geometric dimensions of the shapes. This means that the user can control the reports quickly and precisely using just an Excel formula – from the overall picture down to the last detail. Even changes to the data are taken into account, as Sparks adapts the relevant charts automatically and dynamically.

Sparks - OnePager

Rules for success according to IBCS ... guaranteed with Sparks

Sparks, the reporting tool from Kern AG, is a software solution based on Excel formulas for the simple creation of professional charts based on modern visualization philosophies – in keeping with the visualization concept of Prof. Hichert and the International Business Communication Standards (IBCS).

Transparent

Focus on the key points

Information not decoration

Structures determine the image

Colors convey messages

Individual

Create your own corporate design

Modify all parameters with ease

Save frequent changes as a template

Dynamic

Define cell references for parameters

If the cells change, the graphic adapts automatically

Integrate any Excel forms

Powerful

Use IBCS templates

Formulas control forms

Reporting in Excel with Sparks

Sparks makes it easy for all Excel users – from beginners to experts – to report on valid figures and data in a visually appealing and consistent way. Sparks is innovative in the way that it brings together all the Excel cells, formulas and shapes, and functions (copy & paste, cell references, range names, data origins, formats), with which all users are familiar.

Layout
Data
Charts
Parameters
Dashboard
Excel and PowerPoint
Reporting
SAP Inplace

Diagram types and tutorials

Create a range of excel charts in simple steps, including charts that meet the IBCS requirements, if needed. Take a look at the different types of charts and see for yourself how simple it is to create clear reports with Sparks. In the tutorial and explanatory videos on our YouTube channel, we present them to you step by step.

Reporting for Everyone

From standard charts to dynamic reports – our Sparks Excel add-in not only makes your work easier when creating reports but also takes your charts to a whole new level.

Use our IBCS templates to create professional business charts (waterfall diagrams, deviations, growth charts, etc.) in a matter of seconds, or create your own Excel graphics in your corporate design.

Still a little unsure whether the Sparks Excel add-in is the right tool for you and your company? Not a problem – you can try out our reporting tool at any time for 60 days without paying a thing. Or perhaps you have further questions? If so, don’t hesitate to contact us. We will be happy to help.

Test now

Prices

Below is an overview of the prices for different users and application areas. We offer a free full version to students, school pupils and trainees for private use.

Convinced? Then please send us a message. We will then prepare an offer tailored to your needs for the purchase of a Sparks license.

FREE

  • For students, pupils, trainees
  • Private use only
  • 24-month term
  • Free full version
Registration

Premium

  • For individuals and self-employed
  • 12-month term
  • €240/year*
  • Incl. maintenance and support
Request now

Corporate

  • For companies
  • Unlimited term
  • From €475/user*
  • Plus maintenance and support
Request now
*plus value-added tax

Payment Methods:

The following credit card payment methods are available in our web shop.

System Requirements:

  • Windows 7 or higher (32 or 64 bit)
  • Excel 2007 or higher (32 bit)

References


Contact

Youtube