RIA

Best MIS Classes in Bangalore

Best MIS Classes in Marathahalli

 Best MIS Classes in Bangalore by RIA institute offers students an innovative way to learn MIS in Bangalore. With experienced MIS professional trainers and advanced lab Facilities to practice Advance Dotnet, students can complete MIS training on real time scenario. Our MIS Training institute in Bangalore is rated as one of the Best MIS Learning Centre on Google.

Training methodology used for conducting MIS course includes ease of understanding MIS concepts, latest examples in MIS  classes andreal-timee practical exposure. This ensures that students opting for MIS training in Marathahalli, Bangalore get value for money. Our MIS course content is structured to cover all concepts under MIS Training.

Best MIS Classes in Bangalore

Advantages of Studying MIS with Us

MIS Trainers at RIA Institute

MIS Course Content

Our Basic .net Course content is structured to cover all the modules within Basic .net. From basic to advance, we give Basic .net training in Bangalore in a manner that is easy to understand.

  1. Pivots and Pivot Graphs:
    1. Creating of Pivot Table
    2. Using Summary function in Pivot Table
    3. Pivot Table Calculations
    4. Creating own formulas in Pivots
    5. Grouping and Ungrouping in Pivot Tables
    6. Creating Pivot Graph
    7. Custom Filter on Pivot Table
    8. Formatting Pivot table (Removing old data, grand total, subtotal …etc.)



  1. Working on  Objects:
    1. Inserting Objects
    2. Inserting different files into Excel (like .doc, .pdf, .txt files)
    3. Hyper linking to different sheets
    4. Providing screen tips in hyper link
    5. Hyperlink to send emails
    6. Inserting symbols
    7. Sending working file to an email



  1. Data Management in Excel:

Sorting:

  1. Rearranging of Data
  2. Sorting by alphabets, numbers and time

Filtering Data:

  1. Using Auto filter option
  2. Custom Filtering with different options
  3. Advanced Filtering
  4. Find Unique records using advanced filtering
  5. Filter using operators AND/OR
  6. Filter by color

Grouping and Outlining Data

  1. Group and ungroup rows and columns
  2. Auto outlining the data

Freezing and Unfreezing 

Data Validation:

  1. Use Data Validation in Excel
  2. Using Input Message in Data validation
  3. Using error message in Data Validation

Removing duplicate records:

  1. Remove duplicate records in a spread sheet
  2. Customize to remove the duplicate values

Split Texts:

  1. Split texts to different columns
  2. Remove special character from a string and split the string

Data Consolidation:

  1. Combining different spreadsheet using data consolidation
  2. Using summary function in data consolidation

Conditional Formatting:

  1. Use of conditional formatting
  2. Custom formatting

Copy Data:

  1. Use of format painter
  2. Use of paste special
  3. Strike through a value
  4. Find and Replace

View Multiple Files:

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

Working on Tab:

  1. Hide/ Unhide a tab
  2. Color a tab
  3. Move /Copy the tab to another sheet/workbook



  1. Advanced Functions:
  2. V-Lookup
  3. H-Lookup
  4. IF
  5. ISERROR
  6. Index Match
  7. Rows
  8. Columns
  9. Match
  10. Offset
  11. Get Pivot Data
  12. Date and Time Functions 
  13. Text Functions
  14. Operators
  15. Mathematical functions
  16. Calculation options

 

Name Manager:

  1. Define a name to a range
  2. Use of name manager
  3. Using formulas in name manager
  4. Editing name range



  1. Data Connection from External Data:
  2. From access
  3. From SQL
  4. From Web
  5. From ODBC



  1. Customize your Excel view:
  2. Customize Excel view
  3. Developer Option
  4. Trust Centre
  5. Add-Ins
  6. Save directory options
  7. Language Setting
  8. Quick access toolbar



  1. Security options in excel:
  2. Protecting the worksheet
  3. Protecting the workbooks
  4. Sharing the workbook
  5. Allow users to edit ranges

 

×