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.
Excel Tutorial For Beginners: • Excel Tutorial For Beg...
Top 30 Excel Tips & Shortcuts:
• Top 30 Excel 2016 Tips...
_________________________________________
Excel - Statistics - Mean, Median, Mode:
• Statistics - Excel
Excel Scatter Charts:
• How To Make a X Y Scat...
Excel - Finding Slope & Y-Intercept:
• Excel Basics - Linear ...
Solving Polynomial Equations - Goal Seek:
• Solving Polynomial Equ...
__________________________________________
How To Calculate Loan Payments In Excel:
• How To Calculate Loan ...
How To Create an Amortization Table:
• How To Create an Amort...
How To Look Up Customer Data In Excel:
• VLookUp - How To Extra...
How To Create a Data Entry Form In Excel:
• How To Create a Data E...
_________________________________________
KZread Channel Growth Accelerator:
/ youtubechannelgrowthac...
Algebra For Beginners:
www.video-tutor.net/algebra-f...
Final Exams and Video Playlists:
www.video-tutor.net/
Full-Length Math & Science Videos:
/ collections
_________________________________________
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:
audiojungle.net/item/heroic-o...
Пікірлер: 70
Final Exams and Video Playlists: www.video-tutor.net/ Full-Length Math & Science Videos: www.patreon.com/mathsciencetutor/collections
My God just how smart this guy is 😮 Tackling all the possible topic there is XD
@threeaxis359
3 жыл бұрын
I know this young man is amazing
If you start to teach code I will give you everything :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!!
@humphreychibesa5393
3 жыл бұрын
sure thing mama
@RayMarlonHormachuelos
4 ай бұрын
Absolutely true.
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.
@hiphipjorge1822
4 жыл бұрын
i have a calculus channel , feel free to suscribe
@rapianopenaldo1669
2 жыл бұрын
@@hiphipjorge1822 no
@lgnobil
2 жыл бұрын
@@rapianopenaldo1669 spoiler: it did work.
@cherryclorox7717
Жыл бұрын
Absolutely
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.
You sir, are the GOAT.
Please never stop making these videos
I'm freaking speechless. this channel is amazing
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.
Thanks for this concise easy to understand tutoring.
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 🙌
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.
Thanks, very helpful. Looking forward to have tutorial on Pivot table and Macro as well.
Wow. How Genius you are! I wonder what you are doing in real life. This is deeply appreciated Mr. Julio G.
Appreciate you! Thanks so much! Great help👍🏽
I have learned a lot from you. Thanks so much.
Thank you for helping me get through college
Thanks for your information, do you use autocad ,
Best video out here on KZread.
I love ❤️ your channel! Thank You 😊
Really the explanations are understandable, I beg u also get me for digital electronics
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?
splendid work
Hello Sir, Can You Make Some Videos On Digital Fundamentals.. Logic Gates, Boolean Expressions, Flip-Flops ETC
always the best!
Thank you!!
you are the best.
Thank you. 🙂
You're a God sent
very nice tutorial sir
Thank you so much..
Are these applicable too for google sheets?
I appriciace you deeply.
Very helpful
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
Thanks
Would you please help where I can practice this?
When he clicks and drags the cell to make it bigger or smaller you can double left click and excel will auto set the with based on the cell with the greatest amount of letters.
why vlookup function doesn't work with my pc though I followed you?
In Basic Division you have entered the formula B3/D3 but you said 15 divided by 97 i.e B3/C3....thats where i got confused and rechecked by using Excel....otherwise very informatic video....thanks a lot for sharing the information.
nice job. please share the file
Hi Mr. OCT (don't know your name, sorry, not being snarky), I love your videos concerning Excel! I have tried other courses, but yours are easier to understand and your examples are great and so useful! It would be so great to have all those tips and tricks on a DVD, for times when I can't get online for whatever reason. I have already put the "VLOOKUP" function w/ Drop down list to good use in the classroom I work in (I work with Special Needs High school students) I used it to create a list of student information that the teacher can search and print out the information.
@Ahzarail
11 ай бұрын
His actual name is Julio Gonzales.
#271 hello my friend 🤟🤘👍👍👍 good video
great video although i feel the music could be lightly less loud. just slightly.
@TheOrganicChemistryTutor
5 жыл бұрын
I'll keep that in mind.
@26d8
4 жыл бұрын
@@TheOrganicChemistryTutor :)
why textjoin doesn't appear in my excel?
23:00- first time stamp
Your name is Julio Gonzalez??
Thank uuu!! (I
The smartest guy I've ever known except God😌
Wow how many subjects are you good at??
@hidaayachannel2688
4 жыл бұрын
Everything 😂.. may Allah guide him to the straight path ( islam) if he's not a muslim. Walah i pray for him.
17:42
At least now we know his name :) Next step is face reveal :)
@26d8
4 жыл бұрын
what is his name?
@ojwanggeoffrey2770
2 жыл бұрын
Julio Gonzales
5:03 five years later today
I have 2 questions please: 1)God is there anything you don't know? 2)Will you marry me?!
@angelitae7294
4 жыл бұрын
😂
Comment 18. Idk how. Its more than 1 year old