Advanced Excel VBA Dashboard

MIS Professionals :Advance Excel, VBA/Macro & Dashboard

Hello Friends,
I hope your doining well.....!!

We are providing a training specially for MIS professionals also for who want to build career in MIS.

Below is the course details, duration time and fee, it will help you to understand training.

MIS Professional Course:
1.Basic to Advanced Excel.
(Formula, functions & Nested function)
2.Excel Dashboard (Interactive & Dynamic)
3.Macro/VBA(Report Automation)

Course Details:
Structurize the unstructured data.
Creating and Formating Table.
Understanding basic features in MS Excel.
All excel formula & Function.
Text function.
Excel Array formulas.
Date and time function.
Mathematical function.
Database function.
Lookup and reference.
Advanced Vlookup, Vlookup, index-Match, ifvlookup, ifhlookup with 2 & 3 Dimension & reverse Vlookup.
Logical function.
Error handling..
If & Nested if.
How to create and develop Nested functions tips and tricks.
Text to column.
Data analysis tool.
Advanced Data Sorting,Filter and advanced filter.
Conditional formatting & Customise (basic to advanced using formula).
Advanced Data validation with Customise ( using formulas.)
Advanced Pivot table, pivot chart and Slicer tips and tricks.
Know the power pivot table.
Charts and graphs (all elements of charts & properties settings)
Uses of charts(how to use chart -which, where,when & how etc)
Name managers -(using in formula)

Macro and Report Automation:-
Macro/VBA:

Introduction of macro/VBA.
Developer Tab,VBA project Explorer,propery window,imediate windows,brake point, object browser.
Macro Recording, Editing ,assigning and Developing macro skill .
Concept of using Object,Method,property & Members.
Working with Message box and input box.
Working with Cell and range object.
Worksheet and workbook object.
Declaration of Variables.
Passing multiple variables.
Data Types
Loops:
For loop..next
For Each Loop...next
Do while Loop..
Nested loop examples
Loop through data consolidation.
Decision Making with on conditional base.
Comparative operators.
Logical operator ,
If ....end if.
If....else ...end if.
If ... ifelse.....end if.
Select Case..
VBA Array
Creating chart object using vba code.
User forms.
Sub Routing and Functions
Debugging and Error handling

With more examples:
Find last row concept.
Copy paste data weethin sheet.
Get data from another worksheet.
Get data from another workbooks.
Transfer data from one workbook to another workbook.
Consolidation data:
Witheen workbook sheets data.
For each workbook data.
Summarized data.
Create sheet, workbook, rename, save as, open and close by etc examples.
Create,delete, folder on path.
VBA Projects etc and many more...

Excel Dashboard Course:
Advanced chatting technique.
Interactive & Dynamic chart , developing Data visulazation skill
Working with all Charts and Graphs(all elements of chart)
Creation of graph and dashboard without using chart.( Chart less chart techniques)
Advanced excel charting techniques.
Developing data visulazation skill using form controls interactive way:
List box.
Option buttons.
Check box.
Combo box.
Spin button.
Scroll buttons and many more.
Developing Data visulazation and analytical orientation Techniques.
Dashboards design, developing,data modeling tips and tricks.
Speedometer chart
Thermometer chart
Dashboard examples:-
Operational dashboard.
Performance Dashboards
Sales dashboard.
Financial dashboard.
Analytical dashboard.

Pareto analysis diagram
Gant chart .
Project management.
And many more examples of dashboards.

Why with us:
Key features of Training:-
Affordable Fee.
Class room training.
Standard course materials.
Totally practically training provided.
Conceptual understanding of Advanced Excel features.
Developing logical & Analytical excel skills.
We build strong excel logic.
Using easy techniques for customizing & manipulate data.
Creating logic for customise data and Nested function tips & tricks.
Experienced trainer and expert in MS Excel.
Logicaly teaching training with more examples.
Techniques of devlopung report and Automation.
Developing data visulazation & Analytical orientation skills.
Assignments and solving most problems with excel test series.
Professional Mis report automation- live projects.

About Trainer:
Expert in MS Excel.
Result oriented training.
Overall 9+ Years Industrial work experience in ms Excel (KPO,BPO, Telecom & Manufacturung ) .

Course fees:
Total MIS(1+2+3)= 10000/-(offer fee)
1) Basic to Advanced Excel: 7000/-
2) Macro/ VBA : 7000/-
2) Excel Dashboard : 3000/-

Course Duration:
1) 80hrs - 3 Month
Time: Sat and Sunday-10:00am To 2:00pm

Next Batch Starting:

Limited seats available please book your seat.

Contact : Mob no : 9921673395 /
Watsup no: 9921673395
Email ID: [email protected]
Location: Hadapsar-411028
Address : Bankar Coloney, Satavwadi,near Tulashi sweet Home corner.
Landmark: Gondhale Nagar ,Hadapsar.

Please feel free to ask if require more information.

Note 100% MIS job assistance for students.

Requesting you to please Forword your friends.

Thanks & Regards,
Balaji Mehtre
Consiatancy is key of success...!!