For instance, =AND(A1=”EXCELLENT”, B3>10) would output true if A1 is “EXCELLENT” and the value of B3 is greater than 10. It automatically checks if certain things are true or false. ANDĪND is one of the widely-used logical functions in Excel. For example, you can put =MAX(A1:A10)if you want to get the maximum numerical value in those rows while you can use MIN to find the minimum. These functions may be simple, but they are sure to help a lot when you have a massive amount of data.

You may be starting to think that these functions can make your complex spreadsheets easier.

This function will automatically add the values of B1 to B10 if the total sum of A1 to A10 has an output of “EXCELLENT”. So in SUM, you can put =SUM(A1:A10, “EXCELLENT”, B1:B10). SUMIF, COUNTIF, AVERAGEIFĪll of these functions or formulas are structured like =FUNCTION(range, criteria, function range). For instance, you can write the function =IF(A1>A2, “EXCELLENT”, “FAIL”), where A1>A2 is the case, “EXCELLENT” is the output if true and “FAIL” is the output if false. It can save your time and output a text if a particular data is valid or false. If statements are useful for several situations. Here are some of the essential functions or formulas in manipulating data. You can use this video as your guide in sorting your data: You can choose your sorting option in the Format Cells dialog, click the Category dropdown and select your preferred sorting option. If you want to sort a column that contains numbers, you can format them either number or text. You must not forget to check if all data is sorted as text. To sort in descending order, click the Z-A button in descending order. To sort in ascending order, click the A-Z button Click the data table, choose the Sort 7 Filter group, and do the following: Select the cell in the column that you want to sort. It sorts the data in a variety of cells without affecting the other content on the worksheet. Sort range is ideal for a sheet with several tables. It is the best one for you if you want to arrange your data alphabetically or alphanumerically. Related information across each row is remained after the sortation. Sort sheet allows you to organize all of your data based on one column. You can also sort it numerically, alphabetically, and in many other ways.īefore sorting the data, you must first decide if you want to sort the entire spreadsheet or just a particular column. For instance, you can sort your list of products by its suppliers. Sorting your data helps you to reorganize your spreadsheet quickly. You can use this video as your guide in freezing your row or column: Select the Freeze Pane dropdown and choose “Freeze Panes.” If you prefer to freeze columns, you must select the cell to the right of the column that you want to freeze.

Select the row below the row or rows that you want to keep visible. Aside from allowing you to compare different columns or rows in a long spreadsheet, the Freezing Panes command also keeps the essential details in view. You must take note that under the Freezing Panes command, you can choose the “Freeze First Column” or “Freeze Top Row” if you want to keep the leftmost column/row visible when you scroll. Excel’s freezing panes allows you to lock specific rows so you can still see them even when you are scrolling.

How to make notes in excel cell