Excel 2021 Full Course Tutorial (3+ Hours)
Excel 2021 Full Course Tutorial (3+ Hours)
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: learnitanytime.com/p/exercise...
Who it's for: Beginners - experienced, everyday users looking to sharpen their skills and increase efficiency in Microsoft Excel.
What it is: Microsoft’s spreadsheet application used to clean and organize data.
What you'll learn: We start with the basics, showing you the user interface and quick ways to navigate. Once you’re comfortable with the software’s layout, we quickly move on to calculating data with basic formulas and functions. In the Intermediate section, we show you the various tools and ways to sort and filter data in a timely manner. Then, we dive into one of Excel’s most popular features; the Pivot Table. Our Advanced training starts with basic functions like the IF function. After that, we explore complex Database functions, provide an introduction to Macros, and show you how to save time by automating common Excel tasks.
Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
www.learnitanytime.com
For Private Group Trainings please visit:
www.learnit.com/private-group...
Manuals: bit.ly/30xZb59
Username: manuals
Password: password
Start 0:00
Introduction 0:03
Start Screen 2:35
Excel Interface 7:03
Zooming, Navigating, and Shortcuts 13:31
Performing Excel Calculations 28:19
Simple Excel Functions 36:53
ABS, REF, and AutoFill Functions 42:25
Checking Compatibility 47:51
Inserting, Moving, and Cutting 49:29
Cell Styles 54:30
Themes 59:41
Showing and Hiding Worksheets 1:03:16
Grouping Worksheets 1:06:19
Freeze Panes 1:08:45
Custom Views 1:14:15
Saving Templates 1:16:09
Spell Check 1:18:36
Print Preview 1:20:09
Conclusion 1:23:17
Introduction 1:23:59
Formatting Lists as Tables 1:25:19
Flash Fill 1:34:16
Custom Sorting 1:37:03
Subtotals 1:41:15
QA Tool 1:45:55
Data Charts 1:49:01
Sparklines 1:56:29
Introduction to Pivot Tables 2:01:26
Advanced Pivot Tables Options 2:13:32
Data Validation 2:21:01
Conditional Formats 2:27:34
Comments and Notes 2:34:05
Linking Data 2:36:40
Privacy and Protection 2:39:41
Conclusion 2:43:16
Introduction 2:43:41
Nesting Functions 2:46:48
Database Functions 2:54:40
XLOOKUP 3:03:11
UNIQUE 3:11:03
SORT and SORTBY 3:16:54
FILTER 3:22:48
LET 3:29:18
Consolidate 3:34:42
Introduction to Macros 3:39:27
Recording and Playing Macros 3:42:02
Conclusion 3:47:27
#excel #excel2021 #exceltutorial
(C) 2023 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.
Пікірлер: 204
Thanks bro! your a freaking legend I honestly don't know what I would've done without you a huge thanks!
@LearnitTraining
8 ай бұрын
No problem 👍
Exactly what I have been looking for. Thanks!!!!!!!!!!!!!!
@LearnitTraining
8 ай бұрын
Glad we could help!
An excellent course well structured with plenty of prompts to give things a try. Thank you very much Faz!
@LearnitTraining
4 ай бұрын
Glad you liked it!
Thank you so much for the tutorials(beginners to advanced) i understood everything. Great work Faz and Learnit.
@LearnitTraining
2 ай бұрын
You are welcome!
Thank you for this awesome tutorial! You are a phenomenal teacher; everything is so clear and nicely paced, and it feels you thought to go over functions more than once, but in different scenarios, which really helped me to remember them! I’m starting new work soon which will require good MS command. And your teaching really helps me be more confident. A big thank you for your awesome work!!
@LearnitTraining
10 ай бұрын
You're very welcome!
Awesome tutorial, dude! Thanks!
@LearnitTraining
8 ай бұрын
Glad it helped!
thanks! simple and understandable guide!
@LearnitTraining
8 ай бұрын
You are welcome!
I can't say THANK YOU enough!! You're one AMAZING teacher.
@LearnitTraining
3 ай бұрын
Thanks!
This is amazing!!
It worked like a charm, thanks.
@LearnitTraining
8 ай бұрын
👍
Great video! Thank you sir!
@LearnitTraining
9 ай бұрын
Glad you liked it!
thanks i never think that will work so good job!
@LearnitTraining
8 ай бұрын
👍
Thank U FAZ Much appreciated ❤
@LearnitTraining
3 ай бұрын
You are so welcome
The whole excel in less than 4 hours God!! what a genius and a phenominal teacher!!
@LearnitTraining
8 ай бұрын
Thank you so much! We think Faz is great as well!
I'm loving this course 🎉❤
@LearnitTraining
4 ай бұрын
👍👍👍👍
Awesome .... Thank you for helping in finding out the solution for my issue 😊
@LearnitTraining
Ай бұрын
Most welcome 😊
Thanks it really worked thanks alot man appreciated
@LearnitTraining
8 ай бұрын
👍
I am from Bangladesh. Thank you for this excellent tutorial.
@LearnitTraining
6 ай бұрын
You are very welcome!
Thank you so much for the training.....👍🤛👏✍👈🙏
@LearnitTraining
10 ай бұрын
Our pleasure!
@odarahanthony9194
10 ай бұрын
@@LearnitTraining cool🥰
Jazakallah Faz, it was an amazing lecture.
@LearnitTraining
4 ай бұрын
It's our pleasure
thank you..ive done it. and it works well.
@LearnitTraining
20 күн бұрын
You're welcome!
Amazing!
Great course ❤ effortlessly
@LearnitTraining
Ай бұрын
Glad you think so!
I learn many things thank you
@LearnitTraining
2 ай бұрын
You are very welcome
Excellent video, I am brand new to Excel and this video is one of the better ones with all the keyboard shortcuts. One funny thing that happened when I was typing in "todays date" around the 42:10 mark, was that today is actually 2 years to the day (October 27) it showed on the video 🤣.
@LearnitTraining
6 ай бұрын
🤣🤣🤣 that is a great coincidence
Muchas Gracias amigo
@LearnitTraining
8 ай бұрын
You are very welcome!
It Work ! Thank you
@LearnitTraining
8 ай бұрын
You're welcome!
thanks very much indeed!
@LearnitTraining
8 күн бұрын
You are welcome!
Thank you!
@LearnitTraining
22 күн бұрын
You're welcome!
Many many thanks
@LearnitTraining
8 ай бұрын
Most welcome!
Sir did u explain finctions like count if and sumif etc
Very good questionnaire app I used. And earn money.
Thank you so much Sir ❤
@LearnitTraining
10 ай бұрын
Most welcome!
Thanks A Lot Dude
@LearnitTraining
8 ай бұрын
You are welcome!
Sportive Video shared.....Thanks
@LearnitTraining
Ай бұрын
Thanks for that!
Thank you sir keep it up
@LearnitTraining
4 ай бұрын
Most welcome
Thank you 👍
@LearnitTraining
Жыл бұрын
You are welcome!
Thanks!
@LearnitTraining
Ай бұрын
Thank you so much Lisa! Your support means so much to us and helps continue to create new videos each and every week. Thank you once again from the Learnit Team!
gracias pór el buen programa, saludos de desde México!
@LearnitTraining
8 ай бұрын
¡De nada!
muchas gracias, funciono 100%
@LearnitTraining
8 ай бұрын
de nada
Thanks you for your tutorial I'm from Nigeria. But try to carry us along the more by creating everything (file) you are going to use to so that we too can learn how to do them instead of coming with auto made ones.
@LearnitTraining
2 ай бұрын
Noted!
awesomely done video, Mr. Faz
@LearnitTraining
10 ай бұрын
Glad you liked it!
Excellent
@LearnitTraining
Ай бұрын
Thank you so much 😀
great course
@LearnitTraining
19 күн бұрын
thanks!
thanks for sharing
@LearnitTraining
10 ай бұрын
You are welcome!
That really work POGchamp
@LearnitTraining
8 ай бұрын
👍
big thenks bro work for me
@LearnitTraining
8 ай бұрын
Welcome 👍
Gracias!
@LearnitTraining
8 ай бұрын
¡De nada!
Sometimes after so many videos it's just so nice to see a muslim brother. Thanks for all the effort mate!
@LearnitTraining
2 ай бұрын
Thanks!
Thank youuuu
@LearnitTraining
8 ай бұрын
You are welcome!
Good place to start
@LearnitTraining
Жыл бұрын
We think so too!
thanks bro
@LearnitTraining
8 ай бұрын
Any time!
Excellent course, thank you so much! Can I ask you what program are you using to draw or make anotattions on the screen? :)
@LearnitTraining
14 күн бұрын
That is Zoomit!
Thank you so much for this! I always used Excel superficially only & and am now looking to improve my skills for my future profession, this is so helpful! I got a bit stuck at creating a table from the list though, for some reason the shortcut does not work and I cannot click on "table" either after choosing the insert tab. There seems to be some sort of error. Do you have any idea why? My cursor indeed has selected a cell within the list so it can't be that. I would appreciate your help! :)
@LearnitTraining
10 ай бұрын
Hello Bobby! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
@bobby7354
10 ай бұрын
Thank you! :)
Thank you. I had trouble grouping worksheets. Only the word would carry over to the workbook, not the formatting (size and color). Also, the word would not show up in A3 unless I inserted columns above the Salesperson data first.
@LearnitTraining
5 ай бұрын
Hello Valerie! You can always get help at www.learnit.com
Is there a way were I can wrap the text additional columns? It seems that the template can only wrap the columns headers and not the text values at Additional columns fields. Thanks in advance :)
Great. Thank you for the upload
@LearnitTraining
Жыл бұрын
You are welcome!
@nomatusi7514
11 ай бұрын
@@LearnitTraining Thank you, Thank you and Thank you. I have learned the new features in excel.
Did you expalin about nestif functions
it work thankssss
@LearnitTraining
8 ай бұрын
You're welcome!
Awesome
@LearnitTraining
Жыл бұрын
Thanks!
Muy bien.
@LearnitTraining
8 ай бұрын
Thanks!
Hi, Loving this tutorial but encountered a problem with grouping worksheets together. I followed what you did with the copy and pasting the data table but when i grouped the sheets and typed 'internal' in the cell A4. It appeared in cell A4 in the data sheet as well but didn't move my data table down which meant that the word internal replaced the name Michael Scott which had originally been in A4. why didn't my data table move in the same way yours did? Thanks
@ArzoCanada
3 ай бұрын
Exactly the same here. not sure why
Are you aware of any way to print the filter selections sort of like in a report summary sense. For example I work in construction and I receive a large data dump from both out estimating software and at other times from our design software. I make various filter selections based on what I am looking to display or print as far as relevant data is concerned. When printing the final filtered dataset I want to also have a printout that outlines the criteria that has been selected to filter the dataset. I.e. let’s say I select 15 specific items out of a list of 100. I want those to be displayed on a separate report recap sheet so that a third party person could independently confirm that the correct selections were made (from a paper / printed view, without having access to the digital file and drilling down on each menu independently).
@LearnitTraining
10 ай бұрын
Hello David! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
@dkerze
10 ай бұрын
@@LearnitTraining Thanks! I signed up and will start to explore.
so cool man
@LearnitTraining
8 ай бұрын
Thanks!
Which formula you have used cell "p1" ?
Hi Thankyou for this wonderful tutorial. I actually saw that chart made in charting 1 when saved as template didnt save the combo chart but only the bar chart. And when you used this chart in charting 2 it didnt mimic the chart but just mimiced the theme and color. Is there a particular reason for this?
@LearnitTraining
11 ай бұрын
Hello What's Your Sin! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
I am in the advanced section now and when I open the Excel Adv Clean file, a lot of the menu in the ribbon bar is greyed out i.e. the Insert tab, the Data tab, Review, View..etc. it doesnt seem to be protected sheet either-Please assist. Thank you
@LearnitTraining
3 ай бұрын
Hello ArzoCanada! We just tested the clean file and there were no issues. Sometimes you will need to enable editing.
nice
@LearnitTraining
Ай бұрын
Thanks
The Insert, Draw and Data Tabs disabled from some reason in Excel Adv Clean file.xlsx
THX
@LearnitTraining
Жыл бұрын
YW
Really good tutorial overall! Probably my error.
@LearnitTraining
5 ай бұрын
Thanks!
3:21:00 How did he add extra columns so fast?
buen video
@LearnitTraining
8 ай бұрын
Thanks!
Your any paid certification course for data analyst
thanks man +1 sub ;)
@LearnitTraining
8 ай бұрын
Thanks for the sub!
Smart Look up is not available if you access Excel via web access.
@LearnitTraining
15 күн бұрын
Great call out!
It doesn’t work under Mac version, I cannot find alt on Mac keyboard 😢
Hi, I have windows 11 but there is no ''notes'' section with drop down list showing on my review tab on my ribbon so cannot convert old notes into comments. any idea why that is?
@LearnitTraining
5 ай бұрын
Hello Alison! This article may help: support.microsoft.com/en-us/office/insert-comments-and-notes-in-excel-bdcc9f5d-38e2-45b4-9a92-0b2b5c7bf6f8?ui=en-us&rs=en-us&ad=us
Can someone kindly drop the exercise files here I'm unable to create a Microsoft account
good
@LearnitTraining
9 ай бұрын
Thanks
Thanks for this easy and very educative video. You an unparalleled instructor. However, it looks like your downloadable file (Excel Adv Clean file) is encrypted.
@ayodexter
7 ай бұрын
Sorry. Have been able to resolve it. The sheets were grouped.
@LearnitTraining
7 ай бұрын
👍👍👍
How can I get a Microsoft Excel certificate through Microsoft? Thanks.
@LearnitTraining
Жыл бұрын
Here is a link to the official Microsoft certification exam: certiport.pearsonvue.com/Certifications/Microsoft/MOS/Certify/Excel
@Briantechnology
Жыл бұрын
Thanks 😊
I cannot edit the downloaded document in some capacity. Do I have to purchase the excel file somehow?
@LearnitTraining
10 ай бұрын
Hello DemWiFo! We just the files and they are currently working. Please be sure to use the file labeled "Clean"
"Faz is even better than I expected!" 02:37:37
@LearnitTraining
4 ай бұрын
Thanks!
why do you have such a soothing voice?
@LearnitTraining
19 күн бұрын
Born that way
In comments and notes section if we protect the cell with password Can we still leave a note or a reply to that existing comment Thank you Faz Karim
@LearnitTraining
11 ай бұрын
Hello Manaal! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com
eccellente...
@LearnitTraining
8 ай бұрын
Thanks!
in Excel Adv Clean file, all commands in Data tab doesn't work for me. they are all disabled. could you help me please?
@LearnitTraining
8 ай бұрын
Hello Whahid Shah Zadran! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
it's magical
@LearnitTraining
8 ай бұрын
Thanks!
When I group the sheets, it won't copy the font color and Bold to the other sheet, just the words
@LearnitTraining
8 ай бұрын
Hello pat p! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
@pat.p
8 ай бұрын
@@LearnitTraining thank you!
it is easy if you are in the developer mode
@LearnitTraining
8 ай бұрын
Noted!
Bro data analytics job lo python course gurinchi video cheyyaledu bro
@LearnitTraining
6 ай бұрын
We will have a video covering Python in Excel soon!
These files don't let me create tables. I selected enable editing but it's still read only, and under properties read only is not checked so I can't uncheck it.
@LearnitTraining
10 ай бұрын
We just checked the files and they worked fine. We recommend to delete the first download and try again. Also be sure to use the "clean" file.
@fenixrising1972
10 ай бұрын
@@LearnitTraining Did both. It doesn't work.
@Rena0142
10 ай бұрын
@@LearnitTraining I also have this problem, after downloading the zipfile and extrating the files, the "Clean" one doesnt seem to let me create tables as well (or to insert anything really). I tried the other 2 and they both work well. Maybe creating a new dowload link might work. *UPDATE:* I clicked on "file" and then in the "info" section where it says "inspect workbook" I used the "check compatibility" feature. It detected 2 issues - one of them wich said "A table style is applied to a table in this woorkbook. Table style formatting cannot be displayed in earlier versions of excel. Location:'Sparklines'. I only clikced find below that mesage , and it seems to solve the issue by it self. At least now im able to use the insert features! @fenixrising1972 try that out, but maybe the problem itself has to do with our excel verion!
@tobioluwasegun4042
9 ай бұрын
It happened to me also, I was able to deduce that if the function only works for excel 21 and you have anything below that, you won't be able to perform such function.
@DanielG10_20
6 ай бұрын
If there is a way to make this Updated comment near the top of the list, that would be awesome! Totally worked for me, however it doesn't mimic the table that's on the video. Better than nothing though.
17:00 cell fit
@LearnitTraining
6 ай бұрын
👍
Thank for this video. Can you help me create an excel calculator? I will send you a video of what i need. It's icm911 where to go yh for now.
@LearnitTraining
Ай бұрын
You can get consulting for such a project at www.learnit.com
how can i download the excel 2021
@LearnitTraining
5 ай бұрын
www.microsoft.com/en-US/microsoft-365/p/office-professional-2021/CFQ7TTC0HHJ9?activetab=pivot:overviewtab
2:01:00
Can you translate these courses into Arabic?
@LearnitTraining
10 ай бұрын
We are definitely working on getting better translations for all our videos.
ga bisa windows geting ready mulu
20/09/2023 Love Cyprus house home economics 2003!
@LearnitTraining
8 ай бұрын
👍👍