• views: 401
• date: 8 July 2022
• posted by: voska89

Building Interactive Dashboard & Advanced Analytics using Microsoft Excel
What you'll learn
Understand use cases of Excel as a Data Analytics Tool & Modeling tool
Understand the core capabilities of Excel
Understand Excel Look-Up Functions with a focus on the VLOOKUP function
Understand Excel Pivot Tables
Basic Principles of Dashboard Design
Build a Personal Finances Dashboard using the skills learned
Requirements
No requirements. You will learn everything along the way.
Description
This is a quick and short course intended to help people understand the data analytics capabilities of Microsoft Excel. Special focus is put on the use of Excel Pivot Tables and principles of dashboard design. You will learn the following
Top use-cases of Microsoft Excel as a Data Analytics & Modeling tool: Top use-cases of Microsoft Excel as a Data Analytics tool will be explained together with top use-cases of Microsoft Excel as a modeling tool.
Use of Lookup functions to enrich a table with more fields / attributes
Excel Pivot Tables: We will go through a step by step process of building Pivot Tables in Microsoft Excel. No previous experience is assumed and we will take you through all the stages of building summarized tables using Microsoft Excel.
Excel Pivot Charts: On top of the summarized tables developed using Pivot Tables, we will create pivot charts which will then be used when building the Personal Finances dashboard.
Slicers: Slicers are a very critical component when you need to make your dashboard interactive. In this course, we will make use of slicers in Microsoft Excel.
Principles of Dashboard Design: You will learn the basic principles of Dashboard design.
Building a personal Finances Dashboard
The course is then concluded by building a Personal Finances dashboard.
By the end of this course, you would have build a personal finances dashboard and understood Excel Pivot Tables.
Who this course is for
Excel Data Analysts
Business people curious about using Excel in Data Analytics
Everyone who wants to make use of Excel in Data Analytics
Homepage

https://www.udemy.com/course/data-analytics-using-excel-mini-course/

   
   
   

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.