Basic Data Analytics in Excel

Basic Data Analytics in Excel, available at $49.99, with 19 lectures.

You will learn about Introduction to modern Excel tools Power Query Excel Tables Dynamic Arrays in Formulas Charts Pivot Tables and Pivot Charts ChatGPT in Excel This course is ideal for individuals who are Long-term Excel users who use Excel the classic way and want to learn about modern Excel features. or New Excel users that know the Excel basics and want to learn about Excel's more advanced tools. or Data analysts who want to get an impression of what's possible with Excel. It is particularly useful for Long-term Excel users who use Excel the classic way and want to learn about modern Excel features. or New Excel users that know the Excel basics and want to learn about Excel's more advanced tools. or Data analysts who want to get an impression of what's possible with Excel.

Enroll now: Basic Data Analytics in Excel

Summary

Title: Basic Data Analytics in Excel

Price: $49.99

Number of Lectures: 19

Number of Published Lectures: 19

Number of Curriculum Items: 19

Number of Published Curriculum Objects: 19

Original Price: $29.99

Quality Status: approved

Status: Live

What You Will Learn

Introduction to modern Excel tools
Power Query
Excel Tables
Dynamic Arrays in Formulas
Charts
Pivot Tables and Pivot Charts
ChatGPT in Excel

Who Should Attend

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.

Target Audiences

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.

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).

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction and Agenda

Lecture 2: Why analyse data? Why with Excel?

Lecture 3: Database terms and Excel

Chapter 2: Power Query

Lecture 1: Introduction to Power Query

Lecture 2: Power Query demonstration

Chapter 3: Excel Tables

Lecture 1: Introduction to Excel Tables

Lecture 2: Excel Tables demonstration

Chapter 4: Basic Functions and Dynamic Arrays

Lecture 1: Introduction to Dynamic Arrays

Lecture 2: Dynamic Arrays demonstration

Lecture 3: Adding a chart

Chapter 5: Power Pivot

Lecture 1: Power Pivot introduction

Lecture 2: Pivot Tables demonstration

Lecture 3: Pivot Charts demonstration

Chapter 6: Generative AI and Excel

Lecture 1: What is Generative AI and how to use it in Excel?

Lecture 2: Installing the Microsoft Garage Labs Excel Add-In

Lecture 3: Improving prompts with data from Excel (and AI-powered Excel formula translator)

Lecture 4: Enhancing an AI powered formula translator with Power Query

Chapter 7: Exercise and Wrapping Up

Lecture 1: Exercise Introduction, Exercise Workbook and Excel Files

Lecture 2: Wrapping Up (and presentation for download)

Instructors

Mitja Martini
Cloud Solution Architect and Software Development Enthusiast

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 0 votes
4 stars: 0 votes
5 stars: 0 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu