Amazon References

Thursday, December 1, 2016

New: Merge Excel Spreadsheets on the Fly

Do you spend countless hours day after day, month after month, putting together the same spreadsheets for reporting, projections, proposals, and more - with only a little bit of the information changing?  We can help!  We’re excited to announce that we have just launched support for Microsoft Excel spreadsheets!  You can easily generate spreadsheets that use calculations, charts, and pictures.  You can even export them to a PDF.

Below we’re going to show you how to setup a quick spreadsheet that is a proposal for customer acquisition that would be sent to a prospective client.  To start, we’re going to put in a little information about the customer, then we will enter some basic calculation parameters (current customers, growth rate, etc) and then our spreadsheet will calculate growth over the next year and even provide us with a nice chart at the bottom.


Once we’ve got our spreadsheet all setup, we going to do a quick test and make sure everything is working correctly.  We’ll just enter some basic information that is easy to double check the calculations.


As you can see, we’ve exported the spreadsheet to a PDF so that it is clean and professional looking when we send it off to our prospective client.  As you can see, the values in our calculations automatically calculated and the graph was updated accordingly.

Doesn’t get much easier than that, does it?  We’re looking forward to seeing how you can use WebMerge to automate your excel spreadsheets.  What are a few ways that you can take advantage of this new feature?


No comments:

Post a Comment