Top 30 Excel 2016 Tips, Tricks, Shortcuts, Functions & Formulas

The Top 30 Excel 2016 Tips and Tricks. This video contains plenty of shortcuts, functions, and formulas that you'll encounter when working with excel.

Top 30 Excel Tips & Shortcuts:

_________________________________________
Excel - Statistics - Mean, Median, Mode:

Excel Scatter Charts:

Excel - Finding Slope & Y-Intercept:

Solving Polynomial Equations - Goal Seek:

__________________________________________
How To Calculate Loan Payments In Excel:

How To Create an Amortization Table:

How To Look Up Customer Data In Excel:

How To Create a Data Entry Form In Excel:

_________________________________________
YouTube Channel Growth Accelerator:

Algebra For Beginners:

Final Exams and Video Playlists:

Full-Length Math & Science Videos:

_________________________________________
1. Excel AutoFill Tutorial 1:53
2. Flash Fill 6:00
3. Quick Save Shortcut 7:09
4. Quick Print Shortcut 7:31
5. New Workbook Shortcut 7:54
6. Concatenate & TextJoin Functions 9:00
7. Text To Column 12:05
8. Transpose Columns to Rows 14:08
9. Sorting Data 16:30
10. Filtering Data 18:40
11. Freeze Rows and Columns With Freezepanes 20:15
12. Extract Text From Cells Using The Left, Mid, and Right Functions 22:36
13. AutoSum Function 25:06
14. The Average Function 26:26
15. Count, CountA, & CountBlank Functions 27:33
16. Basic Math Operations - Addition, Subtraction, Multiplication, Division, Exponents, & Square Roots 29:55
17. Basic Statistics - Max, Min, Median, Mode, & Standard Deviation Functions - 33:32
18. Show Formulas - 37:09
19. Excel VLookUp Function - 38:32
20. Drop Down List With VlookUp - 42:46
21. Shortcut Keys - Bold, Italicize, Underline & Strike through 44:17
22. Insert Line Break Shortcut 45:23
23. Autofit Column Width 46:34
24. Insert Rows and Columns 47:12
25. Moving Rows and Columns 47:48
26. Find and Replace Tutorial With Shortcut Key 49:00
27. Lowercase, Uppercase, & Proper Functions 50:27
28. Excel Calendars 52:01
29. Conditional Formatting 54:05
30. Line Graphs & X Y Scatter Charts With Trendlines and Slope-Intercept Equations Plus The Forecast Function 55:40

Music Track Link:

[Cucumberick]

My God just how smart this guy is 😮 Tackling all the possible topic there is XD

[matthewroelofse]

If you start to teach code I will give you everything :D

[sam]

I like how he's more or less producing videos that will gain views over time not just in the moment. People could be watching these in ten years like how people still watch some of the original 2008 khan academy videos. It's a brilliant plan and it'll work out long run.

[d]

the best tutor ever! I hope you get everything you want from life, you are by far much better than any professor I've ever had!!

[LarryWallace-tdvx]

This Excel tips and tricks video is a real gem. The The tutorial breaks down complex functions into easy steps. I love how it makes it so practical – I've learned things that are making my spreadsheet work way smoother.

[humphreychibesa]

May God be with you man.Honestly most of the times in university i fail to keep up with the pace but you are always being of help.You are a versatile genius.how does your face look like.I enjoy Indians and surprisingly you are among the best , those who can teach.

[nuraismail]

Thanks for this concise easy to understand tutoring.

[MrDmac]

I'm freaking speechless. this channel is amazing

[agostinhoinocencio]

you have been helped a lot on math now you came to excel who i am to not joining you
The best teacher I have ever seen. I don't know what to say, thank you so much.

[NightWalker]

Loving the simplistic videos. Basically helped me understand what I've learnt much better, and also given me many ideas to use for my assignment. Can't thank you enough 🙌

[khmerscenery]

I have learned a lot from you. Thanks so much.

[abibuyog]

Wow. How Genius you are! I wonder what you are doing in real life. This is deeply appreciated Mr. Julio G.

[Angie-ohfp]

Appreciate you! Thanks so much! Great help👍🏽

[cchau]

Thanks, very helpful. Looking forward to have tutorial on Pivot table and Macro as well.

[Sampson]

Thank you for helping me get through college

[kacperm.]

35:33
=median() doesn't require sorting data first.
It does it automatically.
Particularly useful if you're filling data over time and want =median() keep updating so you can monitor the changes

[kibetcaleb]

Really the explanations are understandable, I beg u also get me for digital electronics

[dragonsKeeper]

I’m currently not Microsoft excel certified but I’m a student who needs to get his excel certification soon. My question is whether you are Microsoft excel certified and if so, could you do a list of what to look out for and prep for the certification exam?

[mwalimsefumrlightman]

Thanks for your information, do you use autocad ,

[francisrpaul]

Hello Sir, Can You Make Some Videos On Digital Fundamentals.. Logic Gates, Boolean Expressions, Flip-Flops ETC