I have said this before and I will say it again: the entire team at Microsoft should have been given some equivalent of the Nobel Prize for inventing Excel. Sir, you did a great job and thank you for sharing it with us. I use excel a lot and I'm stunned when I remember how difficult my life used to be prior to applying such tips & tricks.
14:15 Number 14 - Absolute Cell Reference Quicker way to do it is select the cell reference, then press the F4 key. Also, you can lock either the row (e.g., A$1) or column (e.g., $A1) by pressing F4 once or twice (F4 scrolls through the options). Nice work! Thanks for the great video, Sele Training.
These videos are AMAZING I have learned more in two hours of watching these videos about excel than I have in years of trial and error on my own. THANK YOU SO MUCH!
WOW! This is the BEST video EVER. Everything is easy to understand, especially VLOOKUP. Others have taught VLOOKUP and I had a very hard time learning but you made things SUPER EASY. I thank GOD for you.
*WOW! Thanks so much for these tips and tricks. Fascinating!!!! I learned a few tricks from watching your tutorial and I have been using Excel for a very, very long time!*
14:20. Excel has 3 types of references :A1(RELATIVE) $A$1(ABSOLUTE) A$1/$A1(MIXED). But in rest much appreciation, it really helped me a lot. BIG LIKE!
I've taken Excell before, but it's then probably 4 to 6 years ago. So this is very helpful in making my memory click, thank you so much for your tutorial!!♡♡♡
Don't mind me this is for personal use 👍 0:49 Quick Analysis Tool 1:45 Filter 2:27 Drop Down List 3:13 Auto fit Column Width 3:47 Transpose (reversed column) 4:13 Remove Duplicates 5:22 Goal Seek 6:55 Vlookup 9:08 Flash and Autofill 10:47 Paste and Special Value 11:50 Images in Chart 12:29 If Function 13:39 Insert Screenshots 14:17 Absolute Cell Reference (Put a dollar sign) 15:57 Show Formulas (CTRL + ~) 16:57 Text to Column 18:12 Conditional Formatting 20:48 Freeze Panes 21:41 Ctrl Arrow keys 21:59 3D References 23:44 Forecast Sheet 24:16 SUMIFS Function 25:39 IFError Function 26:30 Filled Maps Thanks
Oh my God! I said that multiple times out loud during this video, pretty sure my dogs even looked at me a few times. I have been using Excel for several years, but just the basic features, picking up on a few of the suggested tips on the video along the way. I look forward to sharing this video and using the tips provided.
Just the ones I thought were really useful (and didn't already know or oft forgotten) 5:22 Goal seek 6:57 VLookup 14:15 Absolute Cell Reference 15:55 Show Formulas (ctrl + ~) 16:57 Text to Columns 22:00 3D References 23:43 Forecast
cool presentation, precise and informative. It was interesting to see the shorter versions of the functions I have used for the longest time. #21 is also my fave. I agree with Michael that it will be cool to have a downloadable file for us to practice. Hope you will consider. thanks and all the best
tips: by holding ctrl + shift + arrow keys you can select a range of cells for exemple: you can select the first cell of the cell range and hold ctrl + shift + ➡ to select the first row and then ctrl + shift + ⬇to select the rest of the range Also for the 3D reference, we can select the range where we want to get the calculated numbers, go to data tab - consolidate - and select "sum" if you want the numbers added, then select the range from each worksheet and click "add" each time. If I'm not mistaken, it works even if the ranges are on different workbooks
I have been following you for the past few days, and I must say, your tutorials are incredible. Very easy to understand and very useful. Thank you so much!
Very, very helpful and gave me tips on functions that I knew about but was a little fuzzy about how they should be processed. I am a new subscriber and am looking forward to the next video
Excellent Top 25 tips and tricks for Excel 2016 I ever encounter, thanks for explaining very effectively the intended material. Request you to make similar videos of macros in office components to carry out daily tasks effectively. It will be blessing for general public. Thanks a lot for these efforts that are easing so many peoples work around the world. Be blessed.
Really nice, I knew a good few of them, but I did learn something. The IFERROR function in particular is very nifty!...Off now to watch your advanced tips and tricks.
"Custom Sort" is also a cool function that comes in handy! I created a cool Excel Text that was inspired by these Tips and Tricks style videos to let everyone see how much they know. The *Ctrl + ~* is really cool - I didn't know about that! I know that is going to be super useful thanks!
Thank you so much for the video. Your explaining is enhanced by your tone and the speed you talk at. I will definitely subscribe. Will also watch your other videos. You should start an online training business.
0:47 quick analysis tool 1:45 filter 2:27 drop down list 3:13 autofit column width 3:47 transpose 4:13 remove duplicates 5:22 goal seek 9:07 flash and auto fill
Ditto #21 being such a frequently used favorite! I also enjoy using Control + Shift and Any Arrow Key to highlight an entire Row or Column (then Control-C to copy, arrow to new location and Control-V to paste a copy of data). Thanks for sharing your awesome tips and kudos for using YT markers (you might want to briefly explain navigation benefits at beginning of your video/s) Happy Trails, Michael