Language: English (US)

A brief introduction to modern Excel features.

https://www.udemy.com/course/basic-data-analytics-in-excel/

This course introduces you to the "hidden powers" of Excel (Power Query, the Data Model, and Power Pivot) and demonstrates how to use Excel formulas in the modern way with Tables and Dynamic Arrays.

The concepts are demonstrated by implementing basic analytics for a "Vibes-o-Meter" web application which gathers the vibes of an audience during a live event. The data is loaded and transformed with Power Query, analyzed with Tables, formulas, dynamic arrays and Pivot Tables and visualized with charts.

You can also do everything that's been demonstrated on your own in an exercise. A comprehensive, 35-page exercise workbook will guide you through each of the steps. The exercise is designed to give you hands-on experience with Power Query, Tables, Dynamic Arrays, Charts, and Pivot Tables.

The course also covers the use of Generative AI (GPT-4 Turbo), in Excel. This is demonstrated with an Excel formula translator which  can translate formulas from one language, e.g. English, to another, e.g. German. The translation is done by GPT-4 in Excel itself using Microsoft's Garage Labs Excel Add-In. The achieved quality is only possible by adding of a list of Excel functions to the prompt. This list has been extracted with Power Query from Microsoft's official documentation. The course includes a demonstration of how to extract and transform data from the web with Power Query by example of adding another language to the formula translator (Italian).