Included Exercise Files
Skill Level : Intermediate
Duration : 1h 49m
Language : English
Released : 8/14/2017
Size : 246,79 Mb
Excel 2016 includes a powerful new set of features called Get & Transform, which provides compelling data gathering and cleansing capabilities. Follow along with Excel MVP Oz du Soleil as he shows you the many uses of Get & Transform. Oz begins by explaining what Get & Transform is, and how its data handling features differ from the Excel functions that most people are familiar with. He then shows how to get started with Get & Transform, whether you want to import and work with data from a table, a file, or a folder. Oz also shows how to merge and cleanse data from multiple sources, and how to pivot data to examine your data from a variety of angles.
Topics include:
What is Get & Transform?
Querying data
Working with columns
Using formulas
Pivoting and unpivoting data
Grouping data
Appending a query
Merging/combining data with joins
