Microsoft Excel Tutorial for Beginners – Full Course
E conheça também sobre o Melhor Bot Para Opções Binárias 2022
Que tal um robo gratuito para IQ Option? Sistema Para IQ Option Grátis
Lean how to use Microsoft Excel from the beginning by creating 6 real-world projects. Most of the content applies to Google Sheets as well.
You will learn how to
– enter data,
– navigate through a spreadsheet,
– create formulas to solve problems,
– create charts and graphs,
– understand relative vs absolute references,
– import and export data,
– implement VLOOKUP,
– use pivot tables,
– split and concatenate text,
– and more.
✏️ Course developed by Shad Sluiter. Check out his YouTube channel:
⭐️ Course Contents ⭐️
⌨️ (0:00:00) Intro
⌨️ (0:04:14) Payroll
⌨️ (0:39:35) Gradebook
⌨️ (0:57:22) Decision Factors
⌨️ (1:04:40) Sales Database
⌨️ (1:23:13) Car Inventory
⌨️ (1:59:29) Problem Solving Templates
⭐️ Special thanks to our Champion supporters! ⭐️
🏆 Loc Do
🏆 Joseph C
🏆 DeezMaster
—
Learn to code for free and get a developer job:
Read hundreds of articles on programming:
And subscribe for new videos on technology every day:
Link do Vídeo
If you have comments or questions for me (author) you can post them here or on my channel at http://youtube.com/shadsluiter
A million likes from me Sir… 👍🏽
5 jan 0-20 minutes + practice
I'm glad I came across this, looking forward to an advanced tutorial. Great work delivered simply!
Thanks a lot for the course. very good stuff. I could not download the car-inventory don't know why. but am really grateful for this.
Sat for 2 hours+ stretched watching this tutorial. Indeed, it's worth it plus the teacher did a great job in putting information out. Now I can always revisit my spreadsheet I built during the tutorials.
PLEASE tell me i am not the only one struggling from 16:09. for some reason, my hourly wage sum total keeps coming out to dec 4, which i'm assuming stems from the january 1 that i previously had there. but i already got rid of the january 1st. is anyone else having this issue??
You have such a classic voice, and the tutorial is really helpful, thanks.
It is great to have these material available, thanks. I do have a question, there are five weeks for January and should be only four, 1 thru 29 days so one column was not needed, correct ?
This was a great tutorial. Perfect for beginners or for those who need a refresher course. I have not searched your playlist but you should definitely do one on short keys. Excel is even more efficient of a tool when you do not have to touch the mouse.
An absolute brilliance of teaching! I wish you were in our country! I have learn not just excel but many teaching skills from this video of excellence!
You lost me at 24:44/2:26:09 I am still trying to figure out how you added jan-1 to 7? 🥴
Can somebody pls send me the car inventory excel file? its available in txt format in the link mentioned in the vid
thanks in advance!!
I have a question! if anyone's kind enough to help me, pls reply.
1:46:44 if we look at the data, I want to basically create a drop down vlookup of manufactured years. so that when I select a year from the drop down I get the model name, its age and miles. so for example, when I select 2006, I want it to show all the model names manufactured that year including its age and miles. how do we do that ?
[ i want to do this without using Pivot tables btw ! ]
pls help.
Wooow am done with the payroll going to assignment number 2 ,
20:20 if it's time and a half, ya shoulda typed "1.5" (without quotes) in the formula bar instead of ".5"; OOPSY!
youtube: this video uploaded a year ago
me: at 5:08 notices 2014 at bottom right of screen
me: 🤔🤔🤔
I can't download the Sales Database spreadsheet and the Car Inventory text file.How can I download these files
Motivated to learning and being able to exceed in excell thank you 🥰 i am taking it a course at a time so this might take longer but i am happy to say I've learned the first part ( payroll) how fun ! Thank u for taking the time to create a video like this
1:11:43 instead of this quirky operation you can double-click on tiny square in the right bottom corner of a cell
1:20:09 no, that's not what you selected. There is no need to select an entire table, instead select one cell and PivotTable creator will select a table automatically
19:21
Please add files to download so that we can practice. Thank you for making me understand Excel
this is pretty beautiful
I really really appreciate you chief for sharing your knowledge on this Ms Office softwarewith us. As for me, I don't have any idea at all on this software but, now in this video of yours I gained some concepts and knowledge from. I'm really keen to know about programming and softwares from your. By the way do you have any websites that we can download pdfs for software file so that we can read through it and solve problems.
GOD BLESS you Prof.
Thank you so much. It was really very well explained.
i cannot find the sales file on the website.
can anybody enlighten me please?
22:20
You explained it very well. It became easy to understand for me .Thanku sir