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
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.
It's May 2024
I see, no wonder i can not find it.
Thank you for this very useful video! The navigation pane is a real game changer for me :)
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!
Loved the video. So insightful!
This video is very much useful and more important for Advance Excel Users.
I love the pivotby function for its dynamic behavior. It is very useful difference compared to the classic pivot
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.
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.
@@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!'
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.
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.
Yet another wasted video… she’s about 6 months late on the “checkboxes are coming soon” train.
Wow, I love Data from the pictures tool.
Thank you.. will these be available soon for Excel on MAC ?
Awesome, Thanks!
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.
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.).
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.
Picture tool - data insert, navigation pane especially if it's an unfamiliar sheet - pivot by maybe have to try them all :):):)
Hey, I like your videos. They are great
Thanks 👍
Good video ❤
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!
Do you know when the checkbox feature will be available to all
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
Nice
Navigation feature is the most promising for me.
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.
when will these be available?
I have still not received this new checkbox version in my Office 365 yet. Please guide me how to get it
What is version of your office?
Group by and pivot by
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.
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.
I have been extracting data from photos for work for a couple years now. Is this something new?
Checkbox, as proposed, is not possible in Belgium. I wait impatiently.
Does anyone know when a Microsoft 365 user would have access to the new checkbox ?
Which Excel Version has these new updates available?
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.
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.
same here
How comes I'm not able to get this on my Office version?
I'm still using excel 365. i can't see the new functions
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.
its now 5/19, and I am on the beta channel, and I still don't have these features.
Those features been available on the insider program like for a year now… I gave up on them by now…
Why has it taken MS so long to implement check boxes? 🙄
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.
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.
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.
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.
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.
instead of
=COUNTIF(C3:C14, true)
here's a much simpler formula:
=SUM(--C3:C14)
Enjoy