Advance Excel, VBA, Macros, MIS & Data Analytics
Training by
Asiawebmedia Management
Inquire Now
On-Site
/ Training
Details
Module 1: Level (Basic)
Module 2:
Module 3:
Module 4: Level (Intermediate)
Module 5: Level (Advanced)
Duration & Fees
- Basic& Advanced Excel- Conditional Formatting, Validation, Pivot Table, Chart, Advance Filtering, Smart Art, Themes, Formula Auditing, Extraction data from Different Sources, Web Queries, Goal Seek, Solver, Table, Connections, Protection on different level etc.
Module 2:
- Dash Board &Power Point – Key Performance Indicators (KPI), Customer Service and Project Management Dashboards, Charts and Graphs, Making Professional Presentation through Power Point etc.
Module 3:
- MS-Access -Introduction to Access, Creating Tables and Adding Records, Designing Table Structures, Working with Data, Forms, Basic Queries, Basic Reports etc.
Module 4: Level (Intermediate)
- VBA/SQL(Basic) – VBA -Macro, Recording Macro, Recording Macro R1C1 Style, Variable, Object Model, If Statement, String and Conversion Functions, Loop, Nested Loops, User form etc.SQL ( Basic) – Introduction to Database, Basic queries, Select Command, Single Row Functions, Group Functions
Module 5: Level (Advanced)
- SAS/Power BI/R Programmimg/Tableu
Duration & Fees
- Level (Basic) Module 1 to 3
Course Duration – 2 Months, Fees –(Payable in easy instalments), Classes of 3 hr. duration on Sundays. - Level (Intermediate) Module 4
Course Duration – 2 Months, Fees –(Payable in easy instalments), Classes of 3 hr. duration on Sundays. - Level (Advanced) Module 5
Course Duration – 2 Months, Fees –(Payable in easy instalments), Classes of 3 hr. duration on Sundays. -
Fast Track Course – 1 Week( 6 Hours daily)
- Fees – Payment in easy Instalments (for fees, please contact concerned Centre)
- Placement – Our past students have exceled in their career and freshershave got lucrative jobs after undergoing training.We have arrangements of placement with companies but do not give 100% guarantee.
Reviews
Be the first to write a review about this course.
Write a Review
Dear All,
HR PROFESIONALS!!!!!!!
We Provide 100% Practical HR Training on
HR GENERALIST, PAYROLL, CORE HR, LABOUR LAWES, RECRUITEMENT, ADVANCE EXCEL, We have a Group of Highly experienced professional, We share our experiences in the HR department from manager level , what we had experience in the industry. For example for a candidates to remember about the HR. on any topics like, Client Management, Employee Relation, Payroll Processing(on Advance excel ,payroll software), regarding Labor Laws, MIS Reports, Attrition, Retention,recruitement,joining formalities,PF,ESI..ETC…
We provide 100% practical JOB ORIENTED Training on Job Portals (TIMESJOBS.COM, NAUKRI.COM, and MONSTER.COM) & Payroll Software...
• TIME DURATION-30 DAYS
• MONDAY-THRUSDAY(5 DAYS IN A WEEK)
• FOR WORKING PROFESSIONAL-ONLY SUNDAY(10 SUNDAYs)
• WE WILL GIVE YOU ALL STUDEY MATERIAL ON HARD COPY AS WELL AS SOFT COPY ALSO
• WE WILL GIVE YOU ALL PAYROLL SOFTWARE ON A C.D.
Thanks & Regards-
HR PROFESIONALS!!!!!!!
We Provide 100% Practical HR Training on
HR GENERALIST, PAYROLL, CORE HR, LABOUR LAWES, RECRUITEMENT, ADVANCE EXCEL, We have a Group of Highly experienced professional, We share our experiences in the HR department from manager level , what we had experience in the industry. For example for a candidates to remember about the HR. on any topics like, Client Management, Employee Relation, Payroll Processing(on Advance excel ,payroll software), regarding Labor Laws, MIS Reports, Attrition, Retention,recruitement,joining formalities,PF,ESI..ETC…
We provide 100% practical JOB ORIENTED Training on Job Portals (TIMESJOBS.COM, NAUKRI.COM, and MONSTER.COM) & Payroll Software...
• TIME DURATION-30 DAYS
• MONDAY-THRUSDAY(5 DAYS IN A WEEK)
• FOR WORKING PROFESSIONAL-ONLY SUNDAY(10 SUNDAYs)
• WE WILL GIVE YOU ALL STUDEY MATERIAL ON HARD COPY AS WELL AS SOFT COPY ALSO
• WE WILL GIVE YOU ALL PAYROLL SOFTWARE ON A C.D.
Thanks & Regards-