This course is a continuation of the Excel training provided during the Octane Conference. This special encore session will focus on discussing and demonstrating Excel's Power Query functionality. With recent Excel updates provided through Microsoft 365/Office 365 subscriptions, Microsoft continues to pack new features into the popular spreadsheet tool. Enhancements to data analysis tools, new functions, and improved collaboration opportunities are available in more recent Excel versions. For those who know about these new features and apply them, exciting opportunities for improved productivity await. Take advantage of this opportunity to learn how you can put Excel’s best new features to work right away!
- Review and list the major features of Excel's Power Query Functionality
- Demonstrate how to connect to Cloud databases and download data directly from Excel.
- Discuss the various ways to prepare your data for analysis using Power Query's incredible transformation tools.
- Outline Power Query's significant features and functions and how they are used for reporting projects.