10 New Features in Microsoft Excel | Fall 2023
HTML-код
- Опубликовано: 30 июл 2024
- This Microsoft Excel tutorial will show you the top 10 updates in MS Excel 365 Desktop and Web for fall 2023. These new MS Excel tips and tricks include improved Check Boxes, Pictures in Cells, Simplified sharing, Interactive pivot charts in Excel for web, PowerAutomate integration and lots more. These time-saving new features in Microsoft Excel are rolling out now for Excel 365 subscribers. To join Office Insiders and get the latest updates in MS Excel 365 Desktop and web, go to insider.office.com
Insider and Tech Community Blogs:
✅ Picture in Cells: insider.microsoft365.com/en-u...
✅ Control Data Conversions: insider.microsoft365.com/en-u...
✅ Automate Work in Excel for web: techcommunity.microsoft.com/t...
✅ Interactive PivotCharts in Excel web: techcommunity.microsoft.com/t...
✅ Explore Addins in Excel web: insider.microsoft365.com/en-u...
✅ Formula Authoring Enhancements: in Excel for web: techcommunity.microsoft.com/t...
✅ Formula Suggestions in Excel web: techcommunity.microsoft.com/t...
📝 Table of contents
0:00 Introduction
0:08 Checkboxes - Excel Desktop 365
1:26 Picture in Cells - Excel Desktop 365
2:28 Simplified Sharing - Excel Desktop 365
3:18 Automatic Data Conversions - Excel Desktop 365
4:29 Power Automate - Excel for web
5:57 Interactive PivotCharts - Excel web
6:40 Explore Addins - Excel web
7:39 Formula Authoring Enhancements - Excel web
8:33 Formula Suggestions - Excel web
8:55 Excel iPad conditional formatting
Excel monthly blogs:
✅ Microsoft Excel new features - October 2023: techcommunity.microsoft.com/t...
✅ Microsoft Excel new features - September 2023: techcommunity.microsoft.com/t...
✅ Microsoft Excel new features - August 2023: techcommunity.microsoft.com/t...
✅ Microsoft Excel new features - July 2023: techcommunity.microsoft.com/t...
✅ Microsoft Excel new features - June 2023: techcommunity.microsoft.com/t...
📺 Top 25 Excel tip and tricks: Top 25 Microsoft Excel Tips and Tricks for 2022 // NEW features, hidden gems and time-saving tips
📺 10 Excel new features: • Top 10 Microsoft Excel...
📺 Excel quick tips playlist: • Excel quick tip videos
🔔 Subscribe to my Channel: aka.ms/MikeRUclipsSubscribe
*Connect with me on Social:
Twitter: / mtholfsen
LinkedIn: / miketholfsen
Instagram: / mtholfsen
Pinterest: / miketholfsen
TikTok: / mtholfsen
Wakelet: www.wakelet.com/@mtholfsen
#Excel #MSExcel #Microsoft 
Наука
From Microsoft 365 Insider blog:
"Don’t have it yet? It’s probably us, not you.
Features are released over some time to ensure things are working smoothly. We highlight features that you may not have because they’re slowly releasing to larger numbers of Insiders. Sometimes we remove elements to further improve them based on your feedback. Though this is rare, we also reserve the option to pull a feature entirely out of the product, even if you, as an Insider, have had the opportunity to try it. "
I just came to see if they improved the checkboxes, thank god!
Thabks a lot for sharing the new featurs. On the othwr hand, My Excel does not have these features.
But once again, very few of these are available for Excel 365 for Mac, even though the subscription price is the same as for the Windows version.
Thanks for sharing this! Do the latest features always roll out to the online version first?
Depends
When are these features actually supposed to roll out? Great there’s a cool tutorial. But sucks that it hasn’t been rolled out to things like my personal 365 liscense or my work liscense.
New Image function we can in office 365 or still it is Beta version ??
Is it available on Microsoft 365 MSO (Version 2310 Build 16.0.16924.20054) 64-bit ?
I can not see it!!!
maybe he is using different license for office 365
1:00 When something is Boolean (True or False) you don't need to test if is True or False, so, instead IF(A2=True, ... you can just put IF(A2, ...
It's been 3 months.
My Office365 still doesn't have the 'Cell Controls' feature in the 'Insert' ribbon.
Any idea when everyone will have this?
what version excel you used , these new features are not showing in my excel 365
It takes some time before it will roll up for every user :)
same to me
My excel 365 didn’t show this features
@@Mu00lia I got it sir, he is using Excel 365 insider build . ✌🏻🥹 I recommend you don't use insider builds because this all new features in currently in beta testing.
I don't have these features either
Automation tab only applicable for Work / School account
things like checkboxes and images in cells continue to blur the lines between Excel and Microsoft list. I think the average person has no idea how to use Lists including me.
Agreed, there's a lots of MS tools that seem to overlap. I was thinking about Microsoft loop too
Yeah.... why waiting soooo long with pictures IN cells and well managed checkboxes in desktop version of Excel when Lists exist at last...? Haaaa Microsoft 🙄🤪😁
What is the function to get the number count of each diff data in an excel sheet? For example, i have a bunch of names, this function will tell me how many times John, Brian, or David appear in the excel sheet 🤷♂️
Or just get all the names and show how many times
@@cryptoico2647 You might consider using =UNIQUE(range) to get a unique list of names then use COUNTIF or COUNTIFS to count those names in the original range.
I think Countif will do for you. Just do =countif (specify range where the names you are counting is located, then specify the cell where the name is located)
Instead of "New Features" I would like to see Excel solve a couple of huge problems, such as the undulterated mess between the formatting of TEXT and NUMBER, as well as Excel not saviing my formulae after I save them.
I am really starting to miss Lotus 1 2 3 a lot.....
There is no such checkbox option in the insert menu in my 365
Are you on the monthly channel for M365 or semiannual?
So when are these new features rolling out? They are completely useless for home and work if everyone’s machine does not have them. On a sidenote, I think this is the third video I’ve seen explaining new features without an actual release date. If you’re gonna take the time to show us these wonderful things then you may wanna wait until you have a release date so that people don’t bombard you with the same question again and again.