Thursday, April 28, 2011

Combine all your business data

One of the best functionalities of Excel is the possibility to import external data. For this, you have standards menus (for a limit of sources types) or, my best choice, the opportunity to create some macros, VBA code, to get data as I want and from where I want. At this moment I am able to create several macros to get data from the sources mentioned in the picture below:
Combining several data sources as I want will give me the opportunity to create only one excel file/report with the most important information that I need. All in one!

Take the opportunity to explore more this functionality and get great results for your management report.

No comments:

Post a Comment