Knowledge Inn

For all those users who want to understand and learn how to apply formula in excel sheet. In this lecture, we will discuss how to apply formula. Very simple and easy way to understand formula. Basics of formula

Sum Formula (to get total of values)
Average Formula (to get mean of values)
Minimum Formula (to obtain minimum value)
Maximum Formula (to obtain maximum value from arry )
Right formula (to get a partial value from right side)
Left formula (to get the partial value from left side of text )
mid formula (to get mid number / text )
Difference between count and counta
Difference between & , jointext and concat
https://youtu.be/yopvoYeYdPI

In order to learn basics of excel appreance see my video 01 as link is : https://www.youtube.com/watch?v=YatGO_eh3go

want to learn how make table see following vide of lecture 02: https://www.youtube.com/watch?v=jGMgezuQqv4

See my Channel and subscribe for more useful videos: https://www.youtube.com/kinn786

Link for the working file is
https://drive.google.com/file/d/1qG-uHplyf5M7OgqybEXPEknENCMfUFUL/view?usp=sharing

3rd lecture: Basic formula tutorial ... How to apply sum formula, average formula, Jointext, min. For all those users who want to understand and learn how to apply formula in excel sheet. In this lecture, we will discuss how to apply formula. Very simple ...

Want to learn Ms excel

Accelerate to output by adding skill (Training Announcement EXCEL) Data Filters | Data Sorting | Pivot Tables | Data Validation | Shortcut Keys | Charts and Analysis | Formulas | Function | Vlookup | Index | Match | Conditio...

Today we observe 15th August as Black Day across Pakistan and on both sides of the Line of Control.
Black Day is being observed in protest against illegal Indian action to change the disputed status of Indian Occupied Jammu & Kashmir.