loading......

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for MIS Training with Advanced Excel,VBA Macro,Access and SQL

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Sky World Tuition Bureau

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

course photo

MIS Training with Advanced Excel,VBA Macro,Access and SQL

Online Instructor led Course

Platform: Skype, WizIQ Virtual Classroom Plateform

10,500

No Reviews Yet
16 Interested

About the Course


This course help to the beginners and professional as well to enhance their technical skills to create MIS reports at corporate level.

Important Point :

Classes will be conducted on Regular Basis and Weekend Basis(SAT & SUN)

Batch timing is:ON Regular Basis
(2 Hour Session 4 days in Weak)

Morning Batch- 7 AM to 9 AM AND 8 AM to 10 AM
Evening Batch- 7 PM to 9 PM AND 8 PM to 10 PM

Weekend Class Time SAT & SUN
(4 Hour Session)

Morning Batch 11 AM to 2 PM AND 2 PM to 5 PM
Evening Batch 3 PM to 6 PM AND 6 PM to 9 PM

Weekend Batch will be started :
From : 17th November 2013

Class Duration :40 days on Regular Basis
27 Days on Weekend Basis

Student can choose batch Time according to their time convenience.





Topics Covered

Module 1&2 Basic and Advanced Excel

Overview of basic Excel skills
Basic Short Keys
Worksheet Operations
Cell Operation
Format Cells
Freeze Panes
Techniques of Paste Special
Protect Worksheets & Workbooks

Time Saving Utilities
Format Painter
Text to Columns with fixed and delimited parameters
Data Sorting using custom list
Summarizing data using Auto Outline

Concept of Cell Referencing
Relative Referencing
Absolute Referencing
Mixed Referencing

Important Functions in Excel

AND
OR
NOT
COUNT
COUNTA
COUNTBLANK
COUNTIF
MAX
MIN
UPPER
LOWER
PROPER
RIGHT
LEFT
MID
POWER
SUM
SUMIF
AVERAGE
EXACT
CONCATENATE
LEN
NETWORKDAYS
IS FUNCTIONS
MATCH
IF
VLOOKUP
HLOOKUP
SUBTOTAL
SUMPRODUCT
NESTED FUNCTIONS

Name Manager
Defining List using names
Use of Names in Advance Reports

Conditional Formatting
Conditional Formatting using Formulas & cell values
Highlighting Duplicates
Calculation based Conditional Formatting

Data Validation
Different Data validation in Excel
Using list in validation

Charts in Excel
Elements of Charts
Major charts used in Excel

Pivot Table
Pivot Table creating Methods
Rearranging a Pivot Table
Filtering Pivot Table Data
Performing Custom Calculation
Creating Dynamic Dashboards using pivot charts and Slicer
Consolidating Data from external source or multiple files in less than a minute

Array Functions for quick conditional calculations

Data Filter
Normal Data Filter
Advance Filter
Calculation based filter
Filter using wild cards

Summarizing data using Subtotal

Analyzing data with What-If Analysis
Determine unknown with Goal Seek
Analyze data with Data Table

Sparklines for Data trends

Error handling Tips and Tricks

Module 3 Visual Basic Programming & Dashboard Preparation

1. Variables, Arrays, Constants, Data Types, Modules, Functions and subroutines,

2. Decisions and Looping, Strings and Functions and Message Boxes, Operators, Debugging, Errors and the Error Function, Dialogs, Common Dialog Control, Command Bars and Buttons.

3. Excel Object Model, Object Model--Main Objects, Business tool objects.

4. Charts and Graphs, Working with Databases, API Calls, Class Modules, Pivot Tables, Ribbon

5. Converting Labels to Numbers and Numbers to Labels, Transposing a Range of Cells, Adding Formula Details into Comments, Calculating a Range, Reversing a Label, Who Created the Workbook, Evaluating a Cell, Sorting Worksheets into Alphabetical Order, Replacing Characters in a String, Timed Events, Auto-Totaling a Matrix of Numbers, Absolute and Relative Formulas, Cells Containing Formulas, Alternate Rows and Columns of the Spreadsheet, Changing a Range of Values, Cells by Reference to a Master Cell, Hidden Sheets Without a Password.

6. VBA Automation Programme: Data distribution ,Data consolidate ,Outlook connectivity program ,User from programs ,data base connectivity with access ,Data insert program ,Data fetch program, Workbook Consolidation Programme, Report Automation, Sample of Productivity Report, Sample of Break Schedule & Time Report, Absenteeism , Shrinkage Report, Sample of Sales Dashboard, Sample of KPI Dashboard & many more as per student requirement.


Module 4 MS Access

Table, Query, Form, Report, Primary Key, Foreign Key, inked tables, Relationships , Calculated fields, Input mask, Importing Data, Exporting Data , Connectivity with Excel to Access, Access To Excel, Access to Word.

Module 5 SQL (Structured Query Language)

What is SQL, Clauses, tables, views, trigger, cursor, query, procedure, all join, functions(aggregate functions, date & time functions, mathematical functions, string functions etc) and DDL commands (create, alter, drop, truncate), DML commands (select, insert, update, delete), DCL commands (grant, revoke), DTL commands (commit, rollback) many more as per student requirement.

Who should attend

Anyone who wish to make career in data analysis and MIS, Finance Professionals, Students from B.Com / Commercial Background, Administration Section, MIS Personals, VBA Programmer, Accounts Personal, Project Managers, Developers, Technical/ Test Leads, Program Managers, Project Managers, Research Workers, Freelancers, Data analysis departments

Pre-requisites

Basic knowledge of Computer.

What you need to bring

Notepad and pen

Add On Benefits:-

• Free Study Material
• Free All Training Classes Video
• Session as per your request
• Life Time Support By Trainer

Key Takeaways

Become expert to create MIS Report within a minute.
Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask

Showing 1 to 3 of 3
A

Agha 26/10/2015

Hello dear

My name is Agha from Delhi, I need to know the fee of this course
and when I can join the the class?

Please let me know asap.

0 0

Answer

You can add upto 6 Images

M

M 13/10/2014

Hi, I am Arsalan. I want to join MIS class as soon as possible
Please suggest how I will join it.

0 0

Answer

You can add upto 6 Images

U

GURMEET VERMA 07/04/2014

HI,,,!! my name is gurmeet and i am working in database company as a mis executive so i want to increse my knowledge.. so that i want to join that course....
please contact me as soon as..

0 0

Answer

You can add upto 6 Images


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

About the Trainer

Skyworld Tuition

CA Corporate Professionals


We worked with high qualified 7-15 years experienced professionals who provide real time industry exposure in the fields of Accounts & Taxation.Top MNCs professional worked with us as part time tutor.
Seats Left-

Students Interested 16

Course Id: 13095