Top 10 Advanced Excel Tricks for Data Analysis - FREE Masterclass with Sample Files

Рет қаралды 309,809

Күн бұрын

Want to analyse data in Excel but don't want to waste hours? In this crisp & informative live stream, learn my favourite top 10 tricks for getting things done in Excel fast and right. We are going to learn:
1) NEW Dynamic Array functionality in Excel
2) NEW Text processing functions
3) Forecasting with a single click
4) Quick analytics
5) Conditional Formatting
6) How to combine two tables of data
7) Pivot Tables ++
8) Instant Dynamic Chart
9) Even Better Dynamic Chart
10) Getting more out of your data
⏱ Video Timestamps:
==================
6:36 Contents Overview
17:28 Tip 0 : Data Table
21:24 Tip 1 : Dynamic Array Functions
31:49 Point to be noted in Dynamic Array Functions
36:33 Tip 2 : New Text Functions
38:13 (a) TEXTBEFORE
38:49 (b) TEXTAFTER
39:28 (c) TEXTSPLIT
46:08 Tip 3 : One Click Forecasting
52:30 Tip 4 : Quick Analysis
59:18 Tip 5 : Conditional Formatting
01:02:31 (a) Highlight complete row based on a Formula
01:07:40 Tip 6 : Combine 2 Tables (DATA → RELATIONSHIPS)
01:16:09 Tip 7 : Pivot Table + + OR Power Pivot
01:26:36 Tip 8 : Instant Dynamic Chart
01:31:49 Tip 9 : Even Better Dynamic Chart
01:42:53 Tip 10 : Some Basic Tips
Thanks to Hritik Raj for creating these timestamps. 😀
📂 Download Sample File:
======================
Blank Data File: chandoo.org/wp/wp-content/upl...
Completed Workbook: chandoo.org/wp/wp-content/upl...
📺 Videos mentioned in the stream:
==============================
Power Pivot & DAX - • Getting started with P...
Dynamic Array Functions - • Beginner to Pro ~ Exce...
XLOOKUP - • I don't use VLOOKUP an...
Operator - • Excel Dynamic Arrays a...
Power Query (intro) - • Learn Power Query & Au...
Power Query (combine files) - • Powerful trick to comb...
#dataanalytics #advancedexcel

Пікірлер: 121

@roberttaylor3594 Жыл бұрын

I like the calm energy in your videos. thanks for not presenting yourself as an 'advertisement' or "TV show".

@MrWebadmn Жыл бұрын

I agree.. its so soothing that whenever I am not able to sleep I turn to Chandoo's and it works like magic... zzz within few minutes 🙂

@susmathapamgr9179 5 ай бұрын

@@MrWebadmnis

@CAhrithik Жыл бұрын

6:36 Contents Overview 17:28 Tip 0 : Data Table 21:24 Tip 1 : Dynamic Array Functions 31:49 Point to be noted in Dynamic Array Functions 36:33 Tip 2 : New Text Functions a) 38:13 TEXTBEFORE b) 38:49 TEXTAFTER c) 39:28 TEXTSPLIT 46:08 Tip 3 : One Click Forecasting 52:30 Tip 4 : Quick Analysis 59:18 Tip 5 : Conditional Formatting a) 01:02:31 Highlight complete row based on a Formula 01:07:40 Tip 6 : Combine 2 Tables (DATA --> RELATIONSHIPS) 01:16:09 Tip 7 : Pivot Table + + OR Power Pivot 01:26:36 Tip 8 : Instant Dynamic Chart 01:31:49 Tip 9 : Even Better Dynamic Chart 01:42:53 Tip 10 : Some Basic Tips

@hahua90 Жыл бұрын

Thanks bro

@chandoo_ Жыл бұрын

Thanks for sharing this Hrithik. Donut for you 🍩

@CAhrithik Жыл бұрын

Thank you sir, for this sweet donut and all your amazing videos for us😃❤️

@CAhrithik Жыл бұрын

@@hahua90 My please Ravi😃

@SathyavageeswaranR Жыл бұрын

One of the excellent info that I have come across! Thanks a lot, Chandoo. Really appreciate it. 🙏

@drivetrainerYT Жыл бұрын

Many thanks, Chandoo, you're as always strait to the point and openly informative.

@mirwaismasood7196 Жыл бұрын

This video exceeded my expectations. Thank you!

@amalaxel Жыл бұрын

Thanks a lot. Missed the live, but still enjoyed the replay. Useful tips bro !!!

@sebulemokwena9250 Жыл бұрын

Lot of content, much appreciated from South Africa

@QuantuMatrix Жыл бұрын

Thanks Chandoo for adding valueable content yet again

@mrstefanpersson Жыл бұрын

Great as always! 👌thanks!

@canirmalchoudhary8173 Жыл бұрын

Awesome webinar. Learnt forecast in one click

@sudhasomasundaram1509 Жыл бұрын

Thank you Chandoo. I can use the dynamic array function today. And yes, I would love an in-depth dynamic array class.

@hawwasheneen6654 Жыл бұрын

I'm Sheneen from Maldives 🇲🇻 thank you for sharing your valuable knowledge ❤️

@digitaljas5594 Жыл бұрын

Awesome tips Mr. Chandu

@suvarnadeshpande8007 Жыл бұрын

Thanks for sharing quick tips. This is very useful as I have just started using excel a while ago.

@mamalik1088 Жыл бұрын

Always nice info u delivered as usual SIR

@prakashchaudhari8444 Жыл бұрын

Excellent information as usual

@joseybera1474 Жыл бұрын

Loving this .Thanks

@daykundindsr Жыл бұрын

this is Haider Ali from Afghanistan . I am very happy to find you in you-tube and learned from your videos about data analysis by excel , thanks for your services for all people in the world.

@johnborg5419 Жыл бұрын

Thanks Chandoo. This was very interesting!!!

@andrewdove342 10 ай бұрын

Thanks Chandoo, its good learning to think analytically with Excel

@MEETMEKANNAN Жыл бұрын

Fantastic presentation - You are really amazing bro

@user-qy5vt9bk6p 3 ай бұрын

muchas gracias!

@Ogbo_Elf 11 ай бұрын

Great presentation. This is awesome

@user-qu6fg5xz4f 7 ай бұрын

Thank you Chandoo. Like your teaching and content.

@muaiqqibdeshmukh9563 Жыл бұрын

I loved dymanic arry sir thank you. I was not knowing about this function. I will watch some more videos of you on this. thanks again

@dollysiharath4205 Жыл бұрын

Your audio is clear.!!!

@oswaldbahati5868 4 ай бұрын

Oswald From Tanzania Am happy to see you in 2024

@taizoondean689 Жыл бұрын

Thankyou Sir 👍🙏

@eswariyer7025 5 ай бұрын

Thank you Chandoo!!

@fufamisgana7834 7 ай бұрын

Nice !

@Tony_Montana659 Жыл бұрын

Happy new year to you . great work with lots of info.😍

@mhkhan0466 Жыл бұрын

Hello, Glad to meet you. I m interested in Excel data Analysis. Enjoying your videos. Looking forward to having good time with you. thank you.

@sanjumondal9976 Жыл бұрын

Hello Sir , I'm from Kolkata, India You are my great teacher.

@Rose-xc7wz 11 ай бұрын

I have to say, I feel good that I am not the only one who finds and reproduces bugs in Excel. I have been doing it for years.

@sibonginkosimantinto9855 Жыл бұрын

Hello Chandoo, thank you am a beginner, and I have a great interest in learning data analytics. Cheers Swaziland.

@manishgarg1 4 ай бұрын

Thanks

@chandoo_ 4 ай бұрын

You are welcome. Thanks for the SUPER 😍

@hemantjoshi5034 Жыл бұрын

Hi Chandoo - Thanks for such a wonderful tutorial ! Can you please do some videos on how to leverage MS Excel for Statistics. If yes, please share the details. Again thank you !

@mahendrawavhal5475 2 ай бұрын

From India, Maharashtra

@sanatsafty Жыл бұрын

Hello Chandoo , you are a good teacher!!

@chandoo_ Жыл бұрын

Thank you! 😃

@paulasaam4439 4 ай бұрын

Hello Paul from Ghana

@agkalyan Жыл бұрын

Hello Chandoo, Thanks for this video, Missed to join live stream. But watcher replay video and it was very useful 👍 .

@adayatoffice7679 Жыл бұрын

loved it

@user-fu3vi2ud8x 3 ай бұрын

hi from marland usa

@tamunamchedlishvili4677 Жыл бұрын

great job Chandoo

@robertlansana7671 Жыл бұрын

Hi Robert Lansana from Sierra Leone. I can hear you loud and clear .

@thiagarajanneelamegam8640 Жыл бұрын

the second one method is awesome

@MrMarcusjames Жыл бұрын

Thanks!

@chandoo_ Жыл бұрын

You are so welcome Marcus. Thank you so much for the Super 😍

@johndove3711 4 ай бұрын

Hello from south New Jersey

@clintonphilip505 Жыл бұрын

Clear!

@anusudanshrestha8358 8 ай бұрын

hello..!! Thank you..

@wondwassenmengistu8772 9 ай бұрын

Hello from Ethiopia Africa

@bijaytanty8434 Жыл бұрын

Thanks Sir

@markp8600 Жыл бұрын

Hi Chandoo -- Happy New Year! I missed the "livestream" - thank you for the replay. USA

@fridayogbonna9592 11 ай бұрын

Great and awesome

@vaughnlancaster1504 3 ай бұрын

Ok. You’re right. My apologies. Have a great day. Thank You

@ambirikumposha1 Жыл бұрын

Greetings from Malawi

@riteshbijawat3489 Жыл бұрын

Hi Chandoo I am a regular visitor and do take reference your teachings in my daily level work. My Question is : How to calculate count by just changing the reference number.

@balaravi7399 Жыл бұрын

HI Chandoo, is there any regular classes for excel as subscription model for learning?

@cheikhahmadoutidianegueye4677 Жыл бұрын

the best

@user-ti2vk4zz1h Жыл бұрын

hi greeting from india chennai

@andriim3661 Жыл бұрын

Thanks, that is awesome. But I couldnt resolve one issue. How to create a measure in pivot table if it is built on data model from the only one table. Couldnt find this option

@shanmugapriyayu2141 Жыл бұрын

Please do a video on the functions that could help with mark analysis and teacher analysis to see how the performance is. It will be a great help. Im using some of the functions like average, max and min. Wish to learn about Ranks , the best teacher etc. .

@user-sy6ue8oy9h Жыл бұрын

Hello ....! everyone from the USA

@palakchawla5524 Ай бұрын

Hello sir.. Please give us tutorial for excel. New I create a account on Microsoft... Please give us some of videos on this particular topic

@user-qg8iv8sh8m 6 ай бұрын

Hi Chandoo, When I use pivot table & give formulae to a new cell...eg. as for point 7 of Agenda... to add value of sales per box. When I give formulae in new cell and drag it, it gives the constant value as of the first cell. How to adjust the setting to get the correct result as against constant value

@user-tq7yt7pb5g Жыл бұрын

hi much clear

@yashmehta6920 Жыл бұрын

Hello Chandoo Sir, In my excel there is no any option of pivot table ++ as you have drop down list of pivot table.. how do i get ?

@usmanayaz4617 Жыл бұрын

Which one is better to use microsoft excel or office365.?

@luvie692 Жыл бұрын

Chandoo, can you do a series on data cleaning and analysis next with Python or R? Pleaseeeeee 🙏🏼 I really enjoyed this livestream btw

@lerunnelefoane8498 Жыл бұрын

HELLOW AFRICA,BOTSWANA

@workukindie8811 3 ай бұрын

So, also how can we submit the splinted names in to one column.

@2010herat Жыл бұрын

Thanks for a great video. My excel has been crashing and won’t let me save the data. :( Seems like it’s not a user issue. 😂

@nondumisomginywa4843 Жыл бұрын

I am trying to analyse for a needs analysis struggled, still struggling, do you have other videos that deals with this sort of data?

@chandoo_ Жыл бұрын

What is the goal of the needs analysis. What data do you have?

@idongesitpeters8862 7 ай бұрын

Hi, I know this is 9 months late. I was trying to get the files for this session. Is that still available?

@philipantoni679 Жыл бұрын

I missed the live Stream :(

@dayamai4552 Жыл бұрын

mastttt

@igbidaokpoitaritheophilus3851 Жыл бұрын

HI, FROM THEOPHILUS NIGERIA

@kawalsingh1643 11 ай бұрын

hi love you

@Ricocase Жыл бұрын

14:48

@navinpithadia8057 Жыл бұрын

I donot have forcast icone in excell 2007,how to get,please

@neelamkushwaha1703 Жыл бұрын

in Dynamic array - when i hit enter , i still get only first value... then i have to manually pull down to get remaining values

@chandoo_ Жыл бұрын

You are probably not using Excel 365.

@twinnyinnocent5741 4 ай бұрын

YEAH

@radiali482 Жыл бұрын

Q:how to select column header

@agg4390 Жыл бұрын

6:00

@kiagupta9964 Жыл бұрын

00:22:00

@theblogger3664 Жыл бұрын

canu pleace make a end to end paid coures Data analysis one Power bi

@chandoo_ Жыл бұрын

I do have a course. See chandoo.org/wp/power-bi-course/

@mohammedaskar6031 Жыл бұрын

sir plse how to install excel free one video explain

@manharkothari8341 Жыл бұрын

Chay.

@hectorfurtado4188 Жыл бұрын

@AnselmAmagnoh 2 ай бұрын

@user-sy6ue8oy9h Жыл бұрын

Diet orange soda

@vaasu3970 2 ай бұрын

musk melon juise

@fbccreedmoor8733 Жыл бұрын

tea

@AnselmAmagnoh 2 ай бұрын

Tea

@radiali482 Жыл бұрын

Hi,drank Arabic Coffe ,Palestine

@himanshut114 11 ай бұрын

your audio is awesome ........... but go brush ........ you look liike sleepy

@vaughnlancaster1504 3 ай бұрын

i'm two minutes from quitting if you don't get on with it

@chandoo_ 3 ай бұрын

dude.. get off your high horse. This is a livestream replay. Feel free to skip to interesting part. I don't owe you anything.

@vaughnlancaster1504 3 ай бұрын

please quit introducing everyone. didn't get online to hear hellos please

@maggiobrc Жыл бұрын

u talk too much bro

@CMAFreedom Жыл бұрын

Thanks!

@chandoo_ Жыл бұрын

Thank you so much for the love and super CMA 😍