Auto Insert Data in Excel Table

This tutorial is very helpful and will save your time if you are using excel sheets in your office or home.In big organisations, there are a lot of data to enter that's why I think this is very helpful tutorial to data entry operators.

How to find required value from database.

In this topic, we will learn how to find required value from a database.There are two ways to find or retrieve required data one is VLOOKUP and second is INDEX and MATCH function.We will use the index and match function in this tutorial.If this tutorial helpful for you then don't forget to share and like this video.

How to create mini database in excel

Today's world database is necessary to keep your record in an organized way.If we have so much record to save then we create a database but what, if we want to retrieve one particular record from the database.  Obviously, there required a lot of time to retrieve data because in a company hundred and thousands of employees.To avoid from consuming the time, here is the solution in this tutorial.If you like this tutorial then don't forget to share.

How to send an email to multiple recipients by using mail merge.

If you want to send an email to multiple recipients then what you will do. Of-course there will be a lot of time required to edit again and again, but you can save your time by watching this video.In this tutorial, you can see I'm using mail merge.Mail merge is a feature in Microsoft Word that links database to your documents once it's linked then automating your documents will be edited by a single click.