Standard Process/Reports Automation
- We probably already acutely aware that the hours you (and others in your organization) spend on reporting tasks are a drag on productivity and a source of stress.
- Organizations are often weighed down by the complexities of reporting, which either causes them to abandon the effort altogether or forces them into a permanent state of inefficiency.
Multiple Excel files Consolidation
- To summarize and report results from separate worksheets, you can consolidate data from each sheets into a master worksheet. The sheets can be in the same workbook as the master worksheet, or in other workbooks.
- When you consolidate data, you assemble data so that you can more easily update and aggregate as necessary.
Multiple Excel files Segregation
- Excel macro to split data into multiple files. It will be helpful for you if you need to split data from a large dataset into multiple workbooks
- Example branch level Segregation file allow to branch user to view the Brach level data only instead of overall country data.
Mail Merge - Multiple Word files Generate
- Mail merge primarily automates the process of sending bulk mail to customers, subscribers or general individuals.
- Mail merge works with two documents, the data file and the letter template. The data file includes the information of the recipients to whom the letter is to be sent.
Data Extraction from Portal
- The data extraction utility extracts data from the SAP applications you specify, and creates sequential files containing transaction and master data from these applications.
- Future default settings allow you to select data for extraction from several SAP components
Access Database
- Macros is an MS Access feature which allows users to automate tasks while adding functionalities in their reports, forms, and controls. Access’s Macros work a little differently from Word and Excel; yet are equally powerful.
- Access Macros is built with a set of default predefined actions, which offer automating tasks and an option to add functionality in objects and controls.
- Macros can also act as standalone objects which can be embedded directly in a Report or a form or can be viewed from Navigation Pane.
- Once the user has created database objects like forms, reports, and tables, Macros can offer an easy and quick way to tie these objects together and create a database application which can be accessed and modified by anyone, with just basic relativity training.
