Excel 2016: Get & Transform
MP4 | Video: 720p | Duration: 1:49:33 | English | Subtitles: VTT | 283.7 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 dataWorking with columnsUsing formulasPivoting and unpivoting dataGrouping dataAppending a queryMerging/combining data with joins
Download link:
Links are Interchangeable - No Password - Single Extraction
Konuyu Favori Sayfanıza Ekleyin