Web Training – The power of Excel – copying information between Excel and SAP Business One, importing data with Excel and using Excel as a reporting tool

In this workshop, we will show you how you can use your favorite Microsoft Excel with SAP Business One;

  • How to copy and paste to/from Excel to your SAP Business One application (e.g. Excel to Sales Quotation).
  • How to import data using Import from Excel utility (e.g. import GL Journals, Business Partner master, stock master files).
  • Microsoft Excel as a reporting tool in SQL version
    • Pivot reports and graphs using Excel’s Data feature.
  • Microsoft Excel as a reporting tool in HANA version
    • Formatted Excel Reports (e.g. Sales Analysis by customer/Item/Sales Employee).
    • Interactive Pivot Analysis. 

Target audience: Finance Manager, Key Finance Users, Key Operations Users, SAP IT Support

*** Please note that this event is open to Inecom customers only. ***

SAP Business One Web Training Schedule