Oz du Soleil an Excel MVP, author, and trainer, with a passion for clean data and reliable reporting.Īn even greater passion is that of teaching, sharing knowledge, and empowering people to handle their data more efficiently and with greater skill. Putting it all Together and Applying your Learning 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. 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 begins by explaining what Get & Transform is, and how its data handling features differ from the Excel functions that most people are familiar with. Follow along with Excel MVP Oz du Soleil as he shows you the many uses of Get & Transform. Excel 2016: Power Query (Get & Transform)Įxcel 2016 includes a powerful new set of features called Get & Transform, which provides compelling data gathering and cleansing capabilities.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |