NEW! Top 5 Excel Features Microsoft Just Released

  Рет қаралды 59,374

Excel Dictionary

Excel Dictionary

Күн бұрын

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 Ай бұрын
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 Ай бұрын
It's May 2024
@erictsang789
@erictsang789 Ай бұрын
I see, no wonder i can not find it.
@Paladin101
@Paladin101 Ай бұрын
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 Ай бұрын
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 Ай бұрын
@@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 Ай бұрын
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 Ай бұрын
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 29 күн бұрын
Yet another wasted video… she’s about 6 months late on the “checkboxes are coming soon” train.
@DarrenNeupert
@DarrenNeupert Ай бұрын
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 Ай бұрын
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.
@beatamarszaek7115
@beatamarszaek7115 Ай бұрын
Thank you for this very useful video! The navigation pane is a real game changer for me :)
@deepk82
@deepk82 29 күн бұрын
Loved the video. So insightful!
@michaeldavenport9268
@michaeldavenport9268 Ай бұрын
Awesome, Thanks!
@VinhDang-xc1ee
@VinhDang-xc1ee Ай бұрын
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!
@arturmusialak8704
@arturmusialak8704 Ай бұрын
I love the pivotby function for its dynamic behavior. It is very useful difference compared to the classic pivot
@bbq4851
@bbq4851 Ай бұрын
Thank you.. will these be available soon for Excel on MAC ?
@yohannaagbanaji8012
@yohannaagbanaji8012 Ай бұрын
Wow, I love Data from the pictures tool.
@rudraprasadgupta8580
@rudraprasadgupta8580 Ай бұрын
This video is very much useful and more important for Advance Excel Users.
@rahulvishwakarma2119
@rahulvishwakarma2119 Ай бұрын
Thanks 👍
@yohannaagbanaji8012
@yohannaagbanaji8012 Ай бұрын
Hey, I like your videos. They are great
@jacquiblue3006
@jacquiblue3006 Ай бұрын
Picture tool - data insert, navigation pane especially if it's an unfamiliar sheet - pivot by maybe have to try them all :):):)
@estebanfigueroa2501
@estebanfigueroa2501 Ай бұрын
Do you know when the checkbox feature will be available to all
@centerdonya2631
@centerdonya2631 Ай бұрын
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
@Keyinfo-zaino
@Keyinfo-zaino 11 күн бұрын
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!
@jeffolefson9415
@jeffolefson9415 29 күн бұрын
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.
@shirazhassen1108
@shirazhassen1108 6 күн бұрын
I have still not received this new checkbox version in my Office 365 yet. Please guide me how to get it
@stevendipietro2928
@stevendipietro2928 Ай бұрын
Nice
@YusufMumtaz
@YusufMumtaz Ай бұрын
when will these be available?
@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 Ай бұрын
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.
@centugurdag7776
@centugurdag7776 27 күн бұрын
Does anyone know when a Microsoft 365 user would have access to the new checkbox ?
@sketchtwenty2
@sketchtwenty2 19 күн бұрын
Navigation feature is the most promising for me.
@jamesclark1001
@jamesclark1001 29 күн бұрын
I have been extracting data from photos for work for a couple years now. Is this something new?
@farzadbaradaran9254
@farzadbaradaran9254 20 күн бұрын
What is version of your office?
@willemcoghe8735
@willemcoghe8735 Ай бұрын
Checkbox, as proposed, is not possible in Belgium. I wait impatiently.
@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.
@Dexter101x
@Dexter101x Ай бұрын
How comes I'm not able to get this on my Office version?
@caa22
@caa22 Ай бұрын
Group by and pivot by
@kelvinlee8754
@kelvinlee8754 Ай бұрын
I'm still using excel 365. i can't see the new functions
@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.
@TheFamilyAdmin
@TheFamilyAdmin Ай бұрын
its now 5/19, and I am on the beta channel, and I still don't have these features.
@djkindred
@djkindred Ай бұрын
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.
@khushiagarwal8564
@khushiagarwal8564 Ай бұрын
same here
@albertomartin70
@albertomartin70 Ай бұрын
Those features been available on the insider program like for a year now… I gave up on them by now…
@cgi2173
@cgi2173 Ай бұрын
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 25 күн бұрын
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 8 күн бұрын
instead of =COUNTIF(C3:C14, true) here's a much simpler formula: =SUM(--C3:C14) Enjoy
The ONLY Way You Should Be Joining Cells in Excel
3:39
Excel Dictionary
Рет қаралды 7 М.
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Excel Campus - Jon
Рет қаралды 68 М.
The Noodle Picture Secret 😱 #shorts
00:35
Mr DegrEE
Рет қаралды 29 МЛН
3 wheeler new bike fitting
00:19
Ruhul Shorts
Рет қаралды 43 МЛН
IS THIS REAL FOOD OR NOT?🤔 PIKACHU AND SONIC CONFUSE THE CAT! 😺🍫
00:41
PivotTable Tricks That Will Change the Way You Excel (Free File)
17:47
MyOnlineTrainingHub
Рет қаралды 106 М.
Say Goodbye to IF Statements in Excel with SWITCH
7:45
Teacher's Tech
Рет қаралды 437 М.
Excel Time-Savers - 5 Hidden Features for Busy People
14:24
Leila Gharani
Рет қаралды 356 М.
Ultimate Guide to Adding Pictures to Excel: No Cell Adjusting Needed
8:50
This ~NEW~ Excel Function is Shockingly Powerful!
9:37
Chandoo
Рет қаралды 264 М.
Best NEW Excel Features EVERYONE Needs
9:20
Leila Gharani
Рет қаралды 378 М.
Top 10 Essential Excel Formulas for Analysts in 2024
13:39
Kenji Explains
Рет қаралды 765 М.
Try This New Formula Instead of Pivot Tables
12:08
Kenji Explains
Рет қаралды 198 М.
7 HIDDEN Apps in Microsoft 365 that will EXPLODE Productivity
28:35
Jonathan Edwards
Рет қаралды 134 М.
The Noodle Picture Secret 😱 #shorts
00:35
Mr DegrEE
Рет қаралды 29 МЛН