Having more than 17 years of experience in providing Excel VBA/Macro Training and Office Project Automation Services. Type of Training: Class Room Training and Online Training Session & Fees: 2 days @ Rs: 2500 per day. Only 5 seats. Attractive discount for early registration.

Topics Covered

Learn Excel VBA/Macro with Robotics. Learn how to create an Excel Macro to Take your Picture through WebCam on click of a commandbutton Learn how to create an MP3 Player, Task Manager, Windows Search tool with Plain Excel Macros Learn How to Program Excel to Speak with Human Voice Basics of Visual Basic Language, Objects, Methods, Properties, Data Types, Loops, IF, ActiveX, Forms Create Sub Routine, Functions, Forms, Class Modules, Save Time through Recording the Macros Use Excel to Send Multiple emails with Different attachments Develop Productivity Monitoring tools with Excel that will Capture Login, Logout, Break Time Run Programs at a Pre-defined Date & time, Create a Reminder tool with Excel On a Click of Button Collate Data from multiple Excel/Text/CSV/HTML Files or Excel Sheets Automate Report Generation, Save Reports to a Designated Folder/Email reports Run Web Browser, Open a Web Site, Download Report, Run in Hidden Mode all using Excel Design Templates to Capture Date & Time on Click of Mouse for Productivity/Time Study Allocate Unique ID to emails on arrival in Inbox and Track Replies, Find the ones not replied Use MS Word file as output Template with Excel database and email word reports Use Excel file as a Database Front & Back end WITH/WITHOUT USING SQL/ADO/OLAP Show Message Box for 10 Seconds and turn it off if not responded by User in 10 to 30 seconds Make Excel to Speak out Warnings/Messages with Human Voice/Type slowly on the Screen Play Audio & Video Files Through Excel, Create File Explorer and Windows Search tool Automatic Data Entry from Excel to EXE Application/Excel to Website/Browser Window Learn how and When to Create a Class Modules, Creating Distributable Excel Add-ins Simple Encryption & Decryption for with VBA Display a Warning when Macros are Disabled and make users Enable Macros Much More Technical Tips & Techniques on Excel, Windows OS required by an Excel Professional

Who should attend

Students, Working Professionals, Entrepreneurs, IT Professionals, BPO & ITES Employees.

Pre-requisites

Excel Knowledge is must.

What you need to bring

Laptop + Pen Drive Desired only

Key Takeaways

Extreme Excel Tricks and Techniques, Excel with Robotics, Develop Small Application Tools, Work as Freelancer, Small Projects