Data is life. In this session, we will explore the basics of Excel's Power Query add-in; extracting, transforming and preparing data for analysis
Learning Objectives
Import and transform basic data into Excel using Power Query;Understand and apply the data load capabilities of loading into Excel versus loading into the "data model", and why it matters;Identify the basics of extracting and transforming data
Major Topics
Deep dive into Power Query (Excel 2016 Get & Transform);
Explore the basics of extracting and transforming data, which is the first necessary step to data analysis and reporting;
Top 6 features most important to accountants (data source flexibility, appending queries, unpivot, etc.);
Exploration of real Power Query use cases, many of which accountants could implement immediately;
A summary of top resources and experts to get you started on the journey of learning Power Query;
Excel workbooks will be made available for all participants to use at their leisure and further explore the topics discussed
