Hands-On Excel Tutorial 📊 Beginner to Pro Course (2024)

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

КОМЕНТАРІ • 44

  • @ShihChiWang
    @ShihChiWang 11 місяців тому +4

    Thanks for always providing valuable courses.

  • @TheMusicalEmpress
    @TheMusicalEmpress 10 місяців тому +3

    I have searched for lots of courses. Some teachers speak to quickly and are not as thorough. Thank you for this excellent course, WITH TIME STAMPS 🥰😃as I definitely need a refresher. :)🥰 Your explanations are fully broken down. New Subscriber with notifications on! Thank You!

  • @chuckchukwuma7085
    @chuckchukwuma7085 6 місяців тому +2

    The Best Excel Professor That I Have Ever Seen. Very straightforward teaching with so much finesse. Good job Allison! Thank you.

  • @AliensMatrix
    @AliensMatrix 10 місяців тому +3

    Thanks for your teaching! It would be great if you chose a bigger mouse pointer to locate the area on the screen you are talking about.

  • @chidozienwokoji4923
    @chidozienwokoji4923 10 місяців тому +2

    Thank your very much for the video. I'm watching from Nigeria. Please in your subsequent videos, try and be zooming in so we can see what you are doing clearer . I was really finding it difficult jotting downs most of the formular

  • @Kwamz6306
    @Kwamz6306 Місяць тому +1

    Hi, I'm abit confused at 47:00. I named my table Orders. When opened PQE on the left there were 2 Queries: CandleTable and Orders. I am not sure where it is pulling this CandleTable from?

  • @jadedagem
    @jadedagem 3 місяці тому +2

    Is the formulas and functions section available PDF form as well? Well, really everything after formulas & functions.

  • @SAUDI-GOD
    @SAUDI-GOD Місяць тому +1

    Hi, could you please expound on the hyperlink feature of excel?

  • @justinlu16
    @justinlu16 Місяць тому

    What software did you use to record/create this video?

  • @አንዲትኢትዮጵያ
    @አንዲትኢትዮጵያ 7 місяців тому +2

    Nero!! Thanks for all what you did and u r non-selfish

  • @jignasajoshi27
    @jignasajoshi27 11 місяців тому +1

    Everything good before pivot table. In Candle Table sheet we have Date field wiht numbers not date so could you please replace data file with date? so we would practice properly.
    Thanks a lot.

    • @PragmaticWorks
      @PragmaticWorks  11 місяців тому +1

      Thanks for letting us know! The link has been updated.

    • @jignasajoshi27
      @jignasajoshi27 11 місяців тому

      Thanks a lot..... appriciate for very quick response@@PragmaticWorks

  • @Gary-ts6dh
    @Gary-ts6dh 11 місяців тому

    1:02:00 - I would have expected Power Query to fill the column only down to the last row of data here. It looks like it filled to the end of the Year column. Is there a way to get it to stop at the end of the data? or at least, enter nothing in the rows where there is no date in the Date column?

  • @TaesGamingYt
    @TaesGamingYt 10 місяців тому

    Can we add this as a skill on our resumes?

  • @Bhavika-n1k
    @Bhavika-n1k 8 місяців тому

    I'm a beginner, with zero excel knowledge. Would this suffice?

  • @tajnazeer9209
    @tajnazeer9209 10 місяців тому

    Hi
    Allison I am searching remote Excel job where to search.?
    Advice please

  • @stephenMKonor
    @stephenMKonor 3 місяці тому

    Hello Allison, how can I get the file for this lesson?

    • @allisongonzalez.pragmatic
      @allisongonzalez.pragmatic 3 місяці тому

      The link is in the video description, right below the link to get the certificate for taking this course:)

  • @KT97379
    @KT97379 11 місяців тому

    Is it possible to earn good side income if one has a good command over excel in 2024 (keeping in mind the influence of AI). Thanks !

  • @courtneysavage7845
    @courtneysavage7845 4 місяці тому

    Thank you, very understandable

  • @Crazymom3
    @Crazymom3 4 місяці тому

    Can you please post the link to your info and slides I don’t see it in the comments. I looks to be buried

  • @emiliaogonowska2792
    @emiliaogonowska2792 10 місяців тому

    Is it possible to download the data file for the tutorial?

    • @PragmaticWorks
      @PragmaticWorks  10 місяців тому

      You can find this in the description of the video.

  • @Gerald-q2k
    @Gerald-q2k 10 місяців тому

    How do I print out the short cuts sheets?

    • @PragmaticWorks
      @PragmaticWorks  10 місяців тому

      The PDF is included in the student files here: pragmaticworks.com/lwtn-excel-beginner-to-pro-student-files

  • @surenderpalsingh6508
    @surenderpalsingh6508 9 місяців тому +1

    Thanks alottt mam❤

  • @chidozienwokoji4923
    @chidozienwokoji4923 11 місяців тому

    Hi, I'm watching from Nigeria. Is there any certificate issued upon completion of this course ?

    • @austinlibal
      @austinlibal 11 місяців тому +1

      There’s a certificate in the video description.

  • @theplumgaming2039
    @theplumgaming2039 11 місяців тому +1

    Don’t see the class sheets

    • @PragmaticWorks
      @PragmaticWorks  11 місяців тому +1

      Student files are in the description. Here you go! pragmaticworks.com/lwtn-excel-beginner-to-pro-student-files

  • @johndonnelly6899
    @johndonnelly6899 11 місяців тому +1

    Had a Pivot Table out of nowhere and didn't explain Dashboard, prior excellent, Thanks.

    • @PragmaticWorks
      @PragmaticWorks  11 місяців тому

      Glad it helped! Here's a link if you want to learn more about Pivot Tables: ua-cam.com/video/JVf1Ln0Enfo/v-deo.html
      We also have an Advanced Pivot Table and Full Dashboard video coming out soon!

  • @lefty21laura
    @lefty21laura 8 місяців тому

    This is not for beginners I am lost already. I need to know about entering data and creating files. Do you have a video for beginners, I have only heard about excel very limited.

  • @shahzadiqbal6739
    @shahzadiqbal6739 11 місяців тому

    Thanks for the Info

  • @mohamedsalah656
    @mohamedsalah656 11 місяців тому

    Thank You Good work

  • @SamiullahEhsan997
    @SamiullahEhsan997 11 місяців тому

    Well taught.

  • @resamitchell7632
    @resamitchell7632 2 місяці тому

    I need tutoring with my excel homework

  • @allstarsacademydaycare5405
    @allstarsacademydaycare5405 8 місяців тому

    Hi, thank you the video. Can you create an Excel calculator for me, please? It's at Icm911 yh for now.

  • @LuisPerez-bu2uc
    @LuisPerez-bu2uc 11 місяців тому

    Sorry to long of a opening. That's why my 4 th grade teacher told me Get to the point.
    Sorry to long opening

  • @agnieszkaz.6110
    @agnieszkaz.6110 4 місяці тому +2

    Quite nice, but you talk too much instead of just showing stuff. This way simple things take ages.

    • @chadshaughnessy4217
      @chadshaughnessy4217 Місяць тому

      I’m trying to learn a bit on excel but she’s more interested in talking than teaching

  • @jenna80532
    @jenna80532 7 місяців тому +2

    Just watched 30 seconds and already don’t understand what she’s talking about.