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 1 of 2 of the Excel Tutorial. For more info. visit http://learn.kaceli.com. 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.

Link to Excel 2016 Part I Tutorial: https://youtu.be/xUM-GvJwTrw

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

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/

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

Keep in touch:

Website: http://kaceli.com

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

If you want to take get a deeper understanding of Microsoft Access, 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.

Amazon Auto Links: No products found.

Great tutorial!

Thanks! Very helpful.

Great Refresher course!…Thanks a million

Thank you so much Sali, you’re a great teacher!

Excellent way of teaching

TA

thanks learned a lot

Thank you sir for sharing us your idea on how to use Excel and you are a great teacher, thumbs up 🙂

thanks for sharing, in the midst of watching. It’s very helpful!

tnxs sir , ur video is too good to learn it very fast within a single hour .

you r the best tutor tnxs to save my money and time

Thanks for the tutorial Mr Kaceli.

I found it very informative, easy to follow and well structured.

DOPE, THANKS ALOT SALI KACELI

heaps good.

Awesome!! This has helped me tremendously

Lovely underestimated the tutorial initially because I thought I am above average in the use of excel but was wrong and i have refer fellow colleagues in the office. Thanks Sali

Excel 2016 for Mac doesn’t seem to have quick analysis…

If I had to recommend only one Excel tutorial for someone to watch, I would recommend yours. It is so well organized and clearly presented. Thank you so much! After this much-needed brushup, I feel very confident going into my job interview tomorrow. Please keep making tutorials!

thanks for saving me with your video. I tried creating a chart with two columns out of 3. just the way you did test 1 and test 3, But it’s highlighting all the 3 columns

Thank you. I have to say this is the easiest excel teaching video I have ever seen

Will be nice to not feel guilty having Excel under my IT skills on my cv from now

very helpful and thank you very much.

I was wondering though, Can I send you an excel spreadsheet that was created and explain how it was done?

Thank you so, so much for this! Finally excel starts to make sense to me and I agree with previous comments, you truly are a wonderful teacher 🙂 Again, thank you.

one of the best Excel tutorials I have ever seen .. 🙂

Very useful thank you very much!

Does the flash fill work on Excel 2007.

So extremely helpful. Structured really well too. Great pace too. Thank you!

u are awesume

This has been great so far. Ive built a budget, after a month, my thinking has become more innovative. I always talk about excel now. Great video and I will be continue to watch your tutorials.

Why is it when i drag from c15 to f15 i get hash tags # ?

Awesome tutorial! Thank you so much! What a great teacher! If you can, please teach in a university! I will register for your class!

thank you sooo much! My degrees were qualitative so never really used Excel.. Have an interview tomorrow and was worried but after watching this I feel better..

you are a wonderful teacher. through you i can proudly say i know excel basics . thanks a lot sir.

very informative.

kindly assist with the download link to the excel workbook you are using in the tutorial.

Thank you very much Sir.

it’s a great idea to do this video to make us learn once again thanks

Where is the link to download the workbook to follow along? I’m on my phone so that could be the problem also.

this is useful but link please part 2

Thank you very much you are a good tutor you explained it very well.

Very detailed instructions! Thank you so much!!!!

Thanks a lot for sharing. it was very helpful

Great Step by step

Thank you for you time. Nicely done.

Thank you for making this great video. It is very helpful.