Excel Tutorial 2016: Excel Part 2 of 2 - Intermediate to Advanced Tutorial

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.

Here is what is covered along with the times. The times might be a bit off. If someone is willing to update them, I can post them here.

00:05 Learn how to use Named References and Cross-sheet calculations in Excel 2016
1:02:29 Learn how to Calculate Percentages in Excel 2013 three types of calculations
10:23 Learn how to use Financial Functions such as PMT, IPMT, PPMT in Excel 2016
22:21 Learn how to use the IF statement and logical functions in Excel 2016
28:29 Learn how to use One Click Forecasting in Excel 2016
30:03 Learn how to use the new and modern charts in Excel 2016
31:43 Learn how to use Pivot Tables in Excel 2016
38:06 Learn how to use Data Gathering in Excel 2016
40:14 Learn how to use the new Financial Charts in Excel 2016
39:45 Learn how to use the 3D Maps and Data Visualization Exel 2016
43:41 Learn how to use the Freeze Panes in Excel 2016
45:11 Learn how to Set the Print Area in Excel 2016
47:33 Learn how to Encrypt and put a Password in a Spreadsheet in Excel 2016
48:14 Learn how to use data validation in Excel 2016
51:56 Learn how to link Excel Data to a Word Report
56:29 Learn how to import and export data in Excel 2016
58:47 Learn how to export an Excel file to PDF in Excel 2016

Keep in touch:

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.

[swolf]

Teaching style is fanastic and as a person that lears faster by both doing and listening to a lecture the approach you've taken for this has been extremely helpful. I reviewed both the access and excel videos so far and am now confident in my access skills where I had NONE before.

[Andyzm]

I wish all online tutorials were as great as this one, - so simple and easy to understand! Great job, Mr. Kaceli!

[iLykeCahrs]

Thanks for taking the time to make these videos, Sali. 5 years ago you had to pay for this stuff. With 2016 there is so much content out there for free we should all be power users. It is just a manner of finding an instructor that works for me. That is you. Thanks again for the content! Really, really appreciate it!

[murphydublin]

Thank you Mr. Sali Kaceli, your tutorial is more than to the sit-in class and with pay.

[michaellarry]

This tutorial have taught me a lot on the intermediate level of excel 2016. These formula's has help me manage my stores more efficiently.

[mrmajkl]

Thank you so much this is really best guide and you explain everything so clear that it saved my life and now I can be all proud at work :) This is exactly how tutorials should be like!

[lindaalberino]

You ARE a blessing...so patient, precise and insightful as to what our struggles may be with excel. This is the BEST tutorial out there...than you much!!!!

[Mlba]

Your directions are so vivid, I can simply comprehend your tutorial. Thanks a lot!

[unekwuojoanthonyotuwe]

I am most grateful for taking out time to educate the public. God bless u real good

[priscilanascimentomol]

Excellent material, thank you so much for that, defo the world needs more people like you

[georgemuyunda]

Excellent presentations and videos, straight sharp, clear and to the point. Great Job Sali. Thank you very much.

[katkaferjova]

Dear Mr. Kaceli, thank you so much for your Excel 2016 Tutorials. You can explain everything so easy, it is so clear...I will check my knowledge on the next job interview!

[aidangonsalves]

Great teacher, thank you very much for making Excel interesting and understandable 😊. This world needs more people like you!

[deblyk]

Your teaching style is wonderful. I look forward to your other videos as well. Glad to share them with others.

[WarwickYT]

Thank you so much for doing this. Very clear explanations of all these functions. Easy to follow for a total noob like myself. This is gonna come in handy in my first job after college!

[rainarclark]

You are such a Blessing! I really appreciate all your videos!!!!

[Jbluestoneful]

Everytime he says *tinker* I smile..really enjoying the vast amount of gems

[artmo]

amazing!!!! really clear, easy to learn! I wish you were my teacher in school.. thank you so so much for putting this together Sali.

[tammykaelin]

You are an outstanding instructor and provide the best tutorials. I hope to find many more by you. Thank you so much for sharing your expertise and in such an exceptional way.

[WinterLynCuento]

I have just started watching your videos and I have already learned so much from the first part of this tutorial. On this next part, I am even amazed how I can now do things better with my work tasks. You are so amazing. Your videos are done so excellently that anyone can truly learn easily.