Top-shelf | search
Click here to view Top-shelf news from 60+ newspapers.
Bookmark or Share- 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.
- Overview of Excel tables - Microsoft SupportTotal row Once you add a total row to a table, Excel gives you an AutoSum drop-down list to select from functions such as SUM, AVERAGE, and so on.When you select one of these options, the table will automatically convert them to a SUBTOTAL function, which will ignore rows that have been hidden with a filter by default.
- Sort data in a range or table - Microsoft SupportIn a range of cells, enter the values that you want to sort by, in the order that you want them, from top to bottom as in this example.
- About Power Query in Excel - Microsoft SupportWith Power Query, you can search for data sources, make connections, and then shape that data (for example remove a column, change a data type, or merge tables) in ways that meet your needs. Once you’ve shaped your data, you can share your findings or use your query to create reports.
- Create a Map chart in Excel - Microsoft SupportCreate 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.Excel will automatically convert your data to a geography data type, and will include properties relevant to that data that ...
More
