Lynda - Excel 2016: Get & Transform
Lynda - Excel 2016: Get & Transform
Size: 285 MB | Duration: 1h 49m | Video: AVC (.mp4) 1280x720 15&30fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Intermediate | Language: English
Size: 285 MB | Duration: 1h 49m | Video: AVC (.mp4) 1280x720 15&30fps | Audio: AAC 48KHz 2ch
Genre: eLearning | Level: Intermediate | Language: English
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.
* 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
* Querying data
* Working with columns
* Using formulas
* Pivoting and unpivoting data
* Grouping data
* Appending a query
* Merging/combining data with joins
Lynda - Excel 2016: Get & Transform
No mirrors below please.