Basic Data Analytics in Excel
Basic Data Analytics in Excel
Published 7/2024
Duration: 59m | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 366 MB
Genre: eLearning | Language: English
Published 7/2024
Duration: 59m | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 366 MB
Genre: eLearning | Language: English
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.
More Info