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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |