RIA

Best MIS Classes in Bangalore

MIS Training In Marathahalli

In recent years the Information industry has been evolving as the biggest industrial power. The information system is ever-changing and has endless promising careers to offer. Almost every sector of business and services handles massive bundles of information on day-to-day basics. However, if not used appropriately, this information does not serve the purpose. This is where MIS students come in. They sort the information to enhance business operations and set up tools to do the same. They ease the decision-making process and provide solutions according to business imperatives. 

If you are a fan of applications like Instagram then this course is for you, as it allows you to use the information to positively impact the lives of others. If you want to pursue your career as a Business Analyst, Business intelligence analyst, or database analyst then learning MIS training in Bangalore is going to be an additional asset. With extensive years of experience, you can even polish your skills to become a developer or mark your footprint in a programming career.

Best MIS Classes in Bangalore

Why choose RIA MIS Training in Bangalore

We strive to empower our candidates by providing a job-oriented course that can help them in real life. We have certified professionals who possess vast years of experience in the field of teaching. Together with them, we have created an innovative novel teaching methodology that will make you understand even the most complexities of MIS easily and quickly. Our professionals enrich your knowledge and provide a solution to all your concerns. You can also benefit from the project assistance given by these wizards. They teach you using real-life examples and actual scenarios to develop analytical thinking for our students. This will help you to enhance your competency and knowledge.  

We also prioritize your comfort, therefore aid you with flexible class hours that can opt to fit your schedules. If you are in a hurry and need to finish the course within a short period of time, then worry not, we got your back. We have Fastrack courses to aid students that need to complete the course in haste. We provide education to all freshers and professionals who wish to optimize their proficiency in MIS. There are lab facilities available for you to practice the classroom work. 

Course summary

We provide you a complete course that gives equal weightage to all essential concepts of MIS. In our MIS Training in Bangalore, we teach you Pivots tables and graphs, working on objects, hyperlinking to different sheets, etc. There will be classes on data management in Excel, sorting, filtering data, grouping, outlining, freezing, unfreezing, data validation, removing duplicate records, split texts, data consolidation, and conditional formatting. We also teach you to copy data, how to view multiple files, working on tab, advanced functions like V-Lookup, IF, Mathematical functions, and so on. In RIA MIS training in Marathahalli, there will be detailed classes on name manager, using formulas, data connection from external data like access, SQL, Web, ODBC, how to customize your excel view, Add-Ins, language settings, and finally about the various security options in excel. 



SYLLABUS

Duration-20 Hours

Pivots and Pivot Graphs:

  • Creating of Pivot Table
  • Using Summary function in Pivot Table
  • Pivot Table Calculations
  • Creating own formulas in Pivots
  • Grouping and Ungrouping in Pivot Tables
  • Creating Pivot Graph
  • Custom Filter on Pivot Table
  • Formatting Pivot table (Removing old data, grand total, subtotal …etc.)

Working on Objects:

  • Inserting Objects
  • Inserting different files into Excel (like .doc, .pdf, .txt files)
  • Hyperlinking to different sheets
  • Providing screen tips in the hyperlink
  • Hyperlink to send emails
  • Inserting symbols
  • Sending a working file to an email

Data Management in Excel - Sorting:

  • Rearranging of Data
  • Sorting by alphabets, numbers and time

Filtering Data:

  • Using Auto filter option
  • Custom Filtering with different options
  • Advanced Filtering
  • Find Unique records using advanced filtering
  • Filter using operators AND/OR
  • Filter by color

Grouping and Outlining Data

  • Group and ungroup rows and columns
  • Auto outlining the data
  • Freezing and Unfreezing

Data Validation:

  • Use Data Validation in Excel
  • Using Input Message in Data validation
  • Using error message in Data Validation

Removing duplicate records:

  • Remove duplicate records in a spread sheet
  • Customize to remove the duplicate values

Removing duplicate records:

  • Remove duplicate records in a spread sheet
  • Customize to remove the duplicate values

Split Texts:

  • Split texts to different columns
  • Remove special character from a string and split the string

Split Texts:

  • Split texts to different columns
  • Remove special character from a string and split the string

Data Consolidation:

  • Combining different spreadsheet using data consolidation
  • Using summary function in data consolidation

Conditional Formatting:

  • Use of conditional formatting
  • Custom formatting

Copy Data:

  • Use of format painter
  • Use of paste special
  • Strike through a value
  • Find and Replace

View Multiple Files:

  • Arrange multiple windows to view in one time
  • Split big sheet into sub sheets for better analysis

Working on Tab:

  • Hide/ Unhide a tab
  • Color a tab
  • Move /Copy the tab to another sheet/workbook

Advanced Functions:

  • V-Lookup
  • H-Lookup
  • IF
  • ISERROR
  • Index Match
  • Rows
  • Columns
  • Match
  • Offset
  • Get Pivot Data
  • Date and Time Functions
  • Text Functions
  • Operators
  • Mathematical functions
  • Calculation options

Name Manager:

  • Define a name to a range
  • Use of name manager
  • Using formulas in name manager
  • Editing name range

Data Connection from External Data:

  • From access
  • From SQL
  • From Web
  • From ODBC

Customize your Excel view:

  • Customize Excel view
  • Developer Option
  • Trust Centre
  • Add-Ins
  • Save directory options
  • Language Setting
  • Quick access toolbar

Security options in excel:

  • Protecting the worksheet
  • Protecting the workbooks
  • Sharing the workbook
  • Allow users to edit ranges

SYLLABUS

Duration-20 Hours

Introduction to VBA

  • WHAT IS VBA?
  • INTRODUCTION TO ANOTHER LANGUAGES
  • VBA: AN EVENT DRIVEN PROGRAMMING
  • VBA: AN OBJECT BASED PROGRAMMING
  • ADVANTAGES AND DISADVANTAGES OF VBA
  • OBJECTS, PROCEDURES AND PROPERTIES

VBA IDE

  • OPENING THE EXCEL VBA IDE
  • MENU BAR
  • TOOLBAR
  • PROJECT WINDOW
  • CODE WINDOW
  • IMMEDIATE WINDOW
  • CUSTOMIZING THE VBE

Getting Started With Macro

  • RECORDING THE MACRO
  • EXAMINING THE MACRO
  • SAVING WORKBOOKS THAT CONTAIN MACROS

Fundamentals of VBA Language

  • VARIABLE & CONSTANTS
  • KEYWORDS
  • DATA TYPES
  • PROCEDURES: SUB AND FUNCTION
  • ARGUMENTS
  • LOCAL VS GLOBAL VARIABLE DECLARATION
  • PROCEDURES: PUBLIC OR PRIVATE
  • COMMENTS

Control Flow & Loops Statements

  • RELATIONAL AND LOGICAL OPERATORS
  • IF….THEN
  • IF….THEN….ELSE
  • IF….THEN….ELSEIF….ELSE
  • SELECT CASE ( WITH TO AND WITH IS)
  • DO WHILE….LOOP
  • DOLOOP….WHILE
  • DO UNTIL….LOOP
  • DOLOOP….UNTIL
  • FOR….NEXT
  • FOR EACH….NEXT
  • WHILE….WEND
  • THE EXIT STATEMENT

Using VBA and Worksheet Functions

  • VB FUNCTIONS
  • EXCEL FUNCTIONS
  • THE WORKBOOKS COLLECTION
  • THE SHEETS COLLECTION
  • ACTIVATE AND SELECT
  • RANGE PROPERTY
  • CELLS PROPERTY
  • OffSET PROPERTY
  • RESIZE PROPERTY
  • CURRENTREGION PROPERTY
  • COLUMNS AND ROWS PROPERTIES
  • REFERENCING RANGES IN OTHER SHEETS
  • USING THE UNION AND INTERSECT METHODS
  • USING THE ISEMPTY FUNCTION
  • USING THE AREAS COLLECTION
  • TRANSFERRING VALUES BETWEEN ARRAYS AND RANGES

Working with Dialog Boxes and Form Objects:

  • USING LABELS
  • USING TEXT BOXES
  • USING THE COMMAND BUTTON CONTROL
  • USING LIST BOXES
  • USING COMBO BOXES
  • USING CHECK BOXES
  • USING RADIO BUTTONS
  • USING TOGGLE BUTTONS
  • USING FRAMES
  • USING MESSAGE BOXES
  • TAKING INPUT USING INPUT BOXES
  • TABSTRIP
  • USING A SCROLLBAR AS A SLIDER TO SELECT VALUES
  • ADDING HELP TIPS TO CONTROLS
  • TAB ORDER
  • COLOURING THE ACTIVE CONTROL
  • TRANSPARENT FORMS
  • WORKING WITH MENUS AND TOOLBARS
  • CREATING MENUS AND TOOLBARS

Handling Errors

  • TYPES OF ERRORS IN VBA
  • USING THE ON ERROR GOTO STATEMENT
  • USING THE RESUME STATEMENT
  • WORKING WITH THE ERR OBJECT

The Excel Object Model

  • INTRODUCING CLASSES AND OBJECTS
  • THE OBJECT HIERARCHY
  • COLLECTIONS
  • REFERRING TO OBJECTS
  • NAVIGATING THROUGH THE HIERARCHY
  • OBJECT PROPERTIES AND METHODS
  • EVENTS
  • USING THE WITH…END WITH STATEMENT

Arrays

  • DECLARING ARRAYS
  • SPECIFYING LIMITS
  • ARRAY FUNCTION
  • TWO DIMENSIONAL ARRAYS
  • MULTI DIMENSIONAL ARRAYS
  • DYNAMIC ARRAYS

The Application Object

  • GLOBALS
  • THE ACTIVE PROPERTIES
  • DISPLAY ALERTS
  • SCREEN UPDATING
  • EVALUATE
  • STATUSBAR
  • SEND KEYS
  • ONTIME & ON KEY

Data Lists

  • SORTING A RANGE
  • CREATING A TABLE
  • SORTING A TABLE
  • AUTOFILTER
×