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