How to Filter data in Excel | How to apply filter in Excel sheet

 Home Page.                 Vipin sir Live Test Class -10

               In the previous topic I will discuss how to Create a designer Table in ms Excel . If you don't shee the previous part then see it . In this part I will discuss about how to Filter data in Excel. First we make a Table like the below picture.

In the above picture given the date wise. If you want to Filter it then you follow the sixth step. 

Step 1 :-

              In this step we go to the small filter icon in table. Icon look like a below picture pointed by mouse pointer. When you click this icon then filter is open like the below picture. In this picture data filter all options is check. 

When all options is check then all table is show in your screen. If all options are not checked then all table is not show. In this case I say that Excel filter is apply.

Step 2:-

              In this step uncheck the all show option in the filter box. If you click ok then all table data is eliminate. So don't click the ok without fallow the all step.

Step 3:-

             In this step select the month whose date is filter right now. When you click the month then open the picture like below. But date is not show then click the + icon in left side of month.

Step 4:-

            In this step when you click the left side of month + icon all month is show like the below picture.

Step 5:-

           In this step select the date whose date is filtering. When you select the date then look at the screen like below picture.

Step 6:-

            First you fallow all the above steps then In this step click ok button. As soon as you click the ok button then open the change table like below picture.

  Again you want to eliminate the filter then you goto the filter icon and select the show all and click the ok button. Your all table is show again.

Some other topics:-

1. How to Create a designer Table in MS Excel 

2. HTML Basic Programming Language Part -1

3. TextBox change Module 

4. Who to Solved Script Error in MS Excel 

5. Use Vlookup Formula in MS Excel UserForm TextBox 

6. Who to Lock your MS Excel File 

7. MS Excel UserForm Save And Edit Module Part-1 

8. MS Excel UserForm Save And Edit Module Part-2 

9. TextBox Enter module. 

10. Daily Current Affairs | most important Questions 

How to Create a Table in Excel | How to Create a designer Table in MS Excel

 Home Page.        Vipin Sir Live Test Class -10

     In this topic I will discuss about how to make a Table in MS Excel sheet . When you think to make a Table in Excel then you select the shell range in MS Excel sheet and goto the insert option in tital bar and click the table. You table is generated automatically. Today I will discuss the practical of how to Create a designer Table in Excel.

It is completed in fourth step:-

 Step 1 :- first we go to the MS office and select the MS Excel. MS Excel sheet is open like the below 👇

In the above picture select the shell A13:J13 and look at the insert option is pointed. Insert option click then table option is show in the below.

Step 2:-

               In this step click the table option then create table option is open like the below picture. In this picture your selected cell is fill automatically if you want to any changes then you can change it . Your cell range is right then Click the ok button. 

Step 3:-

          Your table is generated like this below picture. In this picture you look at the design options. Design options is show many of the features of table. 

Step 4:-

             When you click the design options then show the same picture as usual at the below. Most of the design features is show. When you select the any tablet style then select table style is apply in your table. 

Finally you make a designer Table in the MS Excel. If you want to see other interesting topics the click the below options and enjoy your computer learning.

Some other topics:-

1. HTML Basic Programming Language Part -1

2. TextBox change Module 

3. Who to Solved Script Error in MS Excel 

4. Use Vlookup Formula in MS Excel UserForm TextBox 

5. Who to Lock your MS Excel File 

6. MS Excel UserForm Save And Edit Module Part-1 

7. MS Excel UserForm Save And Edit Module Part-2 

8. TextBox Enter module. 

9. Daily Current Affairs | most important Questions 

                  

How to use Round Functions in MS Excel with example and practical

 HOME PAGE 

Round Functions:-

                                Round Functions is use in a MS Excel Numerical cell value. Three type of  Round Functions .

1. ROUND Functions 

2. ROUNDUP Functions 

3. ROUNDDOWN Functions 

1. Round Functions:-

                                      Round Functions is also known as Roundup and Rounddowm Functions because he works in two ways.  Fist method is if cell value is greater than 0.5 then Round Functions work as Roundup Functions ans when cell value is less than 0.5 then Round Functions is work as Rounddowm Functions. 

Example 1. If cell value is 68.4 then find the Round , Roundup, Rounddowm  Functions value. 

Solution:-

                Round value = 68

              Roundup value = 69

            Rounddowm value = 68

Know look at the practical sheet:-

Round Functions practical sheet:-

Results of practical sheet:-

Roundup Functions Practical sheet:-

Results of above Formula:-

Rounddowm Functions practical sheet:-

Results of above Formula:-

Example 2. Find the one ,two, three, four digit Decimal number Round Functions value.  If the number is 689.6544. 

Solution:-

               Given Number is   689.6544

A)Decimal Number two digits round Functions used,  then find the value is 689.65. 

B) Decimal Number three digits Round Functions used, then find the value is 689.654

C) Decimal Number Fourth digits round Functions used, then find the value is 689.6544

D) Decimal Number one digits round Functions used, then find the value is 689.7

E) Decimal Number zero digits round Functions used ,then find the value is 690

These are above some examples of round Functions and its value is given.  Know you goto the excel sheet and practice it.  

Difference of Round Functions, Roundup Functions, and Rounddowm Functions:-

                                                                    The basic differences of in this function is that Round Functions gives the value in the base of Round Functions rule , Roundup Functions gives the +1 value is every condition and Rounddowm Functions gives the -1 value is every condition. 

Round Rule:-

                         Many type of Round Functions rule. Someone can write the below. 

1. If the given number value is greater then 0.5 then the round Functions gives the result (number + 1)

2. If the given number value is less then  0.5 then Round Functions gives the result (number  - 1)

MS Excel: How to use the If Function with example and practical

 HOME PAGE 

About of Logistics functions:-

                                                     It is also known as the conditional function. If functions is one of these . 

If functions:-

Examples 1. Write a formula who find the greater number and smaller number.  If two number is given.     

Solution:-

                  Let's   Fist number a is = C3

                        Second number b is = C4

    Formula   [ = if(C3>C4,"a is greater than b","b is greater than a")   ]

Look at my practical sheet:-

Result of practical sheet:-

When changes the value of a and b then result will be changed. 

Example 2. Find the value of functions =80÷8÷2.

Solution:- 

             This type of functions solved in two step

Step1.   80÷8  = 10

Step 2. 10÷3   = 5 Ans

Look at the practical sheet :-

Result of above Formula:-

Example 3. Write a formula who find the failure and pass students in your classroom.  Students data is given in the excel sheet. 

Solution:-

     Look at the practical sheet and sea the using of If Functions :-

Other Cell If function Formula:-

Example 4. 

Compound Interest Calculator Formula for MS Excel with examples and practical

HOME PAGE

Compound Interest:-

                                      Compound Interest is known as the interest of interest.  He provide the multiple benefits. Compound Interest > Simple interest. 

Compound Interest = p[{1+(r÷100)^t}-1]

Results of above sheet:-

Other Results :-

Simple interest calculator Formula:-

                                                                 Simple interest, Interest is equal every year if principal amount is not charged. 

Simple interest = (P×t×r)÷100

Practical sheet is given in previous Page Click 

Example 1. Write a MS Excel Formula who calculate the difference of compound Interest and Simple interest. 

Solution:- 

                  Let's  P = C1 

                             t = C2

                             r = C3

       Different of SI and CI = C5

Results of above sheet Formula:-

Other Results:-

Example 2. Write a formula who calculated the 5year compound Interest,  If principal amount is 8000 and rate 10%  par year. 

Solution:-

                 Let's   D3 = Principle Amount

                            D4 = rate of interest 

                            D5 = Time 

  Formula    [  =D3×((1+(D4÷100))^D5)  ]

Results of this example:-

                            

Other Page

1. All Mathematical Formula used in MS Excel with example and practical 

2. MS Excel VBA Codding Project 

3. All Mathematical Formula used in MS Excel UserForm 

4. VLOOKUP Formula used in MS Excel UserForm 

5. Best MS Excel security Locker 

6. MS Excel: How to use If Function with example and practical 

All Mathematical Formulas used in [MS Excel] with examples and practical

 HOME PAGE 

1. Addition Formula use in [ MS Excel ] :-

                                    In the Normal condition when the two given no add like ( 3+6)=9 . But the ms excel is a application software . He provides the sheet (like a black copy) . A sheet provides a lot of ms excel cells.  

Let's go to a example and solved the problem in ms excel sheet. 

Example 1. Write a formula to add the given no 34,54,76,24,80 if cell is anything.

Solution:-

                 Let A1 cell = 34

                        A2 cell = 54

                        A3 cell = 76

                        A4 cell = 24

                        A5 cell = 80

Formula    [ =A1+A2+A3+A4+A5 ] 

Look the practical sheet and Solution:-

Result :-

Example 2. Write the Additional Formula if cell value is given A2=56, B6=40, D5=76 Write the result in cell B8 ?

Solution:-

                 Formula   [ =A2+B6+D5 ]

Look the practical sheet, who to apply Formula and Additional Formula result :-

Additional Formula result:-

Example 3. Write a formula who add all the value of columns A and B and show the result in D3 cell. 

Solution:-

         Formula  is [ =sum(A:A+B:B) ]

This Formula is working only Google works sheet

   MS Excel Formula  [ =sum(sum(A1:A8)+sum(B1:B8))]

Look at the Additional example practical sheet:-

Result of Formula:-

Example 4. Write a formula who add the given cell value.  A1,A2,A3,A4,A5,A6,A7,A8,A9 and B1,B2,B3,B4,B5,B6,B7,B8,B9 and write the result in cell B11.

Solution:- 

 Formula of this Addition  [ =sum(sum(A1:A9)+sum(B1:B))]

Practical sheet of above Formula:-

Result practical sheet:-

Note :- Substation and  multiplication  process is same as the Additional Formula.  If change the Additional symbol (+) your Formula is charged according you.

Example:-

1.  Substation Formula 

a)   =A1-A2

Look practical sheet:-

Result:-

b)   =D5-E4

Practical sheet of above Formula:-

Result of Formula sheet:-

Note:- standard Formula of Additional example 3 and 4 is not applicable for the substantial and multiplication function. 

2. Multiplication Formula 

a)  = A1×A2×A3×A4

Project sheet of above Formula:-

Note :- If you drop any cell value the result is 0 find because cell default value is equal to 0.

Result:-

b)  =C3×B4×K8

Project sheet of above Formula 

Results of this example:-

Example 5. Write a formula who calculated the simple interest,  if all the value is given.

Solution:- 

                we khon that SI = (P×t×r)/100

Where P = Principle Amount 

             t = Time

             r = ratio 

Let C1 =P

       C2 = t

       C3 = r

Then

MS Excel Formula for this problem 

              =((C1×C2×C3)/100)

Look the practical sheet of above Formula:-

Result of above sheet Formula:-

My practical vedio:-

Other Page

   1. 10 Important Formula applies in [ MS Excel] Sheet

  2. Important Excel Project using VBA Codding

  3. IAS / PCS Best Book And PDF Note

  4 . (4 )Important Excel Codding tips 

  5. Compound Interest calculator Formula for MS Excel