Another 15 Excel 2016 Tips and Tricks

Рет қаралды 399,669

Күн бұрын

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

Пікірлер: 241

@JamesTRyder 6 жыл бұрын

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!

@selfprotectionessentials4930 5 жыл бұрын

Best Excel Tutorial I've seen... I learned a lot.

@herveat5678 5 жыл бұрын

Much thanks Sele for making our lives easier for computations. these are excellently helpful indeed.

@nyawarageorge2971 4 жыл бұрын

You are exceptionally doing well in this. I enjoy and learn a lot from your tutorials. That you very much.

@joannamajorek5721 4 жыл бұрын

Thank you Sele. Fantastic and easy to understand tutorials.

@kxmo3805 6 жыл бұрын

Thank you~ very informative and useful!

@kentvercher1908 5 жыл бұрын

Thank you, I like learning new things.

@Marzchello 5 жыл бұрын

Excellent tips. Thank you very much!

@manongkris9017 5 жыл бұрын

thanks bro this really helps! thumbs up!

@onyxravenstorm5898 5 жыл бұрын

Appreciate your videos - Your voice cadence and ease of style makes you superb in your flow - subscribed and will reference frequently!

@luzhellman4298 4 жыл бұрын

Thank you! Great presentation and very useful tips.

@rahmanrahmani2896 5 жыл бұрын

fantastic presentation. thank you!!!

@kathyschmitz1048 5 жыл бұрын

Great rhythm in your teaching explanations.

@mehmetkaya4330 6 жыл бұрын

Also great! Liked all 3 excel tips$tricks videos. Thank you!

@tomjun8945 4 жыл бұрын

Thank you for the amazing videos. Very informative and helpful in my everyday work life.

@stephaniebravo7773 4 жыл бұрын

I’m very new at this. Thank you for your video!

@aakashmehta108 5 жыл бұрын

Thank you so much for free teaching.

@rajaramk8203 5 жыл бұрын

Thanks for your efforts. Its really helpful

@ottomulder7279 3 жыл бұрын

Nice to listen to. Nice voice. And no word to much. Perfectly explained.

@juniorpolo9301 5 жыл бұрын

Thanks for the video it is very helpful.

@nisarnasim 5 жыл бұрын

thanks for the guidance, your voice and the way you talk is really nice..

@tambasessie9198 4 жыл бұрын

thanks for these tips it has made my work much easier

@sirraymondluxuryyacht8131 4 жыл бұрын

This is some great info. Thanks!

@terrymadeley 5 жыл бұрын

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.

@SeleTraining 5 жыл бұрын

Excellent!

@coachhumph5524 5 жыл бұрын

@@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.

@iridababameto9055 5 жыл бұрын

Very useful tricks .Thank you sir!

@faisalhaq8410 6 жыл бұрын

Helpful and informative. Thanks

@tukahatem1627 5 жыл бұрын

thank you sooooo much ,,, your videos helped me very much

@marcelvanderiet2042 5 жыл бұрын

Great tips and tricks, verry helpfull

@donegal79 6 жыл бұрын

great - thank you very much

@anarenteria331 5 жыл бұрын

Thank you so much. Your videos are so easy to follow. You sir are awesome!!! Many many thanks for these videos..

@Cris-hk4cn 4 жыл бұрын

Found very valuable tips. Thanks

@allabout1135 6 жыл бұрын

Thanks You so mutch. Always wach your videos with plearure. Me interested topics are : VBA, data analysis, formulas, report building. Thanks!

@mintubiswas2546 5 жыл бұрын

Thank you so much,sir.....

@noel89nuyda 4 жыл бұрын

Very nice not a lot of explanations just get right to it. Very simple.

@pmplife6868 5 жыл бұрын

Very Helpful!

@metalpower18 5 жыл бұрын

Excellent tips!

@rossmail5924 6 жыл бұрын

Awesome!! More more more!!!

@sameerahmad6834 5 жыл бұрын

Excellent tips. Thank you very much! sir ..

@tazanoshin5473 5 жыл бұрын

Be sucussfull

@kodidiba8718 4 жыл бұрын

You rock! Keep it up. Thanks for all these tips that makes our day to day tasks much easier and faster.

@michaelyoung5364 6 жыл бұрын

Great stuff!

@rifathhossain2996 5 жыл бұрын

this video is helpful really

@erickbourdin4039 6 жыл бұрын

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

@SeleTraining 6 жыл бұрын

Make sure to check out the first Excel video: kzfaq.info/get/bejne/e8qedMii3dfIqoE.html

@Tina-gp4rg 5 жыл бұрын

Thank you very much.

@thevarajahthambirajah5241 4 жыл бұрын

Useful information. Thank you

@bannuch5041 5 жыл бұрын

Thanks , some one in mouth!!!

@lkuliar 5 жыл бұрын

Very helpful!!!

@maryeilerman2060 4 жыл бұрын

pacing is just right. thanks

@tipu725 5 жыл бұрын

useful info, thanks

@earninvestsave4712 5 жыл бұрын

Great video, Thanks for the video

@aravindyadav3273 4 жыл бұрын

Best Excell video ever

@SeleTraining 4 жыл бұрын

Thanks!

@hemantd9349 3 жыл бұрын

I can see Your voice is your strength Training is your passion All your videos are great and precise and helpful

@SeleTraining 3 жыл бұрын

I appreciate that!

@yoosuffoss5049 5 жыл бұрын

Thank you

@LeahyPhoto 2 жыл бұрын

To change formulae to values, select formula cells Right click and hold throughout drag right to an empty area, then drag back into place

@francisselvaraja3689 5 жыл бұрын

thank U very much

@daisyanthony4660 5 жыл бұрын

thanks a lot for this lesson. well presented

@santoshkhaparde2298 4 жыл бұрын

Very useful excel tips

@marcelocojr 6 жыл бұрын

Thank you :)

@wilidi4108 5 жыл бұрын

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.

@falshiki 6 жыл бұрын

You are a great man 👍🏻

@kelechiokali8446 4 жыл бұрын

great tool. thanks man

@zenbabasha 5 жыл бұрын

Excellent Tips 1000 Tums Up

@yehtetzaw8616 4 жыл бұрын

These are the best tip for excel user, I think. Thanks million Sele Training

@SeleTraining 4 жыл бұрын

Thanks

@thebesttechnical3608 5 жыл бұрын

Supper explanation, and very helpful

@siadalawneh8593 4 жыл бұрын

Thank you.

@noraliew2059 4 жыл бұрын

Hi, for item no. 10, you can actually split the names by using Ctrl + E function as well. It's easy and efficient. Cheers

@troynappier6040 4 жыл бұрын

You are great. Keep going.

@bskrmusic3932 2 жыл бұрын

Its really Great session !

@viviansun844 5 жыл бұрын

very useful !

@mokhtarsaeed4931 6 жыл бұрын

nice work

@tdrawsa 5 жыл бұрын

Excellent tutorial. Thank you!

@suyogpathak9897 5 жыл бұрын

Thanks sir from mumbai.pls make video for data analysis

@alafterplan427 2 жыл бұрын

thanks for sharing

@charlyRoot 4 жыл бұрын

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.

@tajammulhsyed 6 жыл бұрын

Awesome

@stevedebree 3 жыл бұрын

Excellent...wow...great tips.

@SeleTraining 3 жыл бұрын

Thanks. Don't miss my newest Excel tips and tricks video: kzfaq.info/get/bejne/fL6jZrp4nLORoZ8.html

@journeyadityaudaypoddar3381 Жыл бұрын

thank you

@Baranilashmi 3 жыл бұрын

Very useful

@ebrimaceesay 3 жыл бұрын

thank you it is very helpful.

@SeleTraining 3 жыл бұрын

Glad to hear that!

@m2badri 5 жыл бұрын

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!

@SeleTraining 5 жыл бұрын

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.

@nicodasm 4 жыл бұрын

thanks!!

@thisisadebrown 5 жыл бұрын

Love it

@jodicamps5693 4 жыл бұрын

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

@SeleTraining 4 жыл бұрын

You can do it!

@jodicamps5693 4 жыл бұрын

Sele Training do you have any certification prep videos?

@SeleTraining 4 жыл бұрын

@@jodicamps5693 No. You can see all my videos from my KZfaq channel page. There are several Excel videos but not specific to certification.

@shafiqislam6994 3 жыл бұрын

excellent

@barryrunner 6 жыл бұрын

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.

@SeleTraining 6 жыл бұрын

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".

@warrenhall1750 5 жыл бұрын

#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.

@SeleTraining 5 жыл бұрын

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.

@wandagreer9144 2 жыл бұрын

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.

@SeleTraining 2 жыл бұрын

Make sure to check out my 50 Ultimate Excel Tips and Tricks video. That one has more recent features.

@faisaldandoti8305 4 жыл бұрын

That was really helpful....

@SeleTraining 4 жыл бұрын

Glad it was helpful!

@richardbrook1386 5 жыл бұрын

I can't thank u enough.

@SuperDarekR 5 жыл бұрын

Wowwww 🤩

@jayaxe79 6 жыл бұрын

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!

@SeleTraining 6 жыл бұрын

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.

@skirolf 4 жыл бұрын

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.

@SeleTraining 4 жыл бұрын

I don't have a spreadsheet for this one but I do have a reference guide with many Excel functions: kzfaq.info/get/bejne/brZkYM2A1L-mmqM.html. You can also use the links in the description of the video to go back to each tip.

@aaqibamjaid8447 5 жыл бұрын

Brilliant videos, please can you explain macros? Also do you have any videos on Mcsft Acess?

@SeleTraining 5 жыл бұрын

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.

@zeus79866 5 жыл бұрын

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 :-)

@lme918 5 жыл бұрын

Or just use Flash fill (crlt+E)

@chandrasekhar4207 5 жыл бұрын

These tips are helpful for excel 2007 also

@SeleTraining 5 жыл бұрын

Excellent!

@Tesnobay 6 жыл бұрын

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?

@SeleTraining 6 жыл бұрын

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.

@Marzchello 5 жыл бұрын

Tesnobay - Yes. Text to columns is a better way of breaking up text. The delimited option is super helpful.

@raygivler 4 жыл бұрын

Testing whether two tables are identical? Copy and paste the second after the first, remove duplicates. If you had N rows, then went to 2N, and returned to N, then they were identical. 1 duplicate was removed for every 1 in the original.

@SeleTraining 4 жыл бұрын

Good idea.

@rina1592 5 жыл бұрын

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.

@SeleTraining 5 жыл бұрын

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.

@jeffbrown6243 5 жыл бұрын

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.

@cambike 5 жыл бұрын

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

@SeleTraining 5 жыл бұрын

Great tip!