-
- دوشنبه تا شنبه: 10:00 - 16:00 / یکشنبه تعطیل است
Have you ever used VLOOKUP to bring a column from one table into another table? Now that Excel has a built-in Data Model, VLOOKUP is obsolete. You can create a relationship between two tables of data, based on matching data in each table.
به خواندن ادامه دهید
In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False. =IF (Something is True, then do something, otherwise do something else)
به خواندن ادامه دهید
You can move between cells in a circular reference by double-clicking the tracer arrow. The arrow indicates the cell that affects the value of the currently selected cell. You show the tracer arrow by selecting Formulas, and then select either Trace Precedents or Trace Dependents.
به خواندن ادامه دهید
Create a Map chart with Data Types. Map charts have gotten even easier with geography data types. Simply input a list of geographic values, such as country, state, county, city, postal code, and so on, then select your list and go to the Data tab > Data Types > Geography.
به خواندن ادامه دهید
Insert the current Excel file name, path, or worksheet in a cell. Let's say you want to add information to a spreadsheet report that confirms the location of a workbook and worksheet so you can quickly track and identify it. There are several ways you can do this task.
به خواندن ادامه دهید
After you create a PivotTable, you can change the range of its source data. For example, you can expand the source data to include more rows of data. However, if the source data has been changed substantially—such as having more or fewer columns, consider creating a …
به خواندن ادامه دهید
Here's a step-by-step process to follow that helps make sure your Lambda works as you intended and closely resembles the behavior of a native Excel function. Step 1: Test the formula. Step 2: Create the Lambda in a cell. Step 3: Add the Lambda to the Name Manager. Examples. Example 1: Convert Fahrenheit to Celsius. Example 2: Find the hypotenuse.
به خواندن ادامه دهید
Structured reference: (DeptSales [ [#Totals], [Sales Amount]] and DeptSales [ [#Data], [Commission Amount]] are structured references, represented by a string that begins with the table name and ends with the column specifier. To create or edit structured references manually, use these syntax rules:
به خواندن ادامه دهید
Count based on criteria by using the COUNT and IF functions together. Let's say you need to determine how many salespeople sold a particular item in a certain region or you want to know how many sales over a certain value were made by a particular salesperson.
به خواندن ادامه دهید
Checkboxes are a versatile feature in Excel, useful for making interactive lists and forms. In this article, we'll cover how to add, remove, and toggle them. To insert Checkboxes: Select the range where you want checkboxes. Select Insert > Checkbox. Removing Checkboxes. To …
به خواندن ادامه دهید
If you set up your list source as an Excel table, then all you need to do is add or remove items from the list, and Excel will automatically update any associated drop-downs for you. To add an item, go to the end of the list and type the new item. To remove an item, press Delete.
به خواندن ادامه دهید