Place your cursor anywhere inside the data.Just like with your pivot table data, you do not need to preselect all this information. It can really mess with features that create visual elements with data… But I digress. Oh, and remember… friends don’t let friends merge cells. This is exactly how data should be laid out in Excel: for pivot tables, for graphing, and also for geographic data. Notice how this list is laid out vertically: each column is a new piece of information and each new row is a separate entry. This is a list of fictional student registrations: student hometowns, class, and the date they registered. Exercise Fileįollow along with the exercise file: GeographicInfo If you are a Mac user and want to try out this feature, please come to one of our open labs listed in myTraining! We would love to have you, and you will be able to export the data we create for use in presentations. WSU faculty and staff, if you have an older version of Office and would like to upgrade, please contact the Help Desk at 4357. This feature is available to those of you using the Windows version of Microsoft Office 2016 or later. This is the beginning of the cool AI features to come with Microsoft Office… it is an amazing tool to help you better illustrate location oriented data, or better yet, location data on a timeline. I learned about this magical feature (wizardry) from a session taught by Mr. I have been including this as a bonus exercise in our Pivot Table sessions, but it is too good not to share as a Byte.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |