Advanced Excel in Corporate World
MS Excel spread sheet is very common these days. In any MIS environment standard reports are generated by advanced function of MS Excel , for comparing actual performance with original budget, hence user can learn the MIS drafting and analyzing by joining MIS training which mainly deals with advanced MS Excel and its applicability, during the MIS training our focus remains on the following area:-
1. Various MIS technique in Advanced Excel VBA Programming
2. Data handling in MIS Reports
3. Reporting and Formatting
4. Fundamentals of data handling, MIS, EXCEL
MIS – Management Information System experts are required for every sector of the economy as well for every industry, there are various reports and information’s that Management of an organization looks for, managers are required to prepare those reports using various functions and formulas available in MS excel spreadsheets however many times managers do feel lack of knowledge and understanding how to use advanced excel commands. Most of the topics mentioned are covered under advanced excel course has however excel has huge potential and the learning process is limitless and it takes years of practice to have full fledge mastering on the subject. This MIS Course fulfill this gap by offering quality training.
What are user’s Defined Functions? How to create & use them. Form Controls vs. ActiveX Controls Getting into the Code MsgBox and Input Box Working with Data in Excel.
Data types in excel worksheets, like dates, texts, and nulls etc. Working with workbooks, worksheets, ranges and cells etc.
Working with dynamic ranges. Protecting worksheets, cells and ranges. Working with multiple files.
Opening & saving files introduction to user forms
Working with user forms & user forms events
User form controls
How to use data validation in the control
Use of text box, label, drop down, list box, image box
What is the use of message box in VBA
Searching data into to the database and finding records from the database
Connecting VBA to outlook
Sending email to multiple users through VBA
How to establish connection between VBA and internet explorer to open any internet website through VBA
Data validation & input restrictions effective coding
Testing and debugging your code
Effective error handling
Automation development report& live project