Microsoft EXCEL

• Automated Reports using VBA/Macro
• VBA automates reporting processes and builds reports based on business needs:

1. to find the data files
2. to choose the right engines for calculation
3. to export the report data to excel files
4. to build charts using macro
5. to format the reports
6. to save the reports to target folders

** Integrating Excel Macro with Task Scheduler can achieve a fully automated reporting process.

Requirements

• Microsoft Office or 365