Best MIS Training in Bangalore
Learn MIS Course from Expert Trainers at RIA Institute of Technology
RIA Institute of Technology provides Best MIS Training in Bangalore, Marathahalli by experienced industry professionals and our Training Institute is well equipped with advanced labs. Trainers working in MIS for more than 7+ years are carefully chosen to conduct high quality MIS Training so that the students can benefit from real time scenarios. Instructors offering MIS Course have practical knowledge as they implement their knowledge and expertise in day to day work.
Course content by best MIS Training Institute in Bangalore is carefully crafted to match the industry requirements. The topics covered in MIS Training include latest and best real-time examples that are aimed to help students in getting the right job so after the completion of Training. Our expert instructors will highlight the Key topics from MIS Training based on the questions that can be possible asked by the interviewer during the job selection process; this provides confidence to the students while facing job interviews.
RIA Institute provides classroom, online, weekend and fast track course for MIS training in Bangalore. The institute is open seven days a week, so students have the option to select the course timings that fit their schedules best. In order to complete SAP training sessions in this schedule, students must follow the class times as per the instructor’s availability.
Book a Free Demo Class with our MIS Experts Today!
Why Choose MIS Training with RIA Institute
- More than 150 Practical Assignments after every session taken from actual project requirements across different domains to reinforce your learning
- Well-furnished WIFI Enabled Computer Lab with good acoustics and ventilation
- Post Training Support for 60 Days
- Mock Interviews, Exams and Resume/Project Preparation
- Typically Our Students get job within two months after training completion
Topics Covered
- Intermediate Excel
- Advanced Excel
- Data Visualization and Dashboarding Methods
- Macros and VBA Programming in Depth
- MS Access Development
- SQL Querying for Analysts
Who should attend
- People Looking For Career Change from BPO to Reporting ,
- Students, Working Professionals, Entrepreneurs, IT Professionals,
- Managers, Employees in Different Departments like Operations,HR, Marketing,Finance,Sales,Banking,Manufacturing and Management professionals(CA’s,MBA)
Pre-requisites
- Basic Excel Knowledge recommended
Key Takeaways
- You will become Power User of Excel and Access ,SQL with expertise in all functions and other features of these applications
- You will be able to automate any task using VBA and improve your existing process, Reduce TAT
- Generate Eye catching Reports and Wow your Audience with our data visualization techniques and Interactive, Dynamic Dashboarding methods
- Your knowledge will be equivalent to seven years experienced person in Excel VBA, Access and SQL because of which you can easily make a transition from BPO or other domain to MIS, Reporting or BI Field without any hassles
MIS Course Fee & Duration
MIS Course
- Course Duration : 3 Months
- Training Hours : 40 Hours
- Type : Online & Classroom
MIS Course Syllabus
- Advanced Excel Course Content
- VBA Course Content
- SQL Course Content
COURSE CONTENT/SYLLABUS FOR ADVANCED EXCEL COURSE : Duration- 30 Hours
1 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.)
2 Working on Objects:
- Inserting Objects
- Inserting different files into Excel (like .doc, .pdf, .txt files)
- Hyperlinking to different sheets
- Providing screen tips in hyperlink
- Hyperlink to send emails
- Inserting symbols
- Sending working file to an email
3 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
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
4 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
5 Data Connection from External Data:
- From access
- From SQL
- From Web
- From ODBC
6 Customize your Excel view:
- Customize Excel view
- Developer Option
- Trust Centre
- Add-Ins
- Save directory options
- Language Setting
- Quick access toolbar
7 Security options in excel:
- Protecting the worksheet
- Protecting the workbooks
- Sharing the workbook
- Allow users to edit ranges
COURSE CONTENT/SYLLABUS FOR VBA COURSE : Duration- 20 Hours
1 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
2 VBA IDE
- OPENING THE EXCEL VBA IDE
- MENU BAR
- TOOLBAR
- PROJECT WINDOW
- CODE WINDOW
- IMMEDIATE WINDOW
- CUSTOMIZING THE VBE
3Getting Started With Macro
- RECORDING THE MACRO
- EXAMINING THE MACRO
- SAVING WORKBOOKS THAT CONTAIN MACROS
4 Fundamentals of VBA Language
- VARIABLE & CONSTANTS
- KEYWORDS
- DATA TYPES
- PROCEDURES: SUB AND FUNCTION
- ARGUMENTS
- LOCAL VS GLOBAL VARIABLE DECLARATION
- PROCEDURES: PUBLIC OR PRIVATE
- COMMENTS
5 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
6 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
7 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
8 Handling Errors
- TYPES OF ERRORS IN VBA
- USING THE ON ERROR GOTO STATEMENT
- USING THE RESUME STATEMENT
- WORKING WITH THE ERR OBJECT
9 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
10 Arrays
- DECLARING ARRAYS
- SPECIFYING LIMITS
- ARRAY FUNCTION
- TWO DIMENSIONAL ARRAYS
- MULTI DIMENSIONAL ARRAYS
- DYNAMIC ARRAYS
11 The Application Object
- GLOBALS
- THE ACTIVE PROPERTIES
- DISPLAY ALERTS
- SCREEN UPDATING
- EVALUATE
- STATUSBAR
- SEND KEYS
- ONTIME & ON KEY
12 Data Lists
- SORTING A RANGE
- CREATING A TABLE
- SORTING A TABLE
- AUTOFILTER
COURSE CONTENT/SYLLABUS FOR SQL COURSE : Duration- 20 Hours
SQL – Part 1
Users and Schemas
- Introduction to Users and Schemas
- Definitions and Client Tools
- SQL Developer Login
- Creating An Application Schema
- Introduction to Users and Schemas
Pseudo Columns & Functions
- Using The Dual Table
- Functions
- Pseudo-Columns
- Using Rowid
- Using Rownum
Using Subqueries
- Simple Subqueries
- Inline Views
- Correlated Subqueries
- Scalar Subquery
Joining Tables
- Review of Joins
- Equijoins
- Inner Joins
- Outer Joins
- Cross Joins
- Natural Joins
- Using Named Subqueries
Group Operations
- About Group Processing
- Simple GROUP BY
- ROLLUP Function
Using Set Operators
- Set Operators Defined
- Relationship to Mathematical Set Theory
- Restrictions on Set Operators
Conditional Processing
- The DECODE Function
- The Case Expression
- Exercise: Conditional Processing
SQL Functions (Character)
- What Are SQL Functions?
- Character Functions
- CONCAT
- LENGTH
- INSTR
- REPLACE
- UPPER
- LOWER
- INITICAP
- LPAD
- RPAD
- TRIM
- TO_CHAR
- SOUNDEX
- SQL Functions (Non-Character)
- Numeric Functions
- The TO_CHAR Function with numbers
- Date/Time Functions
- Date Format Functions
- Date Arithmetic Functions
- Null Value Functions
- Numeric Functions
- SQL Data Manipulation Language
- The INSERT Statement
- INSERT Statement Categories
- The UPDATE Statement
- The DELETE Statement
- Transactions
- Complex Table References
- The MERGE statement
- The INSERT Statement
SQL – Part 2 – Advanced:
- Analytical Functions
- Queries for Queries
- Techniques to compare data.
- Efficiently writing SQL queries.
Hear From Our Happy Students
I have joined this institute to learn Advanced Excel. It was really a very good experience as I could learn all the commands and formulas and the trainer was also very good. Thanks to Ria Institute of Technology.
Raghu
[Advanced Excel]
Ria institute provides very good course training and has experienced staff faculty for classroom training. I have attended Advanced Excel course weekend batch where the Institute was flexible with the timings to our timings due to office timings.
Sriram
[Advanced Excel]
It's a very good institute to learn VBA and Advanced Excel. My trainer was Mr. Neeraj and he is an expert in the VBA/Excel. This institute is very supportive too.
Rajesh Nair
[Advanced Excel]
This institute has not only trained me on all the theoretical concepts but they were also providing assignments to implement all the concepts practically and learn. Thanks to the trainer, who is very cooperative and supportive.
Amal
[Advanced Excel]
I am an employee working with one private firm and I wanted to learn Advanced Excel along with my work. This Institute has provided me a very good support in scheduling a proper time as per my convenience. They are very supportive and helpful. I would recommend everyone to join Ria Institute of Technology who is looking out to take classes on Advanced Excel.
Ankur
[Advanced Excel]
Book a Free Demo Today!

Frequently Asked Questions
Call our Helpline now: +91 80506 01060 and know the exciting offers available for you!
RIA Institute of Technology offers 63+ IT & Non IT training courses in marathahalli, Bangalore with 10+ years of Experienced Expert level Trainers.
- Fully hands-on training
- 30+ hours course duration
- Industry expert faculties
- Completed 1500+ batches
- 100% job oriented training
- Certification guidance
- Own course materials
- Resume editing
- Interview preparation
- Affordable fees structure
- All Our trainers are more than 10+ years of experience in course relavent technologies.
- Trainers are expert level and fully up-to-date in the subjects they teach because they continue to spend time working on real-world industry applications.
- Trainers have experienced on multiple real-time projects in their industries.
- Are working professionals working in multinational companies such as Oracle, TCS, HCL Technologies, ZOHO, Birlasoft, IBM, Microsoft, HP, Scope, Philips Technologies, etc…
- Trained more than 2000+ students in a year.
- Strong theoretical & practical knowledge.
- Are certified professionals with high grade.
- Are well connected with hiring HRs in multinational companies.
No worries. RIA institute of Technology assures that no one misses single lectures topics. We will reschedule the classes as per your convenience within the stipulated course duration with all such possibilities. If required you can even attend that topic with any other batches.
RIA Institute of Technology provides many suitable modes of training to the students like
- Classroom training
- One to One training
- Fast track training
- Live Instructor LED Online training
- Customized training
You will receive globally recognized course completion certificate issued from RIA Institute of Technology.
We accept all major kinds of payment options. Cash, Card (Master, Visa, and Maestro, etc), Net Banking and etc.
Please Contact our course advisor/consultant on +91 8050601060. Or you can share your queries through info@riainstitute.in
Trusted By 25,000+ Ambitious Students Who Dream To Achieve Their Goals












Achieve Your Goals With Our Classroom & Online Courses
Get unlimited access to online & offline courses, learn any skill and gain knowledge from expert real-time trainers, achieve highly recognized certificates, get in touch with leading companies – kickstart your career!
