IMPORTRANGE-1.pptx

Ghh

1. What is the NOT Function The NOT Function is an Excel Logical function. The function helps check if one value is not equal to another. If we give TRUE, it will return FALSE and when given FALSE, it will return TRUE. So, basically, it will always return a reverse logical value. As a financial analyst, the NOT function is useful when we wish to know if a specific condition was not met

2. Formula=NOT(logical) Where: Logical (required argument) – The argument should be a logical or numerical value. If the given logical argument is a numeric value, zero is treated as the logical value FALSE and any other numeric value is treated as the logical value TRUE.

3. Example 1Suppose we don’t want the red and blue combination for soft toys. We are given the data below: To avoid the Red Blue combination, we will use the formula =NOT(C6=”Red Blue”). We will get the results: If we wish to test several conditions in a single formula, then we can use NOT in conjunction with the AND or OR function. For example, if we wanted to exclude Red Blue and Slate Black, the formula would be =NOT(OR(C2=”Slate black”, C2=”Red Blue”).

4. what is nested if Nested IF functions, meaning one IF function inside of another, allows you to test multiple criteria and increases the number of possible outcomes.

5. Example #1Now take a look at the popular nested IF example. We need to arrive at standards based on the student’s score. Consider the below data for an example. o arrive at the results, we need to test the below conditions. These conditions are nothing but our logical tests. If the score is >=585 result should be “ Dist ” If the score is >=500 result should be “First” If the score is >=400 result should be “Second” If the score is >=350 result should be “Pass” If all the above conditions are “FALSE,” the result should be “FAIL.” Now, we have a total of 5 conditions to test. Unfortunately, the logical tests are more than one logical test at the moment. So we need to use Nested IFs to try multiple criteria.

6. Like this, we can test multiple conditions by nesting many IF conditions inside the one IF condition.The logic here is the first IF result will come if the logical test is “TRUE.” If the logical test is “FALSE,” then the second IF can be executed. Until the formula finds the “TRUE” test result, it will execute it. If none of the results is “TRUE,” it will execute the final “FALSE” result.

7. IMPORTRANGE The  IMPORTRAGE  Google Sheets function is the only way to integrate data between spreadsheets without third-party add-ons in Google Sheets. This function provides a more streamlined way to easily import data from one Google Sheets file to another. Not only does this save you time, but you also avoid the risk of human error from manual copy and pasting.

8. How To Use IMPORTRANGE We have a simple sheet of two columns and eight rows. click a blank cell so that you can access the function bar. In it, type =IMPORTRANGE. copy the complete URL of the spreadsheet that has the data you’d like to import. Complete URL https://docs.google.com/spreadsheets/d/ 1sqWKxq4mbsJVqy2mZbeV2H7MWF9TZ2V-yU6Ne0NGL0g / Spreadsheet key 1sqWKxq4mbsJVqy2mZbeV2H7MWF9TZ2V-yU6Ne0NGL0g

9. What Is Formatting in Excel? Formatting in  Excel  is a simple process of modifying or manipulating data in spreadsheets from one form to another. Formatting can be done based on appearance and data types. F ormatting in excel can be done based on various requirements, including appearance, datatype, and data organization.

10. Number Formatting General :- General is a number format selected as the default by excel for any number you type into the spreadsheet. Number :- Number Format is exclusively used when you are working with numbers. Currency :- Currency Number Format is used when you want to represent numbers in the form of currency. Accounting :- Accounting is completely similar to currency. You can use the accounting Number Format to add decimal places to your currency to make it more accurate. Date :- The Date Format is employed in spreadsheets to consider your input as a calendar date instead of a regular number. Time :- The Time Format converts the general default number format to the time format. Percentage :- The Percentage Data Format represents the values in terms of percentages. Text :- The text includes the textual type of data. Here, Excel treats any number of data you type as text format and keeps it the way it is without adding any decimals or mathematical symbols. Custom :- Apart from all the available options, Excel also provides its users with a customizable option that will help them use existing formats and customize them to create a completely new one.

11. Cell Formatting Text Color Formatting :- The Text color option will help users customize the text color in Excel with various color Cell Color Formatting :- The Cell background color option will help users modify the cell background color in the spreadsheet Cell Borders Formatting :- The spreadsheet borders option will allow users to add cell borders as per the requirement of the users. Conditional Formatting :- The Conditional formatting option will allow the users to highlight or mark cells on excel spreadsheets based on logical functions and formulae Table, Cell Formatting :- The Table Formatting in excel will allow you to modify the tabular data in Excel with various options

12. Applying Data Filters If your worksheet contains a lot of content, it can be difficult to find information quickly.  Filters  can be used to  narrow down  the data in your worksheet, allowing you to view only the information you need.

13. To filter data: In our example, we'll apply a filter to an equipment log worksheet to display only the laptops and projectors that are available for checkout. In order for filtering to work correctly, your worksheet should include a  header row , which is used to identify the name of each column. In our example, our worksheet is organized into different columns identified by the header cells in row 1:  ID# ,  Type ,  Equipment   Detail , and so on. Select the  Data  tab, then click the  Filter  command. A  drop-down arrow  will appear in the header cell for each column. Click the  drop-down arrow  for the column you want to filter. In our example, we will filter column  B  to view only certain types of equipment.

14. The  Filter   menu  will appear. Uncheck  the box next to  Select All  to quickly deselect all data. Check  the boxes next to the data you want to filter, then click  OK . In this example, we will check  Laptop  and  Projector  to view only these types of equipment. The data will be  filtered , temporarily hiding any content that doesn't match the criteria. In our example, only laptops and projectors are visible.