Skip navigation

Combine fields with concatenate

Combine fields with concatenate: Working with Real-Time Data in Excel
Combine fields with concatenate: Working with Real-Time Data in Excel

Combine the year, month, and day columns into a single, composite date field using Excel’s CONCATENATE function. Understand the importance of creating a valid “key” that can be used to join multiple data sources together using lookup functions or data models, and recognize the difference between 1-to-1 and 1-to-many relationships.

Resume Transcript Auto-Scroll
Skill Level Intermediate
1h 18m
Duration
94,589
Views
Show More Show Less

Continue Assessment

You started this assessment previously and didn't complete it. You can pick up where you left off, or start over.

Start Your Free Trial Now

Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now