10 Best Practices for Project Management Spreadsheets!

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

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

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

    Do you empathize more with the sales person or marketer? 😏
    TIMESTAMPS
    00:00 Shared Spreadsheet for Project Management
    00:34 Add Explanation to Every Tab
    01:22 Make Deadlines Obvious
    01:46 Hyperlink to Specific Tabs
    02:30 Use Descriptions below Header Rows
    03:07 Data Validation is Your BEST FRIEND
    04:40 Use Formulas Whenever Possible
    05:51 Import Raw Data Properly
    06:50 Key Info Tabs
    07:25 Raw Data Tabs
    07:43 Share Spreadsheet with Teammates

    • @alex-coelho
      @alex-coelho 2 ปีที่แล้ว

      Jeff thank you so much for this video! now lemme watch it cuz I got too emotional and made this comment before even watching it

    • @alex-coelho
      @alex-coelho 2 ปีที่แล้ว

      edit: nevermind, it was already there, the very first link! Jeff you're awesome!
      I've just watched it and I gotta say: Jeff you nailed it! plenty of good ideas and best practices! would you mind making that spreadsheet available as a template in the description?

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

      @@alex-coelho you’re very welcome Alex 😁✌️

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

      @June@97 decrease column width

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

      Your content is not available in my country (Yemen)... Please could you check this issue

  • @connorcscott
    @connorcscott ปีที่แล้ว +10

    First channel I have subbed with notifications turned on - every video is high-value, high-quality content. Great work Jeff!

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

      Thanks so much Connor!! I'll try my best to keep it that way

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

      For real. My LinkedIn and resumes are on point now

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

    Great tips! Thanks a lot. Any chance of future tips on the table/spreadsheet design itself? I often end up with the same color across the board. You seem to have some pretty useful distinctions in there!

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

      I have 2 other google sheets videos up! Have you checked those out 😁

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

      @@JeffSu Should have checked that, will do! thanks :)

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

    Hi Jeff, do you have a blank project management template? I am a career shifter and would like to practice on your templates while watching your videos. please and thank you

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

      Yup you can download from my Skillshare course!

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

    I love Google Sheets as well, but what the comparitive steps for Excel? BTW love your work!

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

      I haven't used Excel in years unfortunately 😅

  • @ShafiUllah-du9cl
    @ShafiUllah-du9cl ปีที่แล้ว +1

    Thanks for this video Jeff! But I want to know to add explanation text in a cell. Can you help me about this.

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

      Use the "Add note" feature

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

    Great video Jeff!! Very informative!
    I see you copied Joma's style at @1:40. "Thought we wouldn't notice.. but we did..!" haha

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

      Wow that's an amazing compliment! I honestly didn't know that was his style but guess I'm moving towards the right direction!!

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

    Liked, subscribed, and would like to have you just follow me around all day making my life easier

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

      I'd be happy to, but that sounds a bit creepy haha

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

    Could you do a video on setting an agenda before a client meeting? Also, what are best practices before and after the meeting?

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

      I have a best practices for meetings video down the line 😁

  • @_-1595
    @_-1595 หลายเดือนก่อน +1

    Jeff, can you please make a video related to the most professional color schemes for sheets?

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

      I'll add that to my next Google Sheets video :)

  • @dagwould
    @dagwould ปีที่แล้ว +3

    A few more tips:
    > validation lists: put them all in a 'sheet data' sheet, easier to manage them. Use tables to make the lists, then they will automatically include additional items.
    > use Excel tables as much as you can everywhere, they can then be analyzed via Pivot Tables.
    > use unique lists on user sheets (in addition to the sheet data sheet) to drive dropdowns. This starts on the way to building a system of relationships, rather than a set of 'dumb' spread sheets. E.g. your contacts list can then provide the drop down for activity assignments, document tracking, risk and issues logs, etc. if you don't have a PM system such as Procore, for example.
    >the system can then include and interrelate all project elements: activities (tasks), the WBS, schedule, costings, risk register, issues log, change log, management reports, document issue and receipt tracking, deliverables tracking, milestone reports, gantt chart, the WBS then drives activities in the schedule, deliverables, schedule, etc. with no double entry of data. Double entry is the door to disaster in any data system, including spreadsheets.
    >document the use and operation of each sheet

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

      These are AWESOME tips, thanks for sharing!

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

    Never knew spreadsheets could be this sexy.

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

    Thanks a lot Jeff! Super helpful and I always learn a lot from your videos. Another feature I use is the group row function especially in our team's SMM planner so we can hide all past contents on a weekly basis. It makes the sheet cleaner and everyone to focus on upcoming contents. 👌

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

      Thanks for the tip LJ!! 😁

  • @tayma___almezogy
    @tayma___almezogy ปีที่แล้ว +3

    As a student just joining the corporate world. these tips are really valuable!! Thanks a lot Jeff and please keep it up🤩

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

      Will do Tayma 😁

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

    Jeff, you're a gift in this world! Thank you for sharing these super helpful and easy tips! I thank God for your existence here on TH-cam. God bless!

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

      That's what my mom said as well, what a coincidence 😂

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

    Thanks @jeffsu .I couldnt download the template....it says wring adress.

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

      What happens when you click the link? You need to be signed into Google

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

      @@JeffSu it says it is not available, I've removed the word "copy" at the end of the link, and then it worked.

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

      I was logged

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

      @@patyolisilva Oh great!

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

    Hi Jeff, Thank you for all of your Google tips. I've been binge watching your videos!! Is there a way to password protect SPECIFIC TABS within a Google Sheet? For example, I'd like to share a sheet with someone that has 30 tabs, but I only want this person to be able to see 1 of the 30 tabs. Thank you so much!

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

      Yup, right click on tab > protect tab

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

      @@JeffSu Thank you for your response and time. However, that only allows you to protect people from accidentally editing the contents of the tab. They can still view the data inside. 😬 Do you known how to hide the data? Thanks.

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

      @@OrigamiTree Ah I see. Unfortunately not. In that case I would importrange the data into a shared spreadsheet and only importrange the data you want to share

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

      @UCwAnu01qlnVg1Ai2Ab%F0%9F%98%82tTMaA Aww shucks! Thanks so much. I've been doing it that way, but then it creates a whole bunch of unnecessary sheets. Boooooo. 🤣

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

    Thank you for the template

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

      You're very welcome 😁

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

    3:35 yes, it is. Just copy from other cell and paste it there 😕

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

      Hahaha technically true but at that point that person might just be messing around on purpose 😂

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

      @@JeffSu Well, I had a spreadsheet treated like that and my colleagues were putting in something that wasn't in the list. I didn't understand how they did it and then I found out that there is this bug 😀

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

    Is it possible to hyperlink or create a link for specific rows of the sheet to consolidated part of the same sheet? When they click on that link, it should navigate to certain rows/range of the same tab.

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

      Yup you need to copy and paste the link of a specific cell 😁

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

      @@JeffSu Thanks. Yeah I just learnt about defining/naming ranges and ctrl+K'ing them. Thanks. Your videos are super useful. Your Excel tips saved my Guide outlook to my team. Is there a video of you discussing Agile/Scrum/kanban?

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

      @@vaishalisridhar293 Not yet!

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

      @@JeffSu Thanks for letting me know. Looking forward to seeing it.

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

    Stealing productivity tips from here........ 🤣🤣🤣🤣🤣

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

      Steal away 😂

  • @eventssimplifiedph3319
    @eventssimplifiedph3319 5 หลายเดือนก่อน +1

    very clear instructions, easy to follow and understand. Thanks for this! I've watched other videos and they just make it more complicated.

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

      Thank you 😁

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

    No.3 in excel, I cannot add hyper link to only word but entire cell which covering whole sentence 😭 did I do something wrong?

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

      You have to click into the cell 😁

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

    You’re the best 👏🏼 Amazing tips as always 💫 Thank you!

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

      You're very welcome Enfis! 😁

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

    This was so helpful! Thank you for sharing. Any chance you have a spreadsheet template for managing vendor contacts and contract info? Asking for a friend 😉

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

      Check out my Personal CRM video for Notion 😁

  • @Erin-Thor
    @Erin-Thor 2 ปีที่แล้ว +2

    You use your hands just like President Trump. 👍🏽

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

      Hahahahaha is that good or bad 😅

    • @Erin-Thor
      @Erin-Thor 2 ปีที่แล้ว +2

      @@JeffSu - Dunno… do you have any political aspirations? 🤣

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

      @@Erin-Thor Not even a little bit 😂

    • @Erin-Thor
      @Erin-Thor 2 ปีที่แล้ว +1

      @@JeffSu - Then it’s all good! 😎

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

    This was so helpful! Thank you for sharing. Any chance you have a spreadsheet template for managing vendor contacts and contract info? Asking for a friend 😉

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

      Unfortunately not (yet)! 😁

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

    Thanks for the video, Jeff! You pointed out so many user-friendly features :D
    Tip #6 was actually something I had to learn the hard way. We had to make a DCF model once but because a lot of our cells were hard coded in due to us just copy & pasting the financials over, our inputs didn’t flow through the model properly 😂 but once the formulas were in, it felt magical

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

      Hahaha I feel you Andrea! Hard-coding is a very short-term solution 😅

  • @meng-chichang3097
    @meng-chichang3097 2 ปีที่แล้ว +1

    What a knowledgeable video, I can't believe I can watch it for free. Thank you!!

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

      You're welcome 😁

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

    Your session learnings are spectacular, all of me when I fully administered - however, your sarcasm takes away from your intellectual mind-

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

      Thanks for the feedback my friend! Glad you still enjoyed the learnings though 😁

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

    I came here for Mac app recommendations! But this is fine too. 😄

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

      Did you already finish all the mac app videos?

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

    What can I say?... Did you know glaciers and ice sheets hold about 69 percent of the world's freshwater? 😂
    Just kidding, but it's true! Thank you for another one mate.

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

      Wow I DIDN'T know that haha. Thanks Luís! 😁

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

      @@JeffSu And someone teach me that stupid questions does not exist, only stupid answers. Make so much sense.

  • @angelanna728
    @angelanna728 5 หลายเดือนก่อน +1

    Sales Team got called out 😂😂

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

      😂

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

      😂

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

    Pro Tip: Grammarly has a Mac desktop version, and when installed, it will let you spell-check your Google Sheets documents. (Couple of typos on the one you shared) Thank you for the template, though. Super helpful.

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

      Oh wow where were the typos? Thanks for letting me know! I wanna go change them now hahaha

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

      @@JeffSu On the Internal Whitelist Tab under the instructions.

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

    I do this a lot but the import range formulas is new thing for me. Thanks so much for the tips!

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

      No problem my friend 😁

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

    Thank you for producing this content. ❤

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

      You're very welcome Jon! 😁

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

    Love your videos!!!! Productivity tips are so good! Keep teaching us!

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

      Will do! Thanks Dan 😁

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

    Man your videos are superb and we'll presented !! I hope you get millions of views!! Totally deserve!!
    Is there any way to password-protect specific areas/cells in a spreadsheet? Like the headings only or cells with certain values only?

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

      I hope I get millions of views too Aadhi 😉. You can right click and select protect range

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

      @@JeffSu Thanks a lot mate! 👍🏼

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

    Use Jira?

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

      I've heard of this tool before. How is it?

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

    I would like to know best books for project management

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

      I would honestly recommend online courses instead of books since online courses are more interactive!

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

    Thanks Jeff, you use shortcut keys like a pro!

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

      Haha thank you 😁

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

    Time to up our spreadsheets game 🔥

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

      For sure 🙌

  • @udaygehani3808
    @udaygehani3808 7 หลายเดือนก่อน +1

    Awesome Jeff. Thank You

    • @JeffSu
      @JeffSu  7 หลายเดือนก่อน

      My pleasure!

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

    Can we be friends? 😂 you crack me up.

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

      Of course Jason 😁

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

    I love those tips on using Docs, Spreadsheets, Slides and other Google products. Thanks for this new video. By the way, I suppose everyone from a sales team company might not be happy with all those jokes about them... ;) \0/

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

      Shhhh don't tell them about this video! 😁

  • @kingastryszowska-hill1648
    @kingastryszowska-hill1648 2 ปีที่แล้ว

    Jeff, I love your video production style. Can you make a video about how you make videos 😂? (I actually need to make a video for work so this fits within your brand). Or if you don't feel like making a video, can you list some resources?

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

      Hi Kinga! That video will probably come much later this year haha. I'd recommend Ali Abdaa's skillshare course on final cut pro!

  • @LS-gy9bq
    @LS-gy9bq 2 ปีที่แล้ว

    ****Jeff, please resend the link to the cover letter I purchased from you yesterday***. The link does not show up in my promo or junk mail and I should have had it already. I wouldn't have normally even purchased something like that but I really liked the format and didn't want to take the time to reproduce it when I could just have that editable version so that's why I purchased it in the interest of time.

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

      Hi L S - Please DM me on instagram (@j.sushie) your email. I'll not only send you the link but I'll also refund you 😁

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

    Jeff Su is the only reason I’ve not yet been fired from my job.

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

      That's so much pressure...

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

    Wow! amazing tips

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

      Glad to hear it!! 😁

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

    Someone talked about how valuable your videos were. I took note of this and decided to check you out.
    I like how you delivered and your sense of humor especially the "stupid questions" part.
    😂😂

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

      Hahahaha well tell your friend "thank you" from me for introducing you to my videos 😁

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

    Too much common sense we often don’t think of

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

      Hahahaha agreed!!

  • @LS-gy9bq
    @LS-gy9bq 2 ปีที่แล้ว

    Hi Jeff, I just purchased one of your cover letters and haven't received it yet. Pls ✅

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

      Have you checked your spam/promotions folder? 😅

    • @LS-gy9bq
      @LS-gy9bq 2 ปีที่แล้ว

      @@JeffSu I checked earlier but I just checked just now and there's still nothing. Are you able to check and make confirm receipt of payment and that it was sent to my email?

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

      @@LS-gy9bq sure I can check. Could you share your email or dm it to me on Instagram?

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

    Thanks for sharing these tips!! What are your suggestions for an entry level project manager??

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

      These can be applied for any level 😉

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

    thank you for the video. I have one question: how can I make excel file on laptop to be related to google spreadsheet, and whenever make change on google spreadsheet it will appear on excel file, and not vice versa. could you please help me with that?

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

      Hmmm I don't think that's possible unless you upload the Excel to Google Drive...

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

    Hey Jeff!!
    Very interesting tips and must say your way of sharing knowledge with humor made me smile and laugh on your face expression. I believe the editing had a major part in that.
    AND YESSS I like the way you edited your video. Maybe you can share the way of doing the setup:P *No but really you should share*
    Wish you all the best. The hard work behind the video is felt.

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

      Hahahaha thank you my friend! Appreciate it 😁

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

    Watched the whole thing, had a great time, learned something, and I have nothing to do with what the video is about, but god daim your personality is just addicting to watch. Keep up the good work mate!!

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

      Hahahaha thanks for that Osama!! 😁

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

    I like you for Your positive Energy!
    Good Job.

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

      Thank you Damian! 😁

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

    Hi Jeff thank you again for the amazing content as always! I was wondering if you’ve ever done a video about starting a new job and what are some of the things we can do to make a great impression for the first few weeks? Would love to hear some of the things you did that helped you in the early stages of starting a new role :)

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

      Are the videos in my "Succeed in the first years of your career" not enough? 😅 That hurts

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

      @@JeffSu lol thanks I’ll go rewatch it

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

      @@hazelchung4610 Let me know if those videos are helpful!

  • @1996goyo
    @1996goyo ปีที่แล้ว

    Hi Jeff,
    is it possible to subscribe to your newsletter without paying for it? 🙂

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

      Hi Goyo! Not right now since it would be a bit unfair for the paying members, but 99% of the content on my website is free (have you checked out the posts under Productivity, Career, and Job Search)? So hopefully you still have plenty of stuff to go through 😁

    • @1996goyo
      @1996goyo ปีที่แล้ว

      @@JeffSu Thank you for the fast answer and for the value of you nice free videos. 🙂 I am sure I will find much stuff to go through on your website. 🙂 Have a great week!

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

      @@1996goyo you too!!

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

    I graduated from "being dumb" 😑😑 Feelin you 😂😂

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

      I really REALLY hope my colleagues aren't watching this 😅

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

      @@JeffSu what about your manager 😂

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

      @@eramuneer She's in marketing, she'll enjoy this video 😉

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

    Love you! Aa always, making my life easier XD

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

      Thank you! And you're very welcome 😁😁

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

    Always enjoy your useful tips. Did you get access to my spreadsheets? 😂

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

      Thank you George 😁

  • @fira5520
    @fira5520 5 หลายเดือนก่อน +1

    Why you cry?

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

      No idea

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

    Great tips man, thank you! Now can you teach my project team how to open a spreadsheet and read for themselves lol

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

      Check out my event management video 😁

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

    yea. commenting for Algo. come to singapore. eat chicken rice with me :D

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

      If I make it to SG, I will let you know for sure (via. Instagram stories), please hit me up!

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

    Magnific!

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

      Thanks my friend 😁😁

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

    Such a life saver, Jeff. Thanks a lot. What would I do without you? 👍🤣

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

      I really don't know 😁

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

    who doesn't enjoy poking fun at the sales team?

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

      I know right 😏

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

    Please do more GSheets tips especially about the basics to be more productive on the tool! 😭

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

      Will do Paul! Did you check out my other 2 videos on Google Sheets?

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

    Thanks

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

      Wow thank YOU Michael 😁

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

    Using these for sure. They are simple but practical.

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

      Glad to hear it Victor! Excellent profile pic by the way 😁

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

      @@JeffSu Thanks, Jeff. Total inspo from your Linkedin Profile tips from a while back. That and your Inbox Zero video were game-changers for me.

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

    This guy is hilarious!! I love it.. keep it up!

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

      Thank you my friend 😁! Will do! 😁

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

    Question on implementing Tab Explanations ( 0:36 ): I use Zapier to automate my Google Sheets-driven project management sheets and they require headers to be row 1. How would you create these notes so that they're obvious yet not impeding with my scripts?

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

      Great question my friend! Row 1 is arbitrary so you can use Rows 2, 3, 4, etc. The point is to have the note in a very obvious location so others won't miss it 😁

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

      ​@@JeffSu Thanks! I'll test that. I also realize that for tabs that Zapier must interact with, I can also use your tip to use IMPORTRANGE, allowing the Raw Data to be unimpinged and Zapier-friendly while having the tabs, views, & explanations available in the new tab.
      I've been working on a project schedule Google Sheet for myself, and your tips have made it a LOT easier to navigate my monster of a spreadsheet. Thank you so much for these tips!

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

      @@Mach3Maelstrom That's awesome to hear!! You're very very welcome!

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

    Great video! very useful, thank you 😸

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

      Not a problem Carlos 😁

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

    Thank you for making your beautiful template available for free. I’m using it as a career counseling tool, and I appreciate your video’s detailed explanation of what each element is. I do believe you have that designer soul in ya.

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

      Hahaha thank you Jennifer! Never thought someone would describe me as a designer 😂

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

    Great video! Thank you

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

      You're very welcome Didier 😁

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

    Labelling questions as “stupid” and making it sound casual can discourage team mates from asking questions. So they pretend to know stuff, carry on and end up making more mistakes. And since this culture of calling mistakes as stupid has become casual, those who are still learning can feel more insecure about it. So, please don’t be one of the condescending people. Great tips though.

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

      Hi Philip! Thanks for the feedback! This is my type of humor and I hope most viewers will give me the benefit of the doubt and won't view it as condescending. I really do appreciate you sharing your perspective! 😁

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

    Very good tips!

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

      Thanks so much Luciano, glad you enjoyed them 😁

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

    Great vid!!! 🤘

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

      Thank you Di 😁

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

    excellent!!

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

      Thank you Dave 😁

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

    Very impressive and informative presentation of this topic that really helps the PM per se. . Thank you very much!

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

      You're very welcome Benjamin 😁

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

    Lol despite numrous follows up still no reply to my messages. As a paid subscriber i am very disappointed . I just followed your advise and reached out to you on IM. Good luck for your videos but i am opting out of your subcription.

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

      Hi Deepak! Sorry to hear that! To be very transparent with you I don't commit to responding to paid subscribers messages so I apologize if I gave you the wrong idea.
      It sucks (for me) to be in a position where if I responded to every single comment (even those from just paid subscribers) I wouldn't have any time for my job and these videos (that are hopefully benefiting others at scale).
      Feel free to ask questions on here and I'll try my best to respond!

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

    Great video. It helps me a lot. Thanks Jeff

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

      You're very welcome! Thank you!!