Short sweet and to the point I really enjoyed the presenter no access very clear. I think this is an excellent tutorial. Thank you.
@SeleTraining
Жыл бұрын
Glad it was helpful!
@syrophenikan
Жыл бұрын
Tip #8 has been around for 10+ years. Your video will hopefully introduce it to more users. It’s a great tool for debugging.
@SeleTraining
Жыл бұрын
The old method has been around for #8 but they added the ability to view it in preview mode. That’s new.
@matttownsend7119
Жыл бұрын
@@SeleTraining What do you mean by preview mode? The only ones I am aware of are the preview of a printed page and the preview of things like format options (eg Bold) in a cell. I can't see how the formula tooltip (which I have also been using for years) is applicable to either of those.
@SeleTraining
Жыл бұрын
@@matttownsend7119 #8 is called Value Preview Tooltip. It is because now it shows you a preview of the formula results without having to do multiple steps as in the past.
@romerozarragossa
Жыл бұрын
Thank you SIR, by far the best presentation I have seen in month. You are a great teacher indeed, SIR. I like to learn how to do that this well.
@salmaalaa6158
Жыл бұрын
thank you Mr. sele and happy to be back after long time
@arvindr2101
Жыл бұрын
This one super useful for day today work. Your video helped to solve picture related task. Thank you
@carlosramia
Жыл бұрын
I love your videos...I'm a passive user who goes to your videos when I get stuck. Keep it up!!
@SargeKot
Жыл бұрын
Thank you, Mr. Sele 💚
@kmt_5418
11 ай бұрын
I really appreciate you thank you❤❤
@ingGS
Жыл бұрын
This was so useful! Thank you very much. I am a power Excel user and I did not know at all about some of these.
@uvsiblings794
Жыл бұрын
Thank you Mr.Sele
@kapil4757
Жыл бұрын
You have nailed it! Awesome way to showcase 👏.
@BenDieselBasicAutomotive
Жыл бұрын
Thank you very much for the very detailed explanation!.... More power...
@user-zx3xg5jp1o
Жыл бұрын
Very interesting and useful. Thank you. You have nailed it! Awesome way to showcase ..
@mehmetkaya4330
Жыл бұрын
Thank you so much for this great tutorial/video!
@abdurrezakoncu8920
Жыл бұрын
Thank you. So valuable information. Almost half of them are, I really needed Before
@reighbernal188
Жыл бұрын
Short tutorials for most yet very informative functions. Thank you so much.... New Subscriber here.
@alfredtomiamubiaya3330
Жыл бұрын
Many thanks for this video
@NithishKumar-uh4kn
Жыл бұрын
Thank you Very much, very helpful.
@jayeshaw5705
Жыл бұрын
Very good explanation!! Loved these tips!
@alexrosen8762
Жыл бұрын
Very interesting and useful. Thank you🙏
@c.mdsalih
Жыл бұрын
Great video. Thanks!
Жыл бұрын
Dreamed with the Ctrl + Shift + V for many years. My laptop had to have a List key to use List+V because of this, from now on i´mfree to buy any laptop :D
@kemad86x
Жыл бұрын
Thanks for update :) Regarding the textsplit and the spaces, I would consider adding another textfeature - the TRIM - this would also handle any possible double spaces, and always beats hardcoding.
@SeleTraining
Жыл бұрын
Good idea
@Jobheha
Жыл бұрын
Very good video thanks
@nadinecohen8482
Жыл бұрын
thank you, very good!
@Schroefdoppie
Жыл бұрын
Like this style of video, solid explanations, no fluff. Picked up a few things I didn't yet know about. Thanks! *subscribed
@khaledaboelhamd
Жыл бұрын
Useful video, thank you
@mikeseal3053
Жыл бұрын
Thanks a lot
@abbottkatz8830
Жыл бұрын
Concerning TEXTSPLIT: you can also enter delimiters in cells and refer to them in the delimiter argument, e.g. =TEXTSPLIT(A3,B1:D1,,1), where the delimiters are posted to B1:D1
@SeleTraining
Жыл бұрын
Good tip
@abbottkatz8830
Жыл бұрын
@@SeleTraining Thanks.
@threeferns8162
Жыл бұрын
Nice video. FYI, also "Recommended Data chart" a new feature add as well.
@ennykraft
Жыл бұрын
Recommended Pivot-Tables have been available since 2013. The only thing that's new is that they show up on the right hand side instead of in a dialog box.
@ExcelWithChris
Жыл бұрын
Loved them ll!!
@johnsantalucia446
Жыл бұрын
These videos are Great! Can I ask a specific question?
@SeleTraining
Жыл бұрын
Sure
@dougmphilly
Жыл бұрын
Textsplit is awesome
@learnspreadsheets
Жыл бұрын
Heya great video, this is useful but some features are only available for the beta channel for now (which isnt generally available), paste values shortcut and recommended pivot tables, also the tooltip click to select has always existed, what is new now is that is shows the value output at each stage but your version doesn’t seem to show it in the demo
@SeleTraining
Жыл бұрын
They are available if you are on the monthly update. If you are set to 6 months you’ll have to wait a bit longer.
@jamc666
Жыл бұрын
great vid
@7513747
Жыл бұрын
Very useful.keep it up. Thank you
@perryham
Жыл бұрын
Awesome
@jamilanjum374
Жыл бұрын
Helpful
@neilvanrooyen7196
Жыл бұрын
CTRL+Shift+V has been around for a VERY long time.
@SeleTraining
Жыл бұрын
It was added recently to Excel. Only at the end of 2022 for the insider preview. It’s been around for other Office apps and Google sheets though.
@neilvanrooyen7196
Жыл бұрын
@@SeleTraining Ah! okay cool, well it's about time then... I was wondering why it wasn't working properly at work. It's about time the MS Office team started creating some more user friendly formulas. I felt like a 12 year old when they finally implemented Xlookup. There is still so much more that they need to do, but at least they're doing something and most importantly focusing on better Formulas again. I've been using Google sheets for a few years now and love what they've done so far... there is still a lot they need to do, but what they have done is implemented Great functions that MS could learn from and adapt. I just wish Google would finish a project before moving on to the next. I must be honest, I mostly use Google sheets, and only use MS office when at work.
@jacqueshollands5630
Жыл бұрын
Excellent video, but sadly the Ctrl+Shift+V option still doesn't work for me
@Bludicka78
Жыл бұрын
yes, the same
@cathielem2023
Жыл бұрын
Do you have an excel template for bank reconciliations without the direct connection to a bank statement? With an option to manually reconcile from the last reconciliation date?
@SF-bm8ns
Жыл бұрын
These features are great. I am suffering from a feature that was in the filter function I have a list in with names, dates, and gender and a photo in one sheet Nd i have a filter function in the next sheet trying to extract a list from the first list based on gender or names or dates and the function works Beautifully and get all the information except for the photo. I tried so many ways but no luck. I will appreciate it if you can help.
@SeleTraining
Жыл бұрын
Yes, I see that the FILTER function will not bring over a photo. If you can referenced the photo as a link you can use the example shown in this video and use a URL. The filter should bring over the URL. Then display the photo based on the URL.
@JRP.1989
Жыл бұрын
Control shift v doesnt work for me and my excel is up to date, any ideas?
@romerozarragossa
Жыл бұрын
I would like to teach a great app called Total Commander which is so much better then File Explorer and Finder. I have the material but don't know how to make great videos and what tools to use. Can you help?
@adamshults9810
Жыл бұрын
It would also be cool if clicking on one of the parameters would display the result of that parameter, and not just highlight that section of the formula. This would prevent you from having to press F9, and then undoing that action to return the formula back to its dynamic state.
@clairejsquibb
Жыл бұрын
This is now available, or if you haven't got it yet, it will be very soon.
@mrj8001
Жыл бұрын
Can you provide the url to the Microsoft image galleries?
@SeleTraining
Жыл бұрын
If you are referring to the Insert Pictures option in Excel it just uses the Bing Photo search. That is the same as doing image search in Bing in your browser. Not sure there is a specific URL for it.
@paulafcooper3794
Жыл бұрын
🤯
@example33888
Жыл бұрын
Well the CTRL-SHIFT-V Shortcut does not work for me. I am using Microsoft 365. Is it because my subscription is not Business version?
@SeleTraining
Жыл бұрын
Make sure to run the update so you have the latest version. It is a very recent addition.
@danbromberg
Жыл бұрын
Will these updates eventually work their way to EXCEL PRO 2016?
@SeleTraining
Жыл бұрын
Not likely. The subscription version is what gets these types of updates.
@skillfulactor09
Жыл бұрын
Do you need office 365 to have these features ? Or can you use the 2021 or something
@SeleTraining
Жыл бұрын
Most of these require the latest subscription version of Microsoft 365 Excel. That’s the version that gets all the updates first.
@abbottkatz8830
Жыл бұрын
Re IMAGE: Google Sheets also allows you to insert images stored on your hard drive.
@SeleTraining
Жыл бұрын
I do see sometimes that Microsoft implements features that Google Sheets already has. I'm sure they keep notes!
@abbottkatz8830
Жыл бұрын
@@SeleTraining Definitely, and vice versa.
@seifaya3724
Жыл бұрын
Does tip n° 5 exist in version 2016?
@SeleTraining
Жыл бұрын
No, this is new only recently.
@jerryeubanks491
Жыл бұрын
About 152 in your clip You're talking about bringing in a table from a web page I don't understand how to get that web page whether I'm in like Yahoo and grab the web page do I take a a copy of it a control copy or what and then bring it in I'm not sure how to do that otherwise the video is great😂
@SeleTraining
Жыл бұрын
Any saved image of a table of data will work. You can use the Snipping Tool in Windows to make a copy of a web page and save it to a file on your computer. Then open it as shown in the video. You could also copy the image to the clipboard and then choose "Image From Clipboard" instead.
@andyrobertson4096
Жыл бұрын
LET and lambda are the biggest things IMHO.
@SeleTraining
Жыл бұрын
True, but those functions have been around for over a year.
@hawler-vd6wh
Жыл бұрын
Mine doesn't have that tab =from picture
@SeleTraining
Жыл бұрын
Make sure you check for updates as shown in the video.
@brazenserpent7
Жыл бұрын
Please switch places for New and Excel in the title.
@andyrobertson4096
Жыл бұрын
Also image is not rolled out everywhere so how useless is that. If you use it you might send it to a colleague ina region where it is not rolled out. Utter trash.
@SeleTraining
Жыл бұрын
You could say that about many features over the years. This is one reason Microsoft pushes the subscription based version of Microsoft 365 Excel. That keeps people up to date.
@Mark-qg8hm
Жыл бұрын
So in other words, nothing useful. Oh, but if you have data in a nice clean excel spreadsheet you can take a picture of it, and then import it into excel from your picture? Wow, that is so much easier than just copying and pasting the sheet! What I NEED is to import data from a picture of data handwritten by my sloppy intern with terrible handwriting.
Пікірлер: 93