Knowledge Inn
08/08/2020
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 ...
17/07/2020
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.
Click here to claim your Sponsored Listing.
Category
Contact the school
Telephone
Website
Address
Lahore
54600
Opening Hours
| Monday | 09:00 - 21:00 |
| Tuesday | 09:00 - 21:00 |
| Wednesday | 09:00 - 21:00 |
| Thursday | 09:00 - 21:00 |
| Friday | 09:00 - 21:00 |
| Saturday | 09:00 - 21:00 |