Data Analyst Excel Course
1:55
28 күн бұрын
Dynamic Calendar
8:08
Ай бұрын
invoice generator in excel
9:12
2 ай бұрын
pre record your script on youtube
2:02
Resource planning template
9:36
2 ай бұрын
Tracking employee onboarding
13:53
employee onboarding tool
11:24
3 ай бұрын
Risk Management
7:47
3 ай бұрын
CRM for solopreneurs
12:32
3 ай бұрын
Task Management 4 0
5:41
3 ай бұрын
candidate assessment tests
5:20
4 ай бұрын
automatic shift scheduling system
14:50
random math questions
13:08
6 ай бұрын
Staff automatic booking   part 3
25:39
Staff automatic booking  - part 2
32:41
staff automatic booking - part 1
24:59
Пікірлер
@Momo33Egy
@Momo33Egy 6 сағат бұрын
Could you send to me downloadable link for this excel sheet to use it directly?
@excelhighway3549
@excelhighway3549 6 сағат бұрын
The file is available on m Patreon page: www.patreon.com/ExcelHighway
@KathleenCarroll-x3q
@KathleenCarroll-x3q 10 сағат бұрын
Hello, do you have the downloadable file ready? Can this be used in Google Sheets?
@excelhighway3549
@excelhighway3549 6 сағат бұрын
The file is available on m Patreon page: www.patreon.com/ExcelHighway
@DanCrawford-f3h
@DanCrawford-f3h Күн бұрын
How do I get this to function on my specific sheet? I added my workbook information to the code but it does not work for me.
@excelhighway3549
@excelhighway3549 21 сағат бұрын
Can you share your code?
@mwandunzimba8711
@mwandunzimba8711 Күн бұрын
Thank you! Very helpful.
@excelhighway3549
@excelhighway3549 Күн бұрын
Glad it was helpful!
@psijjjm
@psijjjm 4 күн бұрын
I need the template.
@excelhighway3549
@excelhighway3549 4 күн бұрын
It's available on my Patreon page or Etsy shop
@psijjjm
@psijjjm 4 күн бұрын
Nice tool. What is the currency of the price tag?
@excelhighway3549
@excelhighway3549 4 күн бұрын
Thank you, USD
@hussainalatia8418
@hussainalatia8418 4 күн бұрын
Awesome work, thanks for sharing
@excelhighway3549
@excelhighway3549 4 күн бұрын
Thanks for watching!
@Evraaah
@Evraaah 6 күн бұрын
Hi sir, may I have the link to the template?
@excelhighway3549
@excelhighway3549 5 күн бұрын
The file is available on my Patreon page: www.patreon.com/ExcelHighway
@tejasmehta5115
@tejasmehta5115 6 күн бұрын
You provided access to the file but its asking for paid subscription.
@excelhighway3549
@excelhighway3549 6 күн бұрын
Correct
@ashwin_khullar07
@ashwin_khullar07 7 күн бұрын
Please send me the sample file
@excelhighway3549
@excelhighway3549 6 күн бұрын
The file is available on my Patreon page: www.patreon.com/ExcelHighway
@patrickmcwhite7443
@patrickmcwhite7443 7 күн бұрын
looks legit i would like a file please
@excelhighway3549
@excelhighway3549 7 күн бұрын
The file is available on my Patreon page: www.patreon.com/ExcelHighway
@carstonclark6313
@carstonclark6313 8 күн бұрын
Hello Elad! This is a great video, would you be able to share the excel file with me, please?
@excelhighway3549
@excelhighway3549 8 күн бұрын
Thanks, the file is available on my Patreon page: www.patreon.com/ExcelHighway
@bluthy2007
@bluthy2007 8 күн бұрын
This is great! I was looking for something exactly like this 2 years ago and couldn't find anything. I just subscribed! Would love a copy of this.
@excelhighway3549
@excelhighway3549 8 күн бұрын
Thanks for the feedback. The file is available on my Patreon page: www.patreon.com/ExcelHighway
@loubonnett
@loubonnett 9 күн бұрын
Great stuff, thank you, sir!!
@excelhighway3549
@excelhighway3549 9 күн бұрын
Glad it was helpful!
@tejasmehta5115
@tejasmehta5115 9 күн бұрын
The formulas that you have used and demonstrated in your video. I used same one but it does not work. Also clarity of your video in the initial part is bit of an issue. Else yours is the only video I got on internet which was meeting my requirement. Thks for reverting
@excelhighway3549
@excelhighway3549 7 күн бұрын
You can have access to the file on my Patreon page: www.patreon.com/ExcelHighway
@tejasmehta5115
@tejasmehta5115 10 күн бұрын
I used same formulaes and it does not work
@excelhighway3549
@excelhighway3549 9 күн бұрын
Which formulas?
@almaldonado4224
@almaldonado4224 10 күн бұрын
The video does not show some of the steps you take, or what screens you are looking at.
@excelhighway3549
@excelhighway3549 9 күн бұрын
Sorry about that, what part are you missing?
@DaltoneWhite
@DaltoneWhite 11 күн бұрын
How can get access to the file
@excelhighway3549
@excelhighway3549 11 күн бұрын
The file is available on my Patreon page: www.patreon.com/ExcelHighway
@Raghie14
@Raghie14 12 күн бұрын
Hello. great lesson. could you send me the template please. Thank you
@excelhighway3549
@excelhighway3549 11 күн бұрын
The file is available on my Patreon page: www.patreon.com/ExcelHighway
@todossantos2173
@todossantos2173 12 күн бұрын
Nice basic crm....just what I'm looking for as I am starting a new home and auto insurance business
@excelhighway3549
@excelhighway3549 12 күн бұрын
Glad to hear, good luck with your business.
@apap7748
@apap7748 13 күн бұрын
please share the file
@excelhighway3549
@excelhighway3549 13 күн бұрын
The file is available on my Patreon page: www.patreon.com/ExcelHighway
@satwindersinghghalay1286
@satwindersinghghalay1286 14 күн бұрын
hi, can I have access to the file, please? I have logged into your account
@excelhighway3549
@excelhighway3549 14 күн бұрын
The file is available on my Patreon Page: www.patreon.com/ExcelHighway
@juantapia7832
@juantapia7832 16 күн бұрын
Hello. Thank you very much for your video, excellent. Can I ask you a question, please? I would like to know what type of value I must to consider in the sale (accounts receivable) : net sale (without VAT) or with VAT? I understand that the sales values, cost, expenses, must always be recorded without VAT. For example: must I consider AMOUNT DUE without VAT? Thank you so much!
@excelhighway3549
@excelhighway3549 16 күн бұрын
Hi , I'm not an accountant so don't know the answer for that question.
@juantapia7832
@juantapia7832 15 күн бұрын
@@excelhighway3549 Thank you!
@mohammadkhader309
@mohammadkhader309 16 күн бұрын
I'm looking how i can drew the pallet
@excelhighway3549
@excelhighway3549 16 күн бұрын
I'm not sure what you mean, can you share more info?
@rejal.a.r
@rejal.a.r 17 күн бұрын
would like to receive the file. TIA
@excelhighway3549
@excelhighway3549 17 күн бұрын
The file is available on my Patreon page: www.patreon.com/ExcelHighway
@MohanChand-d9e
@MohanChand-d9e 18 күн бұрын
hi can you share this excel file
@excelhighway3549
@excelhighway3549 18 күн бұрын
Yes, the file is available on my Patreon page: www.patreon.com/ExcelHighway
@MohanChand-d9e
@MohanChand-d9e 17 күн бұрын
@@excelhighway3549 unable to join due to this problem "Something went wrong. Please refresh the page to try again." same issues at different browser.
@MohanChand-d9e
@MohanChand-d9e 17 күн бұрын
@@excelhighway3549 Something went wrong. Please refresh the page to try again. this problem i am facing during join.
@floresf001
@floresf001 18 күн бұрын
Do you still have this as a template?
@excelhighway3549
@excelhighway3549 18 күн бұрын
Yes, it's available on my Patreon page: www.patreon.com/ExcelHighway
@lunardisetiawan2059
@lunardisetiawan2059 19 күн бұрын
For A lot of data >10000 orders, it took a while to calculate, any solution to this?
@excelhighway3549
@excelhighway3549 18 күн бұрын
Thanks for your feedback, I'll look into this.
@cswitzer5163
@cswitzer5163 20 күн бұрын
It looks like the "Balance" column on the Auto Balance tab disappears half way through the video, which affects the formulas that use the J column.
@excelhighway3549
@excelhighway3549 18 күн бұрын
I'm not sure what you mean.
@cswitzer5163
@cswitzer5163 18 күн бұрын
@@excelhighway3549 If you look at the tab "Auto Balance" at time stamp 2:10, column I is titled "Balance" and Column J is titled "Payment". Then at time stamp 9:11, the "Balance" column is gone. Not sure if the formulas for column F "needs to pay" should draw from I or J?
@excelhighway3549
@excelhighway3549 18 күн бұрын
@@cswitzer5163 the formula for F is =MIN(VLOOKUP(E8,'Balance Sheet'!B:E,4,0),0)+SUMIF(E$1:E7,E8,I$1:I7)
@charntellekoch5607
@charntellekoch5607 22 күн бұрын
May I have access to the file please?
@excelhighway3549
@excelhighway3549 22 күн бұрын
The file is available on my Patreon page: www.patreon.com/ExcelHighway
@excelhighway3549
@excelhighway3549 22 күн бұрын
Here is the link to the course: elad-sharon-s-school.teachable.com/p/data-analyst
@ShahsawarKhan-d1z
@ShahsawarKhan-d1z 23 күн бұрын
plz sir this file can be send me on this gamil
@excelhighway3549
@excelhighway3549 23 күн бұрын
The file is available on my Patreon page: www.patreon.com/ExcelHighway
@studywithlexieMD
@studywithlexieMD 23 күн бұрын
Hi. I had trouble with the app script in the ChatGBTrecipe sheet because it was looking for a variable. The recipe does not disappear like in the video. Can you help me out?
@excelhighway3549
@excelhighway3549 22 күн бұрын
I fixed the script , you can recopy the file or change line 7 in the code to this : if(sh.getName() == 'ChatGBT Recipe' && e.range.columnStart == 1 && e.range.rowStart == 2)
@studywithlexieMD
@studywithlexieMD 20 күн бұрын
@@excelhighway3549 Still the same :// the data in A8:A Doesn't disappear :/
@studywithlexieMD
@studywithlexieMD 20 күн бұрын
@@excelhighway3549 wouldn't this affect the code for the shopping list?
@happybaby-littleangelheba2698
@happybaby-littleangelheba2698 25 күн бұрын
Hello Sir, great video. And you made it so simple , awesome. Possible to get the file please ?
@excelhighway3549
@excelhighway3549 25 күн бұрын
The file is available on my Patreon page: www.patreon.com/ExcelHighway
@samiphysio617
@samiphysio617 25 күн бұрын
Hi love the work , can you please share a template
@excelhighway3549
@excelhighway3549 25 күн бұрын
The file is available on my Patreon page: www.patreon.com/ExcelHighway
@mohammadalshaboul9569
@mohammadalshaboul9569 28 күн бұрын
Incredible work thank you so much. This basically solves my problem with the last video I believe I watched on your channel on the same topic.
@excelhighway3549
@excelhighway3549 27 күн бұрын
Glad it helped!
@mohammedbelattar8212
@mohammedbelattar8212 28 күн бұрын
Thanks for the vidéo. That s what I was looking for 🎉
@excelhighway3549
@excelhighway3549 28 күн бұрын
You are welcome
@md.rakibulhasan2704
@md.rakibulhasan2704 28 күн бұрын
Appreciate a copy of the file
@excelhighway3549
@excelhighway3549 28 күн бұрын
The file is available on my Patreon page: www.patreon.com/ExcelHighway
@edsmith7889
@edsmith7889 29 күн бұрын
Bless you! 🤧
@excelhighway3549
@excelhighway3549 29 күн бұрын
Thank you
@mixerman4541
@mixerman4541 Ай бұрын
Can I get this template
@excelhighway3549
@excelhighway3549 Ай бұрын
Yes, it's available on my Patreon page: www.patreon.com/ExcelHighway
@vikasadhav42
@vikasadhav42 Ай бұрын
Can you provide me free excel template..
@excelhighway3549
@excelhighway3549 Ай бұрын
The file is no longer available for free, you can gain access to it via my Patreon page: www.patreon.com/ExcelHighway
@AlindaLomeli
@AlindaLomeli Ай бұрын
I need help with the array formula
@excelhighway3549
@excelhighway3549 Ай бұрын
Happy to help, what's the issue?
@Cncbd
@Cncbd Ай бұрын
Can you give me the file, thank you
@excelhighway3549
@excelhighway3549 Ай бұрын
Please subscribe to my newsletter and you will receive it: excelhighway.ck.page/b35ec4b6d7
@justinpark9089
@justinpark9089 Ай бұрын
I got great information from your youtube. I really appreciate it. I will use this wonderful skill to my job.
@excelhighway3549
@excelhighway3549 Ай бұрын
Thank you! That's great feedback.
@MarissaKessler-xq6kr
@MarissaKessler-xq6kr Ай бұрын
Great page, looks like I could easily convert this to track how many items can be made from individual rolls of fabric. Thanks.
@excelhighway3549
@excelhighway3549 Ай бұрын
Interesting, thank you for your feedback.
@spiritch3r
@spiritch3r Ай бұрын
Appreciate a copy of the file, please. Love your work.
@excelhighway3549
@excelhighway3549 Ай бұрын
Thanks, this file along with other is available on my Patreon page: www.patreon.com/ExcelHighway
@spiritch3r
@spiritch3r Ай бұрын
Appreciate a copy please
@excelhighway3549
@excelhighway3549 Ай бұрын
Thanks, this file along with other is available on my Patreon page: www.patreon.com/ExcelHighway
@waeldalgamouni6837
@waeldalgamouni6837 Ай бұрын
Can I get this sheet
@excelhighway3549
@excelhighway3549 Ай бұрын
This file along with other is available on my Patreon page: www.patreon.com/ExcelHighway
@martindobson6445
@martindobson6445 Ай бұрын
Great spreadsheet, It is password protected. So I cannot add anything
@excelhighway3549
@excelhighway3549 Ай бұрын
Thanks, an unprotected version is available on my Patreon page: www.patreon.com/ExcelHighway You will have access to over 50 files including this one and your support will allow me to focus more on creating useful content like this.
@denverdano6487
@denverdano6487 Ай бұрын
Very nice. Would love to have a copy of this. Thank you.
@excelhighway3549
@excelhighway3549 Ай бұрын
Thanks, the file is available on my Patreon page: www.patreon.com/ExcelHighway