How to use Formulas and Functions in Microsoft Excel

In this video tutorial, I will show you how to use formulas and functions in Microsoft Excel. I will start with basic math formulas in Excel and show you some of the very popular and powerful functions. Use the timestamps below to help you navigate through this video.
Download the practice file here. You will need to go to file and save as: leveragingdigitalinc-my.share...
My playlist to all of my Microsoft Excel Tutorials: • Excel for Beginners: E...
VLOOKUP Tutorial: • Vlookup Function in Ex...
0:00 Intro
0:49 Basic math formulas
3:20 Starting with the SUM Function in Excel (with shortcuts)
5:47 The COUNT function
6:29 Take a look at the status bar in Excel
8:10 AVERAGE, MEDIAN and MODE functions
10:05 MIN and MAX functions in Microsoft Excel
10:54 Functions and formulas with Date and time in Excel
14:11 Using formulas to combine columns
16:05 If statements in Excel
19:26 How VLOOKUP works
21:34 Conditional functions (SUMIF, SUMIFS, COUNTIF, etc.)
24:33 How to use the function wizard
Microsoft Excel for Beginners - Level 1: • Microsoft Excel Tutori...
Microsoft Excel for Beginners - Level 2: • Microsoft Excel Tutori...
Microsoft Excel for Beginners - Level 3: • Microsoft Excel Tutori...

Пікірлер: 165

  • @darrelynguinaling9547
    @darrelynguinaling95473 жыл бұрын

    I just finished watching tutorials 1-4 and you really did a great job making it so easy to follow through. Thank you, sir!

  • @TeachersTech

    @TeachersTech

    3 жыл бұрын

    You’re welcome!

  • @beckymurayama955

    @beckymurayama955

    2 жыл бұрын

    @@TeachersTech You really are easy to follow and you have a very nice demenor.

  • @sibusiso_ashley

    @sibusiso_ashley

    Жыл бұрын

    Welele, inganekwane

  • @wandagreer9144
    @wandagreer91442 жыл бұрын

    I wish I would have had you as a college professor! You are an excellent teacher. Thank you.

  • @ahmednavivwala1707

    @ahmednavivwala1707

    Жыл бұрын

    0:21

  • @Giul_Ranz
    @Giul_Ranz2 жыл бұрын

    I am starting to really like Excel and never thought this would happen! I think in the past I was just fearful because I did a short course many years ago, and then never had the opportunity to use Excel much in my job, however a lot of EA jobs now require a very good understanding of excel. I just used SUMIF in a table and it worked! You are such a fantastic teacher. THANK YOU AGAIN!!! :)

  • @MM-uw4lc
    @MM-uw4lc3 жыл бұрын

    Excellent professor, quick and simple and easy to understand. Thank U!

  • @michaelren9771
    @michaelren97712 жыл бұрын

    I liked your tutorial because it was concise and to the point, not too much self-promotion, which goes on too much on youtube nowadays.

  • @Da-vinceArt3901
    @Da-vinceArt39013 жыл бұрын

    Jamie i've been going through your videos on teachers tech, n believe me you ,you and the most talented and the best teacher in the whole world for me, your videos are so clear and crisp, so much clarity of information , thank you so very much pls do keep up the good work of uploading videos and education people thanks a million, god speed and god bless you.

  • @TeachersTech

    @TeachersTech

    3 жыл бұрын

    Wow, thank you!

  • @user-it4im4wk8q
    @user-it4im4wk8q8 ай бұрын

    Thank you! This was so helpful!!! I was scouring the internet trying to get the answer to this, and in just a few minutes you had shown me exactly what I needed! :)

  • @toeknee6548
    @toeknee65482 жыл бұрын

    Thank you for working hard to create this simplified tutorial videos. 💜 I couldnt thank you enough 🙏

  • @debbiechigozie5349
    @debbiechigozie5349 Жыл бұрын

    Didn't know learning excel would be this easy. Thank you so much.

  • @FrancisSneh-qf8gt
    @FrancisSneh-qf8gt10 ай бұрын

    Jamie,you are doing a great job. The truth is you have brought the school in my home. Congratulations!

  • @annelinnane7949
    @annelinnane79492 жыл бұрын

    Hi Jamie, I just want to say thank you for all your tutorial. I have learnt so much and growing in confidence using Microsoft 365

  • @kalhussain787
    @kalhussain7872 жыл бұрын

    Top class videos, i've watched all 5 of the beginners one's and really reminded myself of the basics!. Will be moving onto the pivot table ones now. Great content and sub'd!

  • @TeachersTech

    @TeachersTech

    2 жыл бұрын

    Awesome, thank you!

  • @jamesblood6882
    @jamesblood6882 Жыл бұрын

    THANK YOU SO MUCH! You are truly educating this old man. You are a wonderful teacher.

  • @limlilian6650
    @limlilian66505 ай бұрын

    Thank you so much sir,I was supposed to go for an interview and had to have an idea on Excel,I watched this video and went and was able to do my interview.🙏

  • @jimcazador6057
    @jimcazador60573 жыл бұрын

    I am doing an ECDL at the moment, these videos are much better than the software provided, These videos really help thanks a million.

  • @bongnwimankaa6090
    @bongnwimankaa60902 жыл бұрын

    Wow I'm short of words I just finished watching from lecture 1-4 and I most say I learned alot and will keep implementing it may God bless you and replenish u

  • @jillkraushaar8804
    @jillkraushaar88046 ай бұрын

    This is THE BEST tutorial on excel functions & formulas I've ever watched! Sooooooooo helpful! Thanks SO much! :)

  • @TeachersTech

    @TeachersTech

    6 ай бұрын

    You're very welcome!

  • @cinamingrl
    @cinamingrl2 жыл бұрын

    Wow I watch these at work during downtime. I really learned a lot so far, thanks very much!

  • @yulia6773
    @yulia67732 жыл бұрын

    That's an amazing tutorials, so helpful!!!Thank you very much!

  • @boitumelomaruping7725
    @boitumelomaruping77253 жыл бұрын

    Love your tutorials. Simple and effective

  • @TeachersTech

    @TeachersTech

    3 жыл бұрын

    Happy to hear that!

  • @brosiff6424
    @brosiff64242 жыл бұрын

    Thank you so much! Being able to follow with your spreadsheets is awesome!

  • @hsu__moments
    @hsu__moments2 жыл бұрын

    I do like your tutorials. Thank you.

  • @geetapandey5325
    @geetapandey5325 Жыл бұрын

    I finished all 5 of beginers. Looking forward to your video on adavnced excel. You are a great teacher

  • @wendyc3175
    @wendyc3175 Жыл бұрын

    Thank you so much. That SUMIF function is wonderful for what I do at work and so time saving, Before I'd data sort based on the criteria then add each separately. I'm really grateful to learn this.

  • @abnerdayrit1998
    @abnerdayrit1998 Жыл бұрын

    Thank you for these tips! You're amazing teacher!

  • @awaywhiskers2
    @awaywhiskers26 күн бұрын

    Great teacher

  • @ShivaKumar-cq7hm
    @ShivaKumar-cq7hm Жыл бұрын

    Thanks for lovely tutorials Your videos are helping me alot it was beneficial for me ..... blessed to have a sir like you .

  • @TeachersTech

    @TeachersTech

    Жыл бұрын

    So nice of you

  • @janreyponceolano7460
    @janreyponceolano74602 жыл бұрын

    Thankyou so much!!

  • @donnaleegoodwin6665
    @donnaleegoodwin66653 жыл бұрын

    Appreciate your time. God bless you.

  • @mohansahareti4678
    @mohansahareti4678 Жыл бұрын

    Loving all your videos! This is helping me tremendously thank you

  • @arozeisarozie
    @arozeisarozie3 жыл бұрын

    I so appreciate the timestamps!

  • @yvonnemunyan4552
    @yvonnemunyan45522 жыл бұрын

    Thank you!! Your wonderful Teacher.

  • @georgejohnson8674
    @georgejohnson8674 Жыл бұрын

    I'm taking over a construction business from my father, I worked for him but didn't have the time for all of the management side. Thank you so much for explaining it so easily that I could understand in less than an hour... It's helped the budgeting side of things tremendously

  • @Touristt

    @Touristt

    Жыл бұрын

    or you can let me be your cheap manager 😭[and i might gain experience and learn a thing or two]

  • @dreasway7918
    @dreasway79183 жыл бұрын

    I watch all of the ads because I appreciate the free information. Thank you

  • @aykutyldz1538
    @aykutyldz15383 жыл бұрын

    this is one of the most awesome tutorials I have ever seen

  • @Rose-fb3qo
    @Rose-fb3qo9 ай бұрын

    Dude .... DUDE .... YOU ARE A DAMN LEGEND!!!!!! ❤❤❤❤❤

  • @gideonmuwanguzi3904
    @gideonmuwanguzi3904 Жыл бұрын

    This is so helpful and really simplifies MS.Excel.

  • @eurekamartinez3712
    @eurekamartinez37125 ай бұрын

    Thank you so much for how easy you make this for me😊

  • @simmagfm7536
    @simmagfm75362 жыл бұрын

    Thankyou so much you make me confident to use excell many blessings to you

  • @lapolitica6590
    @lapolitica6590 Жыл бұрын

    Thank you so much for this course!

  • @englishlanguagelearning9672
    @englishlanguagelearning96723 жыл бұрын

    Very clever and concise presentation

  • @koffiemaker416
    @koffiemaker416 Жыл бұрын

    Thanks to being my rain drop again✊🤝

  • @an.f9197
    @an.f9197 Жыл бұрын

    Jamie you are the G.O.A.T thank you so much. Would like to learn more about pivot tables

  • @TeachersTech

    @TeachersTech

    Жыл бұрын

    Here you go! kzread.info/dash/bejne/gqWX3Kqno7GslLA.html

  • @yordanosbayru6288
    @yordanosbayru62882 жыл бұрын

    Thank you so much it helps me a lot 🙏

  • @LittleStarsDH
    @LittleStarsDH Жыл бұрын

    You are an excellent teacher 👏

  • @jamesjohnson4273
    @jamesjohnson42732 жыл бұрын

    Until recently I was indifferent towards learning Excel. But because the last two jobs I worked for required a good Excel background I'm now prioritizing myself towards learning as much as I can regarding Excel (along with Word, Outlook and Power Point).

  • @marfinjoymisa2873
    @marfinjoymisa28733 жыл бұрын

    Thank you for your videos! Very helpful. :)

  • @TeachersTech

    @TeachersTech

    3 жыл бұрын

    You're very welcome!

  • @romanusoriji5261
    @romanusoriji52612 жыл бұрын

    Thanks for your great job, I appreciate.

  • @frankmunro1303
    @frankmunro13035 ай бұрын

    Thank you, well explained.

  • @user-nj5uq6hv7f
    @user-nj5uq6hv7f8 ай бұрын

    Great Job,

  • @abdoulayendoyediene5688
    @abdoulayendoyediene5688 Жыл бұрын

    Thanks again.

  • @shoppersdream
    @shoppersdream4 ай бұрын

    Nice, thanks!

  • @senabulyatonny9235
    @senabulyatonny9235 Жыл бұрын

    Thank you teacher

  • @mohammed96011
    @mohammed96011 Жыл бұрын

    Love the vids You're an amazing teacher

  • @TeachersTech

    @TeachersTech

    Жыл бұрын

    I appreciate that!

  • @Mahdul
    @Mahdul2 жыл бұрын

    great lesson !

  • @rebeccadavis220
    @rebeccadavis2203 жыл бұрын

    Thank you!!

  • @lexophile9667
    @lexophile96672 жыл бұрын

    Thanks for all these vids. It took me from the first tutorial until now to realize this, but you look like Michael Keaton. More Birdman than Batman but does anyone else see it? lol

  • @jaqsmith1289
    @jaqsmith12893 жыл бұрын

    Thanks a lot!

  • @eliasnalau5509
    @eliasnalau5509 Жыл бұрын

    Powerful. Thanks.

  • @elizabethosborne3606
    @elizabethosborne36062 жыл бұрын

    Thank you. =)

  • @maymanalo2540
    @maymanalo25402 жыл бұрын

    You are very helpful 😊

  • @camelliaoeillet1906
    @camelliaoeillet19062 жыл бұрын

    Your way is straightforward and I like it so much. Not related but can you make a video about tips or easy steps to do in order to how clean your computer and make it quicker.

  • @aloneogist1440
    @aloneogist1440 Жыл бұрын

    thank you sir , you did a great job

  • @SouthDallas357
    @SouthDallas35711 ай бұрын

    You’re amazing!!

  • @delmyjaghab609
    @delmyjaghab609 Жыл бұрын

    Best tutorials!!!

  • @anthonymejia631
    @anthonymejia6313 жыл бұрын

    You're awesome!!!

  • @smfahim3078
    @smfahim30782 жыл бұрын

    Very helpful. thank you sir.

  • @AtheneHolder
    @AtheneHolder3 жыл бұрын

    I actually needed this, job interview tomorrow and I'm giving myself a crash course... 🤞

  • @TeachersTech

    @TeachersTech

    3 жыл бұрын

    I'm glad I could help!

  • @ste_drag206

    @ste_drag206

    3 жыл бұрын

    How did it go??

  • @vmhitz5969

    @vmhitz5969

    2 жыл бұрын

    @@ste_drag206 yay how did it go pls

  • @macanocious3000

    @macanocious3000

    2 жыл бұрын

    Was so mad he didn't get the job - rammed car into tree..... 💀

  • @-ellol4198
    @-ellol4198 Жыл бұрын

    Thanks for that great tutorial :D

  • @yulia6773
    @yulia67732 жыл бұрын

    Thanks!

  • @doyouknow4530
    @doyouknow45302 жыл бұрын

    Please do more Excel videos..! U r awesome

  • @kathyroberts7777
    @kathyroberts77773 жыл бұрын

    Thank you for the information, I have just watched all four of your first videos plus this one. I need constant refreshing on how to use Excel because I keep forgetting the simplest things. I work with pretty complex spreadsheets that upload thousands of lines of information that have been already set up by others. I am hoping to just get some insight as to how they set them up and if I can do the functions myself. Listening to what you have reviewed, I realize I know most of the basics, but appreciate your overview. I am not sure whether to use VLookups, Pivot Tables or other formulas to achieve my end result. Currently I have a spreadsheet, where there is a listing of numbers and words that I need to relate to a separate worksheet but these are constantly changing. Which worksheet should I use to make the changes, the main one where the info is updated or the smaller ones that are broken down pieces of information from the main one. Just getting a bit lost, it is probably an easy solution, I am not thinking clearly.

  • @IQMIK11
    @IQMIK112 жыл бұрын

    Thank you Sir.. 👍

  • @Blasphemer_Cosmos
    @Blasphemer_Cosmos Жыл бұрын

    On the next one 😁👍

  • @kashyapmishra6205
    @kashyapmishra62052 жыл бұрын

    Thank you

  • @mickbryan7716
    @mickbryan77163 жыл бұрын

    I reckon your the best

  • @mymusicforrelaxing9404
    @mymusicforrelaxing94043 жыл бұрын

    nice video, so helpful thankful sir

  • @TeachersTech

    @TeachersTech

    3 жыл бұрын

    Most welcome

  • @jenny-ef1gf
    @jenny-ef1gf2 жыл бұрын

    ur the best

  • @user-bj6ux9cc5r
    @user-bj6ux9cc5r2 жыл бұрын

    Hi Jamie nice work Just finished watching excel tutorials for beginners and was wondering if there are more higher level excel video tutorial intermediate advanced etc..

  • @TeachersTech

    @TeachersTech

    2 жыл бұрын

    Working on putting out one of these very soon.

  • @nakasliviey2113
    @nakasliviey21132 жыл бұрын

    i really want to know more but thanx for your services

  • @aydanwildfang5314
    @aydanwildfang53143 жыл бұрын

    Please do more videos!

  • @TeachersTech

    @TeachersTech

    3 жыл бұрын

    You bet!

  • @cmee2119
    @cmee21192 жыл бұрын

    Hello and thank you Sir for these videos, they're of great help. I have a question though and hope you can help. I'm practicing the =if.... using a set of numbers and the number that I'm expecting to show true is showing false which I'd expect for the other numbers that aren't the one used in the formula. Is there a reason for this? Thanks in advance for any assistance you can offer.

  • @Gaaaaaaaaaaad
    @Gaaaaaaaaaaad Жыл бұрын

    Thanks

  • @mauriciocastro4609
    @mauriciocastro4609 Жыл бұрын

    I’ve been watching several of your very helpful videos. I’m wondering if you have a video that shows how to add # of hours, for example 10:09am to 10:00pm, a formula to calculate 12 hours. Thank you

  • @jonithenjackson5521
    @jonithenjackson55213 жыл бұрын

    Thank u

  • @edwinkingsbury5372
    @edwinkingsbury5372 Жыл бұрын

    You da man

  • @Rurkiworld
    @Rurkiworld3 жыл бұрын

    Hello there. Hope that you are keeing safe in these torrid times. I have a request. Could you do an intruction video on how to keep a students online attendence sheet in Excell? Thanks

  • @atreusspartan9059
    @atreusspartan9059 Жыл бұрын

    Thankyou

  • @javaidiqbal8467
    @javaidiqbal846713 күн бұрын

    Best

  • @ezeuba001
    @ezeuba0013 жыл бұрын

    Nice one

  • @TeachersTech

    @TeachersTech

    3 жыл бұрын

    Thanks!

  • @AlexFoster029
    @AlexFoster0293 жыл бұрын

    If I want a a row of names and a row of days that ultimately calculate for a week after whether they can work or not how can I do this. For example happy potter worked Friday and Sunday so I need it to automatically black it out for the week later. But not for any other weeks?

  • @Ghostbustin
    @Ghostbustin2 жыл бұрын

    What trip I am watching this video on November 17th! if it is actually the day of your bday happy bday!

  • @isaacjimmy829
    @isaacjimmy829 Жыл бұрын

    I like your view and i wish you could help me with a problem.

  • @bobblack4048
    @bobblack40482 жыл бұрын

    Hi, I've just discovered your you tube page. I find it very interesting and helpful. Can I ask, do you have any video's to create a spreadsheet for a Forex Trading Journal.

  • @victorvonderkrausse5492
    @victorvonderkrausse54929 ай бұрын

    HI, I am encountering a problem after I am using " sign in excel and space or other character is showing me teh $ sign , it is very annoying in formulas, i dont know how to get rid of it !

  • @buddyusa1
    @buddyusa12 жыл бұрын

    Can you explain how to use =mid() to return the absolute value of the specific place holder. I can get it to work for text and I can get it to work for numbers, but I can't get it to work for both at the same time. Example. SR5BQ2MT. With =mid() it will return all the text but not the number. With =value(mid)), it will return the numbers but not the text. I would like it to do both so as the character string that people enter changes the data will be updated. Thanks

  • @elycamacho8563
    @elycamacho85632 жыл бұрын

    Can you use IF statements on dates to determine if for example If a bill is past due? Using the current date?

  • @drejprogress
    @drejprogress2 жыл бұрын

    Hey Jamie, anything on Pivot table?

  • @MuhammadAli-ij9xj
    @MuhammadAli-ij9xj2 жыл бұрын

    Hi , I am beginner on excel, I have a one question , how i minus the 9:00 AM from 2:00 AM second day time?

  • @2badger2
    @2badger210 ай бұрын

    Great video! How can a write a equation in one tab and then call that equation up in other tabs? I presently copy and paste the equation in one tab which is easy, but in the future many more tabs will be used. As time goes by the equation is getting updated and I don't want to copy it to all of the tab again. Thank you