DATA ANALYSIS MADE EASY
Open in Telegram
8 759
Subscribers
-224 hours
-167 days
-6830 days
Posts Archive
Differences between IF and IFS in Excel
https://youtu.be/LuwDeoQTrS8
Donât forget to subscribeâ€ïž
FREE Datasets to practice Data Analysis
Don't forget to subscribe to my YouTube Channel, I have a video coming up you don't want to miss: https://www.youtube.com/@EzekielAleke
Hi Guys
I published my first video on YouTube today
I will be creating more videos on:
EXCEL
SQL
POWER BI
PYTHON
Watch, subscribe and on post notifications
Donât miss my next videos
https://youtu.be/IXAbOPIWMt8
Dear Data Analyst,
It's Tomorrowâ ïž
Don't miss this class for anything.
Register now
This Saturday, we will build this dashboard together in Excel.
Using what we have learned in the last classes.
You will work on your own dataset I am going to give you after the class.
I will show you how to build your portfolio website and add your projects to it.
If you are just registering, I will share the link to the past classes with you.
Register now at half the initial price.
Please donât miss this class.
Register NOW: https://paystack.com/pay/dataanalysiscohort
5 Websites to get Data Sets for your Data Projects.
1. KAGGLE: https://www.kaggle.com/datasets
2. United Kingdom Gov Datasets https://data.gov.uk
3. Awesome Github Datasets: https://github.com/awesomedata/awesome-public-datasets
4.Paper With Code Datasets: https://paperswithcode.com/datasets
5. Data World: https://data.world/datasets/images
This Dashboard was created in Excelđ„
Using what we have learned in the past 3 classes.
I will show you how I created it, this Saturday.
I will give you your own dataset that you will use to create your own dashboard
I will also show you how to create a portfolio website and add this project to your portfolio website
Register now at half the initial price and I will share link to the last classes to you after registration.
Register NOW: https://paystack.com/pay/dataanalysiscohort
Yesterday I demystified the most useful functions in Excel:
Pivot Table
Pivot Chart
How to use TABLE in excel
Analyze Data
XLOOKUP
Vlookup
We will be creating an Excel Dashboard next week.
And I will show you how to create a portfolio website that you can add your excel project to.
The price is now half, Register now and get the link to our previous classes
https://paystack.com/pay/dataanalysiscohort
Kindly check your email if you registered for our classes.
If you have not registered do so NOW don't miss today's class for anything.
We will be teaching the most important thing in Excel: Pivot Table and LookUp functionsđ„
Register here NOW: https://paystack.com/pay/dataanalysiscohort
We are going to hold a session where we will build a Power BI DASHBOARD from scratch.
For absolutely FREE.
Make sure you are reading and practicing DATA ANALYSIS MADE EASY.
Exclusive to this COMMUNITY.đ„
If you registered for the DATA ANALYSIS MADE EASY COHORT kindly check your email.
This week's meeting link has been sent.
With the link to our last class.
if you are yet to register, kindly do so here Now: https://paystack.com/pay/DataAnalysisMadeEasyDiscountLink
And I will message you immediately after registration.
This Saturday I will explain in details the following in EXCEL:
IF
IFS
SUMIF
SUMIFS
AVERAGEIF
AVERAGEIFS
COUNTIF
COUNTIFS
MAXIFS
MINIFS
XLOOKUP
VLOOKP
PIVOT TABLE
PIVOT CHART
Register NOW donât miss this class.
Hereâs a discount link for everyone in this Channel: https://paystack.com/pay/DataAnalysisMadeEasyDiscountLink
In todayâs class we treated in details:
Introduction to Excel
Working with tables
FILTERING and SORTING data
Calculation with Formular/Functions:
SUM(), AVG(), COUNT(), TRIM(), UNIQUE(), CONCATENATE()/CONCATENATE(), LEFT(), MID() RIGHT(), AND()/OR()
And lots more.
Next week we will treat:
IF(), IFS(), SUMIF(), AVERAGEIF(), COUNTIF().
PivotTable, PivotChart and Analyze Data.
LookUP values: XLOOKUP and VLOOKUP
If you are yet to register.
Register NOW: https://paystack.com/pay/DataAnalysisMadeEasyDiscountLink
You will get the link to the recording of todayâs class after registration.
The class starts in 2hrs
If youâre yet to register.
Do so NOW: https://paystack.com/pay/DataAnalysisMadeEasyDiscountLink
And you will get the link to the class immediately.
