- 60
- 37 442
With OJASS
France
Приєднався 28 бер 2021
Discover 'How to' tutorials on Microsoft Excel, Python, Stata, and R, designed to boost your efficiency and skills.
How to Use INDEX/MATCH with Multiple Criteria in Excel | Advanced Lookup Tutorial
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 more Excel tutorials!
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 more Excel tutorials!
Переглядів: 14
Відео
Excel's INDEX/MATCH dynamic search tutorial (XLOOKUP replacement)
Переглядів 1273 місяці тому
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?
Переглядів 1913 місяці тому
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
Переглядів 514 місяці тому
In this video, we’ll explore two handy Excel tricks that can save you time and effort. Tip 1: Generating a Sequence of Numbers Did you know you can easily generate a sequence of numbers in Excel? Simply enter the first three values, and Excel will recognize the pattern. When you drag down, it automatically generates the subsequent values. You can also use the SEQUENCE function for this task. Ti...
10 Essential Excel Functions You Need To Know
Переглядів 834 місяці тому
10 Essential Excel Functions You Need To Know
How to Create an Interactive Excel Dashboard
Переглядів 1304 місяці тому
How to Create an Interactive Excel Dashboard
Excel Hack: Format Multiple Cells in Seconds
Переглядів 284 місяці тому
Excel Hack: Format Multiple Cells in Seconds
Master Excel Pivot Tables with this Easy Tutorial (Free Download)
Переглядів 524 місяці тому
Master Excel Pivot Tables with this Easy Tutorial (Free Download)
How to Create a Dynamic Search Bar / Box in Excel
Переглядів 2645 місяців тому
How to Create a Dynamic Search Bar / Box in Excel
Master Excel Emojis! 🧚♂️📊 👩🏻❤️👨🏽😀😅🤣
Переглядів 415 місяців тому
Master Excel Emojis! 🧚♂️📊 👩🏻❤️👨🏽😀😅🤣
Excel Tips: Using Slicers, Hiding Cell Values, and UNIQUE function
Переглядів 615 місяців тому
Excel Tips: Using Slicers, Hiding Cell Values, and UNIQUE function
Master Excel with These Advanced Tips!
Переглядів 635 місяців тому
Master Excel with These Advanced Tips!
How to Create Dynamic Transpose of Data in Excel #excel
Переглядів 995 місяців тому
How to Create Dynamic Transpose of Data in Excel #excel
Master Excel's People Graph Feature in Minutes
Переглядів 625 місяців тому
Master Excel's People Graph Feature in Minutes
Excel Data Entry WITHOUT Macros! Step-by-Step Tutorial
Переглядів 825 місяців тому
Excel Data Entry WITHOUT Macros! Step-by-Step Tutorial
How to Create Automated Salary/PaySlip in Excel - Save as PDF
Переглядів 2,9 тис.5 місяців тому
How to Create Automated Salary/PaySlip in Excel - Save as PDF
10 Top Excel Shortcuts You Can't Live Without
Переглядів 2,2 тис.5 місяців тому
10 Top Excel Shortcuts You Can't Live Without
Excel Functions Tutorial: LEFT, RIGHT, MID, LEN
Переглядів 775 місяців тому
Excel Functions Tutorial: LEFT, RIGHT, MID, LEN
Master Microsoft Excel in 20 Minutes
Переглядів 1976 місяців тому
Master Microsoft Excel in 20 Minutes
Descriptive Statistics in Excel - Under 1 Minute
Переглядів 526 місяців тому
Descriptive Statistics in Excel - Under 1 Minute
Ultimate Guide to Download World Bank Data in Panel Format
Переглядів 2866 місяців тому
Ultimate Guide to Download World Bank Data in Panel Format
Excel Interview Questions: What If Analysis, Loan Amortization, XLOOKUP & VLOOKUP Explained
Переглядів 1296 місяців тому
Excel Interview Questions: What If Analysis, Loan Amortization, XLOOKUP & VLOOKUP Explained
My First Drawing Experience With Pen Tablet- One by Wacom Medium
Переглядів 327 місяців тому
My First Drawing Experience With Pen Tablet- One by Wacom Medium
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
Wow
wow