A comprehensive tutorial on Excel 2016 covering most essential features for business professionals, students or anyone that wants to learn how to use Excel. This is part 2 of 2 of the Excel 2016 tutorial. The concepts covered here apply also to previous versions of Excel such as Excel 2013, 2010 and 2007. For more info. visit http://learn.kaceli.com.

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.

Microsoft Excel 2016 Tutorial URL: https://youtu.be/8lXerL3DHRw

Microsoft Excel 2016 Tutorial Part I: https://www.youtube.com/watch?v=xUM-GvJwTrw

Microsoft Excel 2016 Tutorial Part II: https://youtu.be/-wJBzxefr8k

The Quick Guide for Excel 2016 along with the data files to follow along are available from here: http://kaceli.com/excel-2016-data-file/

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:

Website: http://kaceli.com

YouTube Channel: http://youtube.com/skaceli

If you want to take get a deeper understanding of Microsoft Office applications, take a look at http://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.

**Price:**~~$36.56~~ $32.99

#### Excel 2019 Bible

(as of October 24, 2020 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)**Price: $18.99**

#### Excel 2019 All-in-One For Dummies

(as of October 24, 2020 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)**Price:**

#### Microsoft Office Home and Student 2019 Download 1 Person Compatible on Windows 10 and Apple MacOS

One time purchase for 1 device, PC or Mac System Requirements Windows 10 or Mac OS X Office for Mac is supported on the three most recent versions of macOS. When a new version of macOS is released, the Office for Mac Operating System requirement beco... (as of October 24, 2020 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)**Price: $4.99**

Hi It is very good to learn but How to download your data in our system.

Good one. Easy to understand.

Thank you.

Thank you so much for the videos, you are a good teacher, pls upload more videos on excel 2016 🙂

Nicely laid out and understandable presentation!

I tried watching other vodios for exel but none were as good as yours

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!

i have learnt allot and shared it with my friends,

May God bless you with these efforts.

This the most useful video I’ve seen on youtube.Thank you so much

Thank you sooo much. Your videos have simplified Excel for me so much.

made it easy to understand and follow.Want more video from this outstanding man on Vlookup etc…

26:14

this is my best teacher ever ,i ve learnt a lot ,based in east africa, thank you Sir God Bless u!

Great tutorial sir, 100% recommended.

i am very appreciate and impressed all videos and thankful i learned a lot no need waste lot of money

Thank you Sali. Your videos are very informative

glad i found this <3 thanks

can you please make a tutorial for visual basic!! thank you!!

Remarkable tutorial! Thanks so much for posting!

Thank you sir!! It helps me a lot. I can’t find forecast sheet in my data tab, where can I get the tool?

28:14 if you get the error ######, resize the cell.

Sir, could you tell me, how to create tertiary vertical axis (3rd y axis) in Excel Graph through overlay or other method, could you please upload a tutorial video regarding this, Thanks

HI Can you please teach me how to compare the data between two wordbooks?

Extremely useful. Thank you

Thanks Mr Sali, am glad for your work. Is their comprehensive microsoft access 2016 part 2 of 2 please?

Thank you very much.

very valuable Tutorial.

You are just amazing .. Thanks for everything

I am watching but he is making me to fall asleep!

How do you select all the data instantly like you do at 45:45?

34:11 How u select the whole table so quickly? I cant’t do it.

Thanks

You are an amazing teacher. Very clear. easy to follow. Thank you!

very useful, really appreciate it

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 !

Sir, I stopped that auto fill feature(that yellow spark button in MS excel 2016) and now I don’t know how to start it again.

Sir, please help and thanks for these awesome videos.

Tweek it and tinker with it!

I’m asfiya and I’m nine years old and I really aprecieate you!!!!!!!

Great tutorial…clear explanations. Thank you!

nice post

Best tutorial ever for excel

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!!!!