Excel VBA Macros Learning | contact 9087888846
EXCEL VBA MACROS / SQL / Power BI TRAINING
▪︎ Free 1st Day of classes & Free Demo
▪︎ 5 - Live Projects
▪︎ 100+ Live Examples
▪︎ Certification
▪︎ End to End Codes will be given
About Trainer,
I am a direct Trainer working as an Automation Engineer in IT Firm, having 10+ years of experience in Automation can take End to End Training with your Project Support
Basics
• Introduction of VBA Macros
• Excel Shortcut. Keys
• Excel Formulas (Business Case)
• Recordings Macro
• Working with VBA Editor
• VBA Programming Concept
• VBA Syntax and Semantics
• Variable Type, Declaration and Array Concepts
• Decisions Making with Operators
• Repeating Actions with a Loops
• Procedures and Events
• Building Intuitive User Interface
• Objects and collections
• Functions
• User Forms and GUI
• Sort and Filter, Pivot Tables and Pivot charts with VBA Macros
Advance
• ODBC Connectivity to SQL Database and Query Handling
• Files and Folder Handling (FSO Method)
• Interacting with other MS - Office applications (word, PowerPoint and MSAcess)
• Interacting with Outlook Applications
• Running the SQL Queries within Excel Environment
• Interacting with Internet Explorer
• Interacting with Client Application
• Interacting with SAP Environment by Excel
• Interacting with MAINFRAME by Excel
• Send keys
SQL
Basics of Query
Queries Building
Interacting with DB with Queries
Power BI
Installing
Basics of Power BI
Importing Data’s with different source
Data Manipulation
Data visualisation
DAX query
Deployment in Different Phases
Maintenance
Automation's with
• Excel to Excel
• Excel to MS Office Applications (Excel, outlook, Access, word, notepad. Etc.)
• Excel to Database by using SQL
• Excel to Mainframe
• Excel to SAP
• Excel to Client Application (All kind of applications by identifying API)
Opportunities in Market
• Automation Engineer
• Vba Developer
• All BPO's and Back end process Automation
• MIS Executive (End to End Control)
Training Covers
• Training
• Training Material's
• Complete Code's for all Scenarios
• Project Assistance
• Interview Questions
• Placement Assistance
Thanks
Next Level Technologies
Call or WhatsApp @ +91 9087888846
Chennai