top of page

Excel Data Connectors - The Missing Link

If you work in industry and get reports on a regular basis then Excel data connectors can save you lots of time and automate a lot of the work you have to do.

What is a Data connector? - It allows you to connect a source file or data source into a table in your excel file and just by hitting refresh you can pull the latest data into the table. The imported columns can be used as the source for additional calculated columns to fix the most common issues with imported data.

Like what? - Additional spaces can be removed with a Trim Column - incorrectly formatted dates can be fixed with a substitute column..

More to follow...

Featured Posts
Check back soon
Once posts are published, you’ll see them here.
Recent Posts
Search By Tags
No tags yet.
Follow Us
  • Facebook Basic Square
  • Twitter Basic Square
  • Google+ Basic Square
bottom of page