BG elements
Round Shape

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 Training in Bangalore
5/5

Book a Free Demo Class






    RIA Institute of Technology

    ISO Certified Training Institute

    0
    +
    Years of Expertise
    0
    +
    Courses Offered
    0
    K+
    Students Trained
    0
    K+
    5 Star Reviews

    MIS Course Fee & Duration

    MIS Course

    15340/-
    • Course Duration : 3 Months
    • Training Hours : 40 Hours
    • Type : Online & Classroom

    MIS Course Syllabus

    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

    1. Users and Schemas
      1. Introduction to Users and Schemas
        1. Definitions and Client Tools
        2. SQL Developer Login
      2. Creating An Application Schema
    2. Pseudo Columns & Functions
      1. Using The Dual Table
      2. Functions
      3. Pseudo-Columns
      4. Using Rowid
      5. Using Rownum
    3. Using Subqueries
      1. Simple Subqueries
      2. Inline Views
      3. Correlated Subqueries
      4. Scalar Subquery
    4. Joining Tables
      1. Review of Joins
      2. Equijoins
        1. Inner Joins
        2. Outer Joins
      3. Cross Joins
      4. Natural Joins
      5. Using Named Subqueries
    5. Group Operations
      1. About Group Processing
      2. Simple GROUP BY
      3. ROLLUP Function
    6. Using Set Operators
      1. Set Operators Defined
      2. Relationship to Mathematical Set Theory
      3. Restrictions on Set Operators
    7. Conditional Processing
      1. The DECODE Function
      2. The Case Expression
      3. Exercise: Conditional Processing
    8. SQL Functions (Character)
      1. What Are SQL Functions?
      2. Character Functions
        1. CONCAT
        2. LENGTH
        3. INSTR
        4. REPLACE
        5. UPPER
        6. LOWER
        7. INITICAP
        8. LPAD
        9. RPAD
        10. TRIM
        11. TO_CHAR
        12. SOUNDEX
      3. SQL Functions (Non-Character)
        1. Numeric Functions
          1. The TO_CHAR Function with numbers
        2. Date/Time Functions
        3. Date Format Functions
        4. Date Arithmetic Functions
        5. Null Value Functions
      4. SQL Data Manipulation Language
        1. The INSERT Statement
          1. INSERT Statement Categories
        2. The UPDATE Statement
        3. The DELETE Statement
        4. Transactions
        5. Complex Table References
        6. The MERGE statement

    SQL – Part 2 – Advanced:

    1. Analytical Functions
    2. Queries for Queries
    3. Techniques to compare data.
    4. 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]

    Enquire Now

    Book a Free Demo Today!






      FAQ's

      Frequently Asked Questions

      Are you looking for exciting offers?

      Call our Helpline now: +91 80506 01060  and know the exciting offers available for you!

      Why should i choose RIA Institute of Technology

      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

      Who is my trainer and how are they selected?

      • 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.

      What if I miss a session?

      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.

      What are the different modes of training Provided?

      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

      What certification will I receive after course completion?

      You will receive globally recognized course completion certificate issued from RIA Institute of Technology.

      What are the payment options?

      We accept all major kinds of payment options. Cash, Card (Master, Visa, and Maestro, etc), Net Banking and etc.

      I have more queries?

      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!

      Round Shape