Excel 2016 Tutorial: A Comprehensive Guide on Excel for Anyone
ฝัง
- เผยแพร่เมื่อ 13 ก.ย. 2024
- A comprehensive tutorial on using Excel 2016, whether you are a student, a business user or in a corporate environment. Learn Excel (including the new features) in just a couple hours from the basics to the advanced features such as 3D Data Maps to recharge your career and resume. Make the most out of this content at learn.kaceli.com and save 50% today.
The concepts covered here apply also to previous versions of Excel such as Excel 2013, 2010 and 2007.
If you like the video, please "Like," "Favorite," and "Share" it with our friends to show your support on this work. Subscribe to this channel so that you do not miss out on the new videos on this series.
Excel 2016 Tutorial URL: • Excel 2016 Tutorial: A...
The Quick Guide for Excel 2016 along with the data files to follow along are available from here: kaceli.com/a/ex...
The following are covered in detail along with the starting times:
00:07 Getting Started with Excel 2016 - Learn the basics including the Tell Me feature.
11:15 Learn about the basic calculations in Excel 2016 such as SUM, AVERAGE, MAX, MIN, COUNT
21:45 Learn how to format a spreadsheet including conditional formatting in Excel 2016
25:04 Learn about additional core Excel functions and concepts such as SUM, Multiplying, Subtracting, Dividing in Excel 2016
32:41 Learn about the Quick Analysis Tools in Excel 2016
35:51 Learn about Data Sorting and Data Filtering in Excel 206
39:17: Learn about core concepts in Excel such as the types of references: Absolute, Relative Reference in Excel 2016
49:30 Learn how to create and use charts in Excel 2016
55:49 Learn how to use the Flash Fill Data feature in Excel 2016
58:17 Learn how to use Named References and Cross-sheet calculations in Excel 2016
1:04:29 Learn how to Calculate Percentages in Excel 2013 three types of calculations
1:12:23 Learn how to use Financial Functions such as PMT, IPMT, PPMT in Excel 2016
1:24:21 Learn how to use the IF statement and logical functions in Excel 2016
1:30:29 Learn how to use One Click Forecasting in Excel 2016
1:32:03 Learn how to use the new and modern charts in Excel 2016
1:33:43 Learn how to use Pivot Tables in Excel 2016
1:40:06 Learn how to use Data Gathering in Excel 2016
1:42:14 Learn how to use the new Financial Charts in Excel 2016
1:53:45 Learn how to use the 3D Maps and Data Visualization Exel 2016
1:45:41 Learn how to use the Freeze Panes in Excel 2016
1:47:11 Learn how to Set the Print Area in Excel 2016
1:49:33 Learn how to Encrypt and put a Password in a Spreadsheet in Excel 2016
1:50:14 Learn how to use data validation in Excel 2016
1:53:56 Learn how to link Excel Data to a Word Report
1:58:29 Learn how to import and export data in Excel 2016
2:02:47 Learn how to export an Excel file to PDF in Excel 2016
Keep in touch:
Website: kaceli.com
TH-cam Channel: / skaceli
If you want to take get a deeper understanding of Microsoft Office applications, take a look at learn.kaceli.com
Copyright notice: These videos may not be downloaded or distributed in any way without permission from Sali Kaceli. Contact me if you have such a need.
Computer Skills for the Workplace - 12 hours of Training is now available: th-cam.com/video/hPEgaVN1Mpg/w-d-xo.html. It covers Word, Excel, PowerPoint, Outlook and Windows. One of the longest TH-cam training tutorials. 12 hours of free training.
I am an unemployed 50-year old mother and this will increase my value for any potential employer. Thank you so much.
It will? Wow.
Ditto 50 yr old divorced empty next woman. Need to learn Excel to get a good data processing job
Michelle Green Ayers
Good luck. The thing about IT that is different from other industries is that if you have the skills you usually get hired. As gender, race and age are deemed much less relevant-at least less so than other industries.
Wish you all the best ..yes you can learn what you want and get the job 😊 im 31 and i was told to improve my skills in typing and excel i found this channel and it is helping..so excited to show them at new job that i can learn faster than they expected .
Dear Mr. Kaceli; I happened to find your Tutorials on TH-cam just now! Thank you for assisting ALL of US! I used Excel for College Report Cards a few years ago, but now I forgot. =( .....I guess it's true: Use it or Lose it! I have the whole MS Suite on my home computer, so I will make this my latest Mission! That's correct: You are a Blessing to all of us! For Sure!
And thanks to All the Bloggers! It takes a Village! =) God bless all of You!
Hello Sali,it's nice to meet you. I have to admit that I needed so badly a tutorial like yours,and you just saved my day. I searched all around,but everywere you have to pay for the courses in the beginners area too. I just have a new job,wich takes good Excel skills and the Director gave me a chance to prove that I can learn to use this wonderful program.Usualy I don't use a youtube account,as I don't write comments oftenly,but I just opened my account to write you BIG THANKS! Not many peoples are willing to spend their time trying to learn others. You have all our RESPECT for having the patience to help us reach the job we want. Thank you an infinite times for your tutorials,carefuly made for everyone.
Sir I always wanted to learn formulas but few videos made it so confusing that I completely lost interest. I was just scrolling and came across your video. Its so professional and easy to understand. Your voice is so calm and evenly paced which makes it easier to understand. The best part is that you have focused mostly on basics because you understand that if your basic concepts are clear advance will be understood better. If you could email me and please let me know what other technologies you teach and where you teach. You are an awesome teacher. I am so glad I found your video.
Priyanka Baniya indeed he is amazing
really, really high level of teaching skills. It is a luxury for any platform to have videos like yours. Thank you again.
i always thank god for a people like you , you made my life much easier, loved your work loved your channel
god bless you.
Te lumte Sali Kaceli.Faleminderit per gjitcka.
I got the "Excel for Dummies". Took weeks to get through the first 100 pages....I watched this video a time or two and within days am doing spreadsheets like a pro. Thank you....excellent tutorial!
You are really a source of learning..Thank you sir.
Oh my God!! You are an excellent teacher. I can not believe that your tutorial is way better than the professional video training that I bought thru amazon. I really regret buying the professional video that does teach as well as you do. Great Job!! Thanks a bunch.
You are a life saver!!
You are a blessing to the million of us.
Thank you Mr Kaceli for making these free, they are by far the most complete tutorials and well explained. Where I study, a course like this one is worth well over 120$.
We really appreciate the value of this tutorial. We are having a pool installed and we need to pay a certain percentage at the completion of several points of the project, down payment 60%, 15%, 15%, 10%. This has helped me manage my budget and learn how to incorporate percentages in excel without having to do it on a calculator the old fashion way. I can also use your methods to follow my credit card bills, and monthly budget and savings. Yay, it's time to play with excel! Thank you!
LOVE the way you explained "absolute reference"
Extremely helpful.
Thanks.
Ser, your tutorial is excellent. Thank you. I have a question regarding absolute reference. I can type "$" manually and it works, but when I pres F4 nothing happens. How do i fix it?
Stefanija Randjelovic Most likely your FN (function keys) are configured to perform different functions other than the regular ones. you may need to press another key combination to activate the function keys. Some computer manufacturers do that.
Sali Kaceli Thank you very much. I will try different key combinatiins and see what happens. All the best.
sir you are really great teacher, i really loved this video, and thank you soo much to get me this knowledge
love you :D
+shobhit sharma glad that you found a video helpful. Thank you for the feedback.
👍👏👏
haven't used excel since 2008 needed the refresher, thanks so much. This is beyond helpful
+Dionna Cook Yes, there are some new features in Excel 2016 that are pretty cool as you probably saw. Glad you found it helpful.
there was no much speculation. right away into the course with details. made me subscribed. Thank you for this great teaching.
Sir, I do not know how to express my feeling about these toturials in fact 90% of my Computer knowledge is through your tutorials l thank very much for the job well done.
Sali you are an EXCELLENT teacher. Thanks so much!
The style of teaching is very good.
Thank you so ,much for being so kind and teaching me for free. Your videos are really helpful.
You are doing a great job. I have been listening to many of your videos. I am learning so much. I am taking classes at the university on computers but I am learning so much more with you.
thank you very much me and my spouse will watch these little a day as if we are in class to update both of our resumes!
This is so helpful. Thank you so much Mr. Kaceli.
This was super easy to learn! Thanks for the advice, Mr. Kaceli
Glad you found it helpful. Thank you Michael for the feedback.
wow sir sali Kaceli, you are really a great teacher... may God Almighty Bless you for your Good work sir
His voice is already so much soothing, makes me want to learn
watching your videos is way better than watching a movie , thanks Professor
Simple and elegant but comprehensive coverage. Keep up your good work. Thank you very much, Mr. Kaceli.
This is the best tutorial I have come across so far. 5stars!!!
Mr. Sali Kaceli, I have no enough words to say thank you for your marvelous way of teaching. I also overwhelmingly admired your generosity that you have shered people your talent and knowledge of Microsoft office software for free of charges. Specifically I have enjoyed the comprehensive Ms excel 2016 modules that is posted on youtkube. I wish if I have had gotten this oportunity long before that could enhance my Ms excel skill in a way extending my operating profession.
Thank you for the feedback and glad you found it helpful. I am also working on Excel 2019 Office 365 from here: th-cam.com/play/PLyy-LLqj7iSZfJUS4ZANp30rgSyKKotMt.html.
This was a great tutorial for excel 2016. Better than every other tutorial I tried. Props to you Sir Kaceli! Thank you.
I thank you Sali for your tutorials.
Absolutely fantastic and easy to follow videos. Very happy to find you and follow your tutorials. Thank you for your time and desire to sharing your knowledge with others.
Praise God literally for these videos. Thank you Sali!
Don't let this video distract you from the fact that John Lennon was a abusive women beater
All the credits goes to Sali why praise someone/something that have nothing to do with?
Sali Kaceli: What an Incredible instructor! Your Excel 2016 Tutorial video is a great help for the beginner (or anyone) wanting to become proficient in Excel applications. Your calm, clear voice, pacing, visuals and presentation skills are exceptional. Thank you for providing help at such a critical time when I needed it most: for re-entering the job market!
thank you. This is so clear and helpful. I learned a lot from this video
You explained it well and simply easy to understand.
+Chloe Perez Thanks.
Thank you thank you for taking the time to do this tutorial. This is my college education :)
Thanks. Glad you found it helpful. Please check out the other videos on this channel and use the Share links under the video sharing the links with your social media friends. That is one way to help with this work.
Seriousleee!!! =)
This has been super helpful - i'm putting a budget together for myself and came across this tutorial and have loved it!
The way you explain it really makes sense and is helping me put my finances together. I don't have a numbers brain, i'm more of a words/creative sort of thinker so it doesn't come naturally to me.
I have saved it as a book to refer back to in case my memory fails me.
This is a life saver video . Thanks a ton !
These videos are such an important resource. I am so grateful and appreciative. Not to repeat myself but I must say thankyou again Sir for your ability to teach this software and the subject so candidly.
Thank you. I appreciate your feedback.
Thank you for this nice tutorial. Last ending modules were just simply amazing.
you working great and very very helpful , thank you very much keep it up love from PAKISTAN
Thank you for simplifing this so anyone can do it much appreciate it
Thanks for great tutorial. Have not used Excel for over 6 years so a good refresher and also good tutorial to find out new features of Excel 2016.
Thank very much Mr Sali Kaceli. You explain very well. Nice English. Nice accent. First time that I understand Excel very well and feel able to apply it in my Job. Best greetings and Best wishes from Africa.
+Monk Monk Hope you get the job that you are applying for. I have designed most of these tutorials for those that are looking to sharpen their skills for a new job and advance in their careers.
Thank you Mr Excel for the tutorial
Many thanks for this tutorial. God bless
This tutorial was refreshing and easy to follow. I thoroughly enjoyed it. Thank you for keeping it simple.
best tutorial..really helped me..especially the worksheet file provided in the description really helps. hats off to you sir
Hello Sir. I am very pleased we have the trainers like you majesty I have learnt loads of new features from your methodology. Keep up the good work and help this nation in more and more better ways Sir.
This is an amazing tutorial, your walk along is brilliant! The Microsoft Word tutorial was also incredible!
thank you soo much all your video are really valuable and anyone can understand your teach thank you for your gift knowlage
Underemployed for a while, devoted 5 or more hrs with examples etc. Thank you is a small phrase, I am working for one of the big 5 international banks now, using Excel all day . Couldn't have been a more solid and condensed tutorial. Needs some hrs to make it your own, though.
thank you so much for the tutorial sir.im glad to learn excel with this tutorial.may god always give you more knowledge to teach other people who cant afford.
I am very happy, because I found your video and I learn many things , Thank you
one of the best exel teacher.thank you sir
Thank you So Much I always thought excel was difficult, but your tutorial enlightened Me and taught Me again Thank You
Really appreciated your tutorial, you were cogent and easy to follow. I'm about to graduate with my BA but I've never had to work with excel so this is really helping me out.
Great tool for learning powerful new tools in Ms Excel 2016. Great for me as a doctoral student
You are the best! Excellent teacher.
thank you Sir for all these tutorial that helps people alot to study and learn more
SIR THIS IS A GREAT LECTURE.SO HELPFUL.
Sir, you are a great Professor! Thank you very much!
Chanced upon your tutorial and really like it! Just love the fact that you have practice work sheets too!
Hallo dear..I am currently learning about excel and I use this video to learn. Could you please tell me where I can find the practice worksheets that is said to be uploaded. Many thanks in advance :)
Very useful for my education, thanks
You are a very awesome man for putting this stuff online.
Thank you Sal. wonderfully done.
Thanks.
Honor be to my master of all seasons, God bless you my dear... From united Arab Emirates
Thank you💚 ...this video made me more confident to work with excel as i avoided it years because felt that it is too complicated for me ..but not any more ..really enjoyed it 👍🏻 .. i finished this one and word .still remaining access as new learner and refresh my memory for powerpoint ..thank you 💚💚
Thank you Sali , you have done a great job by bringing a new tutorial on Excel 2016 and the way you have explained each topic its amazing. I am going through step by step and also writing my own notes to clarify. some topics and download file are not in sequence but its okay, You have not missed any thing. Thumbs up.
The screen turns into mini size after 32:56. But great teaching and your materials with the added notes added in is amazing!! Thank you.
Wow that was a long one! Thank you very much!!. I'm useless at maths and excel in the workplace is scary so you made it alot easier!.. Tania
+tankersmit Thanks for the feedback. Glad you found it helpful.
I always want to grow in experience and knowledge. Thanks for these videos!
Hello Sir,thank you so much for such wonderful efforts...I always believe that educating others is a divine act which God loves to the core & it indeed is a real tool to uplift the society.You are not just teaching but you are serving for the humanity...May the Peace & Blessings of The Almighty be upon you...! Jaza'kallahu Khairan!
Fantastic video!
Thank you!
Thanks a ton for providing such an excellent learning platform.like to see more from you.
so great and important. i have gotten more than i wanted thank you sir
Thank you for your awesome teachings, easy and transparent.
+Denny Chow Thanks.
very clear and friendly to all beginners. nice work!
Thank you so much for taking the time to post this video! So helpful!
This vid is fantastic. So easy to follow. Thank you.
I love your lecture...please do you have this kind of training on Microsoft Access? You are one the best teachers I have found so far
Excellent tutorial. Thanks Sir. Your a very good teacher/instructor.
Thank you for ur useful videos Sir . I just finished watching the full tuturial and it was Great thank you again Sir . And I'm missing something else how to Calculate Tax..
Best tutor ever! Thank you, Sali
Thank you so much for this tutorial. I really appreciate this free learning tool.
thanks. you have taught me a lot.
You are awesome! Thank you so much. I am learning so much with you.
Hey man. This is Jason Wooten. Been a long time. Glad to see you are doing well.
Thanks!!!
Have been wanting to upscale my Excel skills for a long time and this was very helpful and well made!
Now I just hope I'll have to use what I learned soon or else I'll forget it!
Excellent job! Very helpful tutorial/guide. Thank you very much for your generosity and help and love for sharing this knowledge.
I found the data file. Thankyou so very much sir. Thankyou! Thankyou!
Sounds good. Glad to hear that.
Dear sir, simply amazing,very informative.Thanks a lot.
Thanks for this very comprehensive Excel 2016 tutorial sir.
Hello Sali Kaceli, your views are helpful.
But there's an issue, at 32:45 the video screen becomes Tiny, quite difficult to see.
Hi,
Sali Kaceli, Thank you so much for providing this amazing course. It really helps everyone, not for only advance, but beginners as well.
I was wondering if you can get chance to add one 30 minute video about Microsoft Access. Your 30 minute of excel, was amazing and most helpful TH-cam Clip I ever see.
Thank you
hey I just loved ur tutorial I'm in 10th grade and is very useful for projects. Never knew how to use excel before
Thank you for this really informative video. Macros are so handy!