Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

"MIS Training with Advanced Excel,VBA Macro,Access and SQL" is no longer available

No Reviews Yet

Course type: Online Instructor led Course

Platform: Skype, WizIQ Virtual Classroom Plateform

Course ID: 13095

Course type: Online Instructor led Course

Platform: Skype, WizIQ Virtual Classroom Plateform

Skyworld Tuition picture
Skyworld Tuition
No Reviews Yet

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.

Date and Time

Not decided yet.

About the Trainer

Skyworld Tuition picture

Avg Rating

Reviews

Students

Courses

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.

Reviews

No reviews currently
Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more