I'm waiting for the calendar :-) I'm sorry, Mynda, but this solution with SCAN (LAMBDA, IF etc.) doesn't look good to me. The Focus Cell is fine and I'm grateful for the integration of regular expressions. (Too bad the IMAGE function can't work with local files.)
Thankyou for sharing these tips. I loved the check box and Focus feature they have included. I am watching your videos and learning a lot. I use it for work.
Thank you for this summary video. The focus cell functionality was new to us. The checkboxes are such a godsend. We just used them in a deliverable for a client, and they were blown away. Keep up the good work!
Hello Mynda, for most of the year 2024, I was learning VBA, DAX and MCode so I missed lots of Excel Worksheet Formulas Updates, but You gave me a nice review. Thanks a lot for your training contribution. Have a nice EXCEL&PowerBI Year 2025😃😃😃😆😆😆!
Thanks for the updates. Wouldn't it just be easier to use IF(C4="","",SUM($C$4:C4)) instead of Scan, Lamda and Trim? Trim still references the full range created.
@@sco0tpa I see your point and Steve's point. However, in my opinion the issue with this example is that: Beginners cannot benefit from it because this is too complex for them and, more importantly, unless they come across another video, they will think you need SCAN to solve a simple problem like this. Intermediate know an alternative way of doing it and think SCAN is not needed. Advanced know that SCAN can do more than this but yet this example does not show a real problem where SCAN is the best option
1:50 You don't need to do COUNTIF, since TRUE/FALSE behaves like 1/0 when used in a calculation. Just use the old -- trick to force a calculation and sum the result, like so: =SUM(--C7:C18)
@@00oxymore It just does a negative of a negative, so returns the same number. But because it's a calculation, it also converts FALSE to 0 and TRUE to (-1 and then to) 1.
I appreciate you were trying to just give a simple example of SCAN which I know can do much more powerful things, but I think IF(C5"",SUM($C$5:C5),"") would be much easier in that example.
This is OT, but do any of you have any idea why "get data from the web" isn't available in Excel 365 for MacOS? I could've sworn it was an option in the past, but this morning I can't find it. TIA
Relative referencing. The copied formula was on column C, when she moved 1 column to the right & pasted the formula, the pasted formula also followed that 1 column move & updated itself.
There is a problem with Focus Cell. Frozen Panes automatically desactivates Focus Cell for the same sheet. MSFT is aware of the issue and is currently working on it. Otherwise, Focus Cell is quite an interesting tool. I must say.
Now that they've deigned to finally implement focus cell/rowcol highlight after years of requests, it looks like we'll finally get the dark mode in a few years as well /s And the speed with which they roll or these new functions in non-beta o365 is quite slow. I mean I still don't have the groupby functions available...
HAHAHAHAHA, a little ambitious with the tasks they need to do. I know exactly what you mean. 😂 I can see what the row of check boxes would look like for my daughter for 'load the dishwasher'. A row of no boxes checked for the entire week. Lol. 😁 🙄
Is that a new feature in 2025? This isn't a running totals video. This is a new features video. She is using running totals as a simple example of a new feature.
Instead of that, how about a relevant comment for the topic of the video. These 'I'm first' comments are childish. How has Excel helped you in your day to day work? I'm loving these new check boxes.
❓Which new Excel feature are you most excited to try?
Learn more about the Excel Expert course: bit.ly/newexcel25course
I'm waiting for the calendar :-) I'm sorry, Mynda, but this solution with SCAN (LAMBDA, IF etc.) doesn't look good to me. The Focus Cell is fine and I'm grateful for the integration of regular expressions. (Too bad the IMAGE function can't work with local files.)
Great content as always. Thanks for sharing the useful updates Mynda!
Glad you found them useful!
Thank you for your ongoing inspiring and valuable input to me personally and to all.
Wishing a great long times to come..
You are most welcome! I appreciate your kind words.
Thankyou for sharing these tips. I loved the check box and Focus feature they have included. I am watching your videos and learning a lot. I use it for work.
Awesome to hear.
I learned new operator - TRIM operator. Great!
Thank you for being so helpful! Love your videos -- always learn something new from you. 🏆
Thanks so much! 🙏
Thank you for this summary video. The focus cell functionality was new to us. The checkboxes are such a godsend. We just used them in a deliverable for a client, and they were blown away. Keep up the good work!
Awesome to hear! Glad they were impressed with the checkboxes, they’re one of my favourites 😁
@@MyOnlineTrainingHub Ours, too!
Thank you! I love Excel and this makes it even better?😊
Glad you like these new features 😁
Very good content and examples. thank you!
Thanks so much, Tom!
Brilliant! So glad I found your channel!
Awesome to hear, welcome!
Hello Mynda, for most of the year 2024, I was learning VBA, DAX and MCode so I missed lots of Excel Worksheet Formulas Updates, but You gave me a nice review. Thanks a lot for your training contribution. Have a nice EXCEL&PowerBI Year 2025😃😃😃😆😆😆!
Great to hear 🙏
Thanks a lot Mynda a great review. Nice year 2025, greetings from Mexico
Likewise, Miguel!
Happy New Year, Mynda … what a start to 2025 with this video. ❤ You are really impressive 😮 … Cheers,
Thank you! You too! Glad you liked the video.
I so much love this checkbox, will be used for my issue resolution. Many thanks for sharing and your knowledge transfer. 👏👌
Glad to hear it will be useful!
Happy New Year and thank you for the continued great content! Hope those new features will soon be released to the mortals!
Happy New Year to you too! 😁 fingers crossed they’re available soon.
That's just great! Thank You, Professor Treacy for this update..!
Awesome to hear you liked it!
Thanks for update,I like new feasure check box very much .
You're welcome! Glad you like the checkbox!
The best! Thank you for these gems Mynda
My pleasure 😇
Thanks for the updates. Wouldn't it just be easier to use IF(C4="","",SUM($C$4:C4)) instead of Scan, Lamda and Trim? Trim still references the full range created.
Yes and what is worse, using the lambda function in Excel requires a developer's mindset. I doubt more than 0.001% of users will ever understand this.
But when doing a video to demonstrate what a function does, it's best to put it in a simple example that people can relate to.
This isn't a running totals video. This is a new features video. She is using running totals as a simple example of a new feature.
@@sco0tpa I see your point and Steve's point. However, in my opinion the issue with this example is that:
Beginners cannot benefit from it because this is too complex for them and, more importantly, unless they come across another video, they will think you need SCAN to solve a simple problem like this.
Intermediate know an alternative way of doing it and think SCAN is not needed.
Advanced know that SCAN can do more than this but yet this example does not show a real problem where SCAN is the best option
excellent.....thank you my friend and mentor. Oh and Happy New Year 2025
Thanks and happy new year to you too! 😁
Happy New Year Mynda! Good luck with the chores list lol
Haha, it’s a work in progress!
Thank You, Mynda!
Best Wishes for a Wonderful 2025 💐
Thanks so much, and you too! 😊
1:50 You don't need to do COUNTIF, since TRUE/FALSE behaves like 1/0 when used in a calculation. Just use the old -- trick to force a calculation and sum the result, like so: =SUM(--C7:C18)
Thanks !! 🙏😊 Can you explain the -- trick ? It works... but I don't know why 😁
@@00oxymore It just does a negative of a negative, so returns the same number. But because it's a calculation, it also converts FALSE to 0 and TRUE to (-1 and then to) 1.
Hi Mynda, Not sure if your teenagers appreciate your examples as much as I do, but they are absolutely fantastic. Thanks a bunch!
They are not liking the fact that I have a record of everything they have and haven’t done. No more arguing about who did which chore last 😅
@MyOnlineTrainingHub How do I install Copilot with office 365 home account.
Thank you very much for your detailed information. How realistic do you think it is to prepare and sell a template using Excel?
There are plenty of people selling templates on Etsy.
Many thanks for your great videos👍
Glad you like them!
Thanks Mynda! The focus cell and TRIMRANGE are big deals.
Two of my favourites too 😁
Hi Mynda, I just had a look at your excel course. Do you also teach how to create dashboards?
Yes I do! You can find it here: www.myonlinetraininghub.com/excel-dashboard-course
Thank you for this video!!!
I really love the focus function, I used to code VBA for this 😂😂😂
😁 glad to hear you’re saving some time and not needing VBA!
great as always...
your fan
Thanks, appreciate your support!
Which office version are you using. Is it available in MS Office 2021 or 2019?
I’m using 365. These are new features that are only available in 365.
Excellent
Thank you so much 😀
How do I get the Copilot icon in home?
Focus Cell.... YEAH!! I really need this one that's NOT a macro... not allowed to use macros at work... even this simple one..
Glad to hear you’re liking the focus cell feature!
RESPECT!!!
Thank you!
how does one get the updated excel features? Do i need to buy another version??
You need a Microsoft 365 license to get access to new features as they’re released.
Excellent trim range example using a shortened formula with a '.' thanks Paul
Glad you liked it, Paul.
I appreciate you were trying to just give a simple example of SCAN which I know can do much more powerful things, but I think IF(C5"",SUM($C$5:C5),"") would be much easier in that example.
Thanks for sharing an alternative.
I really like the focus cell…..but it clears when I click on another program. Any ideas to make it stick until I choose another cell on the sheet?
Not possible. It’s one of those annoying limitations.
This is OT, but do any of you have any idea why "get data from the web" isn't available in Excel 365 for MacOS? I could've sworn it was an option in the past, but this morning I can't find it. TIA
Power Query in Mac Excel doesn’t have all the connectors of the windows version yet.
@ thanks. I thought I was losing my mind. 😂 I even booted up my old Windows computer to make sure.
ISBLANK would have been faster than scan for the empty values tbh in the first simple example, but Trimrange looks useful to save file size.
Isblank wouldn't have demonstrated a new feature.
I don’t have checkbox in my Excel. Will it come in a future update?
Yes, if you have a 365 subscription you can update Excel to get the checkbox.
When you copy the formula for total checkboxes, how does the column change automatically from C to D?
Relative referencing.
The copied formula was on column C, when she moved 1 column to the right & pasted the formula, the pasted formula also followed that 1 column move & updated itself.
There is a problem with Focus Cell. Frozen Panes automatically desactivates Focus Cell for the same sheet. MSFT is aware of the issue and is currently working on it. Otherwise, Focus Cell is quite an interesting tool. I must say.
They’ve fixed the issue with freeze panes now.
Now that they've deigned to finally implement focus cell/rowcol highlight after years of requests, it looks like we'll finally get the dark mode in a few years as well /s
And the speed with which they roll or these new functions in non-beta o365 is quite slow. I mean I still don't have the groupby functions available...
I agree, some of these features take forever to roll out, and functions are usually the slowest because they can’t change them once they’re released.
That's cool
Glad you like these new features.
Checkbox is not active. What to do ?
If you are using office 365, then update it else, you need office 365 to access checkbox ✅
2:23 Couldn't you also do a COUNTIF()?
Not if you want to demonstrate a new feature.
i still do not have the trimrange feature. cant wait for them to roll out this function to everyone
Yeah, it’s a game changer.
good luck with getting the kids to do the chores - if this works you need to do a whole video just on that
Thanks! If this works I reckon I could sell this as a template and retire 😅 I doubt it’ll be that easy though.
That's a crazy number of chores!
Too many? 😆
TH-cam features language hindi enabled please
TH-cam should be auto-translating my videos now.
@@MyOnlineTrainingHubplease enable language india hindi, auto translate
@@MyOnlineTrainingHubplease india hindi language enable
6:24 Or - You could just use tables and it will automatically fill down for you... 😉
Actually, running totals in tables are buggy unless you use a trick with the INDEX function.
I saved that to "Watch later" for when I am sober 🍷😀
HAHAHAHAHA, a little ambitious with the tasks they need to do.
I know exactly what you mean. 😂
I can see what the row of check boxes would look like for my daughter for 'load the dishwasher'.
A row of no boxes checked for the entire week. Lol. 😁 🙄
😆 glad I’m not alone with chore battles!
running total =IF(A8"";SUM($A$1:A8);"")
Is that a new feature in 2025? This isn't a running totals video. This is a new features video. She is using running totals as a simple example of a new feature.
"I can dream" 🤣
🤦♀️😁
✅
Thanks for watching.
I am first to comment
Instead of that, how about a relevant comment for the topic of the video.
These 'I'm first' comments are childish.
How has Excel helped you in your day to day work?
I'm loving these new check boxes.
@cgi2173 great to hear you’re making use of the new checkboxes 😁
@@cgi2173 I am already using
Do appreciate your videos tho 🙏
Thank you!
Uh, scan function... Hard pass 😂
Fair enough 😁