Skip navigation

Combine fields with concatenate

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

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.

  • Overview
  • Transcript
  • View Offline
Resume Transcript Auto-Scroll
Skill Level Intermediate
1h 18m
Duration
52,524
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