Microsoft office Excel

Use conditional formatting rules in Google Sheets

2022-12-06T01:46:00.002-08:00

Cells, rows, or columns can be formatted to change text or background color if they meet certain conditions. For example, if they contain a certain word or a number.

On your computer, open a spreadsheet in Google Sheets.
Select the cells you want to apply format rules to.
Click Format Conditional formatting. A toolbar will open to the right.
Create a rule.
- Single color: Under "Format cells if," choose the condition that you want to trigger the rule. Under "Formatting style, choose what the cell will look like when conditions are met.
- Color scale: Under "Preview," select the color scale. Then, choose a minimum and maximum value, and an optional midpoint value. To choose the value category, click the Down arrow .
Click Done.

Example

A teacher can highlight test scores to see which students scored less than 80%.

On your computer, open a spreadsheet in Google Sheets.
Select the test scores.
Click Format Conditional formatting.
Under "Format cells if," click Less than. If there's already a rule, click it or Add new rule Less than.
Click Value or formula and enter 0.8.
To choose a red color, click Fill .
Click Done. The low scores will be highlighted in red.

Excel Max Function

2022-11-30T00:06:00.000-08:00

MAX function in Excel: formula examples to find and highlight highest value

Excel MAX function

The MAX function in Excel returns the highest value in a set of data that you specify.

How to make a MAX formula in Excel

To create a MAX formula in its simplest from, you can type numbers directly in the list of arguments, like this:

=MAX(1, 2, 3)

In practice, it's quite a rare case when numbers are "hardcoded". For the most part, you will deal with ranges and cells.

The fastest way to build a Max formula that finds the highest value in a range is this:

In a cell, type =MAX(
Select a range of numbers using the mouse.
Type the closing parenthesis.
Press the Enter key to complete your formula.

For example, to work out the largest value in the range A1:A6, the formula would go as follows:

=MAX(A1:A6)

If your numbers are in a contiguous row or column (like in this example), you can get Excel to make a Max formula for you automatically. Here's how:

1- Select the cells with your numbers.
2- On the Home tab, in the Formats group, click AutoSum and pick Max from the drop-down list. (Or click AutoSum > Max on the Formulas tab in the Function Library group.)

This will insert a ready-to-use formula in a cell below the selected range, so please make sure there is at least one blank cell underneath the list of numbers that you've selected:

5 things to know about MAX function

To successfully use Max formulas your worksheets, please remember these simple facts:

1- In the current versions of Excel, a MAX formula can accept up to 255 arguments.
2- If the arguments do not contain a single number, the MAX function returns zero.
3- If the arguments contain one or more error values, an error is returned.
4- Empty cells are ignored.
5- Logical values and text representations of numbers supplied directly in the list of arguments are processed (TRUE evaluates as 1, FALSE evaluates as 0). In references, logical and text values are ignored.

How to use MAX function in Excel – formula examples

Below you will find a few typical uses of the Excel MAX function. In many cases, there are a few different solutions for the same task, so I encourage you to test all the formulas to choose the one best suited for your data type.

How to find max value in a group

To extract the largest number in a group of numbers, supply that group to the MAX function as a range reference. A range can contain as many rows and columns as you desire. For example, to get the highest value in the range C2:E7, use this simple formula:

=MAX(C2:E7)

How to use the SUMIF Function?

2021-10-30T09:35:00.004-07:00

MS Excel: How to use the SUMIF Function (WS)

This Excel tutorial explains how to use the Excel SUMIF function with syntax and examples.

Description

The SUMIF function is a worksheet function that adds all numbers in a range of cells based on one criteria (for example, is equal to 2000).

The SUMIF function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the SUMIF function can be entered as part of a formula in a cell of a worksheet.

To add numbers in a range based on multiple criteria, try the SUMIFS function.

Syntax

The syntax for the SUMIF function in Microsoft Excel is:

SUMIF( range, criteria, [sum_range] )

Parameters or Arguments

range

The range of cells that you want to apply the criteria against.

criteria

The criteria used to determine which cells to add.

sum_range

Optional. It is the range of cells to sum together. If this parameter is omitted, it uses range as the sum_range.

Returns

The SUMIF function returns a numeric value.

Applies To

Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Function

Worksheet function (WS)

Example (as Worksheet Function)

Let's explore how to use SUMIF as a worksheet function in Microsoft Excel.

Microsoft Excel

Based on the Excel spreadsheet above, the following SUMIF examples would return:

=SUMIF(A2:A6, D2, C2:C6)

Result: 218.6 'Criteria is the value in cell D2

=SUMIF(A:A, D2, C:C)

Result: 218.6 'Criteria applies to all of column A (ie: A:A)

=SUMIF(A2:A6, 2003, C2:C6)

Result: 7.2 'Criteria is the number 2003

=SUMIF(A2:A6, ">=2001", C2:C6)

Result: 12.6 'Criteria is greater than or equal to 2001

=SUMIF(C2:C6, "<100")

Result: 31.2 'Adds values in C2:C6 that are less than 100 (3rd parameter is omitted)

Now, let's look at the example =SUMIF(A2:A6, D2, C2:C6) that returns a value of 218.6 and take a closer look why.

First Parameter

The first parameter in the SUMIF function is the range of cells that you want to apply the criteria against.

Microsoft Excel

In this example, the first parameter is A2:A6. This is the range of cells that will be tested to determine if they meet the criteria.

Second Parameter

The second parameter in the SUMIF function is the criteria that will be applied against the range, A2:A6.

Microsoft Excel

In this example, the second parameter is D2. This is a reference to the cell D2 which contains the numeric value, 2000. The SUMIF function will test each value in A2:A6 to see if it is equal to 2000.

Third Parameter

The third parameter in the SUMIF function is the range of numbers that will potentially be added together.

Microsoft Excel

In this example, the third parameter is C2:C6. For every value in A2:A6 that matches D2, the corresponding value in C2:C6 will be summed.

Using Named Ranges

You can also use a named range in the SUMIF function. A named range is a descriptive name for a collection of cells or range in a worksheet. If you are unsure of how to setup a named range in your spreadsheet, read our tutorial on Adding a Named Range.

For example, if we created a named range called years in our spreadsheet that refers to cells A2:A6 in Sheet1 (Notice that the named range is an absolute reference that refers to =Sheet1!$A$2:$A$6 in the image below):

Microsoft Excel

We could use this named range in our current example.

Microsoft Excel

This would allow us to replace A2:A6 as the first parameter with the named range called years, as follows:

=SUMIF(A2:A6, D2, C2:C6) 'First parameter uses a standard range

Result: 218.6

=SUMIF(years, D2, C2:C6) 'First parameter uses a named range called years

Result: 218.6

Frequently Asked Questions

Question: I have a question about how to write the following formula in Excel.

I have a few cells, but I only need the sum of all the negative cells. So if I have 8 values, A1 to A8 and only A1, A4 and A6 are negative then I want B1 to be sum(A1,A4,A6).

Answer: You can use the SUMIF function to sum only the negative values as you described above. For example:

=SUMIF(A1:A8,"<0")

This formula would sum only the values in cells A1:A8 where the value is negative (ie: <0).

Question:In Microsoft Excel I'm trying to achieve the following with IF function:

If a value in any cell in column F is "food" then add the value of its corresponding cell in column G (eg a corresponding cell for F3 is G3). The IF function is performed in another cell altogether. I can do it for a single pair of cells but I don't know how to do it for an entire column. Could you help?

At the moment, I've got this:

=IF(F3="food"; G3; 0)

Answer:This formula can be created using the SUMIF formula instead of using the IF function:

=SUMIF(F1:F10,"=food",G1:G10)

This will evaluate the first 10 rows of data in your spreadsheet. You may need to adjust the ranges accordingly.

WHAT IS VLOOKUP?

2021-10-22T09:49:00.001-07:00

What is VLOOKUP?

VLOOKUP stands for ‘Vertical Lookup’. It is a function that makes Excel search for a certain value in a column (the so called ‘table array’), in order to return a value from a different column in the same row. This article will teach you how to use the VLOOKUP function.

1. The value you want to look up.

HLOOKUP Function in Excel With Example

2021-07-08T13:21:00.004-07:00

HLOOKUP in Excel – With Examples

HLOOKUP function in Excel is a sibling of the VLOOKUP function. The H in the HLOOKUP stands for “Horizontal” and hence it is often called Horizontal Lookup.

HLOOKUP is a very useful function for creating horizontal lookups, but as most of the tables that we deal with are vertical hence this function is not very popular.

The task of the HLOOKUP function is to search for a value in the topmost row of a table, and then return a corresponding value in the same column from a row you specify.

Definition and Syntax of HLOOKUP Function in Excel

Microsoft Excel defines HLOOKUP as a function that “looks for a value in the top row of a table or array of values and returns the value in the same column from a row you specify”.

Syntax of Excel HLOOKUP

The syntax of the HLOOKUP function in Excel is as follows:

=HLOOKUP(lookup_value,table_array,row_index_number,range_lookup)

How to Use HLOOKUP in Excel

Now, let’s understand how to use this function in Excel.

Consider, we have a Student Table as shown below:

Objective: In this case, our objective is to fetch Steve’s marks in English using Horizontal Lookup.

1- So, we will try to apply an HLOOKUP to get the result.

2- ‘lookup_value’: As we know that we have to find the marks of Steve, so our ‘lookup_value’ will be a “Steve”.

3- ‘table_array’: In this argument, we give the reference of our table i.e. A1:I4.

4- ‘row_index_num’: The ‘row_index_num’ in this case, would be 4 as here we have to fetch a value from the fourth row of the table.

5- ‘range_lookup’: ‘range_lookup’ will be FALSE as here we only want to fetch the exact match value.

The result of this formula is 61.

Example-

Now, let’s see some examples of Horizontal Lookup Function.

Using the below table, find the Marks in English of a student who has got 75 marks in Science.

We can use this formula to get the result:

=HLOOKUP(75,B2:I4,3,FALSE)

The result of this formula is 40.

Explanation:

The first argument to the function i.e. ‘lookup_value’ = 75 (Marks of the student in Science)
Second argument i.e. ‘table_array’ = B2:I4 (Range of student table)
Third argument i.e. ‘row_index_num’ = 3 (the row number whose value the HLOOKUP function should return)
Fourth argument i.e. ‘range_lookup’ = FALSE (Signifies that we only want the exact match)

Ms Excel find minimum amount formula

2021-06-24T07:54:00.001-07:00

How to find minimum figure.

=Min(select the range) then press enter.

ADVANCE FILTER IN EXCEL

2021-06-23T11:07:00.003-07:00

Advanced filtering

To filter using search:

Searching for data is a convenient alternative to checking or unchecking data from the list. You can search for data that contains an exact phrase, number, date, or simple fragment. For example, searching for the exact phrase Saris X-10 Laptop will display only Saris X-10 laptops. Searching for the word Saris, however, will display Saris X-10 laptops and any other Saris equipment, including projectors and digital cameras.

1- From the Data tab, click the Filter command.
2- Click the drop-down arrow in the column you want to filter. In this example, we'll filter the Equipment Detail column to view only a specific brand.
3- Enter the data you want to view in the Search box. We'll enter the word Saris to find all Saris brand equipment. The search results will appear automatically.
4- Check the boxes next to the data you want to display. We'll display all of the data that includes the brand name Saris.
5- Click OK. The worksheet will be filtered according to your search term.

Using advanced text filters

Advanced text filters can be used to display more specific information, such as cells that contain a certain number of characters or data that does not contain a word you specify. In this example, we'll use advanced text filters to hide any equipment that is related to cameras, including digital cameras and camcorders.

1- From the Data tab, click the Filter command.
2- Click the drop-down arrow in the column of text you want to filter. In this example, we'll filter the Equipment Detail column to view only certain types of equipment.
3- Choose Text Filters to open the advanced filtering menu.
4- Choose a filter. In this example, we will choose Does Not Contain to view data that does not contain the text we specify.
5- The Custom AutoFilter dialog box appears.
6- Enter your text to the right of your filter. In this example, we'll enter cam to view data that does not contain these letters. That will exclude any equipment related to cameras, such as digital cameras, camcorders, camera bags, and the digicam printer.
7- Click OK. The data will be filtered according to the filter you chose and the text you specified.

Using advanced date filters

Advanced date filters can be used to view information from a certain time period, such as last year, next quarter, or between two dates. Excel automatically knows your current date and time, making this tool easy to use. In this example, we'll use advanced date filters to view only the equipment that has been checked out this week.

1- From the Data tab, click the Filter command.
2- Click the drop-down arrow in the column of dates you want to filter. In this example, we'll filter the Checked Out column to view only a certain range of dates.
3- Choose Date Filters to open the advanced filtering menu.
4- Click a filter. We'll choose This Week to view equipment that has been checked out this week.
5- The worksheet will be filtered according to the date filter you chose.
If you're working along with the example file, your results will be different from the images above. If you want, you can change some of the dates so the filter will give more results.

Using advanced number filters

Advanced number filters allow you to manipulate numbered data in different ways. For example, in a worksheet of exam grades you could display the top and bottom numbers to view the highest and lowest scores. In this example, we'll display only certain types of equipment based on the range of ID #s that have been assigned to them.

1- From the Data tab, click the Filter command.
2- Click the drop-down arrow in the column of numbers you want to filter. In this example, we'll filter the ID # column to view only a certain range of ID #s.
3- Choose Number Filters to open the advanced filtering menu.
4- Choose a filter. In this example, we'll choose Between to view ID #s between the numbers we specify.
5- Enter a number to the right of each filter. In this example, we'll view ID #s greater than or equal to 3000 but less than or equal to 4000. This will display ID #s in the 3000-4000 range.
6- Click OK. The data will be filtered according to the filter you chose and the numbers you specified.

How to use vlookup in excel

2021-06-05T08:18:00.003-07:00

What is Vlookup?

Vlookup stands for "vertical lookup". It is function that makes excel search for a certain value in a column in order to return a value from a different column in the same row.

About the vlookup function:

A vlookup function exists of 4 components:

1. The value you want to look up.

2. The range in which you want to find the value and the return value.

3. The number of the column with in your defined range that contains the return value.

4. 0 or false for an exact match with the value you are looking for 1 or true for an approximate match.

=Vlookup([value],[range],[column number],[false or true])

Example:-

In our example we have a list of fruits, the amount in stock and the current price. We want to find the amount of all fruits quickly in this table.

First put on the cursor where you want to put the amounts:

In our selected cell we start put the formula =vlookup(:

Then we select the value we want to lookup, in this case it's "fruits" in cell B2:

Then select the range of table array in which we want to find the lookup value and the return value. In this case it is (H7:I11) then fix the table array press F4 one time ($H$7:$I$11):

Then the number of the column with in the defined range in which we want to look for the return value. In this case it is column 2, and "0" or "False" for an exact match with the lookup value "Fruits":

Then press enter, we get the corresponding price from the row that contains value "Fruits" with in the selected table array:

Then drag the amount then automatic fill in amount column by fruits:

In this example we only have a small list of fruits, but imagine you have a long list of data and you wish to use a certain value elsewhere in your spreadsheet. Using Vlookup (and Hlookup) the user only has to change a certain value in one worksheet and it will automatically be changed in all othe relevant places.

But what if we are not certain about the lookup value? This is when the approximate match might be useful.

Excel shortcut key

2021-06-04T07:46:00.000-07:00

Control Functions

ctrl + - = Delete Row / Column Menu

ctrl + " = Copy above cell values

ctrl + ; = Display date

ctrl + E = Flash Fill

ctrl + Q = Quick Analysis

ctrl + ~ = Show formulas/ values

ctrl + ,,(apostrophe) = Copy above formula

ctrl + 0 = Hide column

ctrl + 1 = Format Box

ctrl + 5 = Strike-through

ctrl + 9 = Hide Row

ctrl + A = Select All

ctrl + B or ctrl + 2 = Bold

ctrl + C = Copy

ctrl + D = Fill Down (Copy above)

ctrl + F = Find

ctrl + G or F5 = Go to

ctrl + H = Replace

ctrl + I or ctrl + 3 = Italic

ctrl + k = Insert Hyperlink

ctrl + L or ctrl + T = Create Table

ctrl + U or ctrl + 4 = Underline

ctrl + V = Paste

ctrl + W = Close window

ctrl + X = Cut

ctrl + Y = Repeat/Redo

ctrl + Z = Undo

ctrl + shift + enter = Enter a formula as an array formula

ctrl + Del = Delete text to the end of the line

ctrl + End = Go to the last content

ctrl + Enter = Fill selection entry

ctrl + Alt + V = Paste special box

ctrl + Arrow keys = Go to the end of data range

ctrl + F1 = Min/Restore Ribbon

ctrl + F3 = Name a cell

ctrl + F4 = Close window

ctrl + F9 = Minimize workbook

ctrl + F10 = Maximize window

ctrl + F12 = Open file

ctrl + Home = Move to cell "A1"

ctrl + minus sign = Delete selected cells

ctrl + Pg Up/Down = Switch worksheets

ctrl + Space = Select Column

ctrl + Tab = Switch workbooks

ctrl + [ = Go to precedent cells

ctrl + ] = Go to dependent cells

ctrl + S = Save

ctrl + P = Print

ctrl + Shift + L = Auto Filter

Alt Functions

alt = = insert autosum formula

alt + down arrow = display a drop - down list

alt + E + L = delete current worksheet

alt + E + M = move current worksheet

alt + F11 = visual basic editor

alt + F4 = close program

alt + F8 = macro box

alt + O + H + R = rename sheet

alt + space = control menu

alt + tab = switch program

Shift Functions

shift + alt + left arrow = ungroup rows / columns

shift + alt + right arrow = group rows / columns

shift + arrow keys or page up down = select a cell range

shift + entre = move to cell above

shift + F10 = display shortcut menu

shift + F10 + m = delete column

shift + F11 = new worksheet

shift + F2 = insert a comment

shift + F3 = insert function box

shift + F4 = find next

shift + F5 = find / replace dialog box

shift + F6 = zoom, task, sheet

shift + F7 = thesaurus

shift + F8 = add to selection

shift + F9 = calculated active sheet

shift + spacebar = select row

shift + tab = move to cell to the left

shift + home = extend the selection to the beginning of the row

When inside cell

alt + entre = start new line in cell ( warp text )

shift + arrow keys = select within cell

ctrl + shift + arrows keys = select contiguous items

F4 = anchor fix cells

Function keys

F1 = excel help menu

F2 = edit cell content

F3 = paste name

F4 = repeat action

F5 = go to

F6 = go to next pane

F7 = spell check

F8 = anchor cell to select

F9 = recalculate workbook

F10 or alt = manu bar ( kep tips )

F11 = new chart

F12 = save as

F5 + entre = go back to original cell

Misc functions

tab = move to cell to the right

window + D = minimize program

window + E = window explorer

home = go to beginning of line

entre = move to cell bellow

Arrows keys = move to new cell

= ( equals sign ) or + ( plus sign ) = start a formula

Formatting Function

ctrl + shift +! = number format

ctrl + shift + # = date format

ctrl + shift + $ = currency format

ctrl + shift + format = percentage format

ctrl + shift + & = outline border

ctrl + shift + * = select active region

ctrl +shift +; = display time

ctrl + shift + @ = time format

ctrl + shift + ^ = scientific format

ctrl + shift + _ = remove border

ctrl + shift + { = trace all precedents ( indirect )

ctrl + shift + } \= trace all dependents ( indirect )

ctrl + shift + ~ = general format

ctrl + shift + " = copy value from above cell

ctrl + shift + + = insert row / column menu

ctrl + shift + 0 = unhide column

ctrl ++ shift +9 = unhide row

ctrl +shift + arrows keys = select contiguous range

ctrl + shift + entre = entre array formula

ctrl ++ shift + F3 = create names from selection

ctrl + shift + o = select cell with comment

ctrl + shift + pg up / dn = select multiple sheets

ctrl + shift + end = extend the selection to the last used cell on the sheet

ctrl + shift + home = extend selection to the beginning of the sheet

How to insert row and column in excel data |

2021-06-01T09:30:00.000-07:00

How to add row and column in data with mouse?

First select the row where you want to add row > then press right key in your mouse > then insert automatic add row in your data.

First select the column where you want to add column > then press right key in your mouse > then insert > then click column.

How to add row and column in data with out mouse?

First select the row then press ctrl+ then automatic add row in your data.

First select the column then press ctrl+ then automatic add column in your data.

How to disable notification in google chrome browser in PC?

2021-04-16T06:47:00.001-07:00

How to disable notification in google chrome browser in PC?

Go to Google chrome > then click 3 doth on the right hand side upper corner which is customize and control google chrome >

then Click settings >

then type in the search settings "site settings" after that you can see that option then click on the site settings >

then scroll down and see the Notifications option then click on the Notifications option >

then click on the Sites can ask to send notifications > after that notifications disable has been success.

I hope this information is helpful for you.

How To Highlight Maximum And Minimum Value In Excel

2021-04-15T22:19:00.004-07:00

How To Highlight Maximum And Minimum Value In Excel

Highlight Maximum Value

Think this that you have a list of data in range A1:F7, and you want to highlight maximum values in Gross column. You need to use the conditional formatting for highlight maximum value. Just do the following steps_

1- Select the range of cells that you want to highlight the maximum values in data,

2- Go to Home tab, then click Conditional Formatting under Styles group, then click New Rule from the drop down list,

3- Select Use a formula to determine which cells to format, then type the formula in the Format values where this formula is true text box, then click Format button,

=F2=MAX($F$2:$F$7)

4- Then click Fill tab, select background color as you need then click Ok button,

5- Click ok maximum value has been highlighted.

Highlight Minimum Value

Think this that you have a list of data in range A1:F7, and you want to highlight minimum values in Gross column. You need to use the conditional formatting for highlight minimum value. Just do the following steps_

1- Select the range of cells that you want to highlight the minimum values in data,

2- Go to Home tab, then click Conditional Formatting under Styles group, then click New Rule from the drop down list,

3- Select Use a formula to determine which cells to format, then type the formula in the Format values where this formula is true text box, then click Format button,

=B2=MIN($B$2:$B$7)

4- Then click Fill tab, select background color as you need then click Ok button,

5- Click ok then minimum value has been highlighted.

What is MS Excel?

2021-04-11T11:33:00.003-07:00

What is Microsoft Excel?

Microsoft Excel is a helpful and powerful program for data analysis and documentation. It is a spreadsheet program, which contains a number of columns and rows, where each intersection of a column and a row is a cell. Each cell contains one point of data or one piece of information. By organizing the information in this way, you can make information easier to find, and automatically draw information from changing data.

Features..

Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering, and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. It allows sectioning of data to view its dependencies on various factors for different perspectives. A PivotTable is a powerful tool that can save time when it comes to data analysis. It does this by simplifying large data sets via PivotTable fields that are also known as "the building blocks of PivotTables. It has a programming aspect, Visual Basic for Applications, allowing the user to employ a wide variety of numerical methods, for example, for solving differential equations of mathematical physics, and then reporting the results back to the spreadsheet. It also has a variety of interactive features allowing user interfaces that can completely hide the spreadsheet from the user, so the spreadsheet presents itself as a so-called application, or decision support system (DSS), via a custom-designed user interface, for example, a stock analyzer, or in general, as a design tool that asks the user questions and provides answers and reports. In a more elaborate realization, an Excel application can automatically poll external databases and measuring instruments using an update schedule, analyze the results, make a Word report or PowerPoint slide show, and e-mail these presentations on a regular basis to a list of participants. Excel was not designed to be used as a database.

Microsoft allows for a number of optional command-line switches to control the manner in which Excel starts.

How to Open Microsoft Excel?

Running Excel is not different from running any other Windows program. If you are running Windows with a GUI like (Windows XP, Vista, and 7) follow the following steps.

Click on start menu
Point to all programs
Point to Microsoft Excel
Click on Microsoft Excel

Alternatively, you can also open it from the start menu if it has been added there. You can also open it from the desktop shortcut if you have created one.

For this tutorial, we will be working with Windows 8.1 and Microsoft Excel 2013. Follow the following steps to run Excel on Windows 8.1

Click on start menu
Search for Excel N.B. even before you even typing, all programs starting with what you have typed will be listed.
Click on Microsoft Excel

FULL FORM

2021-04-10T09:39:00.003-07:00

WHAT IS THE POLICE FULL FORM ?

POLICE KA FULL FORM KYA HAI?

PROTECT OF LIFE IN CIVIL ESTABLISHMENT

https://youtu.be/cfgt5XE_Tqs

WHAT IS THE FULL FORM OF MBBS?

MBBS KA FULL FORM KYA HAI?

BACHELOR OF MEDICINE & BACHELOR OF SURJERY

WHAT IS THE FULL FORM OF NDA?

NDA KA FULL FORM KYA HAI?

NATIONAL DEFENCE OF ACADMY

WHAT IS THE FULL FORM OF ATM?

ATM KA FULL FORM KYA HAI?

ANY TIME MONEY

AUTOMATIC TELLOR MACHINE

https://youtu.be/m2T9Mpu3hss

WHAT IS THE FULL FORM OF AM & PM?

AM & PM KA FULL FORM KYA HOTA HAI?

ANTI MERIDIEM & POST MERIDIEM

WHAT IS THE FULL FORM OF HR?

HUMAN RESOURCE

Shring to fitt in excel

2021-04-08T10:39:00.001-07:00

How to shring to fit in excel?

Shring to fit in excel

https://youtu.be/Qcv4vTIHzb0

https://www.facebook.com/Full-Harkat-114089750775194/?ref=page_internal

https://amzn.to/2Q2ssFb

Full form of police

2021-04-08T10:15:00.002-07:00

What is the full form of police?

Police ka full form kya hota hai?

Protect of Life In Civil Establishment

https://www.facebook.com/Full-Harkat-114089750775194/?ref=page_internal

How to hide data in excel (hide trick)

2021-04-06T08:18:00.002-07:00

How to hide data in excel (hide trick).

Excel me cell ka data kaise chup.

https://www.facebook.com/Full-Harkat-114089750775194/?ref=page_internal

https://youtu.be/zE-371wdQd8

How to insert currency symbol in excel ; Excel me rupee ka chinh kaise l...

2021-04-06T08:06:00.002-07:00

How to insert currency symbol in excel ;

Excel me rupee ka chinh kaise l...

select the range then go to home tab > number drop down list> select currency.

https://www.facebook.com/Full-Harkat-114089750775194/?ref=page_internal

https://youtu.be/2rL0QFrrJOc

Conditional Formatting in Excel

2021-04-05T10:08:00.002-07:00

How to apply conditional formatting?

https://youtu.be/PDADoKr5OHg

Select the Criteria where you can apply conditional formatting>

Go to home tab> then select conditional formatting.

How to highlight grater than ( ) less than ( ) equals to ( )

How to apply conditional formatting?

https://youtu.be/PDADoKr5OHg

https://www.facebook.com/Full-Harkat-114089750775194/videos/?ref=page_internal

DATA FILTER IN EXCEL

2021-04-04T10:10:00.002-07:00

Filtering data

Filters can be applied in different ways to improve the performance of your worksheet. You can filter text, dates, and numbers. You can even use more than one filter to further narrow your results.

1- Begin with a worksheet that identifies each column using a header row.
2- Select the Data tab, then locate the Sort & Filter group.
3- Click the Filter command.
4- Drop-down arrows will appear in the header of each column.
5- Click the drop-down arrow for the column you want to filter. In this example, we'll filter the Type column to view only certain types of equipment.
6- The Filter menu appears.
7- Uncheck the boxes next to the data you don't want to view, or uncheck the box next to Select All to quickly uncheck all.
8- Check the boxes next to the data you do want to view. In this example, we'll check Laptop and Projector to view only these types of equipment.
9- Click OK. All other data will be filtered, or temporarily hidden. Only laptops and projectors will be visible.
Filtering options can also be found on the Home tab, condensed into the Sort & Filter command.

To add another filter:

Filters are additive, meaning you can use as many as you need to narrow your results. In this example, we'll work with a spreadsheet that has already been filtered to display only laptops and projectors. Now we'll display only laptops and projectors that were checked out during the month of August.

1- Click the drop-down arrow where you want to add a filter. In this example, we'll add a filter to the Checked Out column to view information by date.
2- Uncheck the boxes next to the data you don't want to view. Check the boxes next to the data you do want to view. In this example, we'll check the box next to August.
3- Click OK. In addition to the original filter, the new filter will be applied. The worksheet will be narrowed down even further.

To clear a filter:

1- Click the drop-down arrow in the column from which you want to clear the filter.
2- Choose Clear Filter From.
3- The filter will be cleared from the column. The data that was previously hidden will be on display once again.
To instantly clear all filters from your worksheet, click the Filter command on the Data tab.

UPDATED TDS Section Rate Chart

2021-03-21T22:01:00.001-07:00

Updated TDS RATE CHART.

Excel Max Formula

2021-03-21T09:20:00.003-07:00

How to find maximum amount.

Excel Sum Formula

2021-03-19T09:34:00.004-07:00

How to calculate amount in excel.

Ms Excel me additional karne ke liye ye formula use kare..

=Sum(select as per addition cell)