Builder | search
Click here to view Builder news from 60+ newspapers.
Bookmark or Share- Create a relationship between tables in Excel - Microsoft SupportYou can create a relationship between two tables of data, based on matching data in each table. Then you can create Power View sheets and build PivotTables and other reports with fields from each table, even when the tables are from different sources.
- Create, load, or edit a query in Excel (Power Query)Create, load, or edit a query in Excel (Power Query) Power Query offers several ways to create and load Power queries into your workbook. You can also set default query load settings in the Query Options window.
- Create custom functions in Excel - Microsoft SupportInstead, Excel provides you with the ability to create custom functions, which are explained in this article. Custom functions, like macros, use the Visual Basic for Applications (VBA) programming language. They differ from macros in two significant ways. First, they use Function procedures instead of Sub procedures.
- Using IF with AND, OR, and NOT functions in ExcelIn 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.
- Look up values with VLOOKUP, INDEX, or MATCH - Microsoft SupportHere's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work. For VLOOKUP, this first argument is the value that you want to find. This argument can be a cell reference, or a fixed value such as "smith" or 21,000.
More
