- Видео 222
- Просмотров 283 983
The Excel Experience
Канада
Добавлен 8 фев 2023
Namskar,
Welcome to The Excel Experience,
This channel is dedicated to everything Microsoft Office! Whether you're a beginner or an advanced user, our videos will help you master the most popular Office applications, including Excel, Word, PowerPoint, and Power BI.
The channel is designed to provide you with the tools and knowledge you need to work more efficiently and effectively in Office. We offer a wide range of topics, from basic functions to advanced techniques, all presented in a clear and easy-to-follow format.
So, whether you're looking to master Excel formulas, create engaging PowerPoint presentations, or analyze data with Power BI, our channel has got you covered.
Subscribe to our channel today to stay up to date with the latest Office tips and tricks!
Welcome to The Excel Experience,
This channel is dedicated to everything Microsoft Office! Whether you're a beginner or an advanced user, our videos will help you master the most popular Office applications, including Excel, Word, PowerPoint, and Power BI.
The channel is designed to provide you with the tools and knowledge you need to work more efficiently and effectively in Office. We offer a wide range of topics, from basic functions to advanced techniques, all presented in a clear and easy-to-follow format.
So, whether you're looking to master Excel formulas, create engaging PowerPoint presentations, or analyze data with Power BI, our channel has got you covered.
Subscribe to our channel today to stay up to date with the latest Office tips and tricks!
How to Create Bar of Pie Chart for Better Data Visualization?
Welcome to The Excel Experience! In this video, we'll show you how to create a Bar of Pie chart in Excel-a powerful tool for breaking down smaller data categories that might get lost in a regular pie chart.
What You'll Learn:
How to set up your data for a Bar of Pie chart
Step-by-step instructions to insert and customize the chart
Tips for adjusting the size and appearance of the second plot
Techniques to enhance your chart with color and styling options
Timestamps:
0:00 Introduction
0:25 Bar of pie chart
2:50 End
This chart type is perfect for making minor categories stand out and improving the clarity of your data visualization.
Checkout my other videos:
Advanced Excel SORTBY Function Tricks (with ...
What You'll Learn:
How to set up your data for a Bar of Pie chart
Step-by-step instructions to insert and customize the chart
Tips for adjusting the size and appearance of the second plot
Techniques to enhance your chart with color and styling options
Timestamps:
0:00 Introduction
0:25 Bar of pie chart
2:50 End
This chart type is perfect for making minor categories stand out and improving the clarity of your data visualization.
Checkout my other videos:
Advanced Excel SORTBY Function Tricks (with ...
Просмотров: 171
Видео
Advanced Excel SORTBY Function Tricks (with 6 Powerful Examples)
Просмотров 5752 месяца назад
In this video, we dive deep into the advanced uses of the SORTBY function in Excel. Whether you’re a beginner or an experienced Excel user, these six examples will help you take your data sorting skills to the next level! Topics Covered: Sorting data by text length in a column Sorting birthdates by month and day Sorting data by a custom list Sorting and concatenating data in a single cell Sorti...
Highlight & Rank Top3️⃣ Data in Excel Column Chart 📊
Просмотров 2142 месяца назад
Learn how to create a dynamic chart in Excel that highlights the top three sales months and ranks your data automatically! Whether you're analyzing sales figures or student performance, this tutorial will guide you step-by-step in visualizing your data like a pro. Perfect for anyone looking to make their reports more impactful and insightful. Timestamps: 0:00 Introduction 0:16 Excel Chart 3:56 ...
SORTBY Function in EXCEL | Explained Excel Function in just 2 Minutes
Просмотров 2242 месяца назад
Welcome to The Excel Experience! In this tutorial, we dive deep into the powerful SORTBY function in Excel. Learn how to dynamically sort your data based on one or more criteria, and see how easy it is to keep your data organized and up-to-date. This video is perfect for anyone looking to take their Excel skills to the next level, whether you're a beginner or an experienced user. Don't miss out...
Ultimate Excel Guide to Working with Percentages - Top Excel % Tricks
Просмотров 6442 месяца назад
In this video, I'll walk you through some essential techniques for working with percentages in Excel, whether you're a data analyst, student, or professional. These skills are crucial for anyone who deals with numbers and data. What you'll learn: How to calculate the percentage of a total. How to calculate percentage change over time. How to increase or decrease a number by a percentage. How to...
Create MULTIPLE DEPENDENT DROP-DOWN in Excel? (with/without XLOOKUP)
Просмотров 5322 месяца назад
In this tutorial, we’ll walk you through creating a dynamic multi-level drop-down list in Excel. Learn how to link categories, sub-categories, and products using both XLOOKUP (available in Excel 2021 and Excel 365) and an alternative method for earlier versions of Excel. We’ll also cover how to make these lists dynamic so they automatically update when new data is added. Plus, discover a bonus ...
Navigate Excel Workbooks 10 Times Faster with These SHORTCUTS
Просмотров 2,1 тыс.2 месяца назад
In this video, I’ll reveal the best shortcuts to navigate your Excel workbooks 10x faster! Whether you’re dealing with simple spreadsheets or complex data sets, these shortcuts will save you time and make you more productive. In this video, you'll learn: How to quickly move between worksheets How to go directly to the first or last worksheet How to add and manage worksheets efficiently And much...
5 Advanced DATA VALIDATION TRICKS in Excel (with Examples)
Просмотров 13 тыс.2 месяца назад
Welcome back to our Excel tutorial channel! In today's video, we're diving into 5 advanced data validation techniques in Excel, perfect for ensuring the integrity of your data. Whether you're managing a team, organizing events, or simply keeping your spreadsheets error-free, these tips are essential. In This Video, You Will Learn: 1. Ensuring Dates are Weekdays: Restrict meeting dates to weekda...
Calculate RANGE in Excel (with 2 examples)
Просмотров 3182 месяца назад
In this video, we will see how to calculate Range in Excel. Also, we will see how to find range with a condition in Excel. Timestamps: 0:00 Introduction 0:16 Calculate Range 1:01 Range with a condition 2:06 Conclusion Checkout my other videos: NEW Excel Function REGEX - RegexTEST, RegexEXTRACT and RegexREPLACE: ruclips.net/video/Yvsl9g3oF9M/видео.html Top 10 Microsoft EXCEL Tricks in 2024 YOU M...
New Function in EXCEL - PIVOTBY | Alternative of PivotTable
Просмотров 8333 месяца назад
New Function in EXCEL - PIVOTBY | Alternative of PivotTable
Add a Secondary Axis in Excel Chart (in just few clicks)
Просмотров 1953 месяца назад
Add a Secondary Axis in Excel Chart (in just few clicks)
New Excel Function - GROUPBY (every EXCEL users must know)
Просмотров 5853 месяца назад
New Excel Function - GROUPBY (every EXCEL users must know)
The Ultimate Excel Bullet Points Guide (2024)
Просмотров 4143 месяца назад
The Ultimate Excel Bullet Points Guide (2024)
5 Data Validation Tricks (with examples)
Просмотров 1,2 тыс.3 месяца назад
5 Data Validation Tricks (with examples)
Create Drop-Down List in Excel - 2 Minutes Excel Tricks
Просмотров 4693 месяца назад
Create Drop-Down List in Excel - 2 Minutes Excel Tricks
Top 10 Data Cleaning Tips in Excel in 2024
Просмотров 1,4 тыс.3 месяца назад
Top 10 Data Cleaning Tips in Excel in 2024
NEW Excel Function REGEX - RegexTEST, RegexEXTRACT and RegexREPLACE
Просмотров 2,7 тыс.4 месяца назад
NEW Excel Function REGEX - RegexTEST, RegexEXTRACT and RegexREPLACE
Never Miss a Bill Payment: Excel Tips for Managing Bills
Просмотров 2385 месяцев назад
Never Miss a Bill Payment: Excel Tips for Managing Bills
Excel Tips: Insert Slicers in Pivot Tables for Effortless Filtering!
Просмотров 2205 месяцев назад
Excel Tips: Insert Slicers in Pivot Tables for Effortless Filtering!
Top 10 Microsoft EXCEL Tricks in 2024 YOU MUST KNOW!!!
Просмотров 9175 месяцев назад
Top 10 Microsoft EXCEL Tricks in 2024 YOU MUST KNOW!!!
Digital Goal Planner | Google Sheets Template - Goal Tracker Spreadsheet - Habit Tracker
Просмотров 2599 месяцев назад
Digital Goal Planner | Google Sheets Template - Goal Tracker Spreadsheet - Habit Tracker
DATA BARS (Conditional Formatting) in Excel
Просмотров 27810 месяцев назад
DATA BARS (Conditional Formatting) in Excel
એક્સેલમાં ડેટા કેવી રીતે ફિલ્ટર કરવો? How to FILTER DATA IN EXCEL?
Просмотров 15410 месяцев назад
એક્સેલમાં ડેટા કેવી રીતે ફિલ્ટર કરવો? How to FILTER DATA IN EXCEL?
Conditional Formatting in Excel - TOP/BOTTOM RULES
Просмотров 25310 месяцев назад
Conditional Formatting in Excel - TOP/BOTTOM RULES
Conditional Formatting in Excel - Highlight Cells Rules
Просмотров 30211 месяцев назад
Conditional Formatting in Excel - Highlight Cells Rules
How to use TRACE PRECEDENTS & DEPENDENTS in Excel
Просмотров 46711 месяцев назад
How to use TRACE PRECEDENTS & DEPENDENTS in Excel
How to SORT by DATE in Microsoft EXCEL?
Просмотров 28511 месяцев назад
How to SORT by DATE in Microsoft EXCEL?
How to use Cell Reference: Relative, Absolute & Mixed
Просмотров 224Год назад
How to use Cell Reference: Relative, Absolute & Mixed
Cell range
🙏🙏🙏🙏🙏
What if there is a need to calculate acceptance criteria in the form of +/- plus or minus of 5 in 20 that is ranging from 15 to 25
What if there is a need to calculate in the form of +/- plus or minus of 5 in 20 that is ranging from 15 to 25
Pleased share detailed Full video
I would be glad if you could help me how to avoid the blank cell from appearing in the drop down list in ms word 2016 and earlier. What if we want to add more category along with "kids furniture" will it up date dynamicaly? Thank you so much
Awesome
Thank You 🫰
Great video. Like several others here I havee only used data validation for drop down list. Not any more. Thanks
Thanks a lot! I'm glad you found the video helpful. There’s so much more you can do with it! If you’re interested in more Excel tips, stay tuned for future videos. 😊
I was impressed by the methodology of your presentations let alone its content! One can learn the power of excel and how to right complex formulas (e.g. in the last example on how to prevent double booking of a meeting room). THANKS!!!
Thank you for the wonderful feedback! I'm glad you found both the content and the presentation style helpful. I always aim to apply real-life problems in my videos to make Excel’s powerful formulas more relatable. Appreciate your support and stay tuned for more! 😊
Apparently Data Cleaning Part 6 doesnt work for me and I still couldn't figure why :(
5 Advanced DATA VALIDATION TRICKS in Excel (with Examples) ruclips.net/video/l8Q1l92O9uM/видео.html
So informative
Thank you so much.. :)
Thank you so much for such invaluable and informative content. 🙏
I'm glad that you liked it.. Check out my another video on 6 Advanced use of SORTBY Function.. ruclips.net/video/BpRZ3i9HOWk/видео.htmlsi=sCkKNcbS1nRbPMwI
Amazing! Amazing! Amazing! I did not know that you can do so much with this function.. Thanks for this excellent video!🫰🫰🫰
Thank you so much.. i'm glad that you liked the video..
Simply fantastic this tutorial, I have been using the SORTBY formula for more than 2 years, but from today, thanks to this video, this formula will be used to the fullest by me. I did not know that sorting matrices could be derived from other formulas, great!!! Thank you very much Ciao from Italy
I’m so glad you found the tutorial !! Thanks for your kind words, good to know that I could help you discover more advanced uses. checkout my other videos on advanced use of data validation
Great
Thanks :)
❤
🫶🫶
What a fantastic video, best and most practical, useful and dynamic use of validation rules I’ve seen on You Tube, thank you.
Thank you so much for the wonderful feedback! I'm really glad you found the video practical and useful. 🫰🫰
I put a query on GROUPBY, please respond
If this data is put into table format the validation updates when data size increases
if this validation is in table format, it will update with table
Informative
Thank you so much ☺️
🚀🚀Discover 5 advanced Excel data validation techniques to keep your data error-free. Watch now and level up your skills!🤘👇 ruclips.net/video/l8Q1l92O9uM/видео.html
Another great video... thanks🤘
Thank you so much 🫰🫰
Thanks for the video
Thanks..
Thank you for sharing 🙂
I'm glad that you liked it..😀
This is so useful.. I didn't know that we can use data validation like this also.. Thanks again..
🤘🤘
Thanks 🙏
🫰
It's a good video kindly share details course of power query from scratch
Thank you so much..
can you please mention Formula here in (metting date-Col E) , time has also to be mentioned and next meeting cant be booked if it is <1 hr to the day end time
Haha... this is such a personal touch! Yes, you can absolutely add that validation too. You can do this by adding another column for the meeting time and then modifying the data validation formula for the meeting room. To ensure that the next meeting can't be booked if it's less than 1 hour before the end of the day (assuming your office time ends at 18:00), you can additional condition like this F2<TIME(17,0,0))
Gotcha!
Thanks :)
Could you please do the Data Analysis on Real Estate Project.
👍👍
Hi!, to be honest i have only used data validation to make lists! the use of custom as a validatation criteria is certainly new to me, but very, very useful indeed! you have a new subscriber!!!
Awww🥹🥹.. Thank You So Much.. Also, checkout my Basic Data Validation video on my channel...
that is so advanced, thank you
Thank You :)
I like this video. The AI voice is hard to listen to though.
Glad that you liked the video.. And thanks for the feedback 🫰🫰Appreciate it!
Thank You for all the tricks especially the last one!
I'm glad that you liked it... :)
your instruction regarding this special use of data validation is very useful for me . I have been looking for the possibility of customized data validation by using a formula for some time. No I'm happy to get the solution ! Thank you very much !
Thank you so much for your kind words! I'm really glad that the data validation tutorial was helpful for you. I truly appreciate you taking the time to share your feedback.
And now do it in vba code and will bring you whole results in less then 10 sec depending of sort and amount of data.
How to install the GROUPBY function in excel worksheet, this function is not available in 2019 version
This function is in Excel365
How can I get this function? I updated my excel (insider member) several times and it still does not have it nor groupby
in insider, currently this function is available in beta channel..
Plz send any file realited whatsapp bulk message
Can it work window7
Can an excel mocro program run on a network?
Hi
Hello..
Thanks for the video...
Advanced
Thanks for watching...
Send me more Thanks
Checkout my other videos too..
Can you help me? I was able to find it in the past but not now. I have multiple dropdown boxes that I want to be able to select and choose the same item from the lists. But I cannot copy and paste, it will mess it up. I remember something about shift/alt/and or ctrl, highlight and use the arrow key. But cannot replicate it.
Select the first dropdown cell, extend the selection to other cells with Shift, open the dropdown list using Alt + Down Arrow, navigate the list with Arrow Keys, and press Ctrl + Enter to apply the selected item to all highlighted cells. I hope this will solve your problem.
Superb!
Thank You 🤘🤘