Excel 2016 Tutorial: A Comprehensive Guide on Excel for Anyone

Поділитися
Вставка
  • Опубліковано 31 гру 2024

КОМЕНТАРІ • 402

  • @KaceliTechTraining
    @KaceliTechTraining  2 роки тому

    Computer Skills for the Workplace - 12 hours of Training is now available: ua-cam.com/video/hPEgaVN1Mpg/v-deo.html. It covers Word, Excel, PowerPoint, Outlook and Windows. One of the longest UA-cam training tutorials. 12 hours of free training.

  • @Kindred.Lines.Genealogy
    @Kindred.Lines.Genealogy 8 років тому +76

    I am an unemployed 50-year old mother and this will increase my value for any potential employer. Thank you so much.

    • @reddnebbula
      @reddnebbula 8 років тому +4

      It will? Wow.

    • @ilovecatsijustlovecats3944
      @ilovecatsijustlovecats3944 8 років тому +4

      Ditto 50 yr old divorced empty next woman. Need to learn Excel to get a good data processing job

    • @fireplace330
      @fireplace330 8 років тому +1

      Michelle Green Ayers

    • @sonofJurell
      @sonofJurell 7 років тому +4

      Good luck. The thing about IT that is different from other industries is that if you have the skills you usually get hired. As gender, race and age are deemed much less relevant-at least less so than other industries.

    • @peace4all87
      @peace4all87 5 років тому

      Wish you all the best ..yes you can learn what you want and get the job 😊 im 31 and i was told to improve my skills in typing and excel i found this channel and it is helping..so excited to show them at new job that i can learn faster than they expected .

  • @daddyamira
    @daddyamira 8 років тому +2

    You are really a source of learning..Thank you sir.

  • @vasilicasandutu1343
    @vasilicasandutu1343 8 років тому

    Hello Sali,it's nice to meet you. I have to admit that I needed so badly a tutorial like yours,and you just saved my day. I searched all around,but everywere you have to pay for the courses in the beginners area too. I just have a new job,wich takes good Excel skills and the Director gave me a chance to prove that I can learn to use this wonderful program.Usualy I don't use a youtube account,as I don't write comments oftenly,but I just opened my account to write you BIG THANKS! Not many peoples are willing to spend their time trying to learn others. You have all our RESPECT for having the patience to help us reach the job we want. Thank you an infinite times for your tutorials,carefuly made for everyone.

  • @bajramkaceli9953
    @bajramkaceli9953 8 років тому

    Te lumte Sali Kaceli.Faleminderit per gjitcka.

  • @CharoBorboa
    @CharoBorboa 7 років тому

    We really appreciate the value of this tutorial. We are having a pool installed and we need to pay a certain percentage at the completion of several points of the project, down payment 60%, 15%, 15%, 10%. This has helped me manage my budget and learn how to incorporate percentages in excel without having to do it on a calculator the old fashion way. I can also use your methods to follow my credit card bills, and monthly budget and savings. Yay, it's time to play with excel! Thank you!

  • @viviennecuriel9262
    @viviennecuriel9262 6 років тому +2

    Dear Mr. Kaceli; I happened to find your Tutorials on UA-cam just now! Thank you for assisting ALL of US! I used Excel for College Report Cards a few years ago, but now I forgot. =( .....I guess it's true: Use it or Lose it! I have the whole MS Suite on my home computer, so I will make this my latest Mission! That's correct: You are a Blessing to all of us! For Sure!
    And thanks to All the Bloggers! It takes a Village! =) God bless all of You!

  • @tinaobrien1828
    @tinaobrien1828 7 років тому

    I got the "Excel for Dummies". Took weeks to get through the first 100 pages....I watched this video a time or two and within days am doing spreadsheets like a pro. Thank you....excellent tutorial!

  • @samanthakidd7600
    @samanthakidd7600 4 роки тому

    This is so helpful. Thank you so much Mr. Kaceli.

  • @jesperehopeman3111
    @jesperehopeman3111 6 років тому

    there was no much speculation. right away into the course with details. made me subscribed. Thank you for this great teaching.

  • @dianeryan5700
    @dianeryan5700 7 років тому

    You are doing a great job. I have been listening to many of your videos. I am learning so much. I am taking classes at the university on computers but I am learning so much more with you.

  • @kendrick10601
    @kendrick10601 7 років тому

    Thank you Mr Kaceli for making these free, they are by far the most complete tutorials and well explained. Where I study, a course like this one is worth well over 120$.

  • @verakutikov6842
    @verakutikov6842 5 років тому

    Absolutely fantastic and easy to follow videos. Very happy to find you and follow your tutorials. Thank you for your time and desire to sharing your knowledge with others.

  • @carmenr7240
    @carmenr7240 8 років тому

    Oh my God!! You are an excellent teacher. I can not believe that your tutorial is way better than the professional video training that I bought thru amazon. I really regret buying the professional video that does teach as well as you do. Great Job!! Thanks a bunch.
    You are a life saver!!

  • @kelvinkalama7391
    @kelvinkalama7391 6 років тому

    You are a blessing to the million of us.

  • @danamclemore3805
    @danamclemore3805 8 років тому

    LOVE the way you explained "absolute reference"
    Extremely helpful.

    • @KaceliTechTraining
      @KaceliTechTraining  8 років тому +1

      Thanks.

    • @stefanijarandjelovic7732
      @stefanijarandjelovic7732 7 років тому

      Ser, your tutorial is excellent. Thank you. I have a question regarding absolute reference. I can type "$" manually and it works, but when I pres F4 nothing happens. How do i fix it?

    • @KaceliTechTraining
      @KaceliTechTraining  7 років тому

      Stefanija Randjelovic Most likely your FN (function keys) are configured to perform different functions other than the regular ones. you may need to press another key combination to activate the function keys. Some computer manufacturers do that.

    • @stefanijarandjelovic7732
      @stefanijarandjelovic7732 7 років тому

      Sali Kaceli Thank you very much. I will try different key combinatiins and see what happens. All the best.

  • @in1235
    @in1235 7 років тому

    Thank you so ,much for being so kind and teaching me for free. Your videos are really helpful.

  • @bookworm8368
    @bookworm8368 2 роки тому

    This was super easy to learn! Thanks for the advice, Mr. Kaceli

    • @KaceliTechTraining
      @KaceliTechTraining  2 роки тому

      Glad you found it helpful. Thank you Michael for the feedback.

  • @michaelblake7164
    @michaelblake7164 6 років тому

    You are the best! Excellent teacher.

  • @subhayanist
    @subhayanist 4 роки тому

    The style of teaching is very good.

  • @yasminealshobaki8252
    @yasminealshobaki8252 8 років тому +4

    i always thank god for a people like you , you made my life much easier, loved your work loved your channel
    god bless you.

  • @priyankabaniya6543
    @priyankabaniya6543 8 років тому +30

    Sir I always wanted to learn formulas but few videos made it so confusing that I completely lost interest. I was just scrolling and came across your video. Its so professional and easy to understand. Your voice is so calm and evenly paced which makes it easier to understand. The best part is that you have focused mostly on basics because you understand that if your basic concepts are clear advance will be understood better. If you could email me and please let me know what other technologies you teach and where you teach. You are an awesome teacher. I am so glad I found your video.

  • @CricketWithHarris
    @CricketWithHarris 5 років тому

    best tutorial..really helped me..especially the worksheet file provided in the description really helps. hats off to you sir

  • @johnvincentparas5728
    @johnvincentparas5728 4 роки тому

    This was a great tutorial for excel 2016. Better than every other tutorial I tried. Props to you Sir Kaceli! Thank you.

  • @chutatipwattana399
    @chutatipwattana399 3 роки тому

    thank you. This is so clear and helpful. I learned a lot from this video

  • @gjonesii
    @gjonesii 7 років тому

    Sali you are an EXCELLENT teacher. Thanks so much!

  • @missafrica3480
    @missafrica3480 8 років тому

    haven't used excel since 2008 needed the refresher, thanks so much. This is beyond helpful

    • @KaceliTechTraining
      @KaceliTechTraining  8 років тому

      +Dionna Cook Yes, there are some new features in Excel 2016 that are pretty cool as you probably saw. Glad you found it helpful.

  • @shewadegwondiche3125
    @shewadegwondiche3125 5 років тому

    Mr. Sali Kaceli, I have no enough words to say thank you for your marvelous way of teaching. I also overwhelmingly admired your generosity that you have shered people your talent and knowledge of Microsoft office software for free of charges. Specifically I have enjoyed the comprehensive Ms excel 2016 modules that is posted on youtkube. I wish if I have had gotten this oportunity long before that could enhance my Ms excel skill in a way extending my operating profession.

    • @KaceliTechTraining
      @KaceliTechTraining  5 років тому

      Thank you for the feedback and glad you found it helpful. I am also working on Excel 2019 Office 365 from here: ua-cam.com/play/PLyy-LLqj7iSZfJUS4ZANp30rgSyKKotMt.html.

  • @paris8100
    @paris8100 8 років тому

    This has been super helpful - i'm putting a budget together for myself and came across this tutorial and have loved it!
    The way you explain it really makes sense and is helping me put my finances together. I don't have a numbers brain, i'm more of a words/creative sort of thinker so it doesn't come naturally to me.
    I have saved it as a book to refer back to in case my memory fails me.

  • @AKIPATIYA
    @AKIPATIYA 8 років тому

    Simple and elegant but comprehensive coverage. Keep up your good work. Thank you very much, Mr. Kaceli.

  • @RajeshPatel-of3qo
    @RajeshPatel-of3qo 5 років тому

    Thanks for great tutorial. Have not used Excel for over 6 years so a good refresher and also good tutorial to find out new features of Excel 2016.

  • @sinshooup
    @sinshooup 8 років тому

    Sali Kaceli: What an Incredible instructor! Your Excel 2016 Tutorial video is a great help for the beginner (or anyone) wanting to become proficient in Excel applications. Your calm, clear voice, pacing, visuals and presentation skills are exceptional. Thank you for providing help at such a critical time when I needed it most: for re-entering the job market!

  • @isaaccharlesfelix493
    @isaaccharlesfelix493 5 років тому

    This is the best tutorial I have come across so far. 5stars!!!

  • @philipatoll1889
    @philipatoll1889 7 років тому

    I thank you Sali for your tutorials.

  • @SuperZippy3
    @SuperZippy3 8 років тому +9

    really, really high level of teaching skills. It is a luxury for any platform to have videos like yours. Thank you again.

  • @azhar9203
    @azhar9203 4 роки тому

    you working great and very very helpful , thank you very much keep it up love from PAKISTAN

  • @monkmonk938
    @monkmonk938 8 років тому

    Thank very much Mr Sali Kaceli. You explain very well. Nice English. Nice accent. First time that I understand Excel very well and feel able to apply it in my Job. Best greetings and Best wishes from Africa.

    • @KaceliTechTraining
      @KaceliTechTraining  8 років тому +1

      +Monk Monk Hope you get the job that you are applying for. I have designed most of these tutorials for those that are looking to sharpen their skills for a new job and advance in their careers.

    • @echubi27
      @echubi27 8 років тому

      Thank you Mr Excel for the tutorial

  • @layeql9814
    @layeql9814 7 років тому

    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.

  • @maazilyt
    @maazilyt 7 років тому

    thank you soo much all your video are really valuable and anyone can understand your teach thank you for your gift knowlage

  • @officialshobhit
    @officialshobhit 8 років тому +49

    sir you are really great teacher, i really loved this video, and thank you soo much to get me this knowledge
    love you :D

    • @KaceliTechTraining
      @KaceliTechTraining  8 років тому +10

      +shobhit sharma glad that you found a video helpful. Thank you for the feedback.

    • @nanasabry2945
      @nanasabry2945 8 років тому +2

      👍👏👏

  • @mdabdulqader9415
    @mdabdulqader9415 5 років тому

    This is a life saver video . Thanks a ton !

  • @chloeperez8703
    @chloeperez8703 8 років тому

    You explained it well and simply easy to understand.

  • @safealaswas2001
    @safealaswas2001 7 років тому

    watching your videos is way better than watching a movie , thanks Professor

  • @babatundeilesanmi1658
    @babatundeilesanmi1658 3 роки тому

    Many thanks for this tutorial. God bless

  • @sydznl
    @sydznl 7 років тому

    The screen turns into mini size after 32:56. But great teaching and your materials with the added notes added in is amazing!! Thank you.

  • @HaydarShaykh
    @HaydarShaykh 6 років тому +1

    Thank you for this nice tutorial. Last ending modules were just simply amazing.

  • @natashagregory-michelman3877
    @natashagregory-michelman3877 8 років тому +1

    I found the data file. Thankyou so very much sir. Thankyou! Thankyou!

  • @wasimbader9170
    @wasimbader9170 9 років тому

    Thank you Sali , you have done a great job by bringing a new tutorial on Excel 2016 and the way you have explained each topic its amazing. I am going through step by step and also writing my own notes to clarify. some topics and download file are not in sequence but its okay, You have not missed any thing. Thumbs up.

  • @thetravelers_blog
    @thetravelers_blog 8 років тому +6

    wow sir sali Kaceli, you are really a great teacher... may God Almighty Bless you for your Good work sir

  • @clucious20091
    @clucious20091 8 років тому

    thank you very much me and my spouse will watch these little a day as if we are in class to update both of our resumes!

  • @lydiasmith5739
    @lydiasmith5739 6 років тому

    This tutorial was refreshing and easy to follow. I thoroughly enjoyed it. Thank you for keeping it simple.

  • @kentignal6891
    @kentignal6891 8 років тому

    very clear and friendly to all beginners. nice work!

  • @petea1uk
    @petea1uk 7 років тому

    This vid is fantastic. So easy to follow. Thank you.

  • @Saintderickabc
    @Saintderickabc 6 років тому

    so great and important. i have gotten more than i wanted thank you sir

  • @irfnkhn84
    @irfnkhn84 8 років тому

    SIR THIS IS A GREAT LECTURE.SO HELPFUL.

  • @natashagregory-michelman3877
    @natashagregory-michelman3877 8 років тому +1

    These videos are such an important resource. I am so grateful and appreciative. Not to repeat myself but I must say thankyou again Sir for your ability to teach this software and the subject so candidly.

  • @gfdg579
    @gfdg579 7 років тому

    one of the best exel teacher.thank you sir

  • @SAMEERKhan-nu7gf
    @SAMEERKhan-nu7gf 7 років тому

    thank you Sir for all these tutorial that helps people alot to study and learn more

  • @nodokefilms3518
    @nodokefilms3518 7 років тому

    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.

  • @joelmontoro8034
    @joelmontoro8034 7 років тому

    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.

  • @jasonwooten9860
    @jasonwooten9860 4 роки тому

    Hey man. This is Jason Wooten. Been a long time. Glad to see you are doing well.

  • @primedynamic3152
    @primedynamic3152 5 років тому

    Very useful for my education, thanks

  • @gwentownsend364
    @gwentownsend364 7 років тому

    Thank you So Much I always thought excel was difficult, but your tutorial enlightened Me and taught Me again Thank You

  • @pavlosgol1190
    @pavlosgol1190 4 роки тому

    Underemployed for a while, devoted 5 or more hrs with examples etc. Thank you is a small phrase, I am working for one of the big 5 international banks now, using Excel all day . Couldn't have been a more solid and condensed tutorial. Needs some hrs to make it your own, though.

  • @rottyangel770
    @rottyangel770 8 років тому +12

    Praise God literally for these videos. Thank you Sali!

    • @johanorre8203
      @johanorre8203 6 років тому

      Don't let this video distract you from the fact that John Lennon was a abusive women beater

    • @shushuyu
      @shushuyu 6 років тому

      All the credits goes to Sali why praise someone/something that have nothing to do with?

  • @isaacseg5652
    @isaacseg5652 4 роки тому

    Honor be to my master of all seasons, God bless you my dear... From united Arab Emirates

  • @msladytsunade777
    @msladytsunade777 8 років тому

    In the Quick Analysis section 32:42 to 35:43, in the data file under the Quick Analysis tab there's a link that says Learn More and a page will pop up for that lesson. Will check it out, hope it helps.

  • @sepidehniknia6977
    @sepidehniknia6977 6 років тому

    I am very happy, because I found your video and I learn many things , Thank you

  • @radostinadimova3748
    @radostinadimova3748 6 років тому

    Thank you so much for taking the time to post this video! So helpful!

  • @saeedahmad3047
    @saeedahmad3047 7 років тому

    Dear sir, simply amazing,very informative.Thanks a lot.

  • @belladavis5657
    @belladavis5657 7 років тому

    Thank you for this really informative video. Macros are so handy!

  • @realvirtualdemand4222
    @realvirtualdemand4222 6 років тому

    I always want to grow in experience and knowledge. Thanks for these videos!

  • @jamalmefleh3832
    @jamalmefleh3832 7 років тому

    amazing tutorial Mr. Sali, well done .

  • @juliane1mota
    @juliane1mota 8 років тому

    You are awesome! Thank you so much. I am learning so much with you.

  • @parulparikh5088
    @parulparikh5088 8 років тому

    Great video and presentation

  • @RP01733
    @RP01733 7 років тому +2

    Chanced upon your tutorial and really like it! Just love the fact that you have practice work sheets too!

    • @claudiaantony8227
      @claudiaantony8227 7 років тому

      Hallo dear..I am currently learning about excel and I use this video to learn. Could you please tell me where I can find the practice worksheets that is said to be uploaded. Many thanks in advance :)

  • @shaundonovan2193
    @shaundonovan2193 8 років тому

    Excellent tutorial. Thanks Sir. Your a very good teacher/instructor.

  • @rottyangel770
    @rottyangel770 8 років тому

    You are a very awesome man for putting this stuff online.

  • @ekowapeja
    @ekowapeja 5 років тому

    His voice is already so much soothing, makes me want to learn

  • @shermanbaptiste3797
    @shermanbaptiste3797 7 років тому

    Thank you for simplifing this so anyone can do it much appreciate it

  • @meolivemedia7520
    @meolivemedia7520 7 років тому

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

  • @GurjeetSingh-ed6kq
    @GurjeetSingh-ed6kq 8 років тому +5

    Hello Sali Kaceli, your views are helpful.
    But there's an issue, at 32:45 the video screen becomes Tiny, quite difficult to see.

  • @michaelw1913
    @michaelw1913 8 років тому +3

    This is an amazing tutorial, your walk along is brilliant! The Microsoft Word tutorial was also incredible!

  • @christianodileke4707
    @christianodileke4707 8 років тому

    Excellent job! Very helpful tutorial/guide. Thank you very much for your generosity and help and love for sharing this knowledge.

  • @sujatrobanerjee2239
    @sujatrobanerjee2239 7 років тому

    thank you sir,,,, it helps me a lot.... incredible thing you have done... student friendly and also included max portion....thanks again..

  • @ademolakamar3190
    @ademolakamar3190 4 роки тому

    Its really helpful. Thank you Sir

  • @kufreakata9014
    @kufreakata9014 8 років тому

    I love your lecture...please do you have this kind of training on Microsoft Access? You are one the best teachers I have found so far

  • @rabiumijinyawa5595
    @rabiumijinyawa5595 8 років тому +4

    Sir, I do not know how to express my feeling about these toturials in fact 90% of my Computer knowledge is through your tutorials l thank very much for the job well done.

  • @jenn634
    @jenn634 8 років тому +5

    Thank you thank you for taking the time to do this tutorial. This is my college education :)

    • @KaceliTechTraining
      @KaceliTechTraining  8 років тому +3

      Thanks. Glad you found it helpful. Please check out the other videos on this channel and use the Share links under the video sharing the links with your social media friends. That is one way to help with this work.

    • @viviennecuriel9262
      @viviennecuriel9262 6 років тому

      Seriousleee!!! =)

  • @eliasath
    @eliasath 8 років тому

    Sir, you are a great Professor! Thank you very much!

  • @syedmohideen2417
    @syedmohideen2417 8 років тому

    Hello Sir,thank you so much for such wonderful efforts...I always believe that educating others is a divine act which God loves to the core & it indeed is a real tool to uplift the society.You are not just teaching but you are serving for the humanity...May the Peace & Blessings of The Almighty be upon you...! Jaza'kallahu Khairan!

  • @savitripal873
    @savitripal873 5 років тому

    Sali kaceli your vedios are truly awesome please make beginner to advance level vedio on MIS too

  • @Illusive270
    @Illusive270 7 років тому

    Excellent Video Sir! Thank you so much for taking the time to do this for others.

  • @subhrajitbhattacharya6340
    @subhrajitbhattacharya6340 8 років тому

    Thank you Sal. wonderfully done.

  • @tankersmit
    @tankersmit 8 років тому

    Wow that was a long one! Thank you very much!!. I'm useless at maths and excel in the workplace is scary so you made it alot easier!.. Tania

    • @KaceliTechTraining
      @KaceliTechTraining  8 років тому

      +tankersmit Thanks for the feedback. Glad you found it helpful.

  • @suponowawan2467
    @suponowawan2467 7 років тому

    GOOD, mr. you are really great teacher, i so loved this video, and thank you soo much to get me this knowledge

  • @Kat74770
    @Kat74770 7 років тому

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

  • @chloeperez8703
    @chloeperez8703 8 років тому

    Great tutorial!

  • @msgigglesbaby
    @msgigglesbaby 8 років тому

    Thank you very much. This was very detailed.

  • @musajanyosufi63
    @musajanyosufi63 4 роки тому

    Thank you for ur useful videos Sir . I just finished watching the full tuturial and it was Great thank you again Sir . And I'm missing something else how to Calculate Tax..