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

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:
======================

📺 Videos mentioned in the stream:
==============================


#dataanalytics #advancedexcel

[roberttaylor]

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

[shreyanshdangi]

after going through all your EXCEL Data Analyst playlist videos...i already covered 95% topics in smaller videoes.

I covered this video just by checking whether something was left or not in just HALF AN HOUR.

All credit goes to you!!!

[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

[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.

[polsecuya]

Thank you, Teacher Chandoo, love from Philippines

[amalaxel]

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

[mirwaismasood]

This video exceeded my expectations. Thank you!

[canirmalchoudhary]

Awesome webinar. Learnt forecast in one click

[hawwasheneen]

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

[andrewdove]

Thanks Chandoo, its good learning to think analytically with Excel

[sebulemokwena]

Lot of content, much appreciated from South Africa

[mhkhan]

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.

[QuantuMatrix]

Thanks Chandoo for adding valueable content yet again

[sanjumondal]

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

[sudhasomasundaram]

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

[sibonginkosimantinto]

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

[Rose-xcwz]

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.

[qufgxzf]

Thank you Chandoo. Like your teaching and content.

[vaughnlancaster]

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

[oswaldbahati]

Oswald From Tanzania
Am happy to see you in 2024