Basic Data Analytics in Excel

A brief introduction to modern Excel features.
What you'll learn:
Introduction to modern Excel tools
Power Query
Excel Tables
Dynamic Arrays in Formulas
Charts
Pivot Tables and Pivot Charts
ChatGPT in Excel
Requirements:
Excel for Windows (for the labs with Power Query), otherwise Excel for the Web or Excel for Mac is sufficient.
Basic Excel knowledge
Description:
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).
Who this course is for:
Long-term Excel users who use Excel the classic way and want to learn about modern Excel features.
New Excel users that know the Excel basics and want to learn about Excel's more advanced tools.
Data analysts who want to get an impression of what's possible with Excel.
Homepage

Rapidgator
gtnwn.Basic.Data.Analytics.in.Excel.rar.html
Fikper
gtnwn.Basic.Data.Analytics.in.Excel.rar.html
​

Click to expand...