F-321 old m.b. road 2nd floor ladosarai new delhi-30
Email Us
Call Us
+91 9313033445

Alpha Technical College
25 Years of expertisation
(100% placement Records since 2006 onwards )

Learn M.I.S from industrial expert
Special Features:-
  • Regular online /offline classes Available Well compiled and Compact Module(notes) would be Provided .
  • Qualified and industrial experienced Faculty
  • New Ugc Pattern Course in Semester wise.
  • classes held in two shift wise !0 A.M.To 2 P.M and 2 P.M To 6 P.M
  • Courses are approved by Ugc Recognised State Private University or Govt. University from Delhi NCR
  • College Bag+ study Material+ Note Book Free
  • Full-time M.I.S course length is for 5-month divided into 6 modules.
  • Students can apply after completing 10+2 from any recognized board.
  • Regular exams will be taken with practical works
About certificate course in M.I.S.

A Certificate Course in Management Information Systems (MIS) is designed to provide individuals with a foundational understanding of how information systems are used to support and enhance business operations and decision-making processes. MIS is a field that combines business and technology to manage information within organizations effectively.

Here's some information about the certificate course in MIS:

  • Course Content:.The course typically covers a range of topics related to information systems, technology, and their integration with business processes. Some common topics include:
  • Introduction to Management Information Systems
  • Data Management and Database Systems
  • Business Analytics and Data Visualization
  • Enterprise Resource Planning (ERP) Systems
  • E-commerce and E-business
  • IT Project Management
  • Information Security and Risk Management
  • Business Process Management
  • Cloud Computing and Emerging Technologies
  • Who Should Enroll M.I.S Course ?
  • Certificate courses in MIS are suitable for various individuals, including:
  • Working professionals who want to enhance their understanding of how information systems impact business operations.
  • Individuals looking to transition into roles that involve IT management or business analysis.
  • Business owners or managers who want to leverage technology for better decision-making.
  • Students or recent graduates interested in gaining a competitive edge in the job market by understanding the intersection of business and technology.
Fee Structure:-
  • Total Course Fee:10,000(Ten Thousands only)
  • Semester:2500 P/s
  • Monthly:2500x4(Installment)
Complete Syllabus of certificate course in M.I.S.
Prof. Ms Excel MS-Access


  • Sum
  • Product
  • Average
  • IF
  • Days360
  • Date
  • Ceiling
  • Floor
  • Round
  • Round up
  • Round down
  • Power
  • Count
  • CountA
  • Count
  • Sum if
  • Maximum
  • Minimum
  • Hlookup for single worksheet
  • Vlookup for single worksheet
  • Hlookup & Vlookup for multiple Sheet
  • Index
  • Show formula
  • Or
  • Not
  • Iferror
  • Lookup
  • Rate
  • Ppmt
  • Ipmt
  • Networkdays
  • Roundup
  • Rounddown
  • Mode
  • Median
  • Received
  • Log
  • Dollar
  • AverageA
  • Averageif
  • Averageifs
  • Mina
  • Maxa
  • Sumifs
  • Large
  • Pv
  • Fv
  • Coupdays
  • Coupnum
  • Datedif
  • Daverage
  • Dproduct
  • Dmin
  • Dmax
  • Dcount
  • Dsum
  • Dget
  • Now
  • Today
  • Weekday
  • SQRT
  • Mod
  • Upper
  • Lower
  • Left
  • Right
  • Exact
  • Len
  • Match
  • Roman
  • Proper
  • Pmt
  • Concatenate
  • IF Function & Nested IF Statements
  • And & Or Functions
  • Match and find record by VLOOKUP And HLOOKUP
  • SLN
  • Effect
  • EoMonth
  • DDB
  • DB
  • Approximate Match with Vlookup
  • Exact match with Vlookup
  • Nesting Lookup Function
  • Choose Function
  • Rank & Rank Average
  • Rand & Rand Between
  • Mod with Conditional Formatting
  • Transpose
  • Find & mid
  • ISERR,
  • IIR
  • NPV
  • Transpose with Vlookup
  • TRIM

Create Statements According to Function
MIS Report

  • Profit & Loss a/c statement
  • Balance sheet
  • Worker contribution statement
  • Cash flow statement
  • Debtor’s & Creditors statement
  • Inventory statement
  • BRS Statement
  • Fixed Assets & fund statement
    • Payroll Report
    • P.F & E.S.I Report

Working with the Web and External Data

  • Inserting a Hyperlink
  • Importing Data from an Access Database or Text File
  • Importing Data from the Web and Other Sources
  • Working with Existing Data Connections


  • Creating a Chart with the 2D or 3D
  • Create Column Chart, Pie Chart
  • Create Pateros Charts
  • Create Speed- O-Meter Chart
  • Moving a Chart One to another Sheet
  • Resizing a Chart, Changing a Chart Type
  • Editing Chart Text, Modifying Chart Options
  • Formatting Category & Value Axis Data
  • Formatting a Data Series
  • Changing a Chart’s Source Data

Formats, Conditional Formatting & Sorting

  • Cell Format.
  • Data Bars, Color Scales & Icon Sets.
  • Conditional formatting with formulas
  • Conditional formatting with Form Controls.
  • Sorting basic.
  • Sorting based on Customized List.
  • Customized Sorting (Advanced).


  • Using Conditional Formatting
  • Removing Conditional Formatting
  • Format As table
  • Create our Styles

Data Management:

  • Data Validation and dealing with Invalid Data.
  • Group and Outline Data
  • Data
  • Data Consolidation.
  • Data text to column.
  • Custom Views


  • Tracing Formula Precedents
  • Tracing Cell Dependents
  • Error Checking
  • Creating a Pivot Table
  • Rearranging a Pivot Table
  • Filtering Pivot Table Data
  • Creating a Pivot Chart


  • Adding Subtotals to a List
  • Nesting Subtotals
  • Applying Advance Filters
  • Adding Group & Outline Criteria to Ranges
  • Using Data Validation
  • Text to Column


  • Using Goal Seek
  • Using Data Table
  • Creating & Displaying Scenarios


  • Sorting Records in a List
  • Using AutoFilter in a List
  • Filter & Advance Filter


  • Locking/Unlocking Cells in a worksheet
  • Protecting a Worksheet
  • Protecting a Workbook
  • Creating a Shared Workbook
  • Tracking Changes to a Workbook
  • Accepting & Rejecting Changes to a Workbook
  • Password Protecting a Workbook
  • Merging Workbooks


  • Web Page Preview
  • Converting Worksheets into Web Pages
  • Inserting Hyperlinks
  • Viewing & Editing Comments


  • Creating a Macro with Condition
  • Running a Macro, Editing a Macro
  • Adding a menu to the Menu Bar
  • Adding a Commands to a Menu
  • Adding Buttons to a Toolbar

Print Settings

  • Page Break
  • Print Area
  • Print Titles
  • Background

Special Operation

  • Link with One sheet,Another Worksheet , One Workbooks,Multiple Workbooks
  • Find record by drop down list according To condition
  • Dash Board

Understanding Databases

  • Starting and Opening an Existing Database
  • Moving Around in Access
  • Understanding Datasheet View & Design View
  • Using the Mouse Pointer to Navigate
  • Using the Keyboard to Navigate

Creating Tables

  • Creating a Database
  • Creating a Table Using the Wizard
  • Creating and Modifying a Table
  • Adding Fields to Tables
  • Adding and Editing Records
  • Printing Tables
  • Moving and Deleting Fields
  • Deleting Records

Working with Tables

  • Formatting a Table
  • Modifying Field Properties
  • Sorting Records in a Table
  • Finding Records in a Table
  • Using Filters with a Table
  • Establishing Relationships Between Tables
  • Creating Subdatasheets
  • Importing Records From an External Source

Creating and Using Queries

  • Creating and Running a Query
  • Specifying Criteria in a Query
  • Using Comparison Operators
  • Creating a Calculated Field
  • Creating a Multiple-Table Query
  • Printing a Query

Designing a Form

  • Creating a Form Using Auto Form
  • Creating a Form Using the Form Wizard
  • Adding Controls to a Form
  • Modifying Control Properties
  • Resizing and Moving Controls
  • Entering Records into a Form
  • Creating Calculated Controls

Designing a Report

  • Creating a Report Using Auto Report
  • Creating a Report Using Report Wizard
  • Adding a Control to a Report
  • Formatting a Report
  • Resizing and Moving Controls
  • Creating Calculated Controls
  • Previewing and Printing

Automating Tasks

  • Creating an Auto Keys Macro
  • Using Controls to Run a Macro
  • Assigning a Macro to an Event
  • Assigning a Macro to a Condition
  • Testing and Debugging a Macro

 I - SQL Overview

  •   Relational database concepts, specific products
  •   SQL syntax rules
  •   Data definition, data manipulation, and data control statements
  •   Getting acquainted with the course database and editor

 II - SQL SELECT statements

  •   Clauses
  •   The SELECT clause: columns and aliases, where expressions, order by expressions how null values behave

 III - SQL Functions and Expressions

  •   Eliminating duplicates with DISTINCT arithmetic expressions
  •   Replacing null values
  •   Numeric operations, including rounding
  •   Date and time functions
  •   Nested table expressions
  •   Case logic
  •   Other expressions in specific dbms products

 IV - SQL Updating

  •   The INSERT, UPDATE and DELETE statements
  •   Column constraints and defaults
  •   Referential integrity constraints

 V - SQL Joins

  •   Inner joins with original and SQL 92 syntax
  •   Table aliases
  •   Left, right and full outer joins, Inner joins
  •   Self-joins

 VI - SQL Sub queries and Unions

  •   Intersection with IN, and, Between
  •   Sub queries
  •   Difference with IS NULL and IS NOT NULL sub queries
  •   The purpose and usage of UNION and UNIONALL

 VII - SQL Summarization

  •    The column functions MIN, MAX, AVG, SUM and COUNT, UPPER, LENGTH, LOWER
  •   The GROUP BY and HAVING clauses Grouping in a combination with joining



  • Quick Review of Macros
  • Introducing the Visual Basic Editor
  • Uses of record Macros
  • Understanding and creating modules



  • VBA Sub and Function Procedures
  • How to create a message box
  • Write a Program to update and retrieve information using Input Box
  • Understanding and using Select Case statement
  • How do I define a variables and Rules for defining a Variables Name and Type
  • Creating And using Variables
  • Working with range Objects
  • How to save and Protect Modules


Decision Makers

  • If……Then……Else
  • If……Then……ElseIf……If


Other Kinds of Loops

  • Working with Do While u. Loop Procedure
  • Do…… Until Loop and Do…… Loop Until
  • Do……While loop and Do…… Loop While
  • For each…… Next
  • For……Next


Workbook Obects Create or Add Single and Multiple Workbooks

  • Workbook Save and Save AS
  • Open Single and Multiple Workbooks
  • Close Specify and Multiple Workbooks
  • Activate From one workbook to another Workbook
  • Open Workbook from Specific Path
  • Get Workbook Name and Paths
  • Hide and Unhide for Single and Multiple Workbooks
  • Protect and Unprotect Worksheets


Worksheet Objects insert a single and Multiple Worksheets

  • Delete Specific and multiple worksheets
  • Get Count of Worksheets
  • Select a Specific and all Worksheets
  • Get All Worksheets Name
  • Hide and Unhide For Single and Multiple Worksheets
  • Rename for Single and Multiple Worksheets
  • Protect and unprotect worksheets
  • Sort and Move worksheets
  • Calculate entire worksheet
  • Using VBA and worksheet Function


Cell objects insert Single and multiple Row , Column and Cells

  • Delete Single and Multiple row, Column and Cells
  • Get Range or Address of Cell and Selection
  • Navigate from one Cell to another Cell
  • Select specific Range, Cell, Rows and Column
  • Types of Selection and Offset method
  • Insert Function In cell


Reading and Writing Arrays

  • Defining Arrays
  • Arrays as Outputs
  • Arrays as inputs
    • The Arrays as a Collection
    • The Array as an Array


Form Controls and User Forms (Create and Design an user Form)

  • Working With User Forms & User Forms Events Like List Box, Combo Box, Option Buttons, Check Box, Text Box, Labels, Command Button, Toggle Button.
  • How To Create Dynamic Dashboard On User Form With Different Controls
  • How To Link Various User Form With Each Other To Create A Complete Interface Between User And System


VBA Programming Functions

  • Create a Sum Functions
  • Create Multiply Function
  • Create Count Function
  • Extract Text & Number
  • Proper Function
  • Vlookup Function
  • Square root Function
  • Public or Private function


Excel VBA Power Programming for VBA Macros

  • Working with Dynamic Ranges. Protecting worksheets, Cells and Ranges. Working with Multiple Files. Opening &saving Files
  • How to Analyze Data On multi Worksheets And Build Summary sheets
  • How to Access the Windows File and Folder System to Open and Close Workbooks
  • How to protect your code Against Errors
  • How to use Excel And VBA to Create Basic Dash Boards
  • How to create Your own custom Business Worksheet Function in VBA
  • How to create Basic Report Generation Tools Using Excel VbA, Microsoft Word and PowerPoint
  • How to use the Excel Visual Basic Macro record Excel Tasks in VBA And then Interpret the code


Connection between Excel VBA & other platforms

  • How To Establish Connection Between VBA And Power Presentation To Create Power Point Through VBA
  • How To Establish Connection Between Excel Vba And Outlooks Through Vba
  • How To Establish Connection Between Excel Vba And MS Word Through Vba
Get In Touch

New delhi saket ladosarai

PH:011 46025188








We are admission and couselling center of various University India and abroad universities . We help you admission for best college and and affordable fee.To get information on mail send your correct mail address

© alphatechnicalcollege.in. All Rights Reserved.ALPHA TECHNICAL EDUCATION