This Excel training is to help everyone to learn, develop and to get exposure to their MS-Excel knowledge. It will help you to get knowledge on various world class examples. This training is based on the practical experience and not just an explanatory course. This aim of this training is to make users expert in excel.

Topics Covered

1. What is VBA 2. How to launch VBA 3. What all you could do with VBA 4. Who can use VBA 5. Different types of Variables 6. Procedures & Objects 7. About Functions 8. Input Values 9. Formatting Data 10. Formatting a Table & its Data 11. How to Display a Message Box 12. Displaying Message Box with Symbol 13. Displaying Message Box with a Heading 14. IF Conditions 15. Nested IF 16. IF AND 17. IF OR 18. Do While 19. For Loop – Very Important 20. Nested For loop 21. Introduction of Select Case statement 22. Use of Select Case 23. How to Save Macros 24. How to Reuse of Macros 25. How to Create an Excel Sheet 26. How to Navigate to an Excel Sheet 27. How to Input Data on a New Sheet 28. How to Copy Data from one Sheet to Another 29. How to Delete an Excel Sheet 30. How to Create an Excel File 31. How to Open an Excel File 32. How to Input Data on a New File 33. How to Copy Data from an Opened File 34. How to Save a Workbook 35. How to Close an Opened Excel Workbook 36. Understand the Data Structure 37. Consolidate Data 38. Sort Data by Ascending 39. Sort Data by Descending Order 40. Sort Data through a Combination of Two or Multiple Columns 41. Select & Deleting Only Blank Cells 42. Auto Filter Object 43. Custom Filter 44. Understanding of Pivot Tables 45. How to Create & Use Pivot Tables through VBA 46. How to Refresh an Existing Pivot Tables 47. How to Filter in a Pivot Table 48. What is a User Form? 49. Various Types of Control Forms 50. Adding Controls to the User Form 51. How to Create a Simple Application Using User Form 52. How to play around with the Imported Data 53. How to Hide & Unhide Excel Sheets 54. How to do Hide Excel Sheets and to restrict not to unhide it 55. Customizing Quick Access Toolbar 56. Homework:Home Work given to Trainees to Explore the Topics and learn it effectively 57. VBA project: How to Create Individual Trackers and Consolidate the Data in a Single File

Who should attend

Who has passion towards learning Excel Macros and Interested to automate the process/task through Excel VBA

Pre-requisites

Knowledge of Excel & Advanced Excel

What you need to bring

As this is an online training, require an internet access and will contact for further details once interested"

Key Takeaways

At the end of the class students will be able to write Excel formulas through macros and can work on excel automation projects as well.