- 156
- 51 517
Data Analysis for Everyone
Приєднався 15 січ 2012
This channel is dedicated to videos that aim to simplify machine learning, data analysis and computer programming concepts.
5 Excel Functions you MUST know for Data Analysis in 2025
This video demonstrates the use of 5 important Excel functions for Data Analysis in 2025. It demonstrates Aggregate, DGet, GroupBy, PivotBy and Transpose functionality in Excel commonly used for Data Analysis.
Переглядів: 195
Відео
Exploratory Data Analysis Steps in Microsoft Excel - Simply Explained
Переглядів 155Місяць тому
This video demonstrates the most important steps of an Exploratory Data Analysis Phase using Microsoft Excel with Simple steps on how to perform the same.
How to perform Data Analysis in Spreadsheets without technical knowledge using AI
Переглядів 64Місяць тому
This video demonstrates how we can analyse data in Spreadsheets without the knowledge of Microsoft Excel or other tools using GenAI. The link to the AI tool used in the video is www.thebricks.com/
How to Analyse Stock Performance using Microsoft Excel
Переглядів 1992 місяці тому
This video explains how to Analyse a Stock's Performance with respect to an existing Benchmark using functions and formulas in Microsoft Excel. PLEASE NOTE: We are analysing performance returns of Apple Stock with respect to SNP 500 index, I happen to mention Price in the latter part of the video instead of Returns.
Why CoPilot in Microsoft Excel is the next best thing since slice bread for Data Analysts
Переглядів 1282 місяці тому
This video explains how Copilot can simplify data analysis tasks for Excel Data analysts
Mastering Excel Tables for Smarter Data Analysis
Переглядів 1792 місяці тому
This video demonstrates the use of Excel tables and why it is necessary to improve your data analysis skills.
How to Easily Analyse your Data using the GroupBy function in Excel.
Переглядів 3343 місяці тому
This video explains how to analyse your data in Excel using the GroupBy function.
VLOOKUP in Excel | A Step-by-Step Masterclass with Best Practices
Переглядів 443 місяці тому
This video explains how to use VLOOKUP in Excel and its current relevance. It also explores 2 real world use-cases of VLOOKUP and focusses on the best practices around the same.
Unlock the Power of Multiple Regression in Excel | Data Analysis & Predictions
Переглядів 2234 місяці тому
Unlock the Power of Multiple Regression in Excel | Data Analysis & Predictions
Automate The 5 Most Important Steps of A Data Analysis Project
Переглядів 524 місяці тому
Automate The 5 Most Important Steps of A Data Analysis Project
From EXCEL to R : Easy Data Analysis and Machine Learning Transition
Переглядів 1734 місяці тому
From EXCEL to R : Easy Data Analysis and Machine Learning Transition
Complete Data Analysis Project in Excel using AgenticAI and ChatGPT
Переглядів 2425 місяців тому
Complete Data Analysis Project in Excel using AgenticAI and ChatGPT
How to improve a Multiple Regression model for making better Predictions
Переглядів 3635 місяців тому
How to improve a Multiple Regression model for making better Predictions
Master Regression Analysis: Interpreting Coefficients & Dummy Variables Explained!
Переглядів 3626 місяців тому
Master Regression Analysis: Interpreting Coefficients & Dummy Variables Explained!
Multiple Regression - Full course in Excel
Переглядів 2986 місяців тому
Multiple Regression - Full course in Excel
Python made SIMPLE for Excel Analysts: Data Analysis
Переглядів 1276 місяців тому
Python made SIMPLE for Excel Analysts: Data Analysis
Excel Users: Discover the Power of Python for Data Analysis
Переглядів 1897 місяців тому
Excel Users: Discover the Power of Python for Data Analysis
Complete Data Analysis project using GenAI - No Code.
Переглядів 3707 місяців тому
Complete Data Analysis project using GenAI - No Code.
How to Build Mutiple Regression Analysis Metrics in Excel from scratch
Переглядів 3177 місяців тому
How to Build Mutiple Regression Analysis Metrics in Excel from scratch
Advanced Data Analytics in Microsoft Excel - Univariate, Bi-Variate and Multi-Variate Analysis
Переглядів 2557 місяців тому
Advanced Data Analytics in Microsoft Excel - Univariate, Bi-Variate and Multi-Variate Analysis
Machine Learning in Excel - Polynomial Regression
Переглядів 3897 місяців тому
Machine Learning in Excel - Polynomial Regression
Applied Statistics in Excel - Part 2: Measures of Central Tendencies and Dispersion
Переглядів 2508 місяців тому
Applied Statistics in Excel - Part 2: Measures of Central Tendencies and Dispersion
Applied Statistical Analysis using Microsoft Excel - Part 1 - Variables and Descriptive Statistics.
Переглядів 3808 місяців тому
Applied Statistical Analysis using Microsoft Excel - Part 1 - Variables and Descriptive Statistics.
Covariance And Correlation Analysis Explained Simply using Excel
Переглядів 3408 місяців тому
Covariance And Correlation Analysis Explained Simply using Excel
Can This NEW GENAI Platform replace all Data Analysts?
Переглядів 3418 місяців тому
Can This NEW GENAI Platform replace all Data Analysts?
LEARN This to evaluate your REGRESSION Analysis Model in Excel
Переглядів 2648 місяців тому
LEARN This to evaluate your REGRESSION Analysis Model in Excel
Statistical Analysis: From Simple to Multiple Regression in Excel
Переглядів 6698 місяців тому
Statistical Analysis: From Simple to Multiple Regression in Excel
Build your first Machine Learning Model in Excel using the Analysis Toolpak
Переглядів 1,2 тис.9 місяців тому
Build your first Machine Learning Model in Excel using the Analysis Toolpak
DIFFERENCE Between MACHINE Learning and STATISTICAL Learning.
Переглядів 5679 місяців тому
DIFFERENCE Between MACHINE Learning and STATISTICAL Learning.
Hello sir, in Aggregate function, how can I know what number represents what ? Like median is 12 ?
When you enter the function name in excel, it will show you what each number represents
thnx a lot .kindly make a video on correlation as well
Welcome. There is already a video of correlation and covariance on my channel, let me know if it was useful
thnx
Thank you
You're welcome
Can I install AI in excel?
You cannot, but you can use all the in built AI features like image extraction, pattern fill etc, alternatively you can install plugins like chatgpt plugin for ai features. I have made a video on that as well
hI sir the video was very useful if you add some diagrams and explain it will be more helpful also the voice is not clear so kindly check on the same
Sure, thanks, stay tuned for all data analysis content on my channel
Where is the data set used as example?
It's fairly famous, would be available on kaggle
why i dont have that " data from image " option?? have 19 version of excel
It's available for office 365 users, you can try the free online version of excel as well which has the feature
@@MrWeelwesley got it, thnaks
Thanks Wesley bhai, you have a subscriber!
Most welcome
Hi, you have explained each concept very nicely, please make full statistical analysis videos (including all concepts required for data analysis). hope you will make it soon, All the best
Thanks for the feedback. It motivates me to make more videos. Keep sharing
Working with more than 80,000 rows in excel I can vouch how much it slows with if formula 😢. This is an amazing tutorial and very efficient way to work with excel shared by you. Thank you so much 🙏
Thank you for the such a nice comment, this gives me the motivation to make more videos. Keep sharing.
Sir can you provide this excel work on my gmail
Will upload the dataset during my next video if that helps
@@MrWeelwesley sir I need this sheet if possible
Great!
Thanks
I like this video ❤❤❤
Thanks, such comments motivates to keep creating more videos
Hi, Your explanation is very clear and concepts are clearly explained. Will look forward to seeing more vidoes on power query subject. Thanks a lot sir.
Thanks for the kind feedback. I look forward to making more videos to help everyone learn
Nice video. I can seems to get the link. Kindly post again
Thank you. The dataset is freely available on kaggle. You can search for unicornstartup dataset on kaggle. Hope this helps
Thanks for this amazing video, can you please make more videos on power query 😊 Also, can use large dataset in power query for analysis?
Thanks for the kind feedback, let me make a video on when you should use Excel vs other power tools which will answer most of your queries
Really learned how to use AI on Excel. Thanks for the knowledge. Pls make more such videos to enhance our knowledge.
Thank you for the kind feedback
I like this video and ❤❤❤❤
Thank you very much
Thank you for this great explanation
Most Welcome
Thanks for clear explanation and demonstration!
Your welcome, and appreciate the nice feedback
Good Explanation !✨
Glad you liked it!
Hi, Link for notebook?
Sure will share
Nice explain sir👍
You are welcome
Thanks man. It was actually well done work!
Thank you for the nice feedback
Why don't you just do Ctrl-t to create the table of data?
Yes you can, this is for anyone who doesn't remember the shortcuts or know where a functionality exists within excel. I have used ctrl + t in my other videos
perfect ^^ if you want a boolean wether a variable is a datatype you can use is_instance("a", int) should return false
Thanks
Brilliant!
Thank you!
As you say, knowing what questions to ask is the true superpower. You don’t waste time writing and editing R!
Agreed, that's the trick on how to use it effectively
Thanks for this
You are welcome
please share machine-readable code through shareGPT plugins
Sure
The conversation context is not available in chatgpt api
Correct
Too good
Thanks
thanks for the nice comments buddy...