- 72
- 49 309
JET-Joy Excel Training
India
Приєднався 26 лис 2019
Platform to Learn Advance Technique and Feature in MS Excel.
Excel Magic! Auto Reconcile Sheets & Spot Variances Instantly! 🔥 by using advance excel 365 formulas
"Are you spending hours manually comparing Excel sheets? 🤯 Say goodbye to manual reconciliation! In this video, I’ll show you an amazing Excel trick to automatically compare two or more sheets and spot variances instantly-all without complex formulas! 🎯
🔥 What you’ll learn:
✅ Auto-reconciliation between multiple sheets in Excel
✅ Find missing or incorrect values effortlessly
✅ Get a clean variance list in just a few clicks!
📊 Whether you're an accountant, data analyst, or Excel enthusiast-this trick will save you HOURS of work! Don’t miss out!
⚡ Subscribe now for more Excel automation hacks! 🚀"
🔥 What you’ll learn:
✅ Auto-reconciliation between multiple sheets in Excel
✅ Find missing or incorrect values effortlessly
✅ Get a clean variance list in just a few clicks!
📊 Whether you're an accountant, data analyst, or Excel enthusiast-this trick will save you HOURS of work! Don’t miss out!
⚡ Subscribe now for more Excel automation hacks! 🚀"
Переглядів: 774
Відео
Say Goodbye to Manual Splitting: Discover new TEXTSPLIT Formula in MS Excel
Переглядів 1,1 тис.3 місяці тому
"🚀 Welcome to our channel! In today’s video, we’re diving deep into one of Excel's newest features: the TEXTSPLIT function. If you've ever faced the hassle of splitting text data into separate cells, this powerful function will change the way you work with spreadsheets forever! 🔍 What You'll Learn: How to use TEXTSPLIT step-by-step Real-life examples that will make your data management a breeze...
Convert Pivot Table Values to Crores: Simplify Your Data in Excel
Переглядів 8304 місяці тому
Transform your data presentation in Excel with our latest tutorial on converting Pivot Table values into crores! 💰 In this video, we'll guide you through the simple steps to make your financial data more readable and impactful by scaling it down effectively. Learn how to: Convert large numbers into crores for better comprehension Use Excel functions to automate the conversion process Enhance yo...
Say goodbye to complex nested IF statements and use XLOOKUP for Aging calculation
Переглядів 5754 місяці тому
Video Description: Unlock the full potential of Excel with our latest video on advanced aging techniques! 🚀 In this tutorial, we'll show you how to use the powerful XLOOKUP function to streamline your aging analysis, cutting down your formula writing time by 10x or more. Say goodbye to complex nested IF statements and discover how XLOOKUP can simplify your data management while improving accura...
Transform Your Excel Charts: Highlight Highs & Lows with Dynamic Colors!
Переглядів 8375 місяців тому
In this tutorial, you'll learn how to create a dynamic bar chart in Excel that automatically highlights the highest value in green and the lowest value in red. This technique makes it easy to visualize key data points at a glance. In this video, we'll cover: Setting up your data for the bar chart. Using conditional formatting to highlight the highest and lowest values. Customizing your chart to...
Doughnut Progress Circle Chart in Excel as NEVER seen before!
Переглядів 617 місяців тому
Discover a unique approach to progress circle charts using the doughnut chart as a base. We’ll also explore an Excel chart trick to enhance your project visuals. 🚀
Actual vs Budget Chart with Variance Analysis with Emoji Indicators 🟢🔴👍
Переглядів 1,1 тис.7 місяців тому
Welcome to our comprehensive Excel tutorial on creating an Actual vs Budget chart with variance analysis! In this video, we'll guide you through the step-by-step process of visualizing your financial data using engaging emoji indicators-green circles for positive variance and red circles for negative variance. Whether you're managing a personal budget or handling corporate finances, this tutori...
Search multiple files in folder by using Excel 365 - TEXTJOIN -Don’t miss out on these expert tips
Переглядів 1,5 тис.7 місяців тому
“Discover the secrets of Excel’s TEXTJOIN function in this must-watch tutorial! Learn how to effortlessly search across multiple files and consolidate data like a pro. Whether you’re a seasoned Excel user or just starting out, this video will transform the way you handle large datasets. Don’t miss out on these expert tips - Subscribe and stay ahead in the Excel game!”
Magic of the UNIQUE function in Excel - Say no to duplicates!
Переглядів 508 місяців тому
Elevate your Excel skills to new heights! 🚀 Join me in this thrilling tutorial where we unravel the mysteries of Excel’s UNIQUE function. Say goodbye to tedious data sorting and hello to effortless uniqueness in your spreadsheets. 🔍 What You’ll Learn: The ins and outs of the UNIQUE function Practical examples to apply in your daily tasks Tips and tricks to maximize your data management efficien...
MS Excel to create a Half Donut Chart and visually represent your data in an eye-catching way
Переглядів 9048 місяців тому
In this tutorial, learn how to create an eye-catching half donut chart using Microsoft Excel. Donut charts are great for visualizing proportions and comparing data segments. We’ll cover the step-by-step process, including selecting data, formatting the chart, and adjusting settings to create a professional-looking half donut chart. Whether you’re a beginner or an Excel pro, this tutorial will h...
Budget vs actual 3D chart in Excel - In less than 5 minutes
Переглядів 1048 місяців тому
In this tutorial, we dive into the world of budget vs actual charts using Excel. 📊 Whether you’re tracking project performance, sales, or costs, understanding the variance between your budgeted and actual values is crucial. Join us as we explore how to create dynamic charts that visually represent these differences. No macros or VBA required!
Discover the Art of Advanced Filtering - Transform Your Data World (Part-6)-Shortcut to launch
Переглядів 3411 місяців тому
Discover the Art of Advanced Filtering - Transform Your Data World (Part-6)-Shortcut to launch
Discover the Art of Advanced Filtering - Transform Your Data World (Part-4), - And/OR/wildcards
Переглядів 4411 місяців тому
Discover the Art of Advanced Filtering - Transform Your Data World (Part-4), - And/OR/wildcards
Discover the Art of Advanced Filtering - Transform Your Data World - (Part-3)-Extract filter only
Переглядів 8911 місяців тому
Extract Data to Another Worksheet Hidden Tips (to extract only required Columns)
Discover the Art of Advanced Filtering - Transform Your Data World (Part-2) - Multiple criteria
Переглядів 8111 місяців тому
Discover the Art of Advanced Filtering - Transform Your Data World (Part-2) - Multiple criteria
Discover the Art of Advanced Filtering - Transform Your Data World (Part 1)
Переглядів 1911 місяців тому
Discover the Art of Advanced Filtering - Transform Your Data World (Part 1)
Excel Magic: Send Emails Without Coding! Hyperlink Hacks for Email Wizards 🚀✉️
Переглядів 310Рік тому
Excel Magic: Send Emails Without Coding! Hyperlink Hacks for Email Wizards 🚀✉️
Mastering Excel: Uncover Hidden Insights with Advanced Data Comparison Techniques
Переглядів 72Рік тому
Mastering Excel: Uncover Hidden Insights with Advanced Data Comparison Techniques
Auto Currency Conversion in MS Excel - New Feature ~
Переглядів 6192 роки тому
Auto Currency Conversion in MS Excel - New Feature ~
Large & Small Formulas in MS Excel - Less Known but very powerful
Переглядів 1102 роки тому
Large & Small Formulas in MS Excel - Less Known but very powerful
XLOOKUP with Multiple Lookup Value | Advance EXCEL Feature
Переглядів 1182 роки тому
XLOOKUP with Multiple Lookup Value | Advance EXCEL Feature
One Pivot Table from two or Multiple Tables - Power Pivot | Very Easy & Useful
Переглядів 1902 роки тому
One Pivot Table from two or Multiple Tables - Power Pivot | Very Easy & Useful
Table Range - Excel Formula Typing with Ease
Переглядів 872 роки тому
Table Range - Excel Formula Typing with Ease
Pivot Unpivot Data in MS Excel by Using Power Query. You will be surprised at how easy it is.
Переглядів 742 роки тому
Pivot Unpivot Data in MS Excel by Using Power Query. You will be surprised at how easy it is.
Multiple Value Lookup in Single Cell | Very simple after 365 formulas
Переглядів 962 роки тому
Multiple Value Lookup in Single Cell | Very simple after 365 formulas
XLOOKUP IN ADVANCE EXCEL | WITH DYNAMIC LOOKUP RANGE
Переглядів 9852 роки тому
XLOOKUP IN ADVANCE EXCEL | WITH DYNAMIC LOOKUP RANGE
DEPENDABLE DROPDOWN | ADVANCE EXCEL | By using Excel 365 Formulas
Переглядів 412 роки тому
DEPENDABLE DROPDOWN | ADVANCE EXCEL | By using Excel 365 Formulas
Dynamic Array Excel365/2021| Get Value in Multiple Cells | Change the way you write Formula in Excel
Переглядів 852 роки тому
Dynamic Array Excel365/2021| Get Value in Multiple Cells | Change the way you write Formula in Excel
Justify your Text in Excel | without using Wrap & Merge | Very Useful Excel Feature
Переглядів 442 роки тому
Justify your Text in Excel | without using Wrap & Merge | Very Useful Excel Feature
OFFSET function in Excel - To make your Cell reference Dynamic | Mysterious formulas, One must learn
Переглядів 5252 роки тому
OFFSET function in Excel - To make your Cell reference Dynamic | Mysterious formulas, One must learn
Sir 20 se jada file search nahi ho rahi h
Thank you for the video. It is really helpful in my daily working
It's my pleasure
Helpful 🤝
Glad you found it useful.
Thank you so much man,
You're welcome!
This was very helpful! I was able to complete my work task in a much shorter time. Thank you
Glad it helped!
Lot of ❤
THANKS, BUT THERE IS A LIMITATION USING THIS FORMULA, CAN BE SEARCHED UP TO 80 FILES, MORE THAN 80 FILES CANNOT WORK BY THIS RULE.
Thanks for update
Very helpful! Thanks
You're welcome!
can we do this type of search with word files ? the files names are in english
Yes
Paaji bahut vadiya
Good learning course
Thanks - Great Information
Not working sir
Pls share screenshot
Thanks, that was super helpful.
Nice
Sir what if the financial year starts from May... Can this quarter formula be further modified
Yes
Very nicely explained. Thanks
You are welcome
Very well explained 😊💯
Thanks 🙂
sir i have one confutation How you decided quter 444,111,222 ? please give me the assistance ...
I am considering Indian financial year from April to March. So Jan to mar will be 4th quarter. That's why use choose formula to convert first three months of calendar year to 444 for 4 quarter and follows
Great trick Vijay ji ,Excel guru
Eagerly wait for more😊.. good one.
Sure 😊
What if date is not sorted and you are not allowed to sort it then choose will not work right !
No, it will work because choose formula is linked with only one cell
Thank you
Great ...
What great information that it 👏👏👏🔥 Thanks a lot for this vedio 🎉
Short and clear. Thank you.
You're welcome!
This is great. Thank you
Welcome
Sir apke wjh se meri excel bahut acchi h
Awesome 👌 sir.
Amazing 👏
Very good.....keep it up dear
Very informative video sir
Very informative video
Wah g wah
Awesome!! Sir thanks for such useful information method to lookup right to left.
Very nice Sir ✌ Thankyou for sharing.