Basic Data Analytics in Excel
Free Download Basic Data Analytics in Excel
Published 7/2024
Created by Mitja Martini
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 19 Lectures ( 59m ) | Size: 367 MB
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/
Basic Data Analytics in Excel Torrent Download , Basic Data Analytics in Excel Watch Free Online , Basic Data Analytics in Excel Download Online
In today's era of digital learning, access to high-quality educational resources has become more accessible than ever, with a plethora of platforms offering free download video courses in various disciplines. One of the most sought-after categories among learners is the skillshar free video editing course, which provides aspiring creators with the tools and techniques needed to master the art of video production. These courses cover everything from basic editing principles to advanced techniques, empowering individuals to unleash their creativity and produce professional-quality content.
Comments (0)
Users of Guests are not allowed to comment this publication.