This course presents five use cases for specific data issues a user may encounter in Power Query (Excel version). Through hands-on examples, users are guided through the process of overcoming each of these issues.Power Query is an "ETL" tool that ex...
With the Power BI ecosystem, a complete business intelligence solution, your company can begin the data analytics journey with Excel. Excel contains two data tools of the Power BI ecosystem to begin developing data skills: Power Query and Power Pivo...
This course covers a number of useful transformations using Power Query (Excel version) to clean, enrich, and shape data. Coverage includes pivoting and unpivoting, filtering and grouping, fuzzy matching, and more, with hands-on exercises for users t...
This one-hour course will serve as an introduction to artificial intelligence and how artificial intelligence is utilized in Excel. Users will be introduced to correlation and trend functions in Excel. The basics of linear regression and its applica...