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

  • @TheOrganicChemistryTutor
    @TheOrganicChemistryTutor3 ай бұрын

    Final Exams and Video Playlists: www.video-tutor.net/ Full-Length Math & Science Videos: www.patreon.com/mathsciencetutor/collections

  • @Cucumberick
    @Cucumberick6 жыл бұрын

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

  • @threeaxis359

    @threeaxis359

    3 жыл бұрын

    I know this young man is amazing

  • @matthewroelofse
    @matthewroelofse6 жыл бұрын

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

  • @26d8
    @26d84 жыл бұрын

    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

    @humphreychibesa5393

    3 жыл бұрын

    sure thing mama

  • @RayMarlonHormachuelos

    @RayMarlonHormachuelos

    4 ай бұрын

    Absolutely true.

  • @sam2026
    @sam20266 жыл бұрын

    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

    @hiphipjorge1822

    4 жыл бұрын

    i have a calculus channel , feel free to suscribe

  • @rapianopenaldo1669

    @rapianopenaldo1669

    2 жыл бұрын

    @@hiphipjorge1822 no

  • @lgnobil

    @lgnobil

    2 жыл бұрын

    @@rapianopenaldo1669 spoiler: it did work.

  • @cherryclorox7717

    @cherryclorox7717

    Жыл бұрын

    Absolutely

  • @LarryWallace-td2vx
    @LarryWallace-td2vx4 ай бұрын

    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.

  • @Y0ungPjay
    @Y0ungPjay3 жыл бұрын

    You sir, are the GOAT.

  • @emyeu6286
    @emyeu62863 ай бұрын

    Please never stop making these videos

  • @MrDmac1980
    @MrDmac19802 жыл бұрын

    I'm freaking speechless. this channel is amazing

  • @humphreychibesa5393
    @humphreychibesa53933 жыл бұрын

    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.

  • @nuraismail1146
    @nuraismail1146 Жыл бұрын

    Thanks for this concise easy to understand tutoring.

  • @NightWalker911
    @NightWalker9112 ай бұрын

    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 🙌

  • @agostinhoinocencio7013
    @agostinhoinocencio70132 жыл бұрын

    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.

  • @cchau17
    @cchau174 жыл бұрын

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

  • @abibuyog
    @abibuyog3 жыл бұрын

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

  • @Angie-oh6fp
    @Angie-oh6fp5 жыл бұрын

    Appreciate you! Thanks so much! Great help👍🏽

  • @khmerscenery
    @khmerscenery Жыл бұрын

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

  • @Sampson2024
    @Sampson20245 жыл бұрын

    Thank you for helping me get through college

  • @mwalimsefumrlightman5270
    @mwalimsefumrlightman52705 жыл бұрын

    Thanks for your information, do you use autocad ,

  • @animatedlife_
    @animatedlife_10 ай бұрын

    Best video out here on KZread.

  • @hanoramicview9054
    @hanoramicview9054 Жыл бұрын

    I love ❤️ your channel! Thank You 😊

  • @kibetcaleb86
    @kibetcaleb864 жыл бұрын

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

  • @dragonsKeeper210
    @dragonsKeeper2103 жыл бұрын

    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?

  • @milelekaziya5465
    @milelekaziya54652 жыл бұрын

    splendid work

  • @francisrpaul
    @francisrpaul6 жыл бұрын

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

  • @annica3288
    @annica32883 жыл бұрын

    always the best!

  • @nataliae9229
    @nataliae92293 жыл бұрын

    Thank you!!

  • @nyfiken8496
    @nyfiken84963 жыл бұрын

    you are the best.

  • @jessamynfinneran5036
    @jessamynfinneran5036 Жыл бұрын

    Thank you. 🙂

  • @sasukekun11907
    @sasukekun11907 Жыл бұрын

    You're a God sent

  • @Inspirational_Homes
    @Inspirational_Homes5 жыл бұрын

    very nice tutorial sir

  • @selmakilic1289
    @selmakilic12893 жыл бұрын

    Thank you so much..

  • @rafjasmin1161
    @rafjasmin11614 жыл бұрын

    Are these applicable too for google sheets?

  • @keziathomas4459
    @keziathomas44595 жыл бұрын

    I appriciace you deeply.

  • @natynt227
    @natynt227 Жыл бұрын

    Very helpful

  • @kacperm.5127
    @kacperm.5127 Жыл бұрын

    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

  • @WaqasAhmed-om8ph
    @WaqasAhmed-om8ph6 жыл бұрын

    Thanks

  • @kabouch
    @kabouch3 жыл бұрын

    Would you please help where I can practice this?

  • @threeaxis359
    @threeaxis3593 жыл бұрын

    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.

  • @annica3288
    @annica32883 жыл бұрын

    why vlookup function doesn't work with my pc though I followed you?

  • @assasinguyleoo
    @assasinguyleoo Жыл бұрын

    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.

  • @ubaidillahmuhammad20
    @ubaidillahmuhammad204 жыл бұрын

    nice job. please share the file

  • @Teacherman1955
    @Teacherman19555 жыл бұрын

    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

    @Ahzarail

    11 ай бұрын

    His actual name is Julio Gonzales.

  • @user-wc8vn9tw9f
    @user-wc8vn9tw9f3 жыл бұрын

    #271 hello my friend 🤟🤘👍👍👍 good video

  • @metaldudeA7X
    @metaldudeA7X5 жыл бұрын

    great video although i feel the music could be lightly less loud. just slightly.

  • @TheOrganicChemistryTutor

    @TheOrganicChemistryTutor

    5 жыл бұрын

    I'll keep that in mind.

  • @26d8

    @26d8

    4 жыл бұрын

    ​@@TheOrganicChemistryTutor :)

  • @annica3288
    @annica32883 жыл бұрын

    why textjoin doesn't appear in my excel?

  • @spinach7205
    @spinach72053 жыл бұрын

    23:00- first time stamp

  • @Aa-cq1ue
    @Aa-cq1ue2 жыл бұрын

    Your name is Julio Gonzalez??

  • @katrinaasa8725
    @katrinaasa87257 ай бұрын

    Thank uuu!! (I

  • @akolangto8225
    @akolangto82253 жыл бұрын

    The smartest guy I've ever known except God😌

  • @sleverlight
    @sleverlight4 жыл бұрын

    Wow how many subjects are you good at??

  • @hidaayachannel2688

    @hidaayachannel2688

    4 жыл бұрын

    Everything 😂.. may Allah guide him to the straight path ( islam) if he's not a muslim. Walah i pray for him.

  • @liliana44119
    @liliana44119 Жыл бұрын

    17:42

  • @AyunaBudaeva
    @AyunaBudaeva5 жыл бұрын

    At least now we know his name :) Next step is face reveal :)

  • @26d8

    @26d8

    4 жыл бұрын

    what is his name?

  • @ojwanggeoffrey2770

    @ojwanggeoffrey2770

    2 жыл бұрын

    Julio Gonzales

  • @lucasemanuel8305
    @lucasemanuel8305 Жыл бұрын

    5:03 five years later today

  • @quinnpan8985
    @quinnpan89854 жыл бұрын

    I have 2 questions please: 1)God is there anything you don't know? 2)Will you marry me?!

  • @angelitae7294

    @angelitae7294

    4 жыл бұрын

    😂

  • @a2kvarnstrom80
    @a2kvarnstrom804 жыл бұрын

    Comment 18. Idk how. Its more than 1 year old