- Видео 141
- Просмотров 738 392
Excel Highway
Израиль
Добавлен 31 янв 2021
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
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
📊 Team Resource Planning in Google Sheets |
Welcome to my channel! In this video, I’ll walk you through a powerful and easy-to-use team resource planning template in Google Sheets. Whether you’re managing a small team or coordinating across departments, this template will help you track availability, assign projects, and ensure that you are staffed efficiently.
🔍 What You’ll Learn:
How to set up your team’s availability and project requirements.
Step-by-step instructions on assigning resources.
💡 Why Use This Template?
This resource planning template offers a clear and organized way to manage your team’s workload, preventing overbooking. It’s perfect for project managers, team leads, or anyone...
Welcome to my channel! In this video, I’ll walk you through a powerful and easy-to-use team resource planning template in Google Sheets. Whether you’re managing a small team or coordinating across departments, this template will help you track availability, assign projects, and ensure that you are staffed efficiently.
🔍 What You’ll Learn:
How to set up your team’s availability and project requirements.
Step-by-step instructions on assigning resources.
💡 Why Use This Template?
This resource planning template offers a clear and organized way to manage your team’s workload, preventing overbooking. It’s perfect for project managers, team leads, or anyone...
Просмотров: 54
Видео
Company Budget management
Просмотров 6314 дней назад
Unlock the Secrets of Effective Company Budget Management with Google Sheets! 📊 In this video, we dive into a comprehensive Google Sheets file designed to streamline your company's budget management. From tracking expenses and HR costs to forecasting income, this sheet provides a complete overview to keep your financials in check. Key Features: Summary Sheet: Combines expenses, HR costs, and in...
Master Data Analysis With Excel: The Ultimate Course
Просмотров 113Месяц назад
Unlock the full potential of Excel and become a data analysis expert with our comprehensive course! Whether you're a beginner or looking to refine your skills, this course is designed to transform you into an Excel powerhouse. Here is the link to the course: elad-sharon-s-school.teachable.com/p/data-analyst
Data Analyst Excel Course
Просмотров 56Месяц назад
Unlock the full potential of Excel with our comprehensive data analyst course! Learn essential skills, advanced techniques, and real-world applications to transform your data into actionable insights. Perfect for beginners and seasoned professionals looking to enhance their expertise. Join now and elevate your data analysis game! Here is the link to the course: elad-sharon-s-school.teachable.co...
employee scheduling system send email notifications
Просмотров 103Месяц назад
In today's video I want to share with you a file I created for preparing a work shift roster schedule in Excel. This is the 2nd part of the file , here I will show the email notification part. Check out the first part here: ruclips.net/video/cO628CbddNs/видео.html Excel is so much more than people think, I love to surprise people with what can be achieved. This video is sponsored by Connecteam,...
prepare work shift roster schedule in excel
Просмотров 1972 месяца назад
In today's video I want to share with you a file I created for preparing a work shift roster schedule in Excel. Excel is so much more than people think, I love to surprise people with what can be achieved. This video is sponsored by Connecteam, the all-in-one employee management app that simplifies communication, time tracking, and task management. Try now for free using my affiliate link: part...
Dynamic Calendar
Просмотров 1282 месяца назад
In today's video I will share with how to easily create a dynamic google sheets calendar. There is no limit to the number of tasks per day. All the cells will change according to the number of events. Here is a link to receive the file: excelhighway.ck.page/fcba7016fe Check out more files on my Patreon page: www.patreon.com/ExcelHighway
Invoice Generator and payment tracker
Просмотров 932 месяца назад
Do you want to custom fit your invoices? Change the text, logos etc. Do you want to track your customer payments in a very easy way? If yes, stay tuned as I show you how I created an Invoice Generator and payment tracker excel file. For a limited time the file will be available by signing up to my newsletter. Click the link: excelhighway.ck.page/656648c0d3 The file is available on my Patreon pa...
invoice generator in excel
Просмотров 1312 месяца назад
Subscribe to my newsletter and receive a free copy: excelhighway.ck.page/85c1123713 Learn how to create a simple but effective invoice generator. There is a built in customer database to speed up the process. Other then that there are a few formulas, some formatting and you can create your very own invoice template.
easy employee scheduling with excel
Просмотров 1303 месяца назад
In today’s video I will share with you a tool for scheduling your employees’ shifts in a centralized way. I wanted to make a very simple and effective tool for managers that want to build shifts - I was thinking of restaurant owners, head nurses etc. I think the result is pretty good. It includes a calendar view of your work week. Automated buttons in a custom ribbon to quickly schedule, remove...
pre record your script on youtube
Просмотров 263 месяца назад
Most of my videos are screen sharing my work explaining the details. I like to write a script before but always had issues reading it while sharing. I tried to read my script on a phone, 2nd computer and even printing it. Every time I had issues focusing on both the text and the screen I'm sharing. Lately I found a simple but effective method to achieve this. Watch the video and you can try it ...
Improving Employee Training Using Feedback
Просмотров 313 месяца назад
Do you want to track your training processes? Want to see which employees completed their needed training receive feedback from them? In today's video I will share how I built a google form and sheets process to do that in a very simple way. This video is sponsored by Connecteam, the all-in-one employee management app that simplifies communication, time tracking, and task management. Try now fo...
Resource planning template
Просмотров 5603 месяца назад
Learn how to build a resource planning template in Google Sheets. Define your team by department / skill and their availability per month. Define your projects / jobs - how many people you need from each department / skill. After that you can play with the scheduling and see if you have enough people to support your needs. You can also see if that changes between months. Download this file and ...
Tracking employee onboarding
Просмотров 1823 месяца назад
Do you want a simple solution for tracking your employees onboarding process? Stay tuned as I walk you through this system built on Google Forms and Google Sheets. Your employees' responses are tracked and gathered in one central file. You can analyze which employees need reminders and your overall status. This video is sponsored by Connecteam, the all-in-one employee management app that simpli...
employee onboarding tool
Просмотров 943 месяца назад
In today's video I want to share how you can use Google forms to create an employee onboarding tool. I use google sheets to create forms that can be filled by employees. In a follow up video I will show how to create a google sheets file to gather all the data and analyze the situation. This video is sponsored by Connecteam, the all-in-one employee management app that simplifies communication, ...
how to make a stakeholder map in excel
Просмотров 8143 месяца назад
how to make a stakeholder map in excel
Create a Project Management tool in Excel
Просмотров 2054 месяца назад
Create a Project Management tool in Excel
container loading model Google sheets
Просмотров 8524 месяца назад
container loading model Google sheets
Efficient Time Tracking with Google Forms and Sheets with time limitations
Просмотров 1225 месяцев назад
Efficient Time Tracking with Google Forms and Sheets with time limitations
Restaurant menu price calculator using google sheets
Просмотров 7215 месяцев назад
Restaurant menu price calculator using google sheets
google sheets meal planner with shopping list tutorial
Просмотров 4,5 тыс.6 месяцев назад
google sheets meal planner with shopping list tutorial
Team/Employee Task Management System
Просмотров 3366 месяцев назад
Team/Employee Task Management System
Efficient Time Tracking with Google Forms and Sheets
Просмотров 8496 месяцев назад
Efficient Time Tracking with Google Forms and Sheets
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?
Thanks, I'm not sure but it sounds possible.
Hello, I would love a free sample of the spreadsheet. Thank you.
The file is available on my Patreon page: www.patreon.com/ExcelHighway
Sir, when I add Line 4-5…, become Number/0 mistakes in Scheduled. How can be fix it?. Thanks
You should check the cells that are calculated that drive the error, perhaps you are trying to divide by zero or a text value?
Great video! Would love to have the template
Thanks , the file is available on my Patreon page: www.patreon.com/ExcelHighway
Kindly share the file .
The file is available on my Patreon page: www.patreon.com/ExcelHighway
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...
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?
You can deplete the quantity of the purchased amount in the purchases sheet.
So nice and easy way u shared thanks
Thank you
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.
Share file
The file is available on my Patreon page: www.patreon.com/ExcelHighway
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.
It is possible. Please send me an email so we can review the requirements.
Can I get this modle please?
The file is available on my Patreon page: www.patreon.com/ExcelHighway
@@excelhighway3549 this link you sent, it can not be open.
@@excelhighway3549 when I click on this link, the page is not loading and says like this (This site can’t be reached)
@@musaali7284 please try again, I just used it and it worked for me.
@@excelhighway3549 I tried many times but it doesn't work with me. Can you send me the file to my email address please?
Hello, me ayudas con el archivo saludo
The file is available on my Patreon page: www.patreon.com/ExcelHighway
This is a great video & visulization of a production schedule. Would you be able to send me a copy of this spreadsheet?
Thank you , the file is available on my Patreon page: www.patreon.com/ExcelHighway
I get a persistent syntax error on line #9 : lRow = ws.Cells(Rows.Count, col).End(xlUp).row Could you please advice?
Is ws defined properly?
Can you please share the file
The file is available on my Patreon page: www.patreon.com/ExcelHighway
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
Yes, absolutely. All the tables and range can be sorted with Google's filter function.
The file is available on my Patreon page: www.patreon.com/ExcelHighway
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?
Update: it looks like sometimes it rows 4-7 show, but other times they do not. Is there a reason for this?
Thanks, no reason the items that are scanned will be saved from row 4.
could you please explain step by step how to make this template
I did. Please watch the video.
It seems like this would be easier without Chat GPT. Lol.
Could be , it's not a must 😀
Could you send to me downloadable link for this excel sheet to use it directly?
The file is available on m Patreon page: www.patreon.com/ExcelHighway
Hello, do you have the downloadable file ready? Can this be used in Google Sheets?
The file is available on m Patreon page: www.patreon.com/ExcelHighway
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.
Can you share your code?
@@excelhighway3549Share code tks ❤
Thank you! Very helpful.
Glad it was helpful!
I need the template.
It's available on my Patreon page or Etsy shop
Nice tool. What is the currency of the price tag?
Thank you, USD
Awesome work, thanks for sharing
Thanks for watching!
Hi sir, may I have the link to the template?
The file is available on my Patreon page: www.patreon.com/ExcelHighway
You provided access to the file but its asking for paid subscription.
Correct
Please send me the sample file
The file is available on my Patreon page: www.patreon.com/ExcelHighway
looks legit i would like a file please
The file is available on my Patreon page: www.patreon.com/ExcelHighway
Hello Elad! This is a great video, would you be able to share the excel file with me, please?
Thanks, the file is available on my Patreon page: www.patreon.com/ExcelHighway
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.
Thanks for the feedback. The file is available on my Patreon page: www.patreon.com/ExcelHighway
Great stuff, thank you, sir!!
Glad it was helpful!
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
You can have access to the file on my Patreon page: www.patreon.com/ExcelHighway
I used same formulaes and it does not work
Which formulas?
The video does not show some of the steps you take, or what screens you are looking at.
Sorry about that, what part are you missing?
How can get access to the file
The file is available on my Patreon page: www.patreon.com/ExcelHighway
Hello. great lesson. could you send me the template please. Thank you
The file is available on my Patreon page: www.patreon.com/ExcelHighway
Nice basic crm....just what I'm looking for as I am starting a new home and auto insurance business
Glad to hear, good luck with your business.
please share the file
The file is available on my Patreon page: www.patreon.com/ExcelHighway
hi, can I have access to the file, please? I have logged into your account
The file is available on my Patreon Page: www.patreon.com/ExcelHighway
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!
Hi , I'm not an accountant so don't know the answer for that question.
@@excelhighway3549 Thank you!
I'm looking how i can drew the pallet
I'm not sure what you mean, can you share more info?
would like to receive the file. TIA
The file is available on my Patreon page: www.patreon.com/ExcelHighway
hi can you share this excel file
Yes, the file is available on my Patreon page: www.patreon.com/ExcelHighway
@@excelhighway3549 unable to join due to this problem "Something went wrong. Please refresh the page to try again." same issues at different browser.
@@excelhighway3549 Something went wrong. Please refresh the page to try again. this problem i am facing during join.
Do you still have this as a template?
Yes, it's available on my Patreon page: www.patreon.com/ExcelHighway
For A lot of data >10000 orders, it took a while to calculate, any solution to this?
Thanks for your feedback, I'll look into this.
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.
I'm not sure what you mean.
@@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?
@@cswitzer5163 the formula for F is =MIN(VLOOKUP(E8,'Balance Sheet'!B:E,4,0),0)+SUMIF(E$1:E7,E8,I$1:I7)