In any analysis problem, most of your time is spent preparing the data for analysis. JMP makes this process easy with powerful data manipulation capabilities. See how to rearrange data to meet any analysis challenge. Topics include: importing data from Excel, Query Builder, Recode, Selecting Matching Cells, Name Selection in Column, Value Labels, Compression of Selected Columns, Stack/Split and Join.
Other useful resources:
Preparing Your Data for Analysis (Mastering JMP webcast video)
If you learn only one formula function, Word() is the one (blog)