Low Cost Automation

Tactical Automation is low cost approach for business units that helps to ease manual efforts by automating the process steps with the help of Office applications like MS-Excel, MS-Access, SQL Server, Web automation. Lets start with VBA/Macros automation process used in most of business hubs.

Visual Basics for Application (VBA)/Macro - is widely used in most of business units to manipulate the mid-size of data on day to day basis. Excel/Access applications are used to hold the data.

MS Excel is an electronic spreadsheet widely used to store information in tabular form and perform mathematical calculations. Large amount of data is saved in a single spreadsheet and used to manipulate in required format. Excel consists of Columns and Rows. Learning Advance Excel helps us to carry out tasks like Complex calculations, presentation, arranging the data is correct format, Create Graphs. Excel allows user to manipulate data in meaningful information:

· Perform Mathematical Calculations from simple to complex.

· Design Dashboard presentation.

· Maintain large amount of data in tabular fashion.

· Excel helps user to perform task by using its in-built function.

· Create Graphs and presentation.

· Automate task by writing programs in simple language VB.

· Import data from other database application and export to other applications.

Excel has its own functions that helps user to get the desired result, knowing Advance Excel does not require and specific qualification. Learning the usage of functions, applying logic helps to handle data.

To summarize any one can work on excel and handle data. This version is designed for Advance Excel learners, having basic knowledge of excel we can learn advance features of excel very easily.

Apart from above bullet points we will learn:

¨ Customizing data.

¨ Referencing cell range.

¨ Data Validation

¨ Advance formulas and functions.