By Jess Stratton | Monday, January 06, 2014
Explore Monday Productivity Pointers at lynda.com.
Welcome to this week’s edition of Monday Productivity Pointers! This week I’m covering a great skill to know: how to migrate data between two apps with minimal headaches, by using an Excel spreadsheet. Hint: It’s all about the header column labels.
In the first video, I’ll show you how to make sure you’re correctly matching up the header row of column labels on your Excel spreadsheet for a smooth data import. And just in case you don’t know the column labels in the app you’ll be importing your data into, I’ll show you a great trick for finding out.
Then again, sometimes you may find your import thwarted by a very common scenario: Your data was exported out of your original app with two separate columns for the first name and last name. The app you’re importing into is asking for one column—name—which is a combined first and last name together.
I’ll show you how to tackle this problem in the second (members-only) video. By using a simple, powerful Excel formula, you can have your data converted and migrated in seconds. Watch this week’s videos to get the edge on your next data migration, and be sure to check back in January for more Productivity Pointers!
With online video courses at lynda.com, you can reach your goals faster. Learn software, improve your skills, and get an inside look at how the professionals work.
Share this article:
Tags: Microsoft Excel, Jess Stratton, Monday Productivity Pointers, Metadata, Data Migration
Thanks for signing up.
We’ll send you a confirmation email shortly.
Sign up and receive emails about lynda.com and our online training library:
Keep up with news, tips, and latest courses with emails from lynda.com.
We've updated our terms and conditions (now called terms of service).Go Review and accept our updated terms of service.