About the Course
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 CoveredLearn 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 attendStudents, Working Professionals, Entrepreneurs, IT Professionals, BPO & ITES Employees.
Pre-requisitesExcel Knowledge is must.
What you need to bringLaptop + Pen Drive Desired only
Key TakeawaysExtreme Excel Tricks and Techniques, Excel with Robotics, Develop Small Application Tools, Work as Freelancer, Small Projects