Excel's NEW Checkboxes Are Incredibly Cool! Here's why

Поділитися
Вставка
  • Опубліковано 30 тра 2024
  • Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
    In this video, I'll introduce you to the brand-new checkboxes in Excel. They're simple and much better than the old ways we used to do things. I'll take you through different ways to use these checkboxes, not just for keeping track of your to-do list. In fact, we'll be creating an interactive Excel dashboard using with the checkboxes.
    ⬇️ Download the file: pages.xelplus.com/checkboxes-...
    Note on availability: The new Excel checkboxes are currently available in Office 365 beta version.
    But first, I'll guide you step by step on how to use these checkboxes in Excel. You'll learn how to keep track of your tasks - then you'll learn how count the total number of checkboxes and also how to count the number of checked checkboxes and add it at the top of our Excel sheet. You'll then learn how to combine these checkboxes with formulas for smarter data analysis - I show the combination with the FILTER function in this example - Then you'll learn how to combine the state of the checkbox with conditional formatting, so that you can change the color and formatting of the entire row when an item is checked. Finally, you'll learn how to add a timestamp to a cell when a checkbox is checked. This is great for task and project management.
    This video is perfect for beginners and for those who want to discover new features in Excel and also learn some dashboard tricks. I've made sure everything is easy to understand, with no complicated terms - just simple, clear steps that you can follow along.
    🌍 My Online Courses ► www.xelplus.com/courses/
    00:00 How to Insert Checkboxes in Excel
    00:19 New Checkboxes in Excel Basics
    03:23 Count Checked Checkboxes
    07:05 Combine Checkbox with Formulas
    08:39 Conditional Formatting with Checkboxes
    11:02 Bonus! Add a Timestamp when Checked
    14:00 Wrap Up
    ➡️ Join this channel to get access to perks:
    / @leilagharani
    🎬 LINKS to related videos:
    🆕 Best NEW Excel Features EVERYONE Needs: • Best NEW Excel Feature...
    👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
    🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
    🎥 RESOURCES I recommend: www.xelplus.com/resources/
    More resources on my Amazon page: www.amazon.com/shop/leilagharani
    🚩Let’s connect on social:
    Instagram: / lgharani
    LinkedIn: / xelplus
    👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
    #Excel

КОМЕНТАРІ • 880

  • @LeilaGharani
    @LeilaGharani  6 місяців тому +103

    Grab the file I used in the video from here 👉 pages.xelplus.com/checkboxes-new-file
    I hope you like the video. Checkboxes are currently a Beta feature in Microsoft 365. Hopefully it will be rolled out soon to everyone.

    • @RAMBOau
      @RAMBOau 6 місяців тому +5

      Can you show us the consequences of using iterative calculations incorrectly

    • @brenner2297
      @brenner2297 6 місяців тому

      I really like your helpful tutorials ❤

    • @bkbaxterNYnowIN
      @bkbaxterNYnowIN 6 місяців тому +12

      How do I sign up to be able to use beta features?

    • @hibee04
      @hibee04 6 місяців тому +8

      Thank You Leila. I was just going to message you that the feature is not on my version of excel. (i do have the current version and get auto updates)

    • @juanrsosa
      @juanrsosa 6 місяців тому

      Were can we follow up on new releases to make sure the updates roll up?, I finally was abe to use the insert image on cell, really nice feature, but it took a while to be released with some minimal changes to the way you showed on your video

  • @TaxTimeForever
    @TaxTimeForever 6 місяців тому +230

    Been waiting 25 years for this

    • @LeilaGharani
      @LeilaGharani  6 місяців тому +24

      It truly was about time.

    • @bc4198
      @bc4198 6 місяців тому +5

      Frankly, I find it hard to applaud now, versus decades ago.

    • @YouTubeGlobalAdminstrator
      @YouTubeGlobalAdminstrator 6 місяців тому +11

      "We didn't have the technology 25 years ago for checkboxes"
      Microsoft (probably) 😅

    • @josesanabria6414
      @josesanabria6414 6 місяців тому +3

      It finally works like you would intuitively think it does. 🎉

    • @danielsequeira6142
      @danielsequeira6142 6 місяців тому +1

      Totally

  • @mulisaurus
    @mulisaurus 4 дні тому +1

    WOW! I just finished slaving away for a client at creating a massive Risk Management risks selector using checkboxes (the old way) and assigning each one to a cell to I can record the true or false value and then do whatever I want with it from there. Now I see this and I smile and cry at same time.

  • @justinwduff
    @justinwduff 6 місяців тому +66

    Love that it wasn't JUST about checkboxes, but included interesting elements of design and a few cool things you can do with checkboxes. I think this is one of your best videos.

  • @Paladin101
    @Paladin101 2 місяці тому +9

    Any idea why this is taking so long to be release? I have 365 for business and we still don’t have this yet I’ve seen questions on it online dated back in September of last year!

  • @julianbuckell6257
    @julianbuckell6257 6 місяців тому

    Excellent! I have been putting off some work involving checkboxes, and boy, am I glad I waited. This is a tremendous improvement. Thanks MS and Leila.

  • @19761999
    @19761999 Місяць тому

    Leila, I can't thank you enough. Not just for this, but for all the things I've learned from you over the years. Lady you rock!

  • @dusty975
    @dusty975 6 місяців тому +45

    I wish all teachers were as good as you, Leila .... very clear, consise and useful instruction.

  • @desuniahardware647
    @desuniahardware647 6 місяців тому +8

    It's remarkable how much information she can fit into 15 minutes. Well done!

  • @kuuuyajim
    @kuuuyajim 6 місяців тому +8

    This would be a game changer for those who are still using Excel as dashboards. We are already using Power BI but I'll try to play with it once it's out. Thank you, Leila! ❤

  • @myoldmate
    @myoldmate 6 місяців тому +1

    Whoosh.
    Beyond my comprehension.
    Thank you for trying to explain.
    I really appreciate your skills.❤

  • @goodgollywally
    @goodgollywally 5 місяців тому

    This is a great tutorial. I plan on using it to keep track of a number of tasks that I have to complete to prepare for an upcoming surgery. I can see many uses for this type of tracking table. You explain things so well and it is easy to follow along..I had to update my version of MS 365 using the latest beta versions.

  • @SothearithKONGMrMuyKhmer
    @SothearithKONGMrMuyKhmer 6 місяців тому +1

    Great tutorial. Thanks so much Leila. This will help me switch from Outlook to-do or OneNote to the new Excel checkbox here. 😘

  • @elzumba70
    @elzumba70 Місяць тому

    This video is packed with tips. Pure gold!

  • @AnthonyEnglish
    @AnthonyEnglish 6 місяців тому +7

    This checkbox functionality is so good! It’s been a constant frustration for me that learning and using checkboxes in Google Sheets takes about a minute to learn, but on Excel, it had the confusing and clunky developer tab. Now we’ve got simple checkboxes! Hooray!

    • @LeilaGharani
      @LeilaGharani  6 місяців тому +1

      It really was about time. Thanks for tuning in, Anthony!

  • @DeclanHiggins-YoutubeChannel
    @DeclanHiggins-YoutubeChannel 6 місяців тому +1

    Thanks for this great video on checkboxes ✅ Leila. Excel just keeps getting better with time 😊

  • @thabisasoko2568
    @thabisasoko2568 6 місяців тому

    Hi Leila. This is useful tool for repitative to do list of task which works well as a checkpoint to avoid missing key stuff. Thank you for your insighful and exciting work🤓

  • @markhuang368
    @markhuang368 6 місяців тому +5

    The last trick is something that really amazed me. Thank you again Leila.

    • @LeilaGharani
      @LeilaGharani  6 місяців тому +6

      I love it too. It was actually one of our team members who came up with it. 🥰

  • @catharinabester1452
    @catharinabester1452 6 місяців тому

    I love your videos and tutorials! I discover all sorts of helpful features that makes MS applications more practical and applicable to my job, team and business. This is a great feature and business application example for my marketing team during NPD launch ready preparation. This check list cover will make it easy to turn my existing table of requirements into a checklist without using Tasks or Loop to tack outstanding elements within my product information hub. Love it and thank you!

  • @aiasaiascon3894
    @aiasaiascon3894 5 місяців тому

    Really cool video Leila !!! Targeted, Useful, Practical, Fun, all in one!!!!

  • @ctojaga1
    @ctojaga1 2 місяці тому

    This is so great! Looking forward to more of your topics. Glad I ran across you today!

  • @markpodesta4605
    @markpodesta4605 6 місяців тому

    Thank you Leila. Looking forward to using checkboxes.

  • @mramsch
    @mramsch 6 місяців тому +35

    WOW, this iterative calculation mode opens up a completely new world of possibilities (and trapdoors 😂)! Thanks heaps for drawing our attention to this!

    • @LeilaGharani
      @LeilaGharani  6 місяців тому +2

      True :) Glad you found it helpful.

    • @gt3726b
      @gt3726b 6 місяців тому

      Amazing! One step closer to the dream of non-volatile random numbers.
      =LET(
      cell_address,ADDRESS(ROW(),COLUMN()),
      x,INDIRECT(cell_address),
      IFS(
      x=0,TEXTSPLIT(RAND() & ";" & cell_address,";"),
      OFFSET(x,0,1)cell_address,TEXTSPLIT(RAND() & ";" & cell_address,";"),
      TRUE,TEXTSPLIT(x & ";" & cell_address,";")
      )
      )

    • @alexanderschmidt75
      @alexanderschmidt75 5 місяців тому

      I have used them to calculate systems of differential equations, it works like a charm!

    • @giodanq759
      @giodanq759 17 днів тому

      I have 365 but the checkbox is know where to be found

  • @ziasiddique3172
    @ziasiddique3172 5 місяців тому +1

    This was one of your best videos. So well thought out. Learnt a lot. There is lot that you can learn when given a simple example. The most important thing is the practical uses of this in the workplace.

  • @DavidNurbin
    @DavidNurbin 2 місяці тому

    This is amazing! I work with a PM that uses colors to represent everything. When I need to work on her info as data, I have to go and copy out cells based on colors to export them. I got her to use the sheets, but this will give us just what we need (with a few tweaks). Thank you!

  • @jamesepace
    @jamesepace 6 місяців тому

    Great explainer! I have passed it along to a coworker. Your timestamp technique is very interesting; I'm going to ponder this approach.

  • @MrAceman82
    @MrAceman82 5 місяців тому

    This new feature helped me to use as checklist with auto formatting. Really nice feature. Thanks Leila Gharani

  • @yvesgysel9834
    @yvesgysel9834 6 місяців тому

    Thanks, Leila. Very good explanation.

  • @giorgidvali951159
    @giorgidvali951159 6 місяців тому

    I love all your video tutorials, thank you very much!

  • @cassioassilva
    @cassioassilva 6 місяців тому +2

    AWESOME! Simply awesome! What a video! What an exceptional explanation! What an exceptional expert! Loved everything, Leila!
    And you, who is reading this and have not even subscribed to this channel yet: you have the moral duty to subscribe right now! This is just a piece of magic that Leila can do with so many resources.
    Thank you for sharing, Leila! This video might well be highly rated to be one of the bests you made so far!

    • @LeilaGharani
      @LeilaGharani  6 місяців тому +1

      I'm so glad you enjoyed the video! It's wonderful to hear such positive feedback. Your support means a lot to me!

  • @meniporat3527
    @meniporat3527 6 місяців тому +39

    A simpler method to count checked items.
    Instead of:
    =COUNTIF(C5:C13,true)
    you can write:
    =SUM(--C5:C13)
    The double-minus converts TRUE's to 1's.
    Hope this helps :-)

    • @mustafamalik4211
      @mustafamalik4211 6 місяців тому +3

      Alternative to the double minus, it is also possible to use the "N" function" :=SUM(N(C5:C13))

    • @meniporat3527
      @meniporat3527 6 місяців тому +5

      @@mustafamalik4211
      not in this case 😞
      =SUM(N(C5:C13)) will return a wrong solution!
      Alternative methods that do work:
      1) =SUM(1*(E2:E13))
      2) =SUM((E2:E13)+0)

    • @Pseudify
      @Pseudify 6 місяців тому +18

      If by simpler you mean “sum” is shorter than “countif”, well…okay, but trivial. Otherwise, I would argue that it’s not simpler because the logic is not as obvious. If someone else was reading or debugging this formula they likely would have no idea what was going on. Also, I suspect the run time of your “sum” is longer than the “countif” - but I haven’t tested it. I’d be interested in seeing the results of that. But yeah, this is a nice trick to know.

    • @stevesigma
      @stevesigma 6 місяців тому +3

      I would definitely use SUMPRODUCT

    • @richardaversa7128
      @richardaversa7128 6 місяців тому +2

      Not a big fan of "--", any team "1*" out there?

  • @DeniseVajdak
    @DeniseVajdak 6 місяців тому +1

    Very cool! I have been using Checkboxes in Google Sheets for a while. Nice to know it's in (or coming) to Excel as well. Great tutorial.

  • @SashaHouseOfFashion
    @SashaHouseOfFashion 6 місяців тому

    Too good, you have great skill to teach complex things in easy way.

  • @danhartman6014
    @danhartman6014 6 місяців тому +23

    This looks like a great feature, and I was looking forward to following along with your turorial; Alas, my work and personal versions of Excel 365 do not have this option on the Insert tab. Is this just a feature I have to wait to be rolled out?

  • @donald-parker
    @donald-parker 6 місяців тому +51

    It would be nice if they had an "iterate" function so instead of an option that affects the whole workbook, you could control it at the cell level. It might be nice to revisit this to show how you could automatically add and remove items from your list.

    • @FreakAzoiyd
      @FreakAzoiyd 6 місяців тому +2

      With self referencing Lambda you can do something like that

    • @mohammedhassan2808
      @mohammedhassan2808 6 місяців тому +1

      yes, we must have "iterate" control depending on our needs, instead of globalization

    • @FreakAzoiyd
      @FreakAzoiyd 6 місяців тому +2

      As I said you can do it with Lambda.
      Create a named lambda function that accepts at least two inputs, your value to be iterated on and an integer that you count down.
      Do your thing with the value and decrease the counter by 1. Exit when you reach 0 or hit another exit criteria. Modify the values inside the function and let it call itself.
      Done it with a formula to calculate pipe friction factor (funnily this is the gel letter Lambda in physics) which for the turbulent Colebrook function is iterative.

    • @mperacchi
      @mperacchi 6 місяців тому +4

      @@FreakAzoiydcould you be so kind to post the formula? Thanks

    • @uchennaanunike9019
      @uchennaanunike9019 6 місяців тому

      ​@@FreakAzoiydPlease how can we get the video or worksheet on how to get this thing done

  • @reza6766
    @reza6766 4 місяці тому

    Dear Leila, This is the best and coolest checklist I've ever seen. I'm using it for various tasks at work. It's just magic. Thanks a lot for that.

  • @chimarokenwaji
    @chimarokenwaji 6 місяців тому

    @LeilaGharani, Thank you for this video. I was able to apply the timestamp trick you showed in the video and it worked!!!!! At first, I did it differently and each time I clicked the checkbox the whole time updated. But when I applied your method and applied iterative calculation check on it, it worked. Thank you, again.

    • @chimarokenwaji
      @chimarokenwaji 6 місяців тому

      Also, I was able to combine this checkbox on task done to my dynamic excel calendar. I have a separate sheet with tasks and dates (DDD, DD-MM-YYYY).
      I have another sheet in the same workbook where I did a monthly calendar with a conditional Formatting highlighting Today's date which changes dynamically each day.
      Beside the calendar I have a task list comprising of 10 tasks, a checkbox for completion, and a timestamp. I used the filter function to select tasks for the day from the task sheet to the calendar sheet and I tick them off when done.
      Thank you once again for your lectures.

  • @HBSuccess
    @HBSuccess 3 місяці тому

    You are a great presenter- I’ll be putting this to all kinds of use!

  • @mr.jaycasey4676
    @mr.jaycasey4676 6 місяців тому +1

    Many times I have wished to be able to use the today() function to autofill and then remain as a timestamp. Well today() is that day! Thanks for pointing out the iteration setting. Just checked, and this works in Google Sheets as well. Very helpful video. Thanks!

  • @kenmcmillan2637
    @kenmcmillan2637 6 місяців тому +1

    I can't wait for the checkboxes to be rolled out. Absolutely fantastic tutorial!!

  • @alexanderschmidt75
    @alexanderschmidt75 5 місяців тому +1

    Cell iteration is an awesome tool, use it for a lot of modeling projects. Great video!

  • @jainnehul
    @jainnehul 6 місяців тому

    Thank you, will implement right away for my monthly checklist

  • @jeyarajshankar
    @jeyarajshankar 6 місяців тому

    So much knowledge sharing in one short but power packed video. Thanks, @LeilaGhairani.

  • @yabbaso
    @yabbaso 6 місяців тому

    Fantastic, i always wondered about iterative calculations!

  • @soundaryasuresh1845
    @soundaryasuresh1845 6 місяців тому

    Excellent video mam. Thank you for new and refreshing ideologies and options 🎉😊🙏

  • @yertletheturtle5843
    @yertletheturtle5843 18 днів тому

    So much packed into one video! This is fantastic.

  • @chrism9037
    @chrism9037 6 місяців тому

    This is awesome, thanks Leila!!

  • @networkn
    @networkn 6 місяців тому

    This was a *fantastic* video. Thank you so much!

  • @MichaelBurkett
    @MichaelBurkett 2 місяці тому

    Great video! I don't have it in my version yet but I can think of several use cases. Thanks Leila!

  • @ianl1052
    @ianl1052 Місяць тому

    Nice one Leila. I signed onto Beta and, after a few attempts, was able to insert checkboxes as intended. I'm running 365 (2024) and the formula at the end (=IFS(C5=FALSE,"",D5="",NOW(),TRUE,D5) returned Circular Reference error, resulting in 0 (twice). Instead of giving into the temptation of giving in, I continued with the video and altered the Formula settiongs as you described. Now it works as intended. Many thanks.
    Edit. I pasted a link to this video in my Worksheet for future reference. Just in case I forget how I achieved it.

  • @vhinsreignletsspinofficial5335
    @vhinsreignletsspinofficial5335 6 місяців тому

    Very helpful, thank you so much!

  • @MR-vj8dn
    @MR-vj8dn 5 місяців тому +1

    Apple Numbers has had checkboxes for many years. I use them daily for almost all sheets to be able to switch formulas on and off. Pretty useful. Happy for Excel users.

    • @willyjimmy8881
      @willyjimmy8881 3 місяці тому +2

      Yes but you have to suffer through using ios to use it, so it's better to not have checkboxes.

  • @dastaan.
    @dastaan. 6 місяців тому +1

    Thanks, always helpful 😊

  • @johnkuczmanski6012
    @johnkuczmanski6012 5 місяців тому

    Bravo! Pure genius. I feel so much smarter now.

  • @mnessim03
    @mnessim03 6 місяців тому

    Wonderful, thanks

  • @HachiAdachi
    @HachiAdachi 6 місяців тому

    oooh, the time stamp trick! 😀 Thanks, Leila!

  • @astrokevin92
    @astrokevin92 5 місяців тому

    I LOVED the idea to timestamp checkboxes.

  • @bugrag.8710
    @bugrag.8710 6 місяців тому +1

    Amazing!Thank you

  • @getzjason
    @getzjason 2 місяці тому

    Thank you for the amazing content! Looking forward to having this functionality in a mac.

  • @kettenbach
    @kettenbach 6 місяців тому

    Omg always so beautiful Leila. Thank you for sharing ❤

  • @walugandaddembe3258
    @walugandaddembe3258 День тому

    I love you Leila 😘 you are such a talented tutor

  • @mjmann2402
    @mjmann2402 5 місяців тому

    This is excellent! Thank you.

  • @akonvano
    @akonvano 6 місяців тому

    Amazing as always!

  • @skylinezan
    @skylinezan 6 місяців тому

    Thank you Ms Leila!
    This is definitely useful for an Exam Moderation Form that my faculty have been wanting to design.
    Thank you so much!

  • @johncrighton4738
    @johncrighton4738 6 місяців тому

    Excellent tutorial!

  • @jlundofu
    @jlundofu 6 місяців тому

    Powerful. I always enjoy your videos.

  • @pezhmanes
    @pezhmanes 6 місяців тому +1

    Thank you!

  • @leonardoggy
    @leonardoggy 4 місяці тому

    The checkboxes are really good, but my mind was blown with a couple of other examples you provided: the iteration setting, and placing a shape on top of cells and using transparency. Thank you so much for always providing such great examples to teach us!

  • @jpv1980
    @jpv1980 6 місяців тому

    Amazing! Thanks for sharing.

  • @joeillingworth1141
    @joeillingworth1141 Місяць тому

    I did this with formulas, this is great!

  • @shanghai4873
    @shanghai4873 6 місяців тому

    Thank you Leila...

  • @cvrsriharsha
    @cvrsriharsha 6 місяців тому

    Thank you so much for such a crystal clear explanation.

  • @cupchanger
    @cupchanger 6 місяців тому

    Your awesome! I have purchased most of your courses. Keep up the good work!

    • @LeilaGharani
      @LeilaGharani  6 місяців тому

      Awesome, thank you for your support!

  • @yatishprasad
    @yatishprasad 6 місяців тому

    Maam You are Brilliant. The way you bundle with other options is superb

  • @petermeijerink277
    @petermeijerink277 3 місяці тому

    Hi Leila. Thanks a lot for your video about checkboxes. I learned a lot form you.

  • @KellyKels23
    @KellyKels23 3 місяці тому +2

    Aw man, I wish my job had this updated version of excel so I could tinker with impingement this.

  • @TerryMundy
    @TerryMundy 6 місяців тому +1

    Fantastic video!

  • @totknox
    @totknox Місяць тому

    Great tutorial. This is what a tutorial should be. Straight to the point, clear, correct phasing and in laymans’ term🫡

  • @keshabrady8487
    @keshabrady8487 6 місяців тому

    I absolutely love this channel ❤️❤️❤️

  • @ukemeisaac
    @ukemeisaac 6 місяців тому

    I've added knowledge. Thank you ❤

  • @JennJenn9
    @JennJenn9 6 місяців тому

    Very cool stuff! and WOW on CHAR(10) for line breaks 🤯 - I ALWAYS learn smthg in your videos 😊

  • @systemtourtvganesh
    @systemtourtvganesh 6 місяців тому

    Excellent Leila! As usual, very nice explanation. I am your big fan. Keep sharing your knowledge

  • @power-reconcile
    @power-reconcile 3 місяці тому

    This video is great! Loved it!

  • @deepk82
    @deepk82 6 місяців тому

    Amazing as always

  • @ademolao.adegoke303
    @ademolao.adegoke303 6 місяців тому

    Thank you Leila

  • @RondenBreems
    @RondenBreems 6 місяців тому

    Great way of demonstrating (work-along) this feature.

  • @ChristiaanRoest79
    @ChristiaanRoest79 6 місяців тому +1

    Thanks for sharing Leila! Your the best ❤

  • @downey6666
    @downey6666 День тому

    13:00 To my knowledge setting the max irratation is still broken (& known bug) - its meant to save the setting to the file -- so it wont save the setting for others using the workbook without some vba code.

  • @annan9752
    @annan9752 6 місяців тому

    Simply amazing! So many uses, so easy to set up.

  • @rayn1384
    @rayn1384 6 місяців тому +1

    The only excel channel you ever need to follow.

  • @tiger131071
    @tiger131071 6 місяців тому +2

    Oh my word, finally! They were so behind google sheets it was bizarre! Great that they have finally caught up!

  • @Luciano_mp
    @Luciano_mp 6 місяців тому

    Cool, good! Thanks Leila!

  • @abdelrahmanalnajjar815
    @abdelrahmanalnajjar815 5 місяців тому

    well done Leila, thanks

  • @joserodall7321
    @joserodall7321 6 місяців тому

    It was about time for XLS to catch up with SmartSheets with this feature. Great video !!

  • @mvg2x34
    @mvg2x34 5 місяців тому

    Very helpful.

  • @MidoCounters
    @MidoCounters 6 місяців тому

    I could see myself making one of these to list tasks I have to do every once a few months. Very cool.

  • @sarahhassan8454
    @sarahhassan8454 4 місяці тому +2

    Oh my goodness. I have been waiting for this! The lack of a real functional checkbox like this was leading me to use Google Sheets more than I would like, and now I can primarily use Excel!

    • @sarahhassan8454
      @sarahhassan8454 4 місяці тому

      Oh bummer. Got all excited about the feature only to find it hasn't been added yet.

    • @therealshakespeare9243
      @therealshakespeare9243 Місяць тому

      Checkboxes were available years ago with EDITGRID (which Apple seems to have made totally invisible since they bought it around 2007 to make into “numbers”). They have been available in Google sheets quite a while too.

  • @TheNabob57
    @TheNabob57 6 місяців тому

    I haven't viewed one of your videos for some months now; but I am pleased to see the level of professionalism is still very high. I especially liked the little cameo ovals of you speaking.
    VERY nice!

    • @LeilaGharani
      @LeilaGharani  6 місяців тому

      Welcome back! Glad you like our new features :)

  • @FredericLEGUEN-Excel
    @FredericLEGUEN-Excel 6 місяців тому

    Thanks Leila, Like you, I start to feel in love with CheckBoxes and I have more ideas 😉
    You kill me with your last IFS function, I must learn and understand it

    • @LeilaGharani
      @LeilaGharani  6 місяців тому +1

      Frederic! Nice to see you here! Looking forward to your video on this.

  • @brunovanherpe8423
    @brunovanherpe8423 6 місяців тому

    Thanks