Purpose of this page is to share knowledge and information
11/06/2022
Bring and complete video on count family.
https://youtu.be/nsKDP95bhMQ
This video contain complete detail of the count, countA, countblank, countif with simple condition, countif application with number condition, countif application with WILDCard.
12/05/2021
بھیگتی آنکھوں کے منظر نہیں دیکھے جاتے
ہم سے اب اتنے سمندر نہیں دیکھے جاتے
زندہ رہنا ہے تو حالات سے ڈرنا کیسا
جنگ لازم ہو تو لشکر نہیں دیکھے جاتے
In this video, we will learn about the auto countdown in excel. It will cover many formulas like int, date, year, month, day, hour, minute and second formula.
6:14 In this part, we will also learn about the macro.
7:11 This part is related with the Birthday alter via excel file also containing conditional formating, upcoming date
14:10 This portion of the video is related to the due date of the loan borrowed or lend. Due date is the important part. For this, we have to calculate and understand NESTEDIF formula. This video also explains how to use more than one formula in a cell.
File link
https://drive.google.com/file/d/1Ny98FTSFwMDOH-wgN74-FtdrgMw8tHkf/view?usp=sharing
Macro Link
https://drive.google.com/file/d/1JnwxQGx5w7e_21TPlWcoIJjBc37vEZDV/view?usp=sharing
, #2021, , ,
In the lecture, we will discuss the top 25 shortcut keys of Ms. Excel. (Each shortcut key has been separated as a chapter in this video you can go directly to your required shortcut key by pressing the chapter in the left top corner)m I usually use these shortcut keys to do my magical work. These keys are very helpful in doing your official work, school assignments, and other routine jobs. Following are the shortcuts keys will discuss in this video: -
0:00 Introduction to Shortcut Keys
1:13 Channel request
1:35 Shortcut key to Select a Row
1:53 Shortcut key to select a Column
2:09 Shortcut key to select the complete sheet
2:33 Shortcut key to insert a row
2:49 Shortcut key to insert a column
3:02 Shortcut key to remove duplicate
3:29 Shortcut key to apply filter
3:50 Shortcut key to adjust the width of the column
4:20 Shortcut key to apply comma
4:37 Shortcut key to add currency sign
5:02 Shortcut key to reduce value after the decimal
5:18 Shortcut key to add the percentage
5:43 Shortcut key to Auto Sum
6:07 Shortcut key to insert date and time
6:26 Shortcut key to open font menu
6:39 Shortcut key to hide row, Shortcut key to hide column
6:53 Shortcut key to open a new sheet and Rename a sheet
7:14 Shortcut key to hide/unhide tab
7:31 Shortcut key to apply the border
8:03 Shortcut key to clear format
8:14 Shortcut Key to clear format and text
8:27 Shortcut key to remove comma
8:53 Shortcut key to show the formula
, , ,
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 ...
27/07/2020
The second lecture on Ms. Excel is available which covers the following points: -
How to create a table in excel sheet
Selecting a table and control A function
How to remove banned rows in the table
How to add 8 formulas without memorizing in table
The benefit of Table, As it scrolls down it replace with alphabets automatically
How to insert slicer
How to customize slicer
How to use a slicer
The difference between filter and slicer
Learning formulas of SUM, AVERAGE, COUNT, COUNT NUMBER, MINIMUM, MAXIMUM, VARIANCE, AND STANDARD DEVIATION
visit my channel: www.youtube.com/kinn786
or
Directly video: https://youtu.be/jGMgezuQqv4
Lecture 02, Excel Table Tutorial, Excel table basics, Create Table, Excel Table formatting, slicer How to create a table in an excel sheet. Selecting a table and control A function. How to remove banned rows in the table. How to 8 learn formulas without me...
19/07/2020
https://youtu.be/YatGO_eh3go
First lecture on air
1st Lecture Excel Introduction to Microsoft Excel | Baby step toward Ms. Excel | Basic Excel knowledge | Introduction to computer | Table in Excel | Tabs, groups and commands ...
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...
Here are some resolutions for the new year.
- Fight For Progress.
- Stand With The Oppressed.
- Never Be A Bystander To Injustice.
- Never Lose Hope.
Happy New Year!
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.
| 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 |