Microsoft Excel Tutorial - Beginners Level 2

Want more Excel videos? Here’s my Excel playlist: • Excel for Beginners: E... This video tutorial will show you how to use Microsoft Excel for beginners level 2. Click here to go to level 1 for beginners • Microsoft Excel Tutori... Microsoft Excel is a powerful spreadsheet tool that is part of Microsoft Office. This is a detailed beginners tutorial, the below timestamps will help you navigate through the lessons that are covered. Looking for more? Let me know in the comments below what types of things you would like to learn in Microsoft Excel
Intermediate Microsoft Excel Lesson 1: • Intermediate Microsoft...
Dive deeper into formulas and functions in excel with this playlist: • Formulas and Function ...
Creating Charts in Excel: • How to Create Charts a...
Subscribe to Teacher's Tech: bit.ly/Subscribe_TeachersTech
0:00 Start
0:52 AutoFilling cells in Excel
4:18 Add your own autofill
5:49 Sorting data in Excel
8:56 Using filters in Microsoft Excel
12:45 Round functions in Excel
15:40 Relative Relative cell references
17:14 Absolute Relative cell references
18:55 Absolute Absolute cell references
20:17 Relative Absolute cell references
**More Videos on Microsoft Excel**
Dive deeper into formulas and functions: • How to use Formulas an...
Microsoft Excel for Beginners - Level 1: • Microsoft Excel Tutori...
Microsoft Excel Tutorial - Level 3: • Microsoft Excel Tutori...
Microsoft Excel Tutorial - Level 4: • Microsoft Excel Tutori...
Microsoft Excel for Beginners - Level 5: • Microsoft Excel Tutori...
VLOOKUP Function for Excel: • Vlookup Function in Ex...
Learn Pivot Tables for Beginners: • Excel Pivot Table Tuto...
10 Best Excel Tips for Beginners: • 10 Best Excel Tips for...
How to Make a Line Graph in Excel: • How to Make a Line Gra...
I use Camtasia to create my videos:
Use this coupon code: TEACHCAM10
Camtasia purchase with 10% OFF code applied: techsmith.z6rjha.net/c/126458...
Camtasia EDU 10% OFF with code applied: techsmith.z6rjha.net/c/126458...
Camtasia Download page: techsmith.z6rjha.net/c/126458...
DISCLAIMER: This video and description contain affiliate links, which means that if you click on one of the product links and end up purchasing it, I’ll receive a small commission. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

[@TeachersTech]

Looking for more? Here's a level 3 Excel tutorial for beginners: kzbin.info/www/bejne/amjcpmhmeNh7ZpI

[@thecomposerchanginggames5250]

Thank you! Your videos help greatly!

[@stephanymoreno8167]

i love you! God bless you!

[@mfpa1733]

THANK YOU SO MUCH SIR😍❤

[@awahritaengwari2915]

Wao thank you so much

[@awahritaengwari2915]

Wish you could teach me another IT field

[@Lauren-ul8im]

Not sure if the instructor will see this but thank god for him he’s made so much of my anxiety surrounding excel and finding a job post college completely disappear. Thank you!! People helping people :)

[@earth7451]

I like the fact that the instructor does NOT use complicated English to explain the subject. It's easy to understand terminology and clear pronunciation. This makes the tutorial easy to understand to those who are not native English speaker. Thanks a lot!!!

[@scottroberts6756]

ExxonMobil purple gas I like the tablet or it can wipe your ass.

[@scottroberts6756]

She's a growth as a clerical bird before I gas is a boron turd. d'pickd..,,,, as.sa.,.

[@rameshagasar1310]

Yes that's correct even I'm of the same opinion. The way he explains things is very easy to understand.

[@doykme]

Definitely agree with you

[@smeraldaasmae4089]

Definitely

[@bukolaobanigba6423]

So glad I made the decision to watch your tutorials. I started learning today 4/04/24

[@DeeMulinge]

Day 2 of learning Excel, and honestly, you are doing the Lord's work. Be blessed. It isn't much complicated as I had initially thought.

[@carolhama4156]

Came here for a refresher...but OMG you sure spilt what looks to me, with my limited knowledge of Excel, ALL THE BEANS! Wow, this a very interesting...I must've wasted years doing everything the slow way! Thank you, thank you for sharing your hard-earned information!

[@TeachersTech]

Glad it was helpful!

[@bibifathima953]

I think my parents are going to be proud of me because i am just almost 9😃 learning exel

[@fictionalcharacterr]

Yes❤

[@bejayii9777]

Good kid

[@nyityoemmanuel5492]

I am a beginner in excel and I thank God for coming across your channel. Your teaching style is second to none. Wishing you well Thank you sir

[@seanmasters233]

Explaining things to where anyone can understand. The un-noticed hero we needed.

[@darklord5319]

This instructor is incredible, he makes every step clear - no confusion. I can't give him enough props on his presentations. Thank you!!

[@zoweegeewhiz]

Except he speaks very rapidly

[@pepsirosie6760]

i thought learning Excel would be daunting and difficult but you've made it easy to follow! definitely helped bolster my resume and skills :) thank you!!

[@brooklynohio518]

Me to waisted 22years of my life thinking Exel is very difficult. He makes it so easy to learn.

[@connief2679]

These are excellent tutorials. Thank you so much. I have saved the entire playlist to my library. One thing that would make even better would be if you could include a download of your sample files. This would make it easier for us to practice as we watch.

[@Ala-ZouEnterprise]

You're completely amazing. College professors should have to watch your video! You've definitely brought to light just because they know what their talking about doesn't mean that they know how to teach others. You are the real MVP!!!🎉

[@rodyncoetzee5289]

Thank you You have just made it possible to get a job

[@wenfin7048]

Thank you so much for making these videos. I've been in a dead end, low paying job for years, I don't have the time or money to return to school, so this is a perfect way to learn Excel and other Microsoft programs to increase my skill set especially if, like me, you're intimidated by the 'inside jargon' techies love to use. These tutorials are clearly taught-the mark of a great teacher

[@genesimmons441]

The word jargon is enough. Its definition indicates inside.

[@crystaltucker3187]

OMG!!!!!!!! Thank you so much, I purchased a Excel online class and I was so confused by this concept they way they described it, you just made it so simple and easy to understand. You're a GREAT! teacher

[@darlawhitley5791]

I paid codefinity and couldn't understand half of what they showed on their video's. I have watched several of your video's now and have learned so much. You make it so easy to learn and understand. Thanks so much!

[@brooklynohio518]

What i like about his courses. He bring your attention on important facts. And his voice very pleasant. And its not 2h long. Its 22 min courses. And easy to learn. He is so good in teaching.

[@gordonbennett556]

All of this is quite helpful and has already benefitted me amazingly. For the future, I'd be very interested in instruction on VBA pivot tables and macros.

[@tevinmukemu8442]

You just saved a life here for someone who.is more computer illiterate and just got out of college these lessons are amazing I like how you teach us with simplicity and understanding

[@susie2630]

I just started this video after watching the first one and I have learned far much more than I have ever in college, thank you! Easy to understand

[@richardnelson4761]

Excellent presentation. Clear, concise, and well-paced. I look forward to taking more with this teacher.

[@venessavera8638]

I love how he put it into breakdowns like subtopics and also the simple terminologies used. Thank you so much.

[@nyanya5057]

You made learning Excel look easy. I really loved that you taught at a pace that was easy to follow.

[@agyenimboatengsolomon7005]

I bless God for your life. I am now in a powerful position in a multinational construction company because of your "Beginners Level 1'' tutorial. I watched and practice on the day before my first day at the job and God gave me speedy understanding in your teachings when i had never used the excel application. Thank you and Keep It Up.

[@fijagorockabilly4527]

After a two year work break, I have just discovered your channel and love it! My previous use of Excel was very basic so I'm starting at the beginning to refresh my memory and learn new things as I go. Level 1 was so clear and easy to follow, I am going straight in on Level 2.

[@ebukalucky7871]

I think am becoming an expert in excel thanks to the instructor

[@richposports7030]

While not going that far (there are so many things you can do in excel), I'm learning lots from this chap. A top teaching style. Salutes. I needed bringing up to speed from what seemed scratch. Feel empowered. Respect. All the best 👍 👌

[@pakitomorales4826]

Great tutorials. Getting ready to take an employment test, your videos help me to refresh my knowledge of Excel. Thanks a lot.

[@qtchikaxoxo]

Thank you for these tutorial videos. Stay at home mom here and I'm trying to get back into the work force by doing remote work but I really needed to brush up on my skills. This brings back a lot of useful tips. Thank you so much!

[@karenkyabega7790]

love the fact that your explaining everything smoothly and with alternative ways. had i watched your tutorial prior my job interview, I would have gotten that position. I appreciate your work!

[@raindrops6342]

It is so far the best tutorial on youtube about microsoft excel

[@fitriainunwidianingrum4268]

Thank you Jamie! I’m so addicted to your lessons it’s very easy to undertand, and i’m not a native English speaker but still can catch the lessons well. Your channel is so helpful!

[@tonibuzzard9312]

Thank you very much for this very informative lesson on Excel. Learned things I did not know even after using for a few years. I do look forward to more information on Excel and even pivot tables.

[@vyhzanabria1]

I’m learning a lot , thank you so much.

[@gabrielsong6124]

Great tutorial, detailed and straight to the point. It's easy to understand. Continue the great work!

[@likithkotian7598]

It’s really being helpful, thank you for this. I would like to request you that if you will do any demonstration regarding restaurant operation chart like costing and budgeting it would be helpful for all.

[@abeebatajirotutu1420]

Personally, i liked the way you pin pointed on ever of the class and your demonstration were so explanatory. The learning world would be a great place with individuals with your teaching skill.

[@barbarad1748]

Wow I never used Excel before, enjoyed your tutorial so clearly explained with every function, looking forward to more tutorials on Excel.

[@ainlee6248]

My first time doing excel at age 54 yo...LOL...simple instruction....understood very fast ...thanks a lot

[@mohansahareti4678]

I never have time to watch your videos back to back but now that I am sick I am here watching them back to back! I just recently been promoted and I need to know everything about excel. Level 1 I knew it, Level 2 knew it too, with the exception of Absolute but now it's making sense. Thank you! Clear cut explanations and I love how detailed you are! Love that I found you and love that I know have time. On to level 3!

[@simpleexcelexamples9619]

Thanks a lot for explaining these concepts! Love the way how you explain everything simple! This video was an inspiration for my own classes (I give Excel classes to students). Thanks again!

[@jasoncherry5849]

Its been. a whie since I’ve used MS excel so this was a great refresher for me. Hopefully I’ll land a new job soon and this will be a vital skill for that position, thank you for the online classes.

[@suzaq5022]

Very articulate and elementary explanation for clear understanding. Sometimes a little quick, but that doesn't matter because I have many references to go back to. Thanks so much for your fantastic tutorials!

[@patoboymende8954]

You are so lovely for I must confess, I pray I impact myself with knowledge as per your easy way of teaching though facing some challenges

[@triciam2911]

Great tutorial! Better than a few other ones I watched for Excel. Would like to see a video on a description of all the features of each icon and what they do.

[@amandanewton203]

My second tutorial, learning heaps with you and will continue. Thank you.

[@shelitap4970]

Just applied for an internship and needed to brush up on my Microsoft Excel skills, was considering enrolling in a class but came to KZbin University first and I'm glad I did.

[@drakkarjones3989]

Absolutely loved learning Excel with your instruction! I had the chance to follow along, pause and input data, and jump back in with no problem. I appreciate you taking the time, energy and effort to create these tutorials! Next up, VLOOKUP!

[@iremideolaleye7087]

You are an ABSOLUTE ABSOLUTE best teacher. Thank you for all the simplified breakdown.

[@Da-vinceArt3901]

Hi jamie, thx I haven't in my life,had any formal training in computer education but have learnt things on my own, our time we didnt have any " you tube" if we had such a platform and access to computer knowledge with a teacher like you things would have been much much prettier for me n all, thanks again I love your teaching style its so unique n easy just of all.

[@iampase3417]

People pay top dollar for this information. Thank you! I watched ALL your ads

[@moureencaroline6446]

I just subscribed to your channel, but I wanted to thank you so much for this. You never make Excel complicated. Thank you, and I will definitely tell my friends about your channel.

[@tanyapickert1243]

I am loving this series! Jamie does a great job of explaining! I am currently in a course for spreadsheets and he makes complete sense. I could not understand the formulas until he explained them. Thank you!

[@rover_doggy3243]

y'all sounding British "drinking a cup of chamomile tea, what ho my fellow boy"

[@tausifrahman7189]

This is my 2nd day of learning Excel. Thank you for making things easy for me.

[@sofienabidi7242]

Million Thanks for these helpful Videos, I will learn Excel, Power Point with you............

[@TeachersTech]

You are very welcome!

[@AusTexish]

This is great, hard to ask folks for help basic or otherwise, Jamie presents it in a conversational tone that is easy to listen to, easy to abosrb.

[@michelleteasley1996]

LOVE HIM! Clear and concise explanations. Great teaching for beginners to may you WANT to learn and develop making spreadsheets.

[@banai1374]

YOU ARE A GOOD TEACHER, LOOKING MORE TUTORIAL.

[@mariavictoriapataky3309]

I never used excel, I was afraid to use it, but now, you explain it so good that I love it and I love you

[@lizdyer9092]

Thank you for making these tutorials! You're so knowledgeable and these tutorials are soooo very helpful!

[@simransingh5379]

Hi Jamie, this is my first time that I am watching your tutorials, and I loved the way you explain each and every detail. I studied excel in my tenth class which was long gone from my brain, but now it feels like I am doing it since forever. Thank you so much. keep it up.

[@amosngongo6274]

This is very wonderful. I truly appreciate your in-depth tutorials and insights for Ms-Excel.

[@Ana-dn6ot]

Thank you so much for your teachings, you are an amazing instructor and the best I had come across in the internet. I love it the way you teach and your lessons, they are so clear and easy to understand, so well explained!! I feel that I am learning a lot and refreshing my knowledge. Thank you, thank you so much once more!! I can't wait for the next level. This is so awesome that inspire me to learn even more!!! I am so exited and very happy to start the next lesson.Thank you!!!

[@jancarlorodriguez829]

Thank you for taking the time to make these !

[@patriciarobinson6970]

This is no doubt the greatest tutorial i have ever got in my life. He even left the time for the topics and it was very helpful. Thank you sooooooooooo much.

[@aimeeelliott7608]

I'm learning so quickly what I need to do to use excel as I set up bookkeeping for our family farm. I'm now needing how to enter data, name columns and rows. I do love your way of teaching It is clear and organized. It's easy to pause, go look at my version of excel, find where the topic you are teaching is located and then come back and continue. You mentioned in this video that you will have a video that will cover a lot of the commands in excel, I hope that is right. I'm listening and have caught F2, F5, but I know there are a lot more. To be honest, I'd love a printout of some sort that listed them so as I go along I can find the right command easily. I do sincerely thank you for all the time and energy that you have invested in this project. THANK YOU!

[@susansmith7053]

Beginner Level 1 was great! I might have missed something but all of the sudden in Level 2 you were talking about formulas, but you had never discussed the "how to" with formulas before that. But overall, these are a big help for someone teaching themselves!

[@alejop5976]

This is amazing! It's been a while since i've touched excel. This is a great refresher. I hope you'll start an intermediate level one day.

[@bibiadetola1028]

Thank you very much. These piece was really insightful and helpful. Thanks again👍

[@Yqwiuyy]

Thank you from Lebanon 🇱🇧

[@pattyaap7345]

I loved your excel tutorial videos! they are so clear and easy to follow!! thank you for your time and effort to make them.

[@Da-vinceArt3901]

Once again Jamie its Vincent here thx a lot, for your perfect n simple way of teaching bless you sir .

[@sakinazahir9916]

thank you I've never used it before and that was really helpful

[@dividendstockpicker9531]

Fabulous , best teacher ever. I always have trouble following online tutorials as the teachers and material become difficult t understand over time. But I watched and tried this out without being bored

[@NantumeMargaret]

wow!!! 😘😘😘 I have loved the tutorials. They are so amazing. Imagine being a beginner to excel without any crew about it, but for the tutorials I have watched so far, I feel like I have exhausted everything, and I am so confident in what I have learnt so far. Thank you so much for the wonderful tutorials and for sparing your time to equip us with this knowledge. God bless you. Waiting to watch all the videos🙏🙏

[@ayteaq]

After watching this, I know I will excel at the job I applied for.

[@gracevargas-cansino4654]

Awesome teacher, very helpful.

[@AlexsonP]

Great video. As a social science graduate, Excel is one of those things I never had a need to use and jumping into the work force where it is very much so commonly brought up as a need got me feeling pretty bummed so this is nice. Learning day by day with your videos!

[@tammieflorence3093]

I love the fact you explain and speak clear and slowly when explaining a function

[@sbn025]

05:13 Oh god thank you!!! that will save me A LOT of time!

[@davishill3305]

I just started a new job and was a little rusty on Excel. Thank you so much for your videos! They saved me my job!!

[@allisonwendell9942]

Thank you so much for this! I've taken both these beginner courses and have been able to execute everything taught! Ready for the intermediate lessons :-)

[@dallastrail]

So beyond happy I found your videos! I had no idea how to use Excel at all. And just watching one video. I learned a lot and keeps me wanting to watch more of your videos. Very easy to watch!

[@allthingsknb]

Thank you for such great content. I am still a bit confused as to when I would need to use the relative vs. absolute.

[@thundermorphine]

Have more to come! You're a great teacher!

[@realisticman7256]

EWWWWW A FUGLY EGG

[@ericakoligokubi5119]

I am Eric from Ghana, currently doing my service at a poultry farm and what they do here us excel, your video has really helped me....Thank you

[@tltaylr35]

Thank you so very much. This is just what I needed as a refresher for the new position I was hired for. I was able to follow along while performing the tasks described in real time, except for when I paused to copy data into the cells.

[@zozi3668]

its 2020 and im trying to learn new things during quarantine. THIS WAS MAGICAL. thank you for making a perfectly planned and explained Excel tutorial.

[@josefinaharry9489]

Teacher... where you have been hiding??? You rock and THANK YOU SO MUCH! I have been trying hard to learn and understand how to be a pro on Excel... You made it so simple and is not intimidating anymore.. NO MAS! ... You really earned our respect for being so mindful posting your easy videos. GRACIAS!!!! GRACIAS!!!

[@Theresabrown1805]

I am really finding your videos interesting and I feel I am learning a lot I have to watch your videos a few times to fully understand what you are talking about. You are very good at explaining how things are done sometimes maybe show us a couple of times so we can get it right I have found that I have gotten the formula wrong and I have to go back and try again to get it right. thank you for your tutorial.

[@yonelaguqaza9522]

Thank you so much for these tutorials. I just watched part 1 and I'm going all the way. Thank you once again!!!!

[@TeachersTech]

You're very welcome!

[@studentassistant2486]

Thank you! Yes, this is very helpful. Could you do a tutorial on pivot tables and how to create a Gantt chart using Excel?

[@TeachersTech]

You’re welcome and I’ll add those to my upcoming video list I’m working on.

[@tambiraarmmand598]

Thank you for these tutorials! As part of my quarantine schedule, I’m watching an Excel tutorial and doing the practice exercises each day.

[@realisticman7256]

GO GET THE CORONA VIRUS AND GET OOF

[@user-hd2di6ob3x]

Bro made me an expert in three videos. Lov u bro thx for the vids really helped me take my business to a whole new level with excel.

[@akinoladhamsel9508]

I love the way you made it so comprehensive... Thank you!

[@basseyjumbo7892]

Thank you for sharing this with us...

[@justjoe942]

Thank you for putting these in order on a play list. I watch others also but, you're the first that's organized and that got you the sub. I'm old and retraining so I can get a job doing data entry from home. If you could point me to videos that address Excel employment tests I would appreciate it. Any advice on the data entry job market would also be helpful. Thanks again.

[@TeachersTech]

You are very welcome! I happy to help!

[@tammyvanvelden6342]

Great videos. Learning a lot. I find near the end of videos, you start to go really quick and I have to pause several times to figure out what I am doing. Looking forward to becoming a pro on excel. Thank you.

[@ibejoseph19]

Love this tutorial. Love the way Mr. Jamie teaches. Thank you Sir

[@supremomilton5378]

Absolute and relative is kinda mixing my brain up a little 😅

[@pulsarstudios3646]

Absolute means its fixed Relative means it changes with the cell your applying too