Spreadsheet Automation

Spotlight on Distribution Manager: For All!

Authored by Sarah Mack, TeamCain

You may have noticed that we’ve been posting videos to our blog from our friends at Global Software. We’ve already spotlighted Spreadsheet Server for PeopleSoft as well as Spreadsheet Server for JD Edwards. Today’s video is a little different because Distribution Manager, a feature of Spreadsheet Server that uses Excel automation to distribute and publish reports, is for any ERP.

Building JDE Reports in Spreadsheet Server (A Video)

Authored by Sarah Mack, TeamCain

"Our estimate was it averaged $2 - $5K per report to have them developed by our IT staff using ERW – and we had 500 reports to create. The payback was immense, and the time savings were dramatic."

Check out this video below from our partners at Global Software to see how you can quickly and easily build a report from scratch in Excel and have it automatically update with live and dynamic JD Edwards data!

I Didn’t Know I Could Do That! Five Excel Tips & Techniques

Authored by Alana Smith, TeamCain

Steve Adair, a Microsoft® Excel Expert from our partner, Global Software, made it look so easy. By “it” I mean using simple techniques to make working in Excel a lot easier. I sat in on a webinar that he presented with TeamCain, where he showed five simple techniques to those who use Excel on a daily basis. As I was sitting there taking my notes all I could think about was “I can do that? I can use my curser like that for fast data entry?