Excel Tutorial 2016: Excel Part 1 of 2 - Beginner to Intermediate 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.

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:

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.

[LameOwl]

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!

[erinhammel]

After trying to follow tutorials with just music and no speaker, this was very refreshing and paced well. Thank you.

[sophiaenoch]

BEST YOUTUBE TEACHER. VERY CLEAR, PRECISE, AND SIMPLE TO UNDERSTAND. GOD BLESS YOU SIR, BLESS YOU ALOT

[robinc]

Thank you so much! I have found myself in the position to look for another job, and at my age, any additional tools to my skill set is a blessing!

[jazzzmo]

I love the fact that you have included a worksheet so I can actually DO these things and follow along hands-on instead of just watch you do it. It helps me commit it to memory better. Thank you!

[manamiemyr]

hands down, one of the best 58 mins spent in my life. Great explanation too.

[susans]

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

[babyharrison]

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

[mohanytube]

thank you very much !!
26:45 Autocorrect options is also available in excel 2007 for auto calculating the column.
office button -> excel options -> proofing -> Autocorrect options -> Autoformat as you type -> Automatically as you work.

[creatorsservant]

Just wonderful! This guy is an excellent instructor! I needed him instructing me in my Medical Office class. Wonderful instructor. He makes it so easy to understand. I've learned more in this particular video than I've leaned in a month of regular training in the technical school that I've attended.

[ruohuili]

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

[hilalsekmen-ferhatovic]

Very simple, clear and useful tutorial. Even though it lasts for an hour, it does not bother or bore you. Yet, dividing the tutorial within the video by given description belove even makes it simpler. Learned a lot and will watch the next one as soon as possible. Thanks!

[Jashi_Kholin]

I have an office interview on Monday, and I wanted to be prepared. I definitely feel prepared after watching this. Thank you!

[dudewasteyourtime]

I took a course in 2010 version and did't use office at all after, work did't require it. Now for my new job does, i was trying to get the sum of 3cells 2 of them simple addition but the 3rd was to be taken out of (subtract) to get total, i did it manual by using =(d4+d5-d6). Which fine for small sheets, but im sure theres a better way to do it. And by the way your video is making me confident enough to even show up for the interview. Big thanks & God bless

[pigeonblox]

I have tried many youtube ms office tutorials, yours is the best so far!

[shivamsharma]

Everything about this tutorial is so perfect. I knew nothing about excel but now i do ALOT.

[Shawnmyrelle]

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.

[iscoalmichael]

Ever since i have been watching excel tutorial I've never come across this impeccable tutorial before. However, i found this tutorial really enthralling and impactful for me and i would wanna take this opportunity to say a big thanks to you sir and keep it up.

[e.mushimiyimana]

Very nice. I had no excel skills and wanted to learn the basic. You really helped me. Thank you so much!

[aces]

Excellent video. Thorough articulated, broken down simplified means, understood each strp as the timing being impeccable to move from one subject to another.