How To Create A Powerful Productivity Tracker In Excel [Full Training & Free Download]

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

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

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

    📅Excel Calendar Pro: Your Solution to Stress-Free Scheduling 👉 rebrand.ly/CalendarPro_PinnedComm

  • @czechyorker
    @czechyorker ปีที่แล้ว +14

    I am well behind on all training videos. But my believe is - that supporting your channel is something that I am obligated to do. Your Excel training videos are the best one can find online. Thank you.

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

      Thank you so very much, I really appreciate your continued support for so many years. :) :)

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

      Agreed!

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

      Thank you very much Alex :)

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

      I am behind on this training pls

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

    After seeing many of your videos and many views, you are really at a very high level in using Excel, your work is excellent and seen by a large community.
    Best regards, you Randy are one of the best!

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

      Thank you so very much, I really appreciate that. I know you have been with me for many years and I really appreciated it.

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

    For upcoming videos, I would suggest a manufacturing production scheduling system. Where you would have multiple project gantt views overlaid with machine, people and process schedules. This would be for job shops to use.

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

      Well Jim, you are in luck. My next video, that I am recording today, will be on Manufacturing, BOM's, costs, Purchase Orders, Work Orders, Sales orders and inventory. It does not have the gantt view however it could easily be added (It's called Manufacturing and Bakery Manager)

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

      Great, your videos are very helpful!!❤

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

      Hi Jim, here is the link to the upcoming training scheduled for next Tuesday: th-cam.com/video/sRJQfJqm6Qc/w-d-xo.html
      I am sure you will enjoy it. Please like and share it.

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

    probably the best training video ive seen so far this was otherwordly
    you have no idea how much i appreciate your work

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

      Thank you so very much, I really appreciate that and so glad to help

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

    Hey Randy. Do you have a video on how to set up a workbook to keep track of when employees have their trainings, and if they train in the same thing more then once to show the most current date?

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

      Hi Kelly, thanks for your comment. Feel free to check out my Employee Training Manager here: th-cam.com/video/T2xUHzSZwTI/w-d-xo.html
      I hope this helps and thanks so much.

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

    reminder is on. As always thumbs up for the BEST teacher Randy on youtube VBA. Thanks a lot Randy for your valuable time & all your hard work 👍

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

      Thanks so much Tammy. I always appreciate your kind comments and continued support.

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

    Thank you so much Randy for this amazing video.

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

    Wow, looks amazing

  • @TheLegend_lab
    @TheLegend_lab 6 หลายเดือนก่อน +1

    Hi Rendy, your videos are great. However, i think the missing part when you start your videos is name manager input. If you could show more of name managers input that will be excellent. Other than that, all inform on videos from scratch will be well covered.

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

      HI and thanks so much. I have a complete video on Named Ranges here: th-cam.com/video/yMz8S5ypBmg/w-d-xo.html
      I hope this helps and thanks so much.

  • @YoucefYoucef-ft9ce
    @YoucefYoucef-ft9ce ปีที่แล้ว +2

    Wow wow wow wait for it
    YOU ARE AMAZING SIR

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

      Thank you so very much, I really appreciate that. I am sure you are going to love this one

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

    Hi Randy thanks for sharing

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

      For sure, you are very welcome Tobaye, and thanks for your continued support

  • @asifosman
    @asifosman 11 หลายเดือนก่อน +1

    Randy, is there another angel like you on TH-cam doing the same for Google sheets? 😊

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

      Hi and thanks for your comment. I am not really sure about that since i have not researched that, however Excel is a great platform to stick with. Thank you for your Likes, Shares & Comments. It really helps.

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

    Almost done customising this one. Not that straight forward but it was doable

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

      Yeah this one was a powerful one. So glad you enjoyed it :)

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

    amazing tools for amazing person Sir

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

    I have a query on the Admin WorkSheet for the Date Ranges. Is it possible to calculate from today as an example to last 30 days? I think I missed something with the Admin setup sheet as it just appeared from somewhere.

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

      Hi and thanks. yes for sure its possible. If the formulas are not in the admin you can check out this video, on The Ultimate ERP application: th-cam.com/video/HE-g2BAC5Ks/w-d-xo.html
      I hope this helps and thanks so much.

  • @JAMR0CK15
    @JAMR0CK15 10 หลายเดือนก่อน +2

    On the selection change section (@ 1:14:22) I'm getting a sub or function error, that highlights (line 1) Private Sub Workseet_SelectionChange(ByVal Target As Range)
    & in (blue on line 7) ReplaceCalendar
    I've double checked the code & it appears to be in order. I'm following it step by step. Is it possibly due to a function that hasn't been assigned yet but will be in the next few steps?

    • @ExcelForFreelancers
      @ExcelForFreelancers  10 หลายเดือนก่อน +1

      Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.

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

    I am new subscriber to your channel, and I am not well verse in excel, but I am glad if you could help me develop a Dashboard for Rainfall reports, dam levels and daily temperature in one like this video, as this vital on my work assignment. Your expertise on the matter are best I can find. Thank you.🙏🙏🙏

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

      Hi and thanks so much for your comment. Great to have you here. Since I get hundreds of requests of help per week, I am unable to take on any projects of my own. If you would like some help with this, we have a group with 60,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet)
      You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project.
      I hope this helps and thanks so much.

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

      @@ExcelForFreelancers Thank You...

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

    With the new formulas in excel, is it better using sort choose filter formulas rather than VBA and advanced filter. Not sure which is best in terms of efficiency, ease etc

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

      Hi Dan, thanks for your comment. It really depends on your use-case of the application you are designing. If you are designing it for yourself or a customer who you know will be using the latest version of Excel, then perhaps, however when I create these templates, I want to make sure that they can be used regardless of the version of Excel the end user is using. This is why I don't often use features that are exclusive to new versions of Excel.
      I hope this helps and thanks so much.

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

      @@ExcelForFreelancers Thanks. Wasn't really thinking about legacy users but makes sense to cover both options if they have older versions

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

      Yes for sure and thank you for your Likes, Shares & Comments. It really helps.

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

    Thank you so much in advance 👍💐

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

      For sure, you are very welcome and I hope to see you for live chat on Tuesday

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

      @@ExcelForFreelancers sure

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

      Hello, can you send me link for live chat and what time on Tuesday. Thank you 🙏

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

    Hello Randy, thank you so much for your tranings, iam stuck in a specific situation when i delete the already present tasks in Tasks sheet in order to add my own and try to add a task using "New task" button it inserts the new task in row 115 although i deleted the already present tasks.

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

      Hi and thanks very much. Make sure when you delete a task, the add new macro is being run and the Task ID is also cleared out when the new task macro is run. This should ensure any new task is inserted into a new line at the bottom of the task list.
      I hope this helps and thanks so much.

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

    Thank you so much it is greatly appreciated 👍💐

  • @ballacusORIGINAL
    @ballacusORIGINAL 6 หลายเดือนก่อน +1

    Do you have a video showing how to setup the admin/settings sheet?

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

      HI and thanks yes i do. You can check out my School Management series in which I show you how you can create your own Excel applications, from scratch, in an amazing series right here: bit.ly/SchoolManagerSeries

  • @mdfarhadalam3306
    @mdfarhadalam3306 3 หลายเดือนก่อน +1

    can I do this in Google sheet? or maybe anything online? or can my file share in online?

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

      Hi and thanks. This only works in Microsoft Excel desktop, however if you want to share and sync your macro-enabled Excel workbook, please watch this training: th-cam.com/video/f_1HsR9305I/w-d-xo.html
      I hope this helps and thanks so much.

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

    Hello, could you please show how to create admins worksheet with the named ranges/cells to follow you from the scratch. I am stuck at the step where I need to refer to the named ranges. Thank you.

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

      Hi and thanks so much. Please check out my School Manager Series here in which I create everything from scratch, including an Admin screen: th-cam.com/play/PLIBeRriXvKzCNzJdnrmVBjgF7W2iBqHqZ.html
      I hope this helps and thanks so much.

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

    Is there a free download for this template :). I am not very technical and it's taking me time to create this excel.

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

      Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.

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

      @@ExcelForFreelancers I didn’t notice a download. I will check. Thanks

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

    The best on youtube!!!

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

      Thank you so very much, I really appreciate that, so very kind of you

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

    Dear Mr. Randy, Thanks for the awesome tutorial. By the way, Can you create a mileage tracker for the drivers. Thanks

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

      Hi and thanks so much. I am glad you liked the training. I do have a mileage tracker here: th-cam.com/video/dsL-yd4ROIw/w-d-xo.html
      I hope this helps and thanks so much.

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

    This is amazing, i absolutely love all your videos. But i have a problem, everytime i want to download a workbook from the link in the description, i follow the steps asked, but never get anything on my email. Can you help me with this?

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

      I am sorry for this. We are really trying to work on this issue as we want to get them to you ASAP. Can you please email shane@ExcelForFreelancers.com and angela@excelforfreelancers.com along with the email you used so we can get to the bottom of this and also make sure you get your workbook. Thanks for your patiences.

    • @thedarkcrower
      @thedarkcrower 2 หลายเดือนก่อน +1

      @@ExcelForFreelancers thank you so much for the reply. I just sent emails as you asked. Waiting for reply now. Thank you once again!!!

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

    Hi
    Do you have a video on how to make your employee names

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

      HI and thanks. I am not sure what do you mean by 'employee names' How to make them where?

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

    Is there a way you could elaborate a bit more on the VBA I really got lost in that screen and feel like a deer in headlights. I have tried looking into different training videos but none really would help with this productivity tracker.

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

      Hi and thanks very much. I can understand since my trainings use an intermediate to advanced vba, however you may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBADiscount_Randy
      Also please check out my 'From Scratch' playlist in which I create templates from scratch here: th-cam.com/play/PLIBeRriXvKzCHVxFYRSMTZu3PmnVn4ujb.html
      I hope this helps and thanks so much.

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

      Sounds great thanks alot!

  • @Entertainment-j3p
    @Entertainment-j3p ปีที่แล้ว +1

    ❤❤❤ sir i impressed your video sir i kandy a suggestion sir create a worker attendants sheet workbook with government holy days sir🎉🎉🎉

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

      HI and thanks so much. I do have an attendance tracker here: th-cam.com/video/CNornJ75mZM/w-d-xo.html
      I hope this helps and thanks so much.

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

    this is amazing, can you help me please with the template? :C thanks for your help

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

      Hi MIshel,
      Thank you for your comment. If you would like some help with this, we have a group with 60,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet)
      You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project.
      I hope this helps and thanks so much.

  • @SharmisthaParui
    @SharmisthaParui 6 หลายเดือนก่อน +1

    Please make a stock market trading journal

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

      HI and thanks so much. I will do my best to get that done. Thank you for your Likes, Shares & Comments. It really helps.

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

    this is useful

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

      Thank you so very much, I really appreciate that and I am sure you will love this training Osama

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

    This is the best honestly. How do I get the file?

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

      Hi and thanks so much. You can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.

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

    if I create one like this, can this be realtime updated if shared to my colleague thats at other part of the world?

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

      Hi and thanks for your comment. Yes for sure you can. To share and sync your macro-enabled Excel workbook, please watch this training: th-cam.com/video/f_1HsR9305I/w-d-xo.html

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

      cool...thanks a lot

  • @JAMR0CK15
    @JAMR0CK15 11 หลายเดือนก่อน +1

    On the task schedule time portion (AI4+Interval) @ 50:40) I'm getting a #Value, but my admin sheet is set up like yours. I can't figure out the error?

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

      Hi and thanks you want to make sure that AI4 value is correct. You can change AI4 to a number and make sure it is actually a number. I hope this helps and thanks so much.

    • @JAMR0CK15
      @JAMR0CK15 11 หลายเดือนก่อน +1

      Got it... I didn't put a space in the time format...🤦🏽‍♂️
      I appreciate all that you do...🫵🏽💪🏽👏🏽

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

      Ah ok very good. For sure, you are very welcome

  • @0re0s-
    @0re0s- 10 หลายเดือนก่อน +1

    Are you able to create an adult education training behavior tracker?

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

      Hi and thank you for your comment. If you would like some help with this, we have a group with 60,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet)
      You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project.
      I hope this helps and thanks so much.

  • @craftspell3182
    @craftspell3182 9 หลายเดือนก่อน +1

    From where did you get the icons?

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

      HI and thanks you can find the icons here:
      icons8.com/iconizer/
      adioma.com/icons
      www.iconsdb.com/
      I hope this helps and thanks so much.

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

    can you create a book reading tracker ?

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

      Hi and thanks for your comment. You can check out my Collectibles Tracker, which should help you out with this: th-cam.com/video/lS-1cbiNbYg/w-d-xo.html

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

    How can i create a phone number generator that i can input the country code head line of number than it's generate for me?

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

      HI and thanks for your comment. I am not sure what a phone number generator is. Will it generate fake phone #'s for data in Excel? If so, there are many websites that can help you generate fake data. You can just search for 'Fake data'
      I hope this helps and thanks so much.

  • @SureshKumar-i1j1q
    @SureshKumar-i1j1q ปีที่แล้ว +1

    This video is really helpfu, but my "ISSUE IS I CANNOT DELETE MULTIPLE ROWS AT A TIME". Like i couldnot select mulitple rows under task list and click delete TASK. because hundreds of tasks are created, manually selecting one by one is very difficult. can you help me with this. i got struck here.

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

      HI and thanks very much, you can select multiple rows, and then loop through those selected rows, using this training: th-cam.com/video/Ltx7DLLGGHo/w-d-xo.html
      I hope this helps and thanks so much.

  • @juandavidfrancofranco641
    @juandavidfrancofranco641 2 หลายเดือนก่อน +1

    In Airtable it would be interesting and more powerful to do it

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

      Yes and thanks so much. A nice idea for sure. Thank you for your Likes, Shares & Comments. It really helps.

  • @Katrina-e7d
    @Katrina-e7d 10 หลายเดือนก่อน +1

    Please send me this! I would love to use it for work!

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

      Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.

  • @miamusashi1111
    @miamusashi1111 11 หลายเดือนก่อน +1

    How did you remove the debug on 57:47? It still won't work for me. It says runtime error 424

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

      A bug in this situation is based on the name of the shape that you clicked when the bug appeared. That name of the shape must be either "Icon" (then a number) or "Menu" then a number. If anything is different that this will cause a bug. Also remember this macro can only be called when you click a button.
      I hope this helps and thanks so much.

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

    Hello sir,
    Please sir stone creshar accounting

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

      Hi and thanks very much. Please check out my Mini-Accounting application here: th-cam.com/video/itHilzsUHck/w-d-xo.html
      I hope this helps and thanks so much.

  • @JAMR0CK15
    @JAMR0CK15 11 หลายเดือนก่อน +1

    At 30:33, The conditional formatting formula, I keep getting the formula error message but it's the same as what you have shown. Why could that be?

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

      Hi and thanks so much. It is possible, based on your regional settings, that you would use a semicolon instead of a comma in your formulas. Let me know if that helps. Thank you for your Likes, Shares and comments. It really helps.

    • @JAMR0CK15
      @JAMR0CK15 11 หลายเดือนก่อน +1

      Yes, it did help. Thank you.

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

      Great, thanks so much

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

    My man, this is what you are known for, looks like userform

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

      For sure, you are very welcome. I am sure you are going to enjoy it.

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

    Hi, I try Sub Menu_Change() by copying your code, but it show compile error "Variable not define" at row "With Main". How can I fix it? thank you!

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

      Hi and thanks for your message. This would mean you do not have a sheet code name that is called "Main" you can search "How to change sheet code name in Excel" to update the sheet code name. I hope this helps and thanks so much.

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

      @@ExcelForFreelancers but I've have a sheet named "Main" already! Or should I do some thing else?

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

      @@ExcelForFreelancers Thank you! I can fix it now!

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

      Ok very good thanks so much

  • @craftspell3182
    @craftspell3182 9 หลายเดือนก่อน +1

    Can you please share the icons

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

      Hi and thanks. All icons, pictures and other resources, as well as new features and updates are available on my Patreon platform here; www.patreon.com/ExcelForFreelancers
      I hope this helps and thanks so much.

  • @vandanpatel9913
    @vandanpatel9913 9 หลายเดือนก่อน +1

    can i get this template pls

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

      Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.

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

    Hi, I cant get the result for =starttime at 48:43 i dont know what i missed

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

      Hi and thanks so much. The 'starttime' is a named range that comes from a cell on the Admin sheet called Start Time. Once you see the Admin sheet, you will see the Start Time field. I hope this helps and thanks so much.

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

      @@ExcelForFreelancers thanks, I'll try that.

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

      ​@@ExcelForFreelancersthank you. It worked ❤

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

      Great, I am happy to hear that

  • @patelkalp823
    @patelkalp823 6 หลายเดือนก่อน +1

    WHY DONT YOU CREATE YOUR COURSE ON UDEMY

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

      Hi and thanks for your comment. Udemy regulates what we can charge, and there is no freedom on that platform. My courses are on my own platform so that I can control every aspect of the course, student experience, price and follow up. I hope this helps and thanks so much.

  • @عاطفشحات-ي9ي
    @عاطفشحات-ي9ي ปีที่แล้ว +1

    السلام عليكم هل يوجد شرج باللغة العربية

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

      Hi and thanks so much. I do have subtitles in Arabic for each video. I hope this helps and thanks so much.

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

    Sorry Randy but I am really disappointed in you. Just received the "Oops our mistake" e mail . Just about everyone uses this sales technique. I follow all of the trainings and really enjoy learning new things from you and never expected this type of sales hype from you

    • @ExcelForFreelancers
      @ExcelForFreelancers  ปีที่แล้ว +5

      Hi and thanks for your comment. I specifically requested that email because we did make a mistake. Last week, on our regular Tuesday email, we sent out an email with a 50% discount on the Ultimate Excel Resource Guide, however, my staff forgot to update the price on the sales page. So the price in the email stated $33.00 and yet when you clicked on the link in the email, it took you to the sales page, and the price on the sales page was $67. So this was a big mistake on our part. So for this email, I instructed my staff to apologize through an email and drop the price from 50% ($33) to 60% off, which is now $26.80 on this sales page here: www.excelforfreelancers.com/product/the-ultimate-excel-resource-guide
      It was an honest mistake, not a sales tactic, and we are trying to make it up with a further discount. As always, you can always email me here Randy@ExcelForFreelancers.com
      I answer each and every email, every day.
      I hope this helps clear things up