Professional 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

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)