Another 15 Excel 2016 Tips and Tricks
Vložit
- čas přidán 24. 07. 2024
- Here's Another 15 Excel 2016 Tips and Tricks. This is a compilation of 15 additional Excel 2016 tips and tricks that didn’t make it in my previous Top 25 Excel Tips and Tricks video. I'm going to show you some powerful tips and tricks to help you become more proficient with Excel 2016. To watch the other videos in the series click on a link below.
Top 25 Excel 2016 Tips & Tricks: • Top 25 Excel 2016 Tips...
Top 15 Advanced Excel 2016 Tips & Tricks: • Top 15 Advanced Excel ...
Introduction to Excel for Beginners: • Excel Tutorial - Beginner
Support me with your Amazon purchases, click here: amzn.to/2Kxp533
Contents 0:00
1. Move Columns/Rows 0:44
2. Name a Range 1:16
3. Status Bar Totals 2:15
4. Insert Multiple Lines 2:54
5. F4 Absolute Reference 3:35
6. Difference Between Lists 4:20
7. Data Entry Limits 5:13
8. Trend Line in Charts 6:16
9. Ctrl-Tab 7:02
10. Split/Combine Names 7:21
11. PROPER() Function 9:27
12. Mean, Median, Mode 9:52
13. PMT() Function 10:49
14. COUNTBLANK() Function 12:23
15. Date/Time Shortcut 12:47
#seletraining #excel #tipsandtricks - Věda a technologie
Thank you Sele. I have difficulty when a training video runs too slow and loses my attention. Your videos are at a good pace, informative and make me more productive. I am described and will start looking at recent videos as well. Great Job!
Best Excel Tutorial I've seen... I learned a lot.
Much thanks Sele for making our lives easier for computations. these are excellently helpful indeed.
You are exceptionally doing well in this. I enjoy and learn a lot from your tutorials. That you very much.
Thank you~ very informative and useful!
Thank you, I like learning new things.
Thank you Sele. Fantastic and easy to understand tutorials.
Excellent tips. Thank you very much!
Also great! Liked all 3 excel tips$tricks videos. Thank you!
Thank you! Great presentation and very useful tips.
thanks bro this really helps! thumbs up!
Thank you for the amazing videos. Very informative and helpful in my everyday work life.
fantastic presentation. thank you!!!
Great rhythm in your teaching explanations.
Appreciate your videos - Your voice cadence and ease of style makes you superb in your flow - subscribed and will reference frequently!
Thank you so much for free teaching.
Thanks for your efforts. Its really helpful
I’m very new at this. Thank you for your video!
Helpful and informative.
Thanks
Thanks for the video it is very helpful.
thanks for the guidance, your voice and the way you talk is really nice..
Thank you so much. Your videos are so easy to follow. You sir are awesome!!! Many many thanks for these videos..
Thanks You so mutch. Always wach your videos with plearure. Me interested topics are : VBA, data analysis, formulas, report building. Thanks!
thanks for these tips it has made my work much easier
This is some great info. Thanks!
Very useful tricks .Thank you sir!
thank you sooooo much ,,, your videos helped me very much
Great tips and tricks, verry helpfull
Awesome!! More more more!!!
Great stuff!
Very Helpful!
Excellent tips!
You rock! Keep it up. Thanks for all these tips that makes our day to day tasks much easier and faster.
Found very valuable tips. Thanks
Nice to listen to. Nice voice. And no word to much. Perfectly explained.
Excellent tips. Thank you very much!
sir ..
Be sucussfull
Wow ! I thought I new how to use excel efficiently ... I was not !
Amazed by the addition of multiple lines columns and moving lines or columns !
If you got more I am a fan !
Very good Tips & tricks videos
Erick from France
Make sure to check out the first Excel video: czcams.com/video/EdnAeqxqdzM/video.html
Thanks for that. Number 6 at 4:19 was especially helpful - I hadn't thought of using it that way, but that's very straightforward.
Excellent!
@@SeleTraining Hello, I tried to select 2 different tables on different worksheets within the same workbook. I copied the 1st table on 1 worksheet, pressed and held the Control Key and then clicked on the other worksheet that contained my 2nd table. As soon as I clicked on the 2nd worksheet the option to click on Conditional formatting became grayed out.
Can you please provide information as to how to highlight duplicate (or unique) cells when the tables are not on the same worksheet. Thank you very much I appreciate your tutorials as they have helped me a lot.
Very helpful!!!
great - thank you very much
Thank you so much,sir.....
Great video, Thanks for the video
You are a great man 👍🏻
thanks a lot for this lesson. well presented
Useful information. Thank you
Its really Great session !
useful info, thanks
You are great. Keep going.
this video is helpful really
Thanks , some one in mouth!!!
Thank you very much.
Thank you :)
These are the best tip for excel user, I think. Thanks million Sele Training
Thanks
great tool. thanks man
Great videos and audio. I found the text messages some actions you perform. Perhaps small fonts will be great or text messages placed where there are no data. Thanks for the great videos.
Well. I watched waking up this AM and you gave me 2 to-dos to do first thing at work to help me with my vacation rental yield management data.
Thanks.
PS I think I'm going to have to crank up my desktop today. Laptop is starting to struggle with all of the linked cells and the myriad of conditional formatting. It's an 4 year old i7 with 8GB of RAM Ultrabook.
Supper explanation, and very helpful
Very nice not a lot of explanations just get right to it. Very simple.
Excellent tutorial. Thank you!
Excellent Tips 1000 Tums Up
very useful !
Excellent...wow...great tips.
Thanks. Don't miss my newest Excel tips and tricks video: czcams.com/video/FXs3WG7M-qk/video.html
pacing is just right. thanks
Hi, for item no. 10, you can actually split the names by using Ctrl + E function as well. It's easy and efficient. Cheers
Thank you
nice work
I can see
Your voice is your strength
Training is your passion
All your videos are great and precise and helpful
I appreciate that!
This one's probably my favorite of all the MS Tutorials !!!! Question. When creating a "trend line" over your graph, how does one include the "equation", be it linear, log-arithmetic, polynomial, etc? This can be useful for extrapolating or interpolating.
On the Trendline settings you can scroll down the list and there is a check box to "Display Equation on chart". You can also "Display R-squared Value on chart".
thanks for sharing
Very useful excel tips
thank U very much
Thank you.
Very useful
thanks!!
Awesome
Awesome tips. Thanks for sharing.
One quick and alternate way to split the name is to use the "Data" menu and "Text to column" function along with a predefined separators like "Space", "comma" or custom. Most easier way to split the text and very powerful without writing any formulas. Please feel free to include them in your next Excel tip videos.
I practice the tips that you are sharing to reinforce the learning. Please keep doing this and I love it!
I have those tips in my original Excel video. You’ll want to check that out if you have not seen it yet. There are three Excel tips videos now.
That was really helpful....
Glad it was helpful!
Thanks sir from mumbai.pls make video for data analysis
thank you
#10 Split/Combine Names: When splitting names I find it very handy to use the "Text to Columns" which is done with far fewer keystrokes, and faster. Nevertheless, you give a great and valuable lesson. Thanks.
Yes, I mentioned that in my previous Excel video. I wanted to show the manual option here so people know how to customize it if needed.
Best Excell video ever
Thanks!
Helping me to stay up to date on my excel skills during quarantine! Thank you so much! After quarantine, I plan to take the 2016 certification exam
You can do it!
Sele Training do you have any certification prep videos?
@@jodicamps5693 No. You can see all my videos from my CZcams channel page. There are several Excel videos but not specific to certification.
Love it
Wowwww 🤩
thank you it is very helpful.
Glad to hear that!
Thanks for the wonderful video, I wd like to know a excel formula to get static date, that will not change when the file is opened the next day.
If you use a formula like =today() it fills in todays date but then updates anytime the spreadsheet is refreshed or opened. You could turn off the automatic refresh but that may have negative consequences to other formulas. The challenge is that any date that auto-fills will also update so how would you know when you want it updated and when you want it stored permanent? One option is to create a Macro that fills in the date one time. You can assign the macro to a keystroke. You do that once and then the date is stored permanently.
excellent
To change formulae to values, select formula cells
Right click and hold throughout
drag right to an empty area,
then drag back into place
10. Split/Combine Names 7:21
An Alternate method on splitting data, you can use the "Text to Columns" tab found in the Data Toolbar.
You can separate the data either Delimited or Fixed Width.
1. Delimited can be used if the characters are were separated with commas or tabs
2. Fixed Width can be used if the fields were aligned in columns with spaces between each field.
For the video, just press F1 on the Excel 2016 and type in "Text to Columns" and look for "Split text into different columns with the Convert Text to Columns Wizard"
for more details.
I hope this helps :-)
Or just use Flash fill (crlt+E)
I have two time series data series on a chart. I would like to show separate trend lines. However, the second trendline is applied to the two series as if they are one series. Even when the series are in separate columns, the trendline spans both. Is there a step I am missing? Thanks for any suggestions.
Hi, great video's very informative. Re: the Proper function. On the part where you breakdown the combined 1st, middle, last names into 3 columns, have you also tried the Text to Columns approach? Using SPACE as the delimiter it seems easier than those long formulas. What do you think?
Yes that is a good option. Another is Flash Fill. If you type the first line in the format you want it figures out the rest for you based on that same logic. I mainly wanted to show the formula option for reference in case someone needed to fine tune the conversion for more complex names but I prefer the flash fill as the quickest method.
Tesnobay - Yes. Text to columns is a better way of breaking up text. The delimited option is super helpful.
I hope you never quit making these videos. More helpful than you can imagine. Thank you! Do you know if Microsoft is planning an updated version since this one is now 6 years old? I hope not as I am just beginning to understand some of this one. :) Whenever things change, too often companies drop features - that makes it more confusing and frustrating and tends to affect files already created. A horrible way to treat people.
Make sure to check out my 50 Ultimate Excel Tips and Tricks video. That one has more recent features.
For the split/combine names, it seems easier to use flash fill. But nevertheless, learnt another useful formula which I never knew existed (find...). Thanks!
Flash fill is usually a better choice and was shown in my other Excel video. I wanted to share the details of a formula solution in case someone needed a complex custom method when flash fill did not work correctly.
I can't thank u enough.
Geweldige video! Leuke inspiratie voor mijn kanaal!
Thank you so very much. You are a Godsend! How do you query a table on the internet to update data on a spreadsheet? The data is password protected. I would prefer this action automatically on intervals I set but manually would be fine. Thanks again so much. You are an answer to prayer.
My latest video shows you how to get data from the Web into Excel: czcams.com/video/-CDu4zFShS0/video.html. I didn't go into detail about getting data when a login is required but there is an option to setup credentials when the web page requires it.
Brilliant videos, please can you explain macros? Also do you have any videos on Mcsft Acess?
No video for access yet. That's not my expertise. I may do a Macros video someday but I have a few others in the queue first.
A slightly easier function to format names from one cell is to use the CNTRL E shortcut, where he had First, Middle and Last in 3 columns, you could write John Lee Smith in cell "D1" press Cntrl E and excel would carry out the function for you
Great tip!
Hello. Very nice tips. Difficult to remember all of them. If you could put all of them down on a xls file for downloading, this would been very nice to have and a lot easier to remember and have access to.
I don't have a spreadsheet for this one but I do have a reference guide with many Excel functions: czcams.com/video/8P4-jOoYBjo/video.html. You can also use the links in the description of the video to go back to each tip.
These tips are helpful for excel 2007 also
Excellent!