Knowledge Inn

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

‏‎بھیگتی آنکھوں کے منظر نہیں دیکھے جاتے

ہم سے اب اتنے سمندر نہیں دیکھے جاتے

زندہ رہنا ہے تو حالات سے ڈرنا کیسا

جنگ لازم ہو تو لشکر نہیں دیکھے جاتے

31/12/2020

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, , ,

22/12/2020

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

, , ,

14/12/2020

https://youtu.be/Y0npxWDUCt0

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

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

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

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

Data Filters | Data Sorting | Pivot Tables | Data Validation | Shortcut Keys | Charts and Analysis | Formulas | Function | Vlookup | Index | Match | Conditio...

31/12/2019

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!

15/08/2019

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.