20 Essential Excel Functions with Downloadable Reference Guide
Vložit
- čas přidán 23. 07. 2024
- Use these 20 essential Excel functions to do 95% of your work in Excel. I explain all 20 with examples of each function. Please follow along with the free downloadable reference guide. You are welcome and encouraged to copy and distribute this guide.
Download the free reference guide EssentialFunctions.xlsx at www.seletraining.com
img1.wsimg.com/blobby/go/b8e6...
Support me with your Amazon purchases, click here: amzn.to/2Kxp533
Contents 0:00
1. SUM 1:00
2. AVERAGE 2:03
3. ROUND 2:46
4. IF 3:56
5. COUNTIF 5:19
6. SUMIF 7:08
7. RANK 8:47
8. TODAY 10:58
9. DATE 12:15
10. VLOOKUP 13:24
11. FIND 15:24
12. CONCATENATE 17:48
13. TRIM 19:13
14. LEN 19:43
15. LEFT & RIGHT 20:20
16. MID 21:00
17. UPPER & LOWER 22:02
18. MIN & MAX 22:43
19. AND & OR 23:50
20. IFERROR 25:26
#seletraining #excel #functions - Věda a technologie
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!
Amazing explanations and so simple to understand! thank you!!
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.
Very helpful review of functions I rarely use. Thank you for putting this out there. Very easy to understand and use.
Really like your Excel video's !!, keep up the great work
Fantastic! Thank you very much for the video! Simple, easy to follow!
Love your videos! There are a lot other training videos on CZcams 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!
What every body being needed is this lesson
Thanks
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: czcams.com/video/cnmPSlajJVM/video.html
Thoroughly enjoyed your videos. Thank You.
Great tutorial, thank you.
Very helpful, thanks a ton!
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!
Thank you
LOVE from Egypt.
Thanks, it was great help for the new users.
Excellent information. Thanks so much!
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!
Very good tutorial. Thank you a lot
great video, learned so much
Simple and very helpful tools. Thanks a lot.
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.
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.
Very comprehensive. Thanks buddy
Thanks for your effort.
This is amazing with the download. Thank you so much!
Don't miss the advanced video: czcams.com/video/cnmPSlajJVM/video.html
Very good explanation, keep it up!!
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?!?
Easy to follow along. Great post. Thanks!
Thank you very much.
very power full explanation and keep it
up
Thank you !
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
Awesome, thanks.
Thank you for this informative video.
Don’t forget to download the guide and share it.
Thank you for the excellent explanation!
You are welcome!
Thank you very much ")
Thank you so much. more power to you sir.
Thank a lot.
Thank you very much it really helpful
thanks for free reference guide this is very helpful :)
Invaluable.
Good training
Really great tutorial. Thank you very much for sharing it.
Glad it was helpful!
Than you muchly for the videos. Well explained in a voice made for CZcams ! And the background music is great too - not too loud and annoying.
Thanks!
Thanks.
thankyou !
thank you sr
your video is really good, your voice and the way you explained added value to your video
Thank you so much 🙂
helpful basics
Useful training video. Thanks.
Glad it was helpful!
Great my teacher
Thanks!
Welcome!
awesome
wow thank you for sharing sir
My pleasure
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!
Hi, please, what do you use to make your videos and the screen recordings ?:)
I use Camtasia
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.
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.
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.
how to have few XL files on one sheet ( not xl sheets )
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.
That is Amazing THANKS 😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍💚💚🤍🤍💛💛🧡🧡🥰🥰👍👍✌✌❤❤
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.
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.
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.
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.
where is the download, I cant find it
Go to seletraining.com and scroll down to the download section.
i dont see a link
Go to www.seletraining.com and click on the file download for EssentialFunctions
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
=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: czcams.com/video/8P4-jOoYBjo/video.html
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
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 download according to your direct link
Try going to seletraining.com and click on the file download section.
can't download，too
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.
Thank you!