Professional & Advanced Excel Training
|
|
|||||
About the Trainer |
Who should Attend |
|
||||
With over 17yr experience, the trainer has provided not only VBA Automation training sessions but also smart automation solutions using Excel and Macros, to some of the top companies including Fortune 500.
Also, trained many including excel trainers, practicing as trainers today. Certified Lean, Kaizen Professional and an ethical hacker.
|
All Working Professionals, Job Seekers for better Jobs, People Seeking Jobs Abroad, Student working on Projects, Fresh Graduates/Post Graduates. Entrepreneurs, Professionals, Govt. Officials and all with Excel use. |
|
||||
Key Takeaways |
|
|||||
n 3 ways of doing PICTURE Lookup and 8 ways of doing VLOOKUP n Merge Excel files without using Macros n Collate 500 CSV files in less than a minute without macros n Overlooked Basics and Excel Hacks n Key Board Shortcuts in Depth, Creating your own Shortcuts n Key Excel Functions in depth including Hidden Functions n Using MSQRY32, Advanced Filter, Database Functions, Filtering Wildcards n Create Graphs & Report with Dropdown, Scroll bar, Check-Box n Professional Dashboard Report Design with Multi Sheet Data n Using Excel Analytical tools: Goal Seek, Solver, Data Tables, Scenarios, Simulation & Excel Tables n Creating Dynamic Named Ranges that will auto update on changes and related functions n Hyperlinks in depth including to Applications and Hyperlink Function Magic n Conditional Format in Depth including using Formula and Hacks n Data Validation with Formula & Auto update on change of Lists n Protection Techniques Cell, Range, Sheet, Workbook File n Design Excel Templates and how they save your time n Playing with Pivot Tables & Charts, Slicers, Timelines, Spark lines n In Depth into Pivot Reports and Charts, Report Filter Pages, Auto Refresh Pivot n Time Saving Tips, Tricks and Techniques n Import & Collate Data in Seconds including use Share & Merge Workbooks n Print Settings and Multi Window for sheet display n Advanced Features and Powerful Functions in Excel and many more Hidden Tricks and Techniques n Using Excel File as a Database to do Mail Merge from MS word Application n Advanced, Complex, Multiple, Nested and Lengthy Excel Functions including Database Functions
|
|
|||||
Enroll Online |
|
Call/SMS |
|
|||
|
|
+91-8939-207070 |
|
|||
|
||||||
VBA & Macro
Professional Training
|
||||||
About the Trainer |
Who should Attend |
|||||
With over 17yr experience, the trainer has provided not only VBA Automation training sessions but also smart automation solutions using Excel and Macros, to some of the top companies including Fortune 500.
Trained many professionals including excel trainers. Certified Lean, Kaizen Professional and an ethical hacker.
|
Pre-requisite: Knowledge of Advanced
Excel All Working Professionals, Job Seekers for
better Career, Students working on Projects, Fresh Graduates/Post Graduates,
Professionals with Prior Knowledge of Excel. (Right of admission reserved for
this Program) |
|||||
Key Takeaways |
||||||
n Learn how to create an Excel Macro to Take your Picture through WebCam on click of a commandbutton n Learn how to create an MP3 Player, Task Manager, Windows Search tool with Plain Excel Macros n Learn How to Program Excel to Speak with Human Voice n Basics of Visual Basic Language, Objects, Methods, Properties, Data Types, Loops, IF, ActiveX, Forms n Create Sub Routine, Functions, Forms, Class Modules, Save Time through Recording the Macros n Use Excel to Send Multiple emails with Different attachments n Develop Productivity Monitoring tools with Excel that will Capture Login, Logout, Break Time n Run Programs at a Pre-defined Date & time, Create a Reminder tool with Excel n On a Click of Button Collate Data from multiple Excel/Text/CSV/HTML Files or Excel Sheets n Automate Report Generation, Save Reports to a Designated Folder/Email reports n Run Web Browser, Open a Web Site, Download Report, Run in Hidden Mode all using Excel n Design Templates to Capture Date & Time on Click of Mouse for Productivity/Time Study n Allocate Unique ID to emails on arrival in Inbox and Track Replies, Find the ones not replied n Use MS Word file as output Template with Excel database and email word reports n Use Excel file as a Database Front & Back end WITH/WITHOUT USING SQL/ADO/OLAP n Show Message Box for 10 Seconds and turn it off if not responded by User in 10 to 30 seconds n Make Excel to Speak out Warnings/Messages with Human Voice/Type slowly on the Screen n Play Audio & Video Files Through Excel, Create File Explorer and Windows Search tool n Automatic Data Entry from Excel to EXE Application/Excel to Website/Browser Window n Learn how and When to Create a Class Modules, Creating Distributable Excel Add-ins n Simple Encryption & Decryption for with VBA n Display a Warning when Macros are Disabled and make users Enable Macros n Much More Technical Tips & Techniques on Excel, Windows OS required by an Excel Professional
|
||||||
Enroll Online |
|
Call/SMS |
||||
|
|
+91-8939-207070 |
||||