Updating imported data in excel dhcp updating dns records
LEARN MORE Enhanced data import functionality Easily import and shape data from various sources.Manage workbook queries and connection with the Queries & Connection side pane, and share queries with others via ODC files.Use your digital pen to select and change objects In Excel, with a digital pen, you can select an area without even tapping the selection tool on the ribbon.Just press the barrel button on the pen and draw with the pen to make a selection.The next time you create a Pivot Table, you will start with that layout.LEARN MORE: SET PIVOTTABLE DEFAULT LAYOUT OPTION | CREATE AND FORMAT PIVOTTABLES WITH FREE TRAINING FROM LINKEDIN LEARNING Insert recent links Easily attach hyperlinks to recent cloud-based files or websites, and create meaningful display names for people using screen readers.Now you can replay or rewind your ink to better understand the flow of it. This will show you all files that have been shared with you.Or your peers can replay it to get step-by-step instructions. CSV (UTF-8) support You asked for it on our Excel User Voice forum: You can now open and save CSV files that use UTF-8 character encoding. Then click the Save as type menu and you'll find the new option for CSV UTF-8 (Comma delimited).
You and your colleagues can open and work on the same Excel workbook. When you co-author, you can see each other's changes quickly — in a matter of seconds.
For more information, see View historical versions of Office files.
Updates for Get & Transform and the Power Query add-in See what's new and improved in the November 2016 feature update, Version 1611 (Build 7571.2072).
New map charts You can create a map chart to compare values and show categories across geographical regions.
Use it when you have geographical regions in your data, like countries/regions, states, counties or postal codes. New icons available on the Insert tab Need to insert an icon that conveys a certain idea or concept, but you don't want to draw it yourself? Choose a category like people, technology, or sports.
LEARN MORE New data transformation: Add Column From Examples In the Query Editor, create a new column by providing sample values.