My YOUTUBE channel Hindi videos are available on this page.
Click on the link to open a video in Hindi.
To read the BLOG and understand the excel functions, please go to the Home page given above.
Video No. 26:
CONCATENATE is the tool that would like to help us to joint the things in Excel. It creates joints between two or more values and providing a result but THIS VIDEO WILL HELP YOU TO UNDERSTAND CONCATENATE PART-2
Watch it now...
Video No. 25:
This video will help you in learning small but the BEST functions we need while bulk data received from different sources. Using this video, we can arrange all the data in perfect formatting and can find-out the wrong data. Watch it now to learn SMALL BUT BEST. I am sure it will help you to make your data perfect.
Watch it now...
Video No. 24:
COUNT series is one of the most powerful series in Excel. It helps us to reach to the goal via different ways like simple COUNT, Conditional COUNTIF Function, and Multiple Conditional Function COUNTIFS. Today everyone wants to complete their tasks in minimum time as they want to use balance time for him/herself. So, guys watch the video till the end to learn many important things including DIFFERENCE in the functions.
Watch it now...
Video No. 23:
These three functions are the power tool of the excel because everyone while working in Excel is needed. Today everyone wants to maintain their data somewhere, wherefrom they can collect any time they want and it’s called digital generation. So guys AVERAGE, MINIMUM and MAXIMUM function are always very important for each and every type of business, JOB, and study.
Watch it now...
Video No. 22:
HLOOKUP is one of the most powerful tools in Excel. The HLOOKUP function can use the relational data essentials of two separate tables and affix the data from one table to the other table. To make it better then simple HLOOKUP we need to use MATCH function and it makes our life really easy.
Watch it now...
Video No. 21:
This video contains many functions called the FILL option. In this video we will let you know about the DATA & FORMATTING transfer from 1 SHEET to 100 SHEETS in 1 second, WEEKDAYS filling in sequence, DATES, MONTHS, YEAR auto-filling.
Watch it now...
Video No. 20:
SUMPRODUCT function is one of the moistest powerful tools in Excel. It will help us to save our maximum time while preparing any report or searching for anything using multiple or single criteria.
Watch it now...
Video No. 19:
TOPIC: CONCATENATE
CONCATENATE is the tool that would like to help us to joint the things in Excel. It creates joints between two or more values and providing a result.
Watch it now...
Video No. 18:
TOPIC: SUMPRODUCT & SUMIF FUNCTION
This video is related to SUMPRODUCT & SUMIF Function. SUMIF & SUMPRODUCT is one of the most powerful tools in Excel. The same is helping us to complete our few hours of daily routine tasks in only a few minutes.
Watch it now...
SUBSCRIBE...LIKE...COMMENTS
Link: Click here for video in Hindi.
Video No. 17:
TOPIC: FLASH FILL FUNCTION
FLASH FILL is a small function but one of the most powerful tools in Excel or I can say a MAGICAL TRICK.
Video No. 16:
TOPIC: SUMIFS & SUM
SUMIFS & SUM is one of the most powerful tools in Excel. The same is helping us to complete our few hours of daily routine tasks in only a few minutes.
Watch it now...
SUBSCRIBE...LIKE...COMMENTS
Link: Click here for video in Hindi.
Video No. 15:
This video will help in learning to repeat the Heading at TOP of every page you want to print.
Video No. 14:
TOPIC: DOUBLE HLOOKUP - Most important for Interview
This video will help in learning an ADVANCE HLOOKUP, This function is very most important to crack the INTERVIEW in most of the Multi-national companies.
Video No. 13:
TOPIC: Advance One Time HLOOKUP
HLOOKUP is one of the most powerful tools in Excel but this video will show you to use HLOOKUP in different ways with a MAGICAL TRICK, and after learning this everyone will say that you are the one and only who knows about the excel.
Video No. 12:
TOPIC: Basic HLOOKUP
HLOOKUP is one of the most powerful tools in Excel. The HLOOKUP function can use the relational data essentials of two separate tables and affix the data from one table (Available in Rows) to the other table.
Video No. 11:
A combination of the VLOOKUP and MATCH function is the MOST POWERFUL tool in excel. This is the most favorite function in excel. LOVED IT...
Video No. 10:
This video will help in learning an ADVANCE VLOOKUP, This function is very most important to crack the INTERVIEW in most of the Multi-national companies and corporates.
Video No. 9:
TOPIC: Advance One Time VLOOKUP
VLOOKUP is one of the most powerful tools in Excel but this video will show you to use VLOOKUP in different ways with a MAGICAL TRICK, and after learning this everyone will say that you are the one and only who knows about the excel.
Video No. 8:
TOPIC: Basic VLOOKUP
VLOOKUP is one of the most powerful tools in Excel. The VLOOKUP function can use the relational data essentials of two separate tables and affix the data from one table (Available in Columns) to the other table.
Video No. 7:
TOPIC: Hyperlink Function
If you are having any document which you are not using on a daily basis…This function is very useful for you…
You don’t need to keep the path remember (Path= where file placed) in your mind…only watch it now in Hindi with multiple and good examples…
Video No. 6:
This video will help you in learning GOOGLE SHEET and sharing documents from GOOGLE DRIVE.
After this video, you can share any of your documents on Google Drive and anyone can see the documents/photos/videos, etc. have links shared by you.
Many of the companies are there who don't allow you to share documents/image/video, etc. heavier than 2mb. In that case, you can share the documents on GOOGLE DRIVE and can access the same from anywhere in the world.
Video No. 5:
In case conditions are only two we can use IF Function but if the conditions are more than two and you don't know how to do it?
Watch it now...
SUBSCRIBE...LIKE...COMMENTS
Link: Click here for video in Hindi.
Video No. 4:
TOPIC: IF with NOT Function
If you are having any task where you need to generate results saying that the so and so related things should not be as a result…but don't know how to do...
Watch it now...
SUBSCRIBE...LIKE...COMMENTS
Link: Click here for video in Hindi.
Video No. 3:
TOPIC: IF with OR Function
This video will help to all of them who want to use multiple criteria and minimum one wants to be fulfilled in IF Function.
Watch it now...
SUBSCRIBE...LIKE...COMMENTS
Link: Click here for video in Hindi.
Video No. 2:
TOPIC: IF with AND Function
This video will help to all of them who want to use multiple criteria and minimum one wants to be fulfilled in IF Function.
Watch it now...
SUBSCRIBE...LIKE...COMMENTS
Link: Click here for video in Hindi.
Video No. 1:
TOPIC: IF Function
This video will help to all of them who want to use multiple criteria and minimum one wants to be fulfilled in IF Function.
Watch it now...
SUBSCRIBE...LIKE...COMMENTS
Link: Click here for video in Hindi.
I will be back with many more videos related to excel, if you need any help in excel, put your comments on my blogs or at youTube channel (ASHVI CITY - Mr. Excel). You will see that in a few days only I am there with a video to solve your problem and make you excel friendly.
To read the BLOG and understand the excel functions, please go to the Home page given above.
TOP (Click to reach to the TOP and refresh the page)
Comments
Post a Comment