The #2 trick was already there for years but not in the ribbon, granted. Just double-click on a value to open a new sheet with relevant data. Only the button in the ribbon is new.
I’ve been reading about the recent checkboxes but I can’t find them in any of the M365 excel that I have, neither the paid personal, nor the work, nor the university. Why is that?
Great video, you didn’t show how amazing flash fill really is. It’s great at extracting data inside other data in a cell. Like a string of numbers inside a cell with numbers and letters. Or a color or size inside a string like “tshirt large green” you could type large the. Flash fill and it finds them all with 99% accuracy.
Show Details on a pivot table was aleady part of Excel if you double clicked onto a pivottable summarised element - it's disappointing that Excel on the Web appears to be given more love than the windows app
Hi Mike. Thx for your video. Excellent ( once again). Would I know how to check if my MS 365 Version ( in South Africa) has the new ‘check box’ released ( or that I can update ), since that feature is NOT on my software although I have all updates checked and this feature does NOT show up. Thanks
Guys! Today I noticed something supper odd. And now I wander was it always like this? Here's the issue/bug: in both Excel and GSheets the COUNT(range) and COUNTIF(range, "") formulas are counting the cells even if they have formula that outputs "" Blank results! WHATA HACK IS EVEN THAT?!
To check out all of the Excel updates, new features and tips, check out this Excel playlist: czcams.com/play/PLdHjJccRYryMeSVJ4231nmf-zondK6oK9.html
Great to see you here, Mike. I've been following your Teams and M365 updates for years.
The #2 trick was already there for years but not in the ribbon, granted. Just double-click on a value to open a new sheet with relevant data. Only the button in the ribbon is new.
No, it’s not. Look at A1 when you drill down.
Very helpful, thank you!
thank you
I’ve been reading about the recent checkboxes but I can’t find them in any of the M365 excel that I have, neither the paid personal, nor the work, nor the university. Why is that?
I hope pivot table for Android is coming soon.
Good video❤
Do you know anything about your second tip for pivottable show details,it breakes the workbook if your using vba/macro?
Great video, you didn’t show how amazing flash fill really is. It’s great at extracting data inside other data in a cell. Like a string of numbers inside a cell with numbers and letters. Or a color or size inside a string like “tshirt large green” you could type large the. Flash fill and it finds them all with 99% accuracy.
What about Drag & Drop for Excel cells in the Desktop app?
Show Details on a pivot table was aleady part of Excel if you double clicked onto a pivottable summarised element - it's disappointing that Excel on the Web appears to be given more love than the windows app
Hi Mike. Thx for your video. Excellent ( once again). Would I know how to check if my MS 365 Version ( in South Africa) has the new ‘check box’ released ( or that I can update ), since that feature is NOT on my software although I have all updates checked and this feature does NOT show up. Thanks
column drag with mouse is not part of the insider program version! how did u get that?? i tried to find it on web version and no luck.
Guys! Today I noticed something supper odd. And now I wander was it always like this? Here's the issue/bug: in both Excel and GSheets the COUNT(range) and COUNTIF(range, "") formulas are counting the cells even if they have formula that outputs "" Blank results!
WHATA HACK IS EVEN THAT?!
Its Neil Pee-rt... not Pert
Your Rush fan card has been permanently revoked
6.36 pls advise how I can set the paste options description instead of symbols.