Тёмный
Excel Highway
Excel Highway
Excel Highway
Подписаться
Hi and welcome to my channel!
My name is Elad, I have been using Excel for more than 10 years.
I have always been the office go to guy for any questions and support using Excel.
For the last few years I have been developing complex files using VBA coding.
In this channel I will share with you excel tips, how to tutorials and nice projects I created.
Feel free to leave a comment if you want me to post a video about a topic that interests you.
Support this channel on Patreon:
www.patreon.com/ExcelHighway?fan_landing=true
You can also send me an email at elad.sharon@excelhighway.com
team resource planning template
13:39
День назад
Company Budget management
13:20
21 день назад
Data Analyst Excel Course
1:55
Месяц назад
prepare work shift roster schedule in excel
10:58
2 месяца назад
Dynamic Calendar
8:08
2 месяца назад
Invoice Generator and payment tracker
7:57
2 месяца назад
invoice generator in excel
9:12
3 месяца назад
easy employee scheduling with excel
10:24
3 месяца назад
pre record your script on youtube
2:02
3 месяца назад
Improving Employee Training Using Feedback
9:44
3 месяца назад
Resource planning template
9:36
3 месяца назад
Tracking employee onboarding
13:53
3 месяца назад
employee onboarding tool
11:24
3 месяца назад
Risk Management
7:47
3 месяца назад
CRM for solopreneurs
12:32
4 месяца назад
Task Management 4 0
5:41
4 месяца назад
Create a Project Management tool in Excel
25:19
4 месяца назад
container loading model Google sheets
14:46
4 месяца назад
candidate assessment tests
5:20
5 месяцев назад
automatic shift scheduling system
14:50
5 месяцев назад
Team/Employee Task Management System
7:37
6 месяцев назад
random math questions
13:08
7 месяцев назад
Комментарии
@leandrin84
@leandrin84 11 часов назад
I would like a sample!
@excelhighway3549
@excelhighway3549 4 часа назад
The file is available on my Patreon page: www.patreon.com/ExcelHighway
@excelhighway3549
@excelhighway3549 День назад
Follow along and build the tracker. The file is available on my Etsy shop: excelhighway.etsy.com/listing/1770536594/customizable-nutrition-tracker-google Or Patreon page: www.patreon.com/ExcelHighway
@PhillipNguyen-x5j
@PhillipNguyen-x5j 6 дней назад
Great video. I love the clear check box function. Is there any function that when we click to one check box, it will uncheck another check box?
@excelhighway3549
@excelhighway3549 6 дней назад
Thanks, I'm not sure but it sounds possible.
@kevincastaneda4088
@kevincastaneda4088 6 дней назад
Hello, I would love a free sample of the spreadsheet. Thank you.
@excelhighway3549
@excelhighway3549 6 дней назад
The file is available on my Patreon page: www.patreon.com/ExcelHighway
@stinglikeabee2469
@stinglikeabee2469 7 дней назад
Sir, when I add Line 4-5…, become Number/0 mistakes in Scheduled. How can be fix it?. Thanks
@excelhighway3549
@excelhighway3549 6 дней назад
You should check the cells that are calculated that drive the error, perhaps you are trying to divide by zero or a text value?
@LieveVrijsen
@LieveVrijsen 7 дней назад
Great video! Would love to have the template
@excelhighway3549
@excelhighway3549 7 дней назад
Thanks , the file is available on my Patreon page: www.patreon.com/ExcelHighway
@IainBensonArmer
@IainBensonArmer 7 дней назад
Kindly share the file .
@excelhighway3549
@excelhighway3549 7 дней назад
The file is available on my Patreon page: www.patreon.com/ExcelHighway
@excelhighway3549
@excelhighway3549 8 дней назад
Follow along and build on your own or purchase on my Etsy shop or Patreon page: excelhighway.etsy.com/listing... www.patreon.com/posts/team-re...
@PaoloDeLuca-g6s
@PaoloDeLuca-g6s 9 дней назад
Nice, one question, if u have a batch depleted, how can i start only the active one for the same product? for expample i dont' want to have row 9, 10, 11 and it start with the row 12?
@excelhighway3549
@excelhighway3549 7 дней назад
You can deplete the quantity of the purchased amount in the purchases sheet.
@sanjayshrestha3013
@sanjayshrestha3013 12 дней назад
So nice and easy way u shared thanks
@excelhighway3549
@excelhighway3549 12 дней назад
Thank you
@aaronp7348
@aaronp7348 13 дней назад
Why are you removing Wolfram Data Types in Excel from Microsoft 365 Personal and Family subscriptions? "As part of our path toward innovation and modernization in Excel, we entered a unique partnership with Wolfram to expand our set of available linked data types and create premium templates by utilizing their pre-existing breadth of knowledge. We’re simply choosing not to renew this partnership for this particular range of data. Instead, we’ll be focusing our efforts on other innovations like using data types to connect to your personal data, and ways for developers to organize data types connected to their own service." Thia iS A JOKE FROM EXCEL... Always trying to make it hard for the person to reach their goals... I promise tracking macros is the only thing you need to lose weight.
@user-yv3kv4vw6v
@user-yv3kv4vw6v 14 дней назад
Share file
@excelhighway3549
@excelhighway3549 14 дней назад
The file is available on my Patreon page: www.patreon.com/ExcelHighway
@KidsJumpNPlayAZ
@KidsJumpNPlayAZ 18 дней назад
I need this please! Would it be possible to include carb amount for each recipes? Im looking for something I can use for my daughters meal planning, she has t1d and we need to keep track of carbs for each recipe. I have all my recipes and ingredient list in excel sheets I just want to make sure I'm able to include the carbs.
@excelhighway3549
@excelhighway3549 18 дней назад
It is possible. Please send me an email so we can review the requirements.
@musaali7284
@musaali7284 18 дней назад
Can I get this modle please?
@excelhighway3549
@excelhighway3549 18 дней назад
The file is available on my Patreon page: www.patreon.com/ExcelHighway
@musaali7284
@musaali7284 18 дней назад
@@excelhighway3549 this link you sent, it can not be open.
@musaali7284
@musaali7284 18 дней назад
@@excelhighway3549 when I click on this link, the page is not loading and says like this (This site can’t be reached)
@excelhighway3549
@excelhighway3549 18 дней назад
@@musaali7284 please try again, I just used it and it worked for me.
@musaali7284
@musaali7284 18 дней назад
@@excelhighway3549 I tried many times but it doesn't work with me. Can you send me the file to my email address please?
@FranklinVillafranca
@FranklinVillafranca 19 дней назад
Hello, me ayudas con el archivo saludo
@excelhighway3549
@excelhighway3549 18 дней назад
The file is available on my Patreon page: www.patreon.com/ExcelHighway
@MrMichaellyday13
@MrMichaellyday13 19 дней назад
This is a great video & visulization of a production schedule. Would you be able to send me a copy of this spreadsheet?
@excelhighway3549
@excelhighway3549 19 дней назад
Thank you , the file is available on my Patreon page: www.patreon.com/ExcelHighway
@user-eg3os6dw6f
@user-eg3os6dw6f 19 дней назад
I get a persistent syntax error on line #9 : lRow = ws.Cells(Rows.Count, col).End(xlUp).row Could you please advice?
@excelhighway3549
@excelhighway3549 19 дней назад
Is ws defined properly?
@Throughourlenz
@Throughourlenz 20 дней назад
Can you please share the file
@excelhighway3549
@excelhighway3549 19 дней назад
The file is available on my Patreon page: www.patreon.com/ExcelHighway
@benipui
@benipui 20 дней назад
Looks good. Tempted to purchase. Want to ask if the ingredients can be sorted alphabetically? as the list of ingredients would be huge for a big menu
@excelhighway3549
@excelhighway3549 20 дней назад
Yes, absolutely. All the tables and range can be sorted with Google's filter function.
@excelhighway3549
@excelhighway3549 22 дня назад
The file is available on my Patreon page: www.patreon.com/ExcelHighway
@jeremyarizona1091
@jeremyarizona1091 23 дня назад
Great video! Quick question. Why are rows 4-7 hidden on your InboundBarcode sheet? The items scanned start on row 8 for the InboundBarcode sheet, but start on row 4 for OutboundBarcode sheet? Why?
@jeremyarizona1091
@jeremyarizona1091 23 дня назад
Update: it looks like sometimes it rows 4-7 show, but other times they do not. Is there a reason for this?
@excelhighway3549
@excelhighway3549 23 дня назад
Thanks, no reason the items that are scanned will be saved from row 4.
@rajasekar7478
@rajasekar7478 23 дня назад
could you please explain step by step how to make this template
@excelhighway3549
@excelhighway3549 23 дня назад
I did. Please watch the video.
@GoingGreenMom
@GoingGreenMom 23 дня назад
It seems like this would be easier without Chat GPT. Lol.
@excelhighway3549
@excelhighway3549 23 дня назад
Could be , it's not a must 😀
@Momo33Egy
@Momo33Egy 28 дней назад
Could you send to me downloadable link for this excel sheet to use it directly?
@excelhighway3549
@excelhighway3549 28 дней назад
The file is available on m Patreon page: www.patreon.com/ExcelHighway
@KathleenCarroll-x3q
@KathleenCarroll-x3q 28 дней назад
Hello, do you have the downloadable file ready? Can this be used in Google Sheets?
@excelhighway3549
@excelhighway3549 28 дней назад
The file is available on m Patreon page: www.patreon.com/ExcelHighway
@DanCrawford-f3h
@DanCrawford-f3h 29 дней назад
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 28 дней назад
Can you share your code?
@binarytinhgontradebo
@binarytinhgontradebo 24 дня назад
​@@excelhighway3549Share code tks ❤
@mwandunzimba8711
@mwandunzimba8711 29 дней назад
Thank you! Very helpful.
@excelhighway3549
@excelhighway3549 29 дней назад
Glad it was helpful!
@psijjjm
@psijjjm Месяц назад
I need the template.
@excelhighway3549
@excelhighway3549 Месяц назад
It's available on my Patreon page or Etsy shop
@psijjjm
@psijjjm Месяц назад
Nice tool. What is the currency of the price tag?
@excelhighway3549
@excelhighway3549 Месяц назад
Thank you, USD
@hussainalatia8418
@hussainalatia8418 Месяц назад
Awesome work, thanks for sharing
@excelhighway3549
@excelhighway3549 Месяц назад
Thanks for watching!
@Evraaah
@Evraaah Месяц назад
Hi sir, may I have the link to the template?
@excelhighway3549
@excelhighway3549 Месяц назад
The file is available on my Patreon page: www.patreon.com/ExcelHighway
@tejasmehta5115
@tejasmehta5115 Месяц назад
You provided access to the file but its asking for paid subscription.
@excelhighway3549
@excelhighway3549 Месяц назад
Correct
@ashwin_khullar07
@ashwin_khullar07 Месяц назад
Please send me the sample file
@excelhighway3549
@excelhighway3549 Месяц назад
The file is available on my Patreon page: www.patreon.com/ExcelHighway
@patrickmcwhite7443
@patrickmcwhite7443 Месяц назад
looks legit i would like a file please
@excelhighway3549
@excelhighway3549 Месяц назад
The file is available on my Patreon page: www.patreon.com/ExcelHighway
@carstonclark6313
@carstonclark6313 Месяц назад
Hello Elad! This is a great video, would you be able to share the excel file with me, please?
@excelhighway3549
@excelhighway3549 Месяц назад
Thanks, the file is available on my Patreon page: www.patreon.com/ExcelHighway
@bluthy2007
@bluthy2007 Месяц назад
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 Месяц назад
Thanks for the feedback. The file is available on my Patreon page: www.patreon.com/ExcelHighway
@loubonnett
@loubonnett Месяц назад
Great stuff, thank you, sir!!
@excelhighway3549
@excelhighway3549 Месяц назад
Glad it was helpful!
@tejasmehta5115
@tejasmehta5115 Месяц назад
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 Месяц назад
You can have access to the file on my Patreon page: www.patreon.com/ExcelHighway
@tejasmehta5115
@tejasmehta5115 Месяц назад
I used same formulaes and it does not work
@excelhighway3549
@excelhighway3549 Месяц назад
Which formulas?
@almaldonado4224
@almaldonado4224 Месяц назад
The video does not show some of the steps you take, or what screens you are looking at.
@excelhighway3549
@excelhighway3549 Месяц назад
Sorry about that, what part are you missing?
@DaltoneWhite
@DaltoneWhite Месяц назад
How can get access to the file
@excelhighway3549
@excelhighway3549 Месяц назад
The file is available on my Patreon page: www.patreon.com/ExcelHighway
@Raghie14
@Raghie14 Месяц назад
Hello. great lesson. could you send me the template please. Thank you
@excelhighway3549
@excelhighway3549 Месяц назад
The file is available on my Patreon page: www.patreon.com/ExcelHighway
@todossantos2173
@todossantos2173 Месяц назад
Nice basic crm....just what I'm looking for as I am starting a new home and auto insurance business
@excelhighway3549
@excelhighway3549 Месяц назад
Glad to hear, good luck with your business.
@apap7748
@apap7748 Месяц назад
please share the file
@excelhighway3549
@excelhighway3549 Месяц назад
The file is available on my Patreon page: www.patreon.com/ExcelHighway
@satwindersinghghalay1286
@satwindersinghghalay1286 Месяц назад
hi, can I have access to the file, please? I have logged into your account
@excelhighway3549
@excelhighway3549 Месяц назад
The file is available on my Patreon Page: www.patreon.com/ExcelHighway
@juantapia7832
@juantapia7832 Месяц назад
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 Месяц назад
Hi , I'm not an accountant so don't know the answer for that question.
@juantapia7832
@juantapia7832 Месяц назад
@@excelhighway3549 Thank you!
@mohammadkhader309
@mohammadkhader309 Месяц назад
I'm looking how i can drew the pallet
@excelhighway3549
@excelhighway3549 Месяц назад
I'm not sure what you mean, can you share more info?
@rejal.a.r
@rejal.a.r Месяц назад
would like to receive the file. TIA
@excelhighway3549
@excelhighway3549 Месяц назад
The file is available on my Patreon page: www.patreon.com/ExcelHighway
@MohanChand-d9e
@MohanChand-d9e Месяц назад
hi can you share this excel file
@excelhighway3549
@excelhighway3549 Месяц назад
Yes, the file is available on my Patreon page: www.patreon.com/ExcelHighway
@MohanChand-d9e
@MohanChand-d9e Месяц назад
@@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 Месяц назад
@@excelhighway3549 Something went wrong. Please refresh the page to try again. this problem i am facing during join.
@floresf001
@floresf001 Месяц назад
Do you still have this as a template?
@excelhighway3549
@excelhighway3549 Месяц назад
Yes, it's available on my Patreon page: www.patreon.com/ExcelHighway