Excels new data import features

I know that many of you are Excel junkies and I mean that in a very good way. You amaze me. Here’s some good news for you. Excel 2016 has just introduced a new feature that you’re going to like. It’s a vastly improved data importation tool.

It’s called Get & Transform

Pulling in data from other sources whether they be CSV’ files, data from inside a database, or even today data from a cloud application has never been very easy to do. This set of tools should make it a bit easier for you.

With Get & Transform in Excel 2016, 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.

 

Here’s an excellent tutorial on how to get starting use it.

https://support.office.com/en-us/article/Getting-Started-with-Get-Transform-in-Excel-2016-a8310388-2a12-438c-9d29-c6d29cb8df6a

 

–Amy, president

About Harbor Computer Services

Harbor Computer Services is an IT firm servicing Southeastern Michigan. We work exclusively under contract with our clients to provide technology direction and either become the IT department or provide assistance to the internal IT they already have. We have won many awards for our work over the years, including the worldwide Microsoft Partner of the Year in 2010. We’re the smallest firm to have ever won this most prestigious award. Most recently we were recognized as one of the top 20 visionaries in small business IT by ChannelPro Magazine (2015). And in 2016 as the top Michigan IT firm for Manufacturing. There are a few simple things that make Harbor Computer Services the best choice for your business. •We are Professionals •We are Responsible •We are Concerned About The Success of Your Business

 

 

Leave a comment

Your email address will not be published. Required fields are marked *

This blog is kept spam free by WP-SpamFree.