Do you ever import data into Excel, and then spend a bunch of time manually preparing it for use? Perhaps you delete extra columns or rows. Maybe you need to split a single column into multiple columns, or, combine multiple columns into a single column.
DESIGNED FOR
Accounting professionals using Excel for Windows
BENEFITS
- Recall the steps to create a new query
- Identify commands that transform data
- State the process to return the transformed data to Excel
HIGHLIGHTS
- Automation capabilities of Excel
- The “Get & Transform” Tool
- Using “Get & Transform” for flattening, splitting and combining data, unpivoting summarized data, and combining CSV exports
PREREQUISITES
Experience working with Excel.
ADVANCE PREPARATION
None