Certificate in MIS

A Certificate in Management Information Systems (MIS) focuses on equipping students with the skills to manage and analyze data for business decision-making. The course covers topics like data management, database design, enterprise resource planning (ERP), business analytics, and IT project management. It helps professionals understand how information systems support business operations, enhance performance, and drive strategic decisions. Ideal for managers, business analysts, and IT professionals, this certification opens up career opportunities in business intelligence, project management, and IT consulting.

Prof. MS EXCEL

MS EXCEL

Mathematical & Statical Function’s

Sum
Product
Average
Ceiling
Floor
Round
Round Up
Round Down
Power
Count
Counta
Maximum
Minimum
Mode
Median
Log
Dollar
Average A
Mina
Maxa
Large
Sqrt
Mod
Roman
Rank
Rank Average
Rand
Rand Between

Logical Function

If
Nested if
SumIf
Sumifs
Averageif
Averageifs
Countif
Countifs
Or
Not
And
If error
If Function & Nested If Statements And & Or Functions
Maxifs
Minifs

Text Function’s

Upper
Lower
Left
Right
Exact
Len
Mid
Concatenate
Proper
Trim
Substitute
Search
Find

Date & Time Function’s

Days360
Date
Network days
Now
Today
Weekday
Effect
Eomonth
Edate
Workdays
Datedif

Lookup &Reference Function’s

Index
Match
Lookup
Choose
Offset
Offset with Match
Xlookup
Transpose
Hlookup For Single Worksheet
Vlookup For Single Worksheet
Hlookup & Vlookup For Multiple Sheet
Match and Find Record by Vlookup And Hlookup
Approximate Match with Vlookup
Exact Match with Vlookup
Nesting Lookup Function
Show Formula
Choose Function with Vlookup
Indirect

Financial Function’s

Pmt
Rate
Ppmt
Ipmt
Fv
Pv
Coupdays
Coupnum
Ispmt
Sln
Cumprinc
Cumipmt
Ddb
Db
Received

Database Function’s

Daverage
Dproduct
Dmin
Dmax
Dcount
Dsum
Dget

Working with Charts

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

Format Cells

Cell Format.
Data Bars, Color Scales & Icon Sets.
Sorting basic.
Sorting based on Customized List.
Customized Sorting (Advanced).

Conditional Formatting with Rules & Color Scale

Using Conditional Formatting
Removing Conditional Formatting
Format As table
Create our Styles
Conditional formatting with formulas
Conditional formatting with Form Controls.

Data Management with Data Validation

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

Data Analysis

Tracing Formula Precedents
Tracing Cell Dependents
Error Checking

Summarizing Data by Subtotal With grouping

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

What –If Data Analysis

Using Goal Seek
Using Data Table
Creating & Displaying Scenarios

Sorting & Filtering

Sorting Records in a List
Using AutoFilter in a List
Filter & Advance Filter
Applying Advance Filters

Protecting Excel Workbook & Sheet

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

Workgroup Collaboration

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

Customizing Macro by Action Button

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

Working with Pivot Table & Pivot Chart

Creating a Pivot Table
Rearranging a Pivot Table
Filtering Pivot Table Data
Creating a Pivot Chart

Reporting with Payroll Statement

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

Advance Paste Special Techniques

Paste Formula’s, Paste Formats
Paste Validations
Transpose Tables
Paste data

Special Operation

Find record by drop down list according To condition
Dash Board
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
Speed o Meter

Print Settings

Page Break
Print Area
Print Titles
Background

Prof. MS Access (RDBMS)

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

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

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

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

SQL

SQL ─ Overview

What is SQL?
SQL Process
SQL Commands

SQL – Operators

What is an Operator in SQL?
SQL Arithmetic Operators
Arithmetic Operators – Examples
SQL Comparison Operators
Operators – Examples
SQL Logical Operators
Logical Operators – Examples

SQL – Expressions

Boolean Expressions

Numeric Expressions

Date Expressions

SQL – CREATE Database

SQL ─ DROP or DELETE Database
SQL ─ SELECT Database, USE Statement
SQL ─ CREATE Table
SQL – Creating a Table from an Existing Table
SQL ─ DROP or DELETE Table
SQL ─ INSERT Query
SQL ─ SELECT Query
SQL ─ WHERE Clause
SQL ─ AND & OR Conjunctive Operators
The AND Operator
The OR Operator
SQL ─ UPDATE Query
SQL ─ DELETE Query.
SQL ─ LIKE Clause.
SQL ─ TOP, LIMIT or ROWNUM Clause
SQL ─ ORDER BY Clause
SQL ─ Group By
SQL ─ Distinct Keyword
SQL ─ SORTING Results

SQL ─ Constraints

SQL ─ Constraints
SQL – NOT NULL Constraint
SQL – DEFAULT Constraint
SQL – UNIQUE Constraint
SQL ─ Primary Key
SQL ─ Foreign Key
SQL ─ CHECK Constraint
SQL ─ INDEX Constraint
Dropping Constraints
Integrity Constraints

SQL ─ Using Joins

JOIN
SQL ─ LEFT JOIN
SQL – RIGHT JOIN
SQL ─ FULL JOIN
SQL ─ SELF JOIN
SQL ─ CARTESIAN or CROSS JOIN

SQL ─ UNIONS CLAUSE

The UNION ALL Clause
SQL ─ INTERSECT Clause
SQL ─ EXCEPT Clause

SQL ─ NULL Values

SQL ─ Alias Syntax

SQL – Indexes

The CREATE INDEX Command
The DROP INDEX Command
SQL – INDEX Constraint

SQL ─ ALTER TABLE Command

SQL – TRUNCATE TABLE Command

SQL ─ Using Views

Creating Views
The WITH CHECK OPTIONSQL ─ Having Clause

SQL – Transactions

Properties of Transactions
Transactional Control Commands

SQL ─ Wildcard Operators

SQL ─ Date Functions

SQL ─ Temporary Tables

What are Temporary Tables?
Dropping Temporary Tables

SQL – Clone Tables

SQL – Sub Queries

Subqueries with the SELECT Statement
Subqueries with the INSERT Statement
Subqueries with the UPDATE Statement
Subqueries with the DELETE Statement

SQL – Using Sequences

Using AUTO_INCREMENT column
Obtain AUTO_INCREMENT Values

VBA MACROS

What Is Vba & How Vba Works With Excel

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

Programming Concepts

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……Else If……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 Objects 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 rows, 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

Database

Types and Structure of Databases

Databases can be classified into various types depending on the way data is stored and accessed. The two main categories include:

Relational Databases (RDBMS): Data is organized in tables with rows and columns, and SQL is used to manage and manipulate the data. Examples include MySQL, PostgreSQL, and Oracle.
NoSQL Databases: Designed for handling unstructured or semi-structured data, NoSQL databases are highly scalable. Examples include MongoDB and Cassandra.

The structure of a database includes tables, relationships, and indexes. Tables store the data in rows and columns, while relationships between tables ensure data consistency. Indexes improve data retrieval speed.

Database Management and SQL

A Database Management System (DBMS) is software that helps create, manage, and interact with databases. It ensures the smooth storage, retrieval, and manipulation of data, and supports various functionalities like data security, backup, and recovery.

SQL (Structured Query Language) is the standard language used to interact with relational databases. It enables data retrieval, insertion, updating, and deletion.
The DBMS also manages database security, performance, and integrity, ensuring that only authorized users can access or modify data.

Dashboard & VBA

What is a Dashboard?

A dashboard is a visual representation of key data and metrics, typically used to monitor and analyze business performance, trends, and progress. Dashboards are designed to provide a quick and easy way for users to access relevant information without the need for deep analysis. They are commonly used in business, finance, marketing, and project management to display real-time or historical data in an organized, graphical format.

Key components of a dashboard include:

Charts & Graphs: Visual elements such as bar charts, line graphs, pie charts, etc., to represent data.
Tables: Data organized in rows and columns for easy comparison.
Key Performance Indicators (KPIs): Metrics that indicate the performance of an organization or specific process.

Dashboards can be created using tools like Microsoft Excel, Power BI, and Tableau.

Using VBA for Automating Dashboard Tasks

VBA (Visual Basic for Applications) is a programming language used to automate tasks in Microsoft Office applications like Excel, Word, and Access. In the context of dashboards, VBA allows you to automate data updates, create dynamic charts, and design interactive elements.

Automating Data Updates: VBA can be used to pull in data from external sources (like databases or online files), perform calculations, and update dashboard elements automatically.
Creating Dynamic Charts: VBA can adjust chart data sources, change chart types, and update visualizations based on new data, improving user interactivity.
User Interaction: VBA enables the addition of buttons, forms, and event-driven macros (e.g., when a user clicks a button, the dashboard updates or performs a calculation).

Incorporating VBA into a dashboard enhances its functionality and allows users to perform complex tasks with minimal manual input.

How to Use Your PC Devices

Connecting and Setting Up Your PC Devices

Properly connecting and setting up your devices is the first step toward using your PC efficiently. Key devices include the monitor, keyboard, mouse, printer, speakers, and external storage devices.

Monitor: Connect the monitor to the PC using HDMI, DisplayPort, or VGA cables. Ensure that the display is powered on and properly selected as the output device.
Keyboard and Mouse: For wired devices, plug the keyboard and mouse into the USB ports. Wireless devices require pairing with the PC through Bluetooth or a USB receiver.
Printer: For wired printers, connect the printer to the PC via USB. For wireless printers, connect the printer to the same Wi-Fi network as the PC and install any necessary drivers.
External Devices (USB, External Hard Drives): Plug in your external storage devices through USB ports. Once connected, these devices will be recognized by your system and can be accessed from File Explorer or Finder.

Managing and Troubleshooting Your PC Devices

Once your devices are connected, managing them and solving any issues is key to ensuring they work correctly.

Device Manager: Use Device Manager (Windows) or System Preferences (Mac) to view, update, and manage device drivers. If a device isn’t functioning, you can troubleshoot or uninstall and reinstall the driver.
Updating Drivers: Periodically update device drivers to ensure compatibility with the operating system and improve device performance. You can do this manually or through Windows Update (for Windows) or system updates (for Mac).
Wireless Devices: For devices like wireless mice or keyboards, check the battery levels, ensure the Bluetooth is turned on, and reconnect the devices if needed.
Troubleshooting:
- No Display: Check the cables, ensure the monitor is powered on, and verify that the PC is outputting to the correct display.
- Device Not Recognized: Ensure that the device is correctly connected, and try plugging it into a different port. Restart your PC and check if it appears in Device Manager.
- Printer Issues: Ensure the printer is connected to the same network (for wireless) or cable (for wired). Restart both the printer and the PC to resolve common connectivity issues.

By properly connecting and troubleshooting your PC devices, you can ensure smooth operation and minimize technical difficulties.

Key Features of Courses

Free Demo Session

Enjoy a free demo session in both classroom and online with a live instructor. This helps you understand our instructors and the atmosphere of our institute. To attend a demo session, call us or fill out the inquiry form or email us at info@lakshayainstitute.com.

Pay Fee in Installments

We offer an easy and hassle-free installment process for course fees. No extra charges or interest fees—discuss your installments during registration and pursue your dreams.

Limited Batch Size

We focus on quality training with limited batch sizes to ensure personal attention, better results, enhanced learning, and greater focus on concepts.

Highly Professional Faculty

Our instructors are passionate and highly experienced, providing a high-quality learning experience with a focus on student achievement and outcomes.

1 Year Free Classes Retake

We offer the opportunity to retake classes at no cost for up to a year, giving you the flexibility to enhance your understanding and knowledge.

Special Classes

In addition to regular classes, we provide special classes to further reinforce concepts and provide a deeper understanding of the software, languages, and tools.