Hi Chandoo. Very nice made! One other drawback of this model is that it only sees one month. What if an employee worked many hours in the previous month? You want to take this into consideration as well. You also want to see the cumulative hours per year. For calculating the numbers of days per employee you used the VSTACK, but why did you not just used COUNTIF and use the “planning range” as input?
Hey Chandoo, would you be able to create step by step excel sheet for staff timesheet. As staff comes in they can scan their unique barcodes and the sheet takes the time. Time in, time out, break in, break out and lunch in, lunch out, time out. Total hours of shift worked deducting break times. Thanks
Chandoo pls love from india. I'm facing the one condition use Google sheet make pivot table need click pivot table showing data as same sheet not new sheet data visible same sheet pls❤help
Hello Sir Pls help me I'm facing the one condition use Google sheet make pivot table need click pivot table showing data as same sheet not new sheet data visible same sheet pls❤help
Hi chandoo hope so you are doing well. I have a query. Let's say we are having two cols Named Category and Subcategory. Like List A List B Category 1 S1 Category 1 S2 Category 1 S3 Category 1 S4 Category 2 H1 Category 2 H2 Category 2 H3 Category 2 H4 What i want Category 1 S1 S2 S3 S4 Category 2 H1 H2 H3 H4 In a simgle column. For creating drop down.
💥Get Connecteam for FREE 👉 connecteam.cc/3QSAjlQ
Use it to manage your staff, shift schedules and vacation details and so much more.
Really nice app! We have it for years now and we all love it! Employees and managers
I absolutely love your sense of humor. 😂😂😂 Thank you for all you do to pull and push us along in this data journey💕
exactly 😂😂e
Great video, thanks Chandoo!
Your classes are, so much useful for beginners, sir
Hi Chandoo. Very nice made! One other drawback of this model is that it only sees one month. What if an employee worked many hours in the previous month? You want to take this into consideration as well. You also want to see the cumulative hours per year. For calculating the numbers of days per employee you used the VSTACK, but why did you not just used COUNTIF and use the “planning range” as input?
Excellent 🎉thanks for sharing 👍
Thanks for watching
Hey Chandoo, would you be able to create step by step excel sheet for staff timesheet. As staff comes in they can scan their unique barcodes and the sheet takes the time. Time in, time out, break in, break out and lunch in, lunch out, time out. Total hours of shift worked deducting break times. Thanks
Praise the Lord Brother 🎊
Chandoo pls love from india.
I'm facing the one condition use Google sheet make pivot table need click pivot table showing data as same sheet not new sheet data visible same sheet pls❤help
Hello Sir Pls help me
I'm facing the one condition use Google sheet make pivot table need click pivot table showing data as same sheet not new sheet data visible same sheet pls❤help
You are so good with explaining concept. god of exce. How did you become so good with excel?
Which version of 365 are you using? I'm using 365 as well but I don't have that Place in cell option yet.
Amazing Sir, could pls schedule live session for Q & A, tq
As a beginner how can i be good at Excel? What is the proper roadmap? It will be very helpful for me. Thanks.
Hi. ..Are you able to do video about Business Analyst tutorial and give some projects to try out pls
Hi chandoo hope so you are doing well.
I have a query.
Let's say we are having two cols
Named Category and Subcategory.
Like
List A List B
Category 1 S1
Category 1 S2
Category 1 S3
Category 1 S4
Category 2 H1
Category 2 H2
Category 2 H3
Category 2 H4
What i want
Category 1
S1
S2
S3
S4
Category 2
H1
H2
H3
H4
In a simgle column. For creating drop down.
Large bush…😂
hello, i am from India and want to take your classes available on the website. Can you provide google pay (G-PAY) option?
Hey Chandoo
Have you gotten the technical writer? Or you are still accepting applications?
Helpful ..
Thank you! Is it possible to learn python 3 on codecademy?
Large Bush 😂😂😂
Can anyone start a data analytics company for small business company using only Excel expertise
Hello bro I'm from Pakistan I want to learn Data analyst basic to advance and go to usa uk or canada for data analyst job thanks
Hi, looks download file doesn't exist, ( page not found)|, any chance you can update. Thanks for all knowledge that I've gained thanx to you.
Hey... Try again please. It works now.
Your employee list isn't dynamic? Use in AM5: =unique(filter(B5:B15,B5:B15"","")) and in the list conditional formatting =$AM$5#
data download is not working
Try again please. It works for me.