Professional Courses

InCIS is offering customized professional courses for early learners to senior executives. These courses have been designed according to the demand of a group of corporates. It is mostly suitable for companies who would like to enhance the skills of their workforces.

Our courses duration and timing are flexible. It can be conducted even on weekends. Our classes are online and live, so learners can join from their comfort zones and participate in a relaxed way. There is a feedback session after each class so, they can ask any relevant questions or discuss their problems with their lessons.

At the end of each topic, a small assignment is given. Learners must complete the assignment and submit it within stipulated times. Feedback is normally given in the next week. When a course is fully completed, a small project is given on the entire course so learners can prove their understanding and improve efficiency. A professional course completion certificate will be awarded to each learner.

NOW WE ARE OFFERING COURSES:

Office Packages:

This course is designed mainly for them who want to handle customized database handling with the aid of built-in programming language Visual Basic Application. It will give a learner much more robust control on the developed system.  

Microsoft Excel is a spreadsheet application developed by Microsoft Inc for Microsoft Windows and MAC OS X. Its use is to do advanced calculation, graphing tools, pivot tables, and a macro programming language referred to as Visual Basic for Applications. The course curriculum is one of the most comprehensive and most advanced. Here you will trained from the very basic till the most advance level in the version 2019.

In this 7 hours of training with 74 lectures, you will be taken through the fundamentals of Excel till the Expertise level. You may expect to learn following topics in detail.

Learn about the structure of Excel

Learn how to adjust the way data and information are displayed in Excel

Learn how to apply function with function facts

Learn how to use relative, absolute, and mixed references in Excel

Learn how to create powerful calculations with Excel functions

Learn how to visually represent your data with charts and other tools in Excel

Learn how to use Excel data tools like Group, subtotaling, and filtering

Learn how to remove duplicates from data in Excel

Learn how to use Excel to leverage data with Pivot Tables & Pivot Charts

Learn how to automate Excel tasks with recording Macros.

Learn how to use passwords in Excel to protect your work in multiple scenarios

Learn how to use printing and sharing in Excel

Learn to use Pivot table with slicers, Grouping and various tricks

Learn how to organise your data based on Condition.

Learn to validate proper entry in the data.

Mastering Date and time related formulas and format.

Mastering all important Text function with nested methodology

Mastering Logical and Lookup and reference Function.

Mastering Operators use and Math Functions.

Who this course is for:
Career in MIS
Want to have expertise in Basic and Advance Excel
Seeking career in Data Management

Course content
Expand 74 lectures
06:58:22

Advance Excel Training

Excel structure

Cell properties

Autofill Number and text

Autofill date

Autofill Adv tools

Cell reference

Operators based equation in Excel

Math Function in Excel

Print related options in Excel Part 1

Print related options in Excel Part 2

What if Analysis – Goal seek

What if Analysis – Scenario Manager

PMT function – EMI calculator

Data table – Create Loan Table

Text Function – Upper, Lower, Proper, Trim

Text Function – Right, Left

Text Function – Find and task

Text Function – Solution and Nested Left

Text Function – Find and Left Nesting

Text Function – MID

Text Function – Mid task and solution

Text Function – Concatenate

Text Function – Concatenate task and solution

Text Function – Replace

Text Function – Replace task and Solution

Text Function – Substitute

Text Function – Len, Rept, Excat, Search

Text to column

Workbook protect

Protect sheet

Hide Formulas and unlocked Cell

Protect File with password

Share workbook

If Function – Logical Test

If Function – with Equation and task

If Function – Nested If

If Function – advance

If Function – advance – 2

AND , OR Function

AND, OR, IF Nested

AND, OR Advance

Pivot Table – Intro

Pivot Table – Manage Field Area

Pivot Table – Value Field, Report and more

Pivot Table – Slicer and Duplicate Pivot

Pivot Table – Group to mange date and values

Pivot Table – Insert Calculated Field

Chart Preparation

Chart Preparation – Advance

Chart Preparation – Customise

Conditional Formatting

Conditional Formatting – Types of Rules

Conditional Formatting – Apply

Conditional Formatting – Create New Rules

Conditional Formatting – Mange Rules

Data Validation

Data Validation – Input message and Error Alert

Advance Math Function

Advance Math Function 2

Using of Wild Card in Math Function

Vlookup Function

Vlookup with Iferror

Vlookup Nesting with If

Hlookup

Match Function

Index and match nested

Vlookup array

Vlookup column func trick

Vlookup TRUE

Advance VLOOKUP

Macro Recording part 1

Macro Recording part 2

Macro Recording part 3

Types to run macros


Microsoft Access is a Database Management System (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools. It is a part of the Microsoft Office suite of applications, included in the professional and higher editions.

This tutorial is designed for those people who want to learn how to start working with Microsoft Access. After completing this tutorial, you will have a better understating of MS Access and how you can use it to store and retrieve data.

It is a simple and easy-to-understand tutorial. There are no set prerequisites as such, and it should be useful for any beginner who want acquire knowledge on MS Access. However it will definitely help if you are aware of some basic concepts of a database, especially RDBMS concepts.


RDBMS

Objects

Create Database

Data Types

Create Tables

Adding Data

Query Data

Query Criteria

Action Queries

Create Queries

Parameter Queries

Alternate Criteria

Relating Data

Create Relationships

One-To-One Relationship

One-To-Many Relationship

Many-To-Many Relationship

Wildcards

Calculated Expression

Indexing

Grouping Data

Summarizing Data

Joins

Duplicate Query Wizard

Unmatched Query Wizard

Create A Form

Modify A Form

Navigation Form

Combo Box

SQL View

Formatting

Controls & Properties

Reports Basics

Formatting Reports

Built-In Functions

Macros

Data Import

Data Export

MS Project, the project management software program by Microsoft, is a very handy tool for project managers that helps them develop a schedule, assign resources to tasks, track the progress, manage the budget, and analyze workloads for an ongoing project. This tutorial discusses the various features of the software program with examples for easy understanding.

This tutorial has been designed keeping in mind the needs of beginner level MS Project user. Project managers and Project planners from varied backgrounds who have not used MS Project before can use this tutorial for scheduling, planning, and reporting their projects of any size. This tutorial is designed with Project Standard features, hence there is no need of Project Professional.

A basic understanding of Computers and Windows Operating System is all it takes to get started. Hardware: A reasonable home desktop configuration. Software: MS Project on Windows OS. (MS Project is not available for Mac)

Programming Languages

JavaScript is a lightweight, interpreted programming language. It is designed for creating network-centric applications. It is complimentary to and integrated with Java. JavaScript is very easy to implement because it is integrated with HTML. It is open and cross-platform.

Javascript is a MUST for students and working professionals to become a great Software Engineer specially when they are working in Web Development Domain. I will list down some of the key advantages of learning Javascript:

Javascript is the most popular programming language in the world and that makes it a programmer’s great choice. Once you learnt Javascript, it helps you developing great front-end as well as back-end softwares using different Javascript based frameworks like jQuery, Node.JS etc.

Javascript is everywhere, it comes installed on every modern web browser and so to learn Javascript you really do not need any special environment setup. For example Chrome, Mozilla Firefox , Safari and every browser you know as of today, supports Javascript.

Javascript helps you create really beautiful and crazy fast websites. You can develop your website with a console like look and feel and give your users the best Graphical User Experience.

JavaScript usage has now extended to mobile app development, desktop app development, and game development. This opens many opportunities for you as Javascript Programmer.

Due to high demand, there is tons of job growth and high pay for those who know JavaScript. You can navigate over to different job sites to see what having JavaScript skills looks like in the job market.

Great thing about Javascript is that you will find tons of frameworks and Libraries already developed which can be used directly in your software development to reduce your time to market.

Overview

Syntax

Enabling

Placement

Variables

Operators

If…Else

Switch Case

While Loop

For Loop

For…in

Loop Control

Functions

Events

Cookies

Page Redirect

Dialog Boxes

Void Keyword

Page Printing

 

JavaScript Objects:

Objects

Number

Boolean

Strings

Arrays

Date

Math

RegExp

HTML DOM


JavaScript Advanced:

Error Handling

Validations

Animation

Multimedia

Debugging

Image Map

Browsers

Overview

Environment Setup

Basic Syntax

Variable Types

Basic Operators

Decision Making

Loops

Numbers

Strings

Lists

Tuples

Dictionary

Date & Time

Functions

Modules

Files I/O

Exceptions

Advanced Tutorial:

Classes/Objects

Reg Expressions

CGI Programming

Database Access

Networking

Sending Email

Multithreading

XML Processing

GUI Programming

Further Extensions

HTML5 is the latest and most enhanced version of HTML. Technically, HTML is not a programming language, but rather a markup language. In this tutorial, we will discuss the features of HTML5 and how to use it in practice. This tutorial has been designed for beginners in HTML5 to make them understand the basic-to-advanced concepts of the subject.

Syntax

 

Attributes

Events

Web Forms 2.0

SVG

MathML

Web Storage

Web SQL Database

Server-Sent Events

WebSocket

Canvas

Audio & Video

Geolocation

Microdata

Drag & drop

Web Workers

IndexedDB

Web Messaging

Web CORS

 

Web RTC

Cascading Style Sheets, fondly referred to as CSS, is a simple design language intended to simplify the process of making web pages presentable.

CSS is a MUST for students and working professionals to become a great Software Engineer specially when they are working in Web Development Domain. I will list down some of the key advantages of learning CSS:

  • Create Stunning Web site – CSS handles the look and feel part of a web page. Using CSS, you can control the color of the text, the style of fonts, the spacing between paragraphs, how columns are sized and laid out, what background images or colors are used, layout designs,variations in display for different devices and screen sizes as well as a variety of other effects.

  • Become a web designer – If you want to start a carrer as a professional web designer, HTML and CSS designing is a must skill.

  • Control web – CSS is easy to learn and understand but it provides powerful control over the presentation of an HTML document. Most commonly, CSS is combined with the markup languages HTML or XHTML.

  • Learn other languages – Once you understands the basic of HTML and CSS then other related technologies like javascript, php, or angular are become easier to understand.

Visibility

Positioning

Layers

Pseudo Classes

Pseudo Elements

@ Rules

Text Effects

Media Types

Paged Media

Aural Media

Printing

Layouts

Validations

Tutorial

Rounded Corner

Border Images

Multi Background

Color

Gradients

Shadow

Text

Web font

2d transform

3d transform

Animation

Multi columns

User Interface

Box Sizing

 

Responsive Web Design

We can add any course on-demand.

Open chat
Hello
Can we help you?