Excel 2016 Tutorial: A Comprehensive Guide on Excel for Anyone

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 http://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: 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
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: 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.

Comments

Alina Podryhun says:

Thank you very much! It was really useful!

Johnny D says:

Starting my own company and your material has helped immensely!! Thumbs Up x 100, thanks!

Sanja Keresteši says:

The best teacher! Thank you. 😀

I G trudel says:

Thank you so much.

Gil says:

Sali you are an EXCELLENT teacher. Thanks so much!

joel montoro says:

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.

Uffepuffeify says:

Nice channel, trying to create a beginner channel for excel for Mac, in Swedish.
Is it ok if I borrow some ideas from you?

falangnoi roblox and more says:

this is a good vdo thx u are my theacher

Eveline Chin says:

To

rexford kwofie says:

Great tutorial God richly bless you, i have learn a lot.Thank you.

Ankit Poddar says:

PLS SHARE ME THE VIDEO FOR HOW TO DELETE EMPTY ROW BETWEEN EACH FILLED DATA TABLE USING IF FUNCTION

Vinay Kumar says:

ty

MrZX1409 says:

Is there anyway to actually get the real tutorial as I want to be able to bounce back and forth using your tabs?

Krishna Sowjanya Maddukuri says:

Too good video

Johann Hornigold says:

Thanks for this video. This helps me a lot.

Richard Penny says:

This is brilliant really helpful. Thank you

NoDokeFilms says:

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.

CrumbleCrumbs says:

Thank you so much for this tutorial. I really appreciate this free learning tool.

Rfmansoh Frimpong says:

cool stuff

INNANZ says:

why is nothing seen but black screen when you are teachin ’32:41 Learn about the Quick Analysis Tools in Excel 2016 thanks

CAREER MAKER says:

sir I really loved this video, and thank to you very much

Layeq l says:

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.

MiddleEast OliveMedia says:

Thank you so much for this tutorial…worth it..God bless you

Fnu Samir says:

thanks really appreciate it Sir, it helped me alot at work to solve my issues

Abdelrahman H.M says:

Thank you :))
Also , We have the same desktop background 😀

 Write a comment

*

Do you like our videos?
Do you want to see more like that?

Please click below to support us on Facebook!