How to Build a Monthly Sales Report in Google Sheets in 10 Easy Steps (FULL COURSE)

แชร์
ฝัง
  • เผยแพร่เมื่อ 26 พ.ย. 2024

ความคิดเห็น • 32

  • @VascoDanielBaiao
    @VascoDanielBaiao ปีที่แล้ว +6

    Your tutorial is gold! When I saw the duration I though I was just going to jump all the time but along the video you provide such handy tips that I had to give an extra attention. Great work!

    • @Nattybrokers
      @Nattybrokers 2 หลายเดือนก่อน

      ive completed the other 2 courses, easily have put in like 15 hours creating these. now im at it agian with the 3rd lol.

  • @medic472
    @medic472 2 ปีที่แล้ว +2

    Thanks for the tutorial, great refresher on something I haven't done in a while. I found the 'edate()' function most useful for generating the drop down for previous months. Much easier than using the 'date()' function.

  • @annette-2938
    @annette-2938 ปีที่แล้ว +1

    Do you have a cheat sheet available? I’m trying to input my numbers in Google sheets to create a profit and loss statement as well as learn how to use the same for monthly reports. I have a small meal prep company.

  • @katelyndo5771
    @katelyndo5771 2 ปีที่แล้ว +1

    thank you🙏🙏🙏🙏🙏🙏 you’re the spreadsheet god

  • @tanakornpromthep9025
    @tanakornpromthep9025 4 หลายเดือนก่อน

    Found it very useful! Thank you

  • @samniengpollong7841
    @samniengpollong7841 2 ปีที่แล้ว +1

    Thank you so much sir!! Your videos have been so helpful.
    I learn a lot from you...

  • @DavidTahalele
    @DavidTahalele 2 ปีที่แล้ว +1

    nice video! very useful, much oblique!

  • @maryivabellebiana6351
    @maryivabellebiana6351 ปีที่แล้ว

    Hi, can you make a tutorial with your dashboard that when you drag down the date you want to show it will automatically change the dashboard data.. Thank you :) .. always watching your tutorial

  • @danhughes4376
    @danhughes4376 2 ปีที่แล้ว

    How do I enable that green dialog that pops up every time you enter "=" in a cell? That looks really helpful

  • @DanielleArtus
    @DanielleArtus 5 หลายเดือนก่อน

    I can't get the unique dropdown to work. The dynamic list works, but the dropdown on the entry page returns an error when I type a unique value. Any additional tips?

  • @User-qx4ql
    @User-qx4ql 2 ปีที่แล้ว +1

    Thank you for this @hustlesheets. Hope you could create a KPI dashboard for a call center dashboard next. 🙏

  • @Fridja
    @Fridja ปีที่แล้ว

    I recreated this sheet for our stock forecasting. I showed my wife, and now she thinks I'm the coolest guy ever. 😎

    • @hustlesheets
      @hustlesheets  ปีที่แล้ว

      That's what we're striving for here at Hustlesheets

  • @GV-gn3mj
    @GV-gn3mj ปีที่แล้ว

    Hi! Thank you for posting. Is there a way to have in the dropdown menú year for example 2022 and 2023 and bring the month belong to every year but without Jun 2022 etc just the Jun?

  • @riteshpradhan9328
    @riteshpradhan9328 2 ปีที่แล้ว

    Sir, i really need a help how to collect data or creat data sheet effectively situation is in small business where their is 5 people working for me they work in differnt position everyday. So on a same day they all works differnt position differnt staff and they got differnt salary for different work. Mainly i wanna creat a dashboard from that datasets ....

  • @jhartttstore6014
    @jhartttstore6014 2 ปีที่แล้ว

    Thankyouu for share full course 😭

  • @User-qx4ql
    @User-qx4ql 2 ปีที่แล้ว

    @hustlesheets, could you share the code to make the bar color to blue please.

  • @truongan8883
    @truongan8883 2 ปีที่แล้ว

    could you make more video about how to creat dashboard with Google studio

  • @Letztravell
    @Letztravell 2 ปีที่แล้ว +1

    Hi bro, new subscribers here. Could you pls make a video regarding the best google sheet for a self-employed food delivery driver's tax assessment? I'm doing multiple company deliveries at a time. So if I get ur tutorial regarding this matter it will be so helpful for me. Thanks in advance bro😊

  • @prasukristam
    @prasukristam 2 ปีที่แล้ว +2

    Bro make dashboard with school marks and monthly and weekly progress reports plz

  • @emmavelasco8725
    @emmavelasco8725 2 ปีที่แล้ว

    thank you so much Sir.. this is so helpful :)

  • @truongan8883
    @truongan8883 2 ปีที่แล้ว

    should we make dashboards with googlesheet or google studio ?

    • @hustlesheets
      @hustlesheets  2 ปีที่แล้ว

      You should use Data Studio, and use Google Sheets for some of the calculated metrics that are difficult to do in Data Studio

  • @trevordaniels4443
    @trevordaniels4443 2 ปีที่แล้ว

    Love the videos; but I work with large data files and Google sheets is far too slow.

    • @danhughes4376
      @danhughes4376 2 ปีที่แล้ว

      Can you not apply the same functions to excel?

  • @kassiowifried
    @kassiowifried 2 ปีที่แล้ว

    Good job

  • @elfridhasman4181
    @elfridhasman4181 2 ปีที่แล้ว

    Thanks a lot 🙏🙏

  • @DeepakSingh-nr9nc
    @DeepakSingh-nr9nc 2 ปีที่แล้ว

    grt

  • @bluespace2697
    @bluespace2697 2 ปีที่แล้ว

    Can you create sheets on request as well plz share email to contact

    • @hustlesheets
      @hustlesheets  2 ปีที่แล้ว

      michael@hustlesheets.com :)

  • @giovannicapuano9729
    @giovannicapuano9729 2 ปีที่แล้ว

    SAME MACRO ON SEVERAL SHEETS OF THE GOOGLE SHEET FILE
    .
    hi, how can I apply the same macro on multiple sheets at the same time?
    .
    This is the JavaScript code:
    .
    function lamiaprimamacro() {
    var spreadsheet = SpreadsheetApp.getActive();
    spreadsheet.getRange('A1'). activate();
    spreadsheet.getCurrentCell(). setValue('MY FIRST MACRO');
    spreadsheet.getRange('A2'). activate();
    spreadsheet.getCurrentCell(). setValue('TEXT EXAMPLE');
    spreadsheet.getRange('A3'). activate();
    };
    .
    this the file
    .
    .
    the macro is located in the sheet "Reset Validation"
    thank you very much