3D Maps then works to plot the data on the globe in the areas recorded in your workbook. You can use any presented drop-down arrow in the fields to ensure the data is matched correctly to the right geodata. The Field List box, next to the Layer pane on the right. Drag the fields from the Field list to the Layer pane as needed.3D Maps will then open with your data presented in the areas listed in your workbook. Click on the tour image, in the Launch 3D Maps popup, to begin editing Click on the tour image to begin editing.The information in your workbook Is geocoded, courtesy of Bing.Open a workbook that contains a table of geographical details.The data could contain details as complex as longitudes and latitudes or as simple as a zip code or postal code. Imagine being able to visually see changes to data over time and by geographical location.īefore you can begin using 3D Maps, you should make sure that your data contains some sort of geographic information within your tables. With 3D Maps, you can generate a three-dimensional presentation of your data that can have a much larger impact on the data than numbers alone. Creating 3D MapsĮven with the most organized database, some information and insight are lost if not visually engaging for the reader. Let's take a look at some even more useful features of Excel. Entering in data is one thing while manipulating the data to get information. Those are some of the basic functions that an Excel user should know to be more efficient with their worksheets. Alternatively, you can also enter in =A1&B1&C1 This would then combine the area code, central office prefix and line number. If we were to use a phone number example, the formula could look like this: =CONCATENATE(A1,B2,C3) It's a basic string function that helps to reduce the amount of data entry steps you have to take. This function can easily combine data from multiple cells into a single cell. We've included column index number as a third argument since the prices are found in the second column. VLOOKUP always searches the first column in a workbook. You would want to type out the following in a nearby cell to find an item and its price: =VLOOKUP('item name', A1:B10, 2, FALSE) Let's say you have 10 items in a list with the item names in the first column and their price in the second column. VLOOKUP helps the user to search for specific data from a table and place it a new table. =LOWER(A1) would change John Smith to john smith. LOWER: The Lower formula will change all alphabetical characters in targeted cells to lower case.UPPER: By using upper in a formula, such as =UPPER(A1), you would change John Smith to JOHN SMITH.=PROPER(A1) will change john smith to John Smith. PROPER: Proper will turn a string of text to the proper case by capitalizing the first letter in each word.While functions such as proper, upper and lower aren't going to solve mathematical problems, they do ensure that the text is displayed correctly. , you have now chosen to find the sum of the numbers in the same cells, but only taking into account values that are greater than 10,000. To take an average of the first 10 cells in column C, type =AVERAGE(C1:C10) into another cell.Ī small, two letter word can provide a lot of functionality to your data. AVERAGE: The average option takes the average of the numerical values found within your selected range of cells. Rather than manually counting how many of the one hundred cells in column B have numbers, you would type =COUNT(B1:100) into another cell. Instead of adding the value of the numbers in cells, Count will count and report on the number of cells that have a numerical value.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |