NEW! Top 5 Excel Features Microsoft Just Released

แชร์
ฝัง
  • เผยแพร่เมื่อ 15 มิ.ย. 2024
  • In this video, we’ll cover the BEST new Excel features EVERYONE needs to know. These 5 tools take Excel to the next level.
    First, we will cover Microsoft’s brand-new checkboxes and how to calculate values depending on whether they are checked or not. Next, we will go over the replacement for Pivot Tables: the GROUPBY and PIVOTBY Functions. Then, we’ll cover how to import data from a picture directly into our workbook with Excel’s new Data From Picture tool. Next, we’ll cover how to insert images directly into cells and the benefits of this. Lastly, we will cover how to quickly navigate our workbook using Excel’s new Navigation Pane.
    FULL CHECKBOX TUTORIAL: • These New Checkboxes W...
    FULL PIVOTBY TUTORIAL: • I stopped using Pivot ...
    📖RESOURCES
    - Download the workbook and follow along: excel-dictionary.com/pages/yo...
    🤓SHOP EXCEL DICTIONARY
    - COURSES: excel-dictionary.com/collecti...
    -GUIDES: excel-dictionary.com/collecti...
    -MERCH: excel-dictionary.com/collecti...
    -TEMPLATES: excel-dictionary.com/collecti...
    📩NEWSLETTER
    -Unlock the full potential of Excel and PowerPoint with expert tips delivered to your inbox each week: www.excel-dictionary.com/subs...
    📺SUBSCRIBE
    -Subscribe to never miss a video: / exceldictionary
    🕰️TIMESTAMPS
    ‘0:00 Intro
    ‘0:17 1. New Checkboxes
    ‘2:19 2. GROUPBY & PIVOTBY Functions
    ‘4:28 3. Data From Picture
    ‘5:19 4. Insert Picture In A Cell
    ‘6:35 5. Navigation Pane
    ‘8:01 Wrap up
    #excel #exceltips #tutorial

ความคิดเห็น • 55

  • @sforti01
    @sforti01 หลายเดือนก่อน +22

    She should preface that these features are only available to Microsoft 365 Insider Program users who are using the Beta channel, and is expected to be available in April 2024. This means that the feature is still in testing and not yet released to everyone.

    • @Chris-im3ys
      @Chris-im3ys หลายเดือนก่อน +6

      It's May 2024

    • @erictsang789
      @erictsang789 27 วันที่ผ่านมา +1

      I see, no wonder i can not find it.

  • @beatamarszaek7115
    @beatamarszaek7115 หลายเดือนก่อน

    Thank you for this very useful video! The navigation pane is a real game changer for me :)

  • @VinhDang-xc1ee
    @VinhDang-xc1ee หลายเดือนก่อน +1

    Thanks for sharing the new excel features! Checkbox is my favorite. Others are handful as well. However, which excel version has these updates available? Thank you!

  • @deepk82
    @deepk82 25 วันที่ผ่านมา

    Loved the video. So insightful!

  • @rudraprasadgupta8580
    @rudraprasadgupta8580 หลายเดือนก่อน

    This video is very much useful and more important for Advance Excel Users.

  • @arturmusialak8704
    @arturmusialak8704 หลายเดือนก่อน +3

    I love the pivotby function for its dynamic behavior. It is very useful difference compared to the classic pivot

  • @Paladin101
    @Paladin101 หลายเดือนก่อน +28

    But, actually, have they released them? I update every day and yet still don’t have checkboxes which I’ve been waiting for since last year when it was first released.

    • @Nitpickerman
      @Nitpickerman หลายเดือนก่อน +11

      True.
      This is frustrating to watch these prerelease presentaions talking about something that, as not in a general availability, cannot be used for business use. As such contains also sharing and others cannot all be in a prereleas version. I think the release is called pre for a reason.

    • @Paladin101
      @Paladin101 หลายเดือนก่อน +3

      @@Nitpickerman I totally agree with you and acknowledge that this is necessary, especially for those who may go on to use these improvements for mission-critical information.
      My problem is that I first saw this being promoted mid-last year so any issues that have emerged should have either been resolved OR, (if it cannot be resolved), they remove the feature altogether and then others will stop promoting it.
      As they say in my country - "sh?t or get off the pot!'

    • @notavailable123
      @notavailable123 หลายเดือนก่อน +13

      video reported for misleading section:
      Microsoft Excel function/feature to insert "checkboxes" from "Insert tab, Controls group" is not yet released to general public and is not available on MS Office 2016, 2019 & MS Office M365 software versions. This video is misleading in video's name and contents.

    • @geekatari4391
      @geekatari4391 28 วันที่ผ่านมา

      Activating beta features is very easy; but I understand the sentiment, she made it sound like they are available right now.
      I know, at least, that picture in cell is available for me now as I've used it to create a dynamic catalog.

    • @craigwatkins2285
      @craigwatkins2285 25 วันที่ผ่านมา

      Yet another wasted video… she’s about 6 months late on the “checkboxes are coming soon” train.

  • @yohannaagbanaji8012
    @yohannaagbanaji8012 หลายเดือนก่อน +1

    Wow, I love Data from the pictures tool.

  • @bbq4851
    @bbq4851 หลายเดือนก่อน +4

    Thank you.. will these be available soon for Excel on MAC ?

  • @michaeldavenport9268
    @michaeldavenport9268 27 วันที่ผ่านมา

    Awesome, Thanks!

  • @DarrenNeupert
    @DarrenNeupert หลายเดือนก่อน +16

    Just released to who exactly? I have the latest version of 365 and the comment section is overrun with comments about not having these features. Specifically, the check box.

    • @slaydesaid8741
      @slaydesaid8741 หลายเดือนก่อน +1

      My question exactly. I've heard about Pivotby/Groupby for at least 6 months and still I don't have it (I use Office 365 so should be updated on all features). I don't think it's been officially released yet but are still in Beta and only available for certain users (beta testers, MS MVP's, etc.).

    • @ItsjustmeAR
      @ItsjustmeAR หลายเดือนก่อน

      I’m ready to play with the pivot by. There could be a delay based on feedback from the beta group. That’s what I’ve heard anyways.

  • @jacquiblue3006
    @jacquiblue3006 หลายเดือนก่อน +1

    Picture tool - data insert, navigation pane especially if it's an unfamiliar sheet - pivot by maybe have to try them all :):):)

  • @yohannaagbanaji8012
    @yohannaagbanaji8012 หลายเดือนก่อน

    Hey, I like your videos. They are great

  • @rahulvishwakarma2119
    @rahulvishwakarma2119 หลายเดือนก่อน

    Thanks 👍

  • @Keyinfo-zaino
    @Keyinfo-zaino 8 วันที่ผ่านมา

    Good video ❤

  • @francosilvestri123
    @francosilvestri123 หลายเดือนก่อน

    Unfortunately I have Excel 2021. I wish I had the new Excel! My favourites are the Navigation pane and Import Data from Picture, so practical!

  • @estebanfigueroa2501
    @estebanfigueroa2501 หลายเดือนก่อน +1

    Do you know when the checkbox feature will be available to all

  • @centerdonya2631
    @centerdonya2631 29 วันที่ผ่านมา

    hi thanks for teaching but i have a question how you set icon checkbox on ribon i use office 2019 and i bring this icon from develp option then i selected four cells and clicked on checkbox but it isn't possible can you show me how set these checkbook thans alots

  • @stevendipietro2928
    @stevendipietro2928 หลายเดือนก่อน

    Nice

  • @sketchtwenty2
    @sketchtwenty2 15 วันที่ผ่านมา

    Navigation feature is the most promising for me.

  • @jeffolefson9415
    @jeffolefson9415 26 วันที่ผ่านมา +1

    Checkboxes are still not available for Excel for the MAC even for office 365 users. Which is a bummer.. Apparently they have different design teams and the Mac lags behind.

  • @YusufMumtaz
    @YusufMumtaz หลายเดือนก่อน

    when will these be available?

  • @shirazhassen1108
    @shirazhassen1108 3 วันที่ผ่านมา

    I have still not received this new checkbox version in my Office 365 yet. Please guide me how to get it

  • @farzadbaradaran9254
    @farzadbaradaran9254 17 วันที่ผ่านมา

    What is version of your office?

  • @caa22
    @caa22 หลายเดือนก่อน

    Group by and pivot by

  • @yohannaagbanaji8012
    @yohannaagbanaji8012 หลายเดือนก่อน

    In which version of Microsoft office can I get a second check box apart from the one under the developer tab. My Microsoft version is 2021.

    • @notavailable123
      @notavailable123 หลายเดือนก่อน +2

      video reported for misleading section:
      Microsoft Excel function/feature to insert "checkboxes" from "Insert tab, Controls group" is not yet released to general public and is not available on MS Office 2016, 2019 & MS Office M365 software versions. This video is misleading in video's name and contents.
      A note to channel owner: If you are releasing educational video content materials to educate your subscribers, at least have dignity to verify in which channels the discussed content is available. Your content is misleading at best, lying/hyping-up and a click-bait at worst.

  • @jamesclark1001
    @jamesclark1001 26 วันที่ผ่านมา

    I have been extracting data from photos for work for a couple years now. Is this something new?

  • @willemcoghe8735
    @willemcoghe8735 หลายเดือนก่อน

    Checkbox, as proposed, is not possible in Belgium. I wait impatiently.

  • @centugurdag7776
    @centugurdag7776 23 วันที่ผ่านมา

    Does anyone know when a Microsoft 365 user would have access to the new checkbox ?

  • @katihar_wala_vlogs
    @katihar_wala_vlogs หลายเดือนก่อน

    Which Excel Version has these new updates available?

    • @notavailable123
      @notavailable123 หลายเดือนก่อน

      video reported for misleading section:
      Microsoft Excel function/feature to insert "checkboxes" from "Insert tab, Controls group" is not yet released to general public and is not available on MS Office 2016, 2019 & MS Office M365 software versions. This video is misleading in video's name and contents.
      A note to channel owner: If you are releasing educational video content materials to educate your subscribers, at least have dignity to verify in which channels the discussed content is available. Your content is misleading at best, lying/hyping-up and a click-bait at worst.

  • @djkindred
    @djkindred 28 วันที่ผ่านมา

    I also don't have these updates and I am part of the insider program running Excel 365. Have done the updates too and still no sign of these new features.

  • @Dexter101x
    @Dexter101x หลายเดือนก่อน

    How comes I'm not able to get this on my Office version?

  • @kelvinlee8754
    @kelvinlee8754 หลายเดือนก่อน +2

    I'm still using excel 365. i can't see the new functions

    • @notavailable123
      @notavailable123 หลายเดือนก่อน +1

      video reported for misleading section:
      Microsoft Excel function/feature to insert "checkboxes" from "Insert tab, Controls group" is not yet released to general public and is not available on MS Office 2016, 2019 & MS Office M365 software versions. This video is misleading in video's name and contents.
      A note to channel owner: If you are releasing educational video content materials to educate your subscribers, at least have dignity to verify in which channels the discussed content is available. Your content is misleading at best, lying/hyping-up and a click-bait at worst.

  • @TheFamilyAdmin
    @TheFamilyAdmin 27 วันที่ผ่านมา

    its now 5/19, and I am on the beta channel, and I still don't have these features.

  • @albertomartin70
    @albertomartin70 หลายเดือนก่อน +1

    Those features been available on the insider program like for a year now… I gave up on them by now…

  • @cgi2173
    @cgi2173 หลายเดือนก่อน +3

    Why has it taken MS so long to implement check boxes? 🙄

  • @dwarfusinterruptus9314
    @dwarfusinterruptus9314 หลายเดือนก่อน

    It is May 2024. I have been seeing videos on nearly ALL of these features in Beta since October or November of 2023. How can you call these new? They are not even in the Insiders Current Version yet. And Microsoft has said they will be released in April. Why are you calling these NEW when they are not for any of the release channels? Click bait.

  • @alschroeder1724
    @alschroeder1724 หลายเดือนก่อน

    little confused....seems like this video is indicating that ALL these features are currently available and after watching this and updating my version and seeing a most of these features are not coming up on my version. If they are not really available to general population the video should not be making seem like it is. Nice clickbait not a good way to build a reputation/following. She did a nice presentation, but if its bogus information not a good thing. Be honest with your information please.

  • @patricklonski
    @patricklonski หลายเดือนก่อน

    The Pivotby function causes workbook crashes. Unless Microsoft has corrected that train wreck in the last two weeks I would recommend not using it in an important workbook.

  • @montebont
    @montebont 22 วันที่ผ่านมา

    CLICK BAIT...not generally available.
    And IMHO checkboxes in this example a solution looking for a problem. In my use cases it is also important WHEN it finished. Just add a date instead of a checkbox and you have a visual clue AND can calculate the duration given a start date.

  • @notavailable123
    @notavailable123 หลายเดือนก่อน

    A note to channel owner: If you are releasing educational video content materials to educate your subscribers, at least have dignity to verify in which channels the discussed content is available. Your content is misleading at best, lying/hyping-up and a click-bait at worst.

  • @meniporat3527
    @meniporat3527 5 วันที่ผ่านมา

    instead of
    =COUNTIF(C3:C14, true)
    here's a much simpler formula:
    =SUM(--C3:C14)
    Enjoy