• views: 207
• date: 3 July 2024
• posted by: voska89

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

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

   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.