As a person who does not know much about Excel I found the examples of the 20 essential EXCEL functions very easy to understand please make more tutorials like this as it helps people with what they can do in Excel.
Thank you for your excellent videos and teaching skills. I just discovered you yesterday and learned several new skills. There is the area concerning Maps that has me intrigued because I believe that it can be a very useful tool in my astrometeorological studies. I'd like to learn how to set this up properly and then load it up with info. I finished a course in Microsoft Access last year and am now 75% through Excel. Both of these programs are very important to me for my astrometeorological studies. Thank you in advance.
thank you so much Sir for sharing your knowledge and experience for free. for me that has almost nothing knowledge of excel it's a great help and a milestone leap. salute to you Sir! more power!
The link in your description sections seems to not be working. Found your website in reply to a comment below and was able to download it that way. You are an excellent teacher - please keep up the good work!
Love your videos! There are a lot other training videos on RUclips and I was attracted by your voice in the first place (haha). I'm making templates to automate files and I just picked up some functions in this video that are super useful. I had a question about how to start a new line within a cell and formula using CONCATENATE but I found the answer in another video - using char(10) between strings. Thanks for the videos!
You have a great presentation, I have watched MANY Excel videos to learn what I can about Excel over the years and have found your videos easy to follow. They have a logical and clear progression, your descriptions and explanation of functions are clear and easy to understand.
Thanks for the great review and examples of the 20 essential EXCEL functions. Always enjoy your videos.. learn something new every time. Keep them coming. Thumbs up!
Were you able to view all the different sheets associated with each function? I've only been able to see/view/download the first sheet. Am I doing something wrong? Thanks.
Your tutorials are fantastic. I was able to download the first excel work sheet, but i am unable to see/find the balance of the sheets beyond the sum function sheet. Thank you.
@@SeleTraining Thank you for your quick response. That's what I was assuming. I could see that in your worksheets. However, there were no separate sheets at the bottom of what i downloaded. I must be doing something wrong I guess.
I thank you for an outstanding lesson. I’m one of your blind biewers, and was wondering if there’s somewhere that I can get the same info with the formulas spoken by character? Thanks again, keep up the outstanding work.
Sele Training When I said “by character”, being that I am blind I cann’t see what you are typing. So I need to know exacctly what you are putting into the formula. Such as words, parentheses,commas and such.
@@cdhankerson7586That's an interesting challenge. For this video I do have a downloadable spreadsheet. I think it may be possible to download the spreadsheet and then setup your computer narrator in accessibility options. That may read aloud the formulas in the Excel file. The spreadsheet follows the video and all of the functions I describe are in the spreadsheet so if can read the formula in the cell it should give you some info. I'm not sure how that works so I don't know if it will accomplish your needs or not. The download file is at seletraining.com but I can send you the direct link in an email if that helps.
I wanted to add something quite useful. You are, for example, writing a list of sales and want to SUM the entire column of it. You select the range of cells and then, SUM. but later yoy realize that the result is wrong. Well, here is a little tip, if you putted in one cel " $10 (in 1 dolar bills)" you just maked it a "text cel" and now the SUM function won't count as something he needs to SUM, and the result, then, will be wrong
Hi, I'm a big follower of your channel. Yesterday if purchased tow products from your website. I realized that I really need only one product of that objective. Can I replace one of the two products with another product? Regard, Noor
Thanks for following. I don’t actually sell any products but I do have links to products I recommend on Amazon. If you made a purchase from Amazon they will allow you to cancel orders or return them. Go to your Amazon account and request a return.
Go to www.seletraining.com and scroll down to the file download section. You will see the ExcelEssentials and ExcelAdvanced spreadsheets in the list and can click to download them.
@@anmeetkaur1109 It's possible you have a keyboard or software that is forcing the F4 key to work differently. You can try Fn-F4 to confirm but it is a built in key in Excel so you don't have to turn it on.
The parameters are SUMIF(range,criteria,sum_range). Not sure what you are trying to accomplish but the criteria must be a value to compare for the range. For example ">10" is a criteria that would sum all values in the range that are greater than 10. You appear to be comparing an entire range for the criteria. Check out SUMIF in this video: ruclips.net/video/8P4-jOoYBjo/видео.html
Go to seletraining.com and scroll to download files. EssentialFunctions.xlsx will be listed for download. The direct link is img1.wsimg.com/blobby/go/b8e6247a-bac3-4465-bcf8-100af056c56f/downloads/EssentialFunctions.xlsx?ver=1560813826006.
Might be a timing issue on the website. You should be able to get it direct at img1.wsimg.com/blobby/go/b8e6247a-bac3-4465-bcf8-100af056c56f/downloads/EssentialFunctions.xlsx?ver=1560813826006.
your way of explaining the concepts is awesome. Within no time I am prepared for my interview
As a person who does not know much about Excel I found the examples of the 20 essential EXCEL functions very easy to understand please make more tutorials like this as it helps people with what they can do in Excel.
Great, Thanks! I thought having a reference like this would be very helpful to people. I am planning to create another follow up to this one soon.
I have searched for a long time on how to change sentence case. Thank you for the upper, lower and proper functions! Amazing!
Thanks. I added a new link in the description.
Good job especially with the "Notes" you wrote in each part. Thanks!
Thank you for your excellent videos and teaching skills. I just discovered you yesterday and learned several new skills. There is the area concerning Maps that has me intrigued because I believe that it can be a very useful tool in my astrometeorological studies. I'd like to learn how to set this up properly and then load it up with info. I finished a course in Microsoft Access last year and am now 75% through Excel. Both of these programs are very important to me for my astrometeorological studies. Thank you in advance.
your video is really good, your voice and the way you explained added value to your video
Thank you so much 🙂
Easy to follow along. Great post. Thanks!
thank you so much Sir for sharing your knowledge and experience for free. for me that has almost nothing knowledge of excel it's a great help and a milestone leap. salute to you Sir! more power!
thanks for free reference guide this is very helpful :)
Simple and very helpful tools. Thanks a lot.
The link in your description sections seems to not be working. Found your website in reply to a comment below and was able to download it that way. You are an excellent teacher - please keep up the good work!
Thank you so much for this tutorial. I have been looking for a quick reference to excel and a download and this is it.
Excellent. Don't miss out on the advanced functions video too: ruclips.net/video/cnmPSlajJVM/видео.html
Very helpful review of functions I rarely use. Thank you for putting this out there. Very easy to understand and use.
What every body being needed is this lesson
Thanks
Very comprehensive. Thanks buddy
Thank you for the excellent explanation!
You are welcome!
Great my teacher
Thoroughly enjoyed your videos. Thank You.
Thank you very much it really helpful
Really great tutorial. Thank you very much for sharing it.
Glad it was helpful!
Thank you!
Useful training video. Thanks.
Glad it was helpful!
Love your videos! There are a lot other training videos on RUclips and I was attracted by your voice in the first place (haha). I'm making templates to automate files and I just picked up some functions in this video that are super useful.
I had a question about how to start a new line within a cell and formula using CONCATENATE but I found the answer in another video - using char(10) between strings.
Thanks for the videos!
Fantastic! Thank you very much for the video! Simple, easy to follow!
Thank you so much. more power to you sir.
Amazing explanations and so simple to understand! thank you!!
Than you muchly for the videos. Well explained in a voice made for RUclips ! And the background music is great too - not too loud and annoying.
Thanks!
You have a great presentation, I have watched MANY Excel videos to learn what I can about Excel over the years and have found your videos easy to follow. They have a logical and clear progression, your descriptions and explanation of functions are clear and easy to understand.
Thanks
Thanks for the great review and examples of the 20 essential EXCEL functions. Always enjoy your videos.. learn something new every time. Keep them coming. Thumbs up!
helpful basics
Thank you
LOVE from Egypt.
Thanks, it was great help for the new users.
wow thank you for sharing sir
My pleasure
This is amazing with the download. Thank you so much!
Don't miss the advanced video: ruclips.net/video/cnmPSlajJVM/видео.html
Excellent information. Thanks so much!
Awesome, thanks.
Really like your Excel video's !!, keep up the great work
Most excellent sir! The downloadable spreadsheet with links to Office Help and the video are great ideas and very useful.
Little Known Fact where is the reference guide?!?
Thank you for this informative video.
Don’t forget to download the guide and share it.
thank you sr
Good training
Great tutorial, thank you.
Very good explanation, keep it up!!
Very good tutorial. Thank you a lot
I like the excel spreadsheet provided with this tutorial. Thank you.
Were you able to view all the different sheets associated with each function? I've only been able to see/view/download the first sheet. Am I doing something wrong? Thanks.
great video, learned so much
Thanks for your effort.
thankyou !
Thanks!
Welcome!
very power full explanation and keep it
up
Very helpful, thanks a ton!
awesome
Invaluable.
Thanks.
Thank you very much ")
Your tutorials are fantastic. I was able to download the first excel work sheet, but i am unable to see/find the balance of the sheets beyond the sum function sheet. Thank you.
Each function is a separate sheet that you should be able to click on at the bottom of the spreadsheet.
@@SeleTraining
Thank you for your quick response. That's what I was assuming. I could see that in your worksheets. However, there were no separate sheets at the bottom of what i downloaded. I must be doing something wrong I guess.
Thank a lot.
THANK YOU SO MUCH.
But can you please also upload the file with your youtube video.
This one is available from the Seletraining.com website. There is a link in the description of the video.
I thank you for an outstanding lesson. I’m one of your blind biewers, and was wondering if there’s somewhere that I can get the same info with the formulas spoken by character? Thanks again, keep up the outstanding work.
By character?
Sele Training When I said “by character”, being that I am blind I cann’t see what you are typing. So I need to know exacctly what you are putting into the formula. Such as words, parentheses,commas and such.
@@cdhankerson7586That's an interesting challenge. For this video I do have a downloadable spreadsheet. I think it may be possible to download the spreadsheet and then setup your computer narrator in accessibility options. That may read aloud the formulas in the Excel file. The spreadsheet follows the video and all of the functions I describe are in the spreadsheet so if can read the formula in the cell it should give you some info. I'm not sure how that works so I don't know if it will accomplish your needs or not. The download file is at seletraining.com but I can send you the direct link in an email if that helps.
Hi, please, what do you use to make your videos and the screen recordings ?:)
I use Camtasia
I wanted to add something quite useful.
You are, for example, writing a list of sales and want to SUM the entire column of it. You select the range of cells and then, SUM. but later yoy realize that the result is wrong. Well, here is a little tip, if you putted in one cel " $10 (in 1 dolar bills)" you just maked it a "text cel" and now the SUM function won't count as something he needs to SUM, and the result, then, will be wrong
Yes the sim functions skips cells that are not numbers so you have to be careful with entries.
Hi,
I'm a big follower of your channel.
Yesterday if purchased tow products from your website. I realized that I really need only one product of that objective. Can I replace one of the two products with another product?
Regard,
Noor
Thanks for following. I don’t actually sell any products but I do have links to products I recommend on Amazon. If you made a purchase from Amazon they will allow you to cancel orders or return them. Go to your Amazon account and request a return.
That is Amazing THANKS 😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍💚💚🤍🤍💛💛🧡🧡🥰🥰👍👍✌✌❤❤
Please, how can I find the downloadable reference guide for this video?
Go to www.seletraining.com and scroll down to the file download section. You will see the ExcelEssentials and ExcelAdvanced spreadsheets in the list and can click to download them.
Can you share the spreadsheet
There is no spreadsheet for this video. The sample data is very minimal. I do have other spreadsheet samples on seletraining.com in the file section.
@@SeleTraining this was great help thank you
I am unable to use absolute reference by hitting f4. what else
Make sure you click on the text in the cell and then click F4
Tried. Didn't work. Do we have to initialise f4 key
@@anmeetkaur1109 It's possible you have a keyboard or software that is forcing the F4 key to work differently. You can try Fn-F4 to confirm but it is a built in key in Excel so you don't have to turn it on.
Thanks a lot ... it helped
How do i download the reference guide?
Go to seletraining.com and look in the file download section. A link is also listed in the description of the video.
=SUMIF($P$7:$Z$7;G13;$P$9:$Z$9) please i need to correct this formula if possible
The parameters are SUMIF(range,criteria,sum_range). Not sure what you are trying to accomplish but the criteria must be a value to compare for the range. For example ">10" is a criteria that would sum all values in the range that are greater than 10. You appear to be comparing an entire range for the criteria. Check out SUMIF in this video: ruclips.net/video/8P4-jOoYBjo/видео.html
How can I download the reference guide for this training?
Go to www.seletraining.com and scroll down to the file download section. EssentialFunctions.xlsx is listed there.
@@SeleTraining thank you. I went to your website and found it/them. Once again, thank you.
how to have few XL files on one sheet ( not xl sheets )
where is the download, I cant find it
Go to seletraining.com and scroll down to the download section.
I couldnt download according to your direct link
Try going to seletraining.com and click on the file download section.
can't download,too
Where is the downloadable guide?
Go to seletraining.com and scroll to download files. EssentialFunctions.xlsx will be listed for download. The direct link is img1.wsimg.com/blobby/go/b8e6247a-bac3-4465-bcf8-100af056c56f/downloads/EssentialFunctions.xlsx?ver=1560813826006.
www.seletraining.com
@@SeleTrainingThank You! My job blocks your website because it isn't classified. So, I couldn't get until you put in the direct link.
I couldnt find guide to download
Go to www.seletraining.com and scroll down to the file downloads. You will see the EssentialFunctions.xlsx file for download.
Direct link is img1.wsimg.com/blobby/go/b8e6247a-bac3-4465-bcf8-100af056c56f/downloads/EssentialFunctions.xlsx?ver=1560813826006
i dont see a link
Go to www.seletraining.com and click on the file download for EssentialFunctions
i can not download that sheet can u me that link ❗❗❗
Go to www.seletraining.com and scroll down to the file downloads. You will see the EssentialFunctions.xlsx file for download.
@@SeleTraining It says files coming soon. So no file at this time
Might be a timing issue on the website. You should be able to get it direct at img1.wsimg.com/blobby/go/b8e6247a-bac3-4465-bcf8-100af056c56f/downloads/EssentialFunctions.xlsx?ver=1560813826006.
Thank you !
Thank you very much.