The Excel Experience
The Excel Experience
  • Видео 222
  • Просмотров 283 983
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 ...
Просмотров: 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 CHECKBOX ✅ feature in excel
Просмотров 1,2 тыс.3 месяца назад
New CHECKBOX ✅ feature in excel
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
MS EXCEL SHORTS COMPILATION (2023)
Просмотров 10411 месяцев назад
MS EXCEL SHORTS COMPILATION (2023)
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

Комментарии

  • @KulveerKundal
    @KulveerKundal 14 дней назад

    Cell range

  • @d.kmakwana1766
    @d.kmakwana1766 Месяц назад

    🙏🙏🙏🙏🙏

  • @wondwossen309
    @wondwossen309 Месяц назад

    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

  • @wondwossen309
    @wondwossen309 Месяц назад

    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

  • @mehulmistri4350
    @mehulmistri4350 Месяц назад

    Pleased share detailed Full video

  • @wondwossen309
    @wondwossen309 Месяц назад

    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

  • @wondwossen309
    @wondwossen309 Месяц назад

    Awesome

  • @renedanos8877
    @renedanos8877 Месяц назад

    Great video. Like several others here I havee only used data validation for drop down list. Not any more. Thanks

    • @theexcelexperience
      @theexcelexperience Месяц назад

      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. 😊

  • @moshegottlieb
    @moshegottlieb Месяц назад

    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!!!

    • @theexcelexperience
      @theexcelexperience Месяц назад

      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! 😊

  • @VitaminseaJane
    @VitaminseaJane Месяц назад

    Apparently Data Cleaning Part 6 doesnt work for me and I still couldn't figure why :(

  • @theexcelexperience
    @theexcelexperience Месяц назад

    5 Advanced DATA VALIDATION TRICKS in Excel (with Examples) ruclips.net/video/l8Q1l92O9uM/видео.html

  • @reshmabenson9826
    @reshmabenson9826 2 месяца назад

    So informative

  • @rishabhmehta3364
    @rishabhmehta3364 2 месяца назад

    Thank you so much for such invaluable and informative content. 🙏

    • @theexcelexperience
      @theexcelexperience 2 месяца назад

      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

  • @ChinmayPatel-p5f
    @ChinmayPatel-p5f 2 месяца назад

    Amazing! Amazing! Amazing! I did not know that you can do so much with this function.. Thanks for this excellent video!🫰🫰🫰

    • @theexcelexperience
      @theexcelexperience 2 месяца назад

      Thank you so much.. i'm glad that you liked the video..

  • @DanieleGaetanoSciuto
    @DanieleGaetanoSciuto 2 месяца назад

    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

    • @theexcelexperience
      @theexcelexperience 2 месяца назад

      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

  • @SanaMASCO
    @SanaMASCO 2 месяца назад

    Great

  • @KapilMakhija-p4b
    @KapilMakhija-p4b 2 месяца назад

  • @YvonneSiswick
    @YvonneSiswick 2 месяца назад

    What a fantastic video, best and most practical, useful and dynamic use of validation rules I’ve seen on You Tube, thank you.

    • @theexcelexperience
      @theexcelexperience 2 месяца назад

      Thank you so much for the wonderful feedback! I'm really glad you found the video practical and useful. 🫰🫰

  • @debashischandra661
    @debashischandra661 2 месяца назад

    I put a query on GROUPBY, please respond

  • @compdum
    @compdum 2 месяца назад

    If this data is put into table format the validation updates when data size increases

    • @theexcelexperience
      @theexcelexperience 2 месяца назад

      if this validation is in table format, it will update with table

  • @AnshulMarele-gbaa
    @AnshulMarele-gbaa 2 месяца назад

    Informative

  • @theexcelexperience
    @theexcelexperience 2 месяца назад

    🚀🚀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

  • @ChinmayHarishkumarPatel
    @ChinmayHarishkumarPatel 2 месяца назад

    Another great video... thanks🤘

  • @ChinmayHarishkumarPatel
    @ChinmayHarishkumarPatel 2 месяца назад

    Thanks for the video

  • @samiisam3185
    @samiisam3185 2 месяца назад

    Thank you for sharing 🙂

  • @ChinmayPatel-yr9gv
    @ChinmayPatel-yr9gv 2 месяца назад

    This is so useful.. I didn't know that we can use data validation like this also.. Thanks again..

  • @mansoorahmad4369
    @mansoorahmad4369 2 месяца назад

    Thanks 🙏

  • @BPraveenKumarV
    @BPraveenKumarV 2 месяца назад

    It's a good video kindly share details course of power query from scratch

  • @sanketv1
    @sanketv1 2 месяца назад

    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

    • @theexcelexperience
      @theexcelexperience 2 месяца назад

      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))

  • @chinmaypatel88
    @chinmaypatel88 2 месяца назад

    Gotcha!

  • @rameshkunda6775
    @rameshkunda6775 2 месяца назад

    Could you please do the Data Analysis on Real Estate Project.

  • @colinhuntley9729
    @colinhuntley9729 2 месяца назад

    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!!!

    • @theexcelexperience
      @theexcelexperience 2 месяца назад

      Awww🥹🥹.. Thank You So Much.. Also, checkout my Basic Data Validation video on my channel...

  • @X1AbuBadr1X
    @X1AbuBadr1X 2 месяца назад

    that is so advanced, thank you

  • @MagicOfMushrooms
    @MagicOfMushrooms 2 месяца назад

    I like this video. The AI voice is hard to listen to though.

    • @theexcelexperience
      @theexcelexperience 2 месяца назад

      Glad that you liked the video.. And thanks for the feedback 🫰🫰Appreciate it!

  • @ChandaniPatel-t9u
    @ChandaniPatel-t9u 2 месяца назад

    Thank You for all the tricks especially the last one!

  • @johanneskeller3794
    @johanneskeller3794 2 месяца назад

    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 !

    • @theexcelexperience
      @theexcelexperience 2 месяца назад

      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.

  • @LifeIsLife1978
    @LifeIsLife1978 2 месяца назад

    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.

  • @debashischandra661
    @debashischandra661 2 месяца назад

    How to install the GROUPBY function in excel worksheet, this function is not available in 2019 version

  • @calilthomas
    @calilthomas 3 месяца назад

    How can I get this function? I updated my excel (insider member) several times and it still does not have it nor groupby

    • @theexcelexperience
      @theexcelexperience 3 месяца назад

      in insider, currently this function is available in beta channel..

  • @kumaramit078
    @kumaramit078 3 месяца назад

    Plz send any file realited whatsapp bulk message

  • @kumaramit078
    @kumaramit078 3 месяца назад

    Can it work window7

  • @robertplata5284
    @robertplata5284 3 месяца назад

    Can an excel mocro program run on a network?

  • @internationaldiamondimport2608
    @internationaldiamondimport2608 3 месяца назад

    Hi

  • @chinmaypatel88
    @chinmaypatel88 3 месяца назад

    Thanks for the video...

  • @video1mwanga532
    @video1mwanga532 3 месяца назад

    Advanced

  • @video1mwanga532
    @video1mwanga532 3 месяца назад

    Send me more Thanks

  • @jeramiajamesjohnson
    @jeramiajamesjohnson 3 месяца назад

    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.

    • @theexcelexperience
      @theexcelexperience 3 месяца назад

      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.

  • @chinmaypatel88
    @chinmaypatel88 3 месяца назад

    Superb!