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:
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
Expand 74 lectures
Advance Excel Training
Autofill Number and text
Autofill Adv tools
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
Hide Formulas and unlocked Cell
Protect File with password
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 – Advance
Chart Preparation – Customise
Conditional Formatting – Types of Rules
Conditional Formatting – Apply
Conditional Formatting – Create New Rules
Conditional Formatting – Mange Rules
Data Validation – Input message and Error Alert
Advance Math Function
Advance Math Function 2
Using of Wild Card in Math Function
Vlookup with Iferror
Vlookup Nesting with If
Index and match nested
Vlookup column func trick
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.
Duplicate Query Wizard
Unmatched Query Wizard
Create A Form
Modify A Form
Controls & Properties
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)
Date & Time
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.
Web Forms 2.0
Web SQL Database
Audio & Video
Drag & drop
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.
Responsive Web Design