- 62
- 40 724
With OJASS
France
Приєднався 28 бер 2021
Discover 'How to' tutorials on Microsoft Excel, Python, Stata, and R, designed to boost your efficiency and skills.
Mastering Data Visualization in Python: Essential Data Preparation Tips!
Learn how to prepare your data effectively for stunning visualizations in Python! In this video, we cover essential data cleaning, transformation, and preparation techniques to make your plots insightful and impactful. Perfect for beginners and data enthusiasts!
#Python #DataVisualization #DataPreparation #DataScience #PythonTutorial #DataCleaning
#Python #DataVisualization #DataPreparation #DataScience #PythonTutorial #DataCleaning
Переглядів: 56
Відео
Pandas in Python for Data Analytics | A Complete Introduction. Data file included
Переглядів 552 місяці тому
In this video, we dive into the essentials of using Pandas in Python for data analytics. Whether you're a beginner or looking to sharpen your skills, this tutorial covers key concepts including: Loading data into Pandas DataFrames Calculating basic statistics and describing data Understanding and using loc and iloc for data selection Renaming columns for better clarity Exploring data with head(...
How to Use INDEX/MATCH with Multiple Criteria in Excel | Advanced Lookup Tutorial
Переглядів 204 місяці тому
In this tutorial, I’ll show you how to perform advanced lookups in Excel using INDEX and MATCH with three criteria. If you're struggling with VLOOKUP limitations or need more flexibility, this guide is for you! Whether you're an Excel beginner or looking to advance your skills, this step-by-step walkthrough will help you handle complex lookups easily. Be sure to like, comment, and subscribe for...
Excel's INDEX/MATCH dynamic search tutorial (XLOOKUP replacement)
Переглядів 1406 місяців тому
Unlock the full potential of Excel with the INDEX-MATCH function! Discover how to perform dynamic and precise data searches in this comprehensive tutorial. INDEX-MATCH allows you to search through large datasets efficiently, matching multiple criteria with ease. Whether you're analyzing sales figures by country and year or any other specific data point, this video will guide you step-by-step. E...
Excel's GROUPBY function, a Scam?
Переглядів 1996 місяців тому
In this tutorial, we'll show you how to use Excel's UNIQUE function in combination with other conditional functions to replicate the results of the 'GROUPBY' function. Learn step-by-step how to extract unique values and perform operations like summing, averaging, and counting within specific categories. Whether you're managing large datasets or just looking to streamline your data analysis, thi...
Excel Hack: Convert Numbers to Roman Numerals in Excel
Переглядів 566 місяців тому
Excel Hack: Convert Numbers to Roman Numerals in Excel
10 Essential Excel Functions You Need To Know
Переглядів 837 місяців тому
10 Essential Excel Functions You Need To Know
How to Create an Interactive Excel Dashboard
Переглядів 1377 місяців тому
How to Create an Interactive Excel Dashboard
Excel Hack: Format Multiple Cells in Seconds
Переглядів 307 місяців тому
Excel Hack: Format Multiple Cells in Seconds
Master Excel Pivot Tables with this Easy Tutorial (Free Download)
Переглядів 537 місяців тому
Master Excel Pivot Tables with this Easy Tutorial (Free Download)
How to Create a Dynamic Search Bar / Box in Excel
Переглядів 4107 місяців тому
How to Create a Dynamic Search Bar / Box in Excel
Master Excel Emojis! 🧚♂️📊 👩🏻❤️👨🏽😀😅🤣
Переглядів 487 місяців тому
Master Excel Emojis! 🧚♂️📊 👩🏻❤️👨🏽😀😅🤣
Excel Tips: Using Slicers, Hiding Cell Values, and UNIQUE function
Переглядів 657 місяців тому
Excel Tips: Using Slicers, Hiding Cell Values, and UNIQUE function
Master Excel with These Advanced Tips!
Переглядів 647 місяців тому
Master Excel with These Advanced Tips!
How to Create Dynamic Transpose of Data in Excel #excel
Переглядів 2187 місяців тому
How to Create Dynamic Transpose of Data in Excel #excel
Master Excel's People Graph Feature in Minutes
Переглядів 778 місяців тому
Master Excel's People Graph Feature in Minutes
Excel Data Entry WITHOUT Macros! Step-by-Step Tutorial
Переглядів 878 місяців тому
Excel Data Entry WITHOUT Macros! Step-by-Step Tutorial
How to Create Automated Salary/PaySlip in Excel - Save as PDF
Переглядів 3,2 тис.8 місяців тому
How to Create Automated Salary/PaySlip in Excel - Save as PDF
10 Top Excel Shortcuts You Can't Live Without
Переглядів 2,2 тис.8 місяців тому
10 Top Excel Shortcuts You Can't Live Without
Excel Functions Tutorial: LEFT, RIGHT, MID, LEN
Переглядів 808 місяців тому
Excel Functions Tutorial: LEFT, RIGHT, MID, LEN
Master Microsoft Excel in 20 Minutes
Переглядів 2148 місяців тому
Master Microsoft Excel in 20 Minutes
Descriptive Statistics in Excel - Under 1 Minute
Переглядів 558 місяців тому
Descriptive Statistics in Excel - Under 1 Minute
Ultimate Guide to Download World Bank Data in Panel Format
Переглядів 4379 місяців тому
Ultimate Guide to Download World Bank Data in Panel Format
Excel Interview Questions: What If Analysis, Loan Amortization, XLOOKUP & VLOOKUP Explained
Переглядів 1429 місяців тому
Excel Interview Questions: What If Analysis, Loan Amortization, XLOOKUP & VLOOKUP Explained
My First Drawing Experience With Pen Tablet- One by Wacom Medium
Переглядів 359 місяців тому
My First Drawing Experience With Pen Tablet- One by Wacom Medium
Great
Yo
Who is free?
Man, Excellent job. Thxs for you video
I'm back again...so informative
Thank you very much. The first part worked for mine.
Well done but mine doesn't work
Update your Excel or use the first option in this video ua-cam.com/video/zTwMYthAtyU/v-deo.html
ua-cam.com/video/zTwMYthAtyU/v-deo.html
@@with_ojass Thank you very much, The first one worked for me. I will seek to update my office to the current version.
I'm here again 😂😂😂
Who is free?
Very precise and informative video
❤❤
I'm here too
Welcome
Very useful tricks. My work will be much easier now.
You are welcome!. Thank you
Thanks for this
This is no Arabic number 😂
1 2 3 4... are the Arabic numbers
My ass who forgot that arabic numerals is what we use every day 🙂👍🏻
How to Create a Dynamic Search Bar in Excel ❤
Who is free?
Who is watching this now?
Nice.... ❤
Thanks
Impactful... Thank you
You are welcome
Don't forget to lock the ranges in the AVERAGEIF formula
lol
I'm here too
Welcome!
Great 👍
You are welcome!
Very impressive tutorial 10/10.... bring more of these.
🎉🎉🎉🎉 Great
You are welcome!
very good ... thanks
not good if you just want an independent copy...weird video. by the way don't use copy if you want to delete it either.
Thank you... I used undo to delete it
I will give it a try...
Will this work if i post the picture in powerpoint? Will it still update?
It works only in Excel. Thank you
“Adjust the width” While adjusting the vertical height with the word “height” on the screen. Try again bub
Thank you...well noted
Great shortcut
You are welcome!
I only make tables because i want to filter/sort
Use slicers for better experience: ua-cam.com/video/YC-uevadsZU/v-deo.html
👍
👍
Nice trick
Or, dubble click in the upper left corner. On the white triangle object
Wow impressive
You are welcome!
Great work senior
THANK you
😂😂😂
Simple and easy... 🎉
Great tutorial. I never knew about this. I have learned something new today.
You are welcome! @kasafidie
I'm here for banku
You are welcome!
Gari olonka
Banku
@@with_ojass Lol
Keep it up
I'm here
Welcome!
Brennan should start a UA-cam channel teaching DnD stuff (or else) since he loves teaching and already has a big fan base.
That's cool
@@with_ojass wtf, I commented this on another video and UA-cam must’ve glitched and put it on this. That’s so weird
@@Adam-oy6nc Happens sometimes when you scroll shorts too fast, it loads the comments from the previous video. Big agree though, Brennan teaching DnD with the passion of some of his GC answers would be phenomenal.
I’ll try to remember this the next time I need to use Roman numerals in excel…
You're welcome. You can also watch other informative tutorials on the channel.
Great tutorial 😘
Welcome