# Video Tutorials

The only thing better than getting new software is learning how to master it with fun, educational tutorials. Whether you want to learn how to use new features, create projects or apply advanced techniques, we can show you how. Watch and download Video Turtoials.

## SubTotal In Excel

 How we calculate the SUBTOTAL of given Range. Learn This in This Video

## Create Pivot Tables in Excel

 Pivot Tables are interactive tables that allow the user to group and summarize large amounts of data in a concise, tabular format for easier reporting and analysis. They can sort, count, and total the data, and are available in a variety of spreadsheet programs. One advantage of this feature in Excel is that it allows you to rearrange, hide, and display different category fields within the Pivot Table to provide alternate views of the data.Watch this video and learn how to create your own pivot table in Excel.

## WorkSheets and Sheets object in Excel VBA

 In this Video, you will learn About WorkSheets and Sheets object in Excel VBA. How we manipulate the date in different worksheets. This is very simple video we explain everything with simple example. Watch video and Share with your friends.

## Function In MS Excel

 In this video tutorials we learn about the MS Excel Built in Function.This is lesson no 3. if you are new user then please must view the first two lesson to understand this tutorial. if you like this then share with your friends.

## IF Function in MS Excel

 The Excel IF function is decision making function. this function checks the values in given cell. match with our given condition and put the result according to our given criteria. watch this video to learn excel If function in Urdu.

## Nested IF Statement and Worksheet cell Change Event

 In this Video, you will learn About Nested IF Statement and Worksheet cell Change Event in Excel VBA. In this lesson you will learn that How we Run a Excel Macro when we change the value of any Cell in Excel. This is very simple video we explain everything with simple example. Watch video and Share with your friends.

## Consolidate Data in Excel

 Consolidate function is used to combine the data form different range to on location. Watch This video and share with you friends

## Do Until, While, Do While Loop In Excel VBA

 In this Video, you will learn About The Use of all The loop in Excel VBA. In this lesson you will learn About Do Until Loop, While loop and Do While loop in Detail. First we understand the definition of all loops and Then we explain everything with simple example. Watch video and Share with your friends.

## FOR LOOP in Excel VBA Macro programming

 In this Video, you will learn About Loop. Especially in This Lesson we Discuses For loop in Excel VBA. In this lesson you will learn that How we Use for loop in inserting, a Deleting and copying the records in excel. This is very simple video we explain everything with simple example. Watch video and Share with your friends.

## Data Entry Through Form In Excel

 In this video you Can watch and learn that how we enter the data in Excel Table through Form .A form provides a convenient way to enter or display one complete row of information in a table without scrolling.Using the form, you can enter data faster and when you Tab to the end of the form, you can press Enter Key to start another record. Learn More Watch This Video. Share with your friends

## Nested IF Function in Excel

 This tutorials guide you that how you can use Nested if In Excel 2007 and excel 2010. Watch this video and share with your friends.