almost 11 years old and still helpful :) I was going crazy since I remembered I had to drag down the mouse but wasn't doing it from the little square !
When 3: 00, It's exactly what I need to know！I was trying to figure out for like about 30min....and now i got it, It's really helped ！Thank you so much ！
Hello Joe, I am at my Witts end. I simply need to schedule an excel worksheet for 2 days every week. So every Tuesday and Friday. I am having a horrible time finding a formula or way to do this. Please help??? Sorry...You are wonderful. An excellent instructor and very easy to listen to. Please keep these coming. ;)
Thank you so much sir, very clear and easy to follow and understand, you helps me a lot... hope more tutorial videos to upload about Microsoft Excel. God bless...
Thanks, Joe. I'd like to have in a row May, 2019; June 2019; July 2019 till May, 2021. But when I introduce May, 2019 and June 2019 and select both and drag down I get May, 2020 and June 2020. How I I make sure that when I drag down I get a continuation of the months that year instead of jumping into the next year? Thank you.
hello, i have a problem with dates and months, when I drag the mouse, I get the same day/month copied to other cells. I tried to use Ctrl at the same time as dragging, same result. Also when I click on auto fill options, I have only "copy cells", "fill without formatting", "fill formatting only" and " flash fill". Any solution to this? Thanks
i need a week ending formula, as weekending is Sun but it should consider the duration from Monday to Sun in the same week. Eg: we should get the weekending as 17th Dec, 2017, duration starting from 11th of Dec ,17- to 17th, Dec,17.
one method is: take three separate columns for day month and year. copy the values of date and year in below cells as it is. start value of month from 1 and increase it by 1 in below columns. now use concatenate all the three columns and make it a date. then use fill handle to copy the formula in below cells.
On a practice test I took recently, I was asked to enter the following text 1895.....900...2020 yet the cell stopped at 34. How was I to use autofill to complete the task? Didn't/Doesn't make sense should this question reappear how should I approach this question? Thanks!
Hi. How do I get fill in increments when I have a letter in it like this (001:A 002:A 003:A 004:A 005:A) I want the number to increase but the rest stay the same? Thank you.
Hi JoeIt is very helpful, but my question still NOT sloved, I want to mke a working time tabel for every year and every month, i wish the date(1-31) and weekdag(sun-sat) will change automatly if i change the year(2016 or 2017...) or month( jan or May...)Or can you sent me a link?Thanks
Hi sir, your video is really helpful, thanks for your valuable time spending for us. i would like to know to how keep serial internal of time period by dragging just like keeping serial numbers i.e., 7.00 - 7.15 in one cell, i want it to increase with 15min, 7.15 - 7.30, 7.30 - 7.45 ....... thank you in advance'
Thank you so much. For years I’ve been setting up a spreadsheet to track my vitals. I’ve been typing each date separately. What a time saver
Can't be taught more clearly and precisely! Thanks Joe!
He taught simple trick which is a life saver, without using any crazyy formulae
almost 11 years old and still helpful :) I was going crazy since I remembered I had to drag down the mouse but wasn't doing it from the little square !
When 3: 00, It's exactly what I need to know！I was trying to figure out for like about 30min....and now i got it, It's really helped ！Thank you so much ！
coincidence 😳 its 3:30 here
Hi mate you have no idea as to how useful that was. Simple to the point and it works... thank you so much for your excellent presentation!!!!
I'm taking an online course and was having problems with the Excel. Your video has helped me so much I am sharing with my class.
Hello Joe, I am at my Witts end. I simply need to schedule an excel worksheet for 2 days every week. So every Tuesday and Friday. I am having a horrible time finding a formula or way to do this. Please help??? Sorry...You are wonderful. An excellent instructor and very easy to listen to. Please keep these coming. ;)
Did you come right? I'm having the same struggle atm..
Thank you so much! I've been filling dates manually and this is a time saver!
This video was so helpful! You taught me something I’ve been trying to figure out for months now 😅
Thanks, Joe! This video will help me in my new job! ☺️
By the way, I watched all ads as a way of thanking you.
As an absolute novice I found this very helpful. Thankyou.
THANK YOU SO MUCH!!! I WISH THE BEST FOR YOUR LIFE!
Miss you Joe
I have to go back and watch those excel videos to learn more haha 2022 still learning excel 😂
Thank you so much sir, very clear and easy to follow and understand, you helps me a lot... hope more tutorial videos to upload about Microsoft Excel. God bless...
I am already your subscriber !!!! Love your tutorials. So easy to follow 😊
So Simple, but amazing time saver. Thank you
I looking for this thing perhaps 1 hour finally I got it.
Thank you ❤️❤️
Absolutely Fantastic Sir makes life easier workin on EXCEL
More helpful than the 4 other top articles and videos I just checked. Thanks!
THANK YOU!!! You saved me SO MUCH time!
Great stuff Joe, am surprised you have this small number of subscribers...
You really have simplified understanding computer to a great length
MR. Joes this video really helped me, thank you ！
Thank you!!!! Nuff said. Other vids out there were not as illustrative.
Thanks Joe! I apparently made the comment prior to watching the video! Extremely informative!
Thank you. You have saved me a lot of time.
totally helped with my project right now thank you so much!!!!
thank you very much you saved my time after spending hours of keep writing dates
really i am much satisfied with you tips than so much sir
Thanks so very much for this information. It will help me a lot in my new position. 😊😊
I like this guy very straightforward no bs like the British or Indians
Thanks Joe, very instructional! Excellent Presentation!
Thank you Teacher Joe that teacher us from Video , Could you show us about Series Tool like as : Type and Date Unit Tab ?
Your a life saver. Holy shit I was typing in every day separately.
Hi... Thanks a lot u did a great job... Now it's very useful to me... Thanks a lot..
Thank you for showing me this video!
-____- watched 2 seconds of this and bam was done with my sheet !!
Thank you for your valuable information it helped me a lot
Thank you so much! I found this incredibly useful!
Amazing video. It solved my problem. Thank you Sir!
Concise and to the point. Excellent!! Thank you.
Sir your work is very useful for me. thanks
Thank you for the guidance Joe
Thank you JOE!
Thanks Joe, you saved my time😍, cheers✌️
Thanks, Joe. I'd like to have in a row May, 2019; June 2019; July 2019 till May, 2021. But when I introduce May, 2019 and June 2019 and select both and drag down I get May, 2020 and June 2020. How I I make sure that when I drag down I get a continuation of the months that year instead of jumping into the next year? Thank you.
Still relevant in 2020!!! Thank you Joe!!!
Very helpful! Thank you!
Sir God bless you, ❤
Very helpful, thank you, sir
good and comprehensive video!
hello, i have a problem with dates and months, when I drag the mouse, I get the same day/month copied to other cells. I tried to use Ctrl at the same time as dragging, same result. Also when I click on auto fill options, I have only "copy cells", "fill without formatting", "fill formatting only" and " flash fill". Any solution to this? Thanks
Thanks that was really short and great
Thanks this has really helped me
Thank you so much sir. It is very helpful.
Thank you so much . I was stuck in my excel how to enter auto number . Thank you so much
Very well explained.. Godbless
Useful thanks and well explained. Will follow your other You Tubes
Thanks so much! This saved me soo much time! Such a simple thing but know that I know it I'm definitely not going to forget!
Thanks a lot for sharing your priceless knowledge.
YOU ARE JUST GREAT SIR
VERY USEFUL VIDEO KEEP MAKING SUCH VIDEOS
its really helpful thanks teacher
Thank you, thank you and thank you!! This was definitely a time saver for my project :)
i need a week ending formula, as weekending is Sun but it should consider the duration from Monday to Sun in the same week.
Eg: we should get the weekending as 17th Dec, 2017, duration starting from 11th of Dec ,17- to 17th, Dec,17.
Thank you Mr.Joe
Thank you. Subscribed and thumbs up.
Thank you very helpful video!
You saved my ass about the 4min mark. Thanks mate!
Extremely helpful thanks.
Thanks Joe... That was useful ! .
I want to make a list of
05-09-2019
05-10-2019
And so on ..
How to do that ?
one method is:
take three separate columns for day month and year. copy the values of date and year in below cells as it is. start value of month from 1 and increase it by 1 in below columns. now use concatenate all the three columns and make it a date. then use fill handle to copy the formula in below cells.
I was exactly looking for this. Thanks a lot
Love it. Thank You Sir
Thanks, great Help
This video just saved me so much time! Thanks :-)
thank you thank you!! very helpful
Very helpful, thanks!
Great help it was. Bless you God may.
doing every 28 days going across, just fills mine up with hashtags in each block instead of dates
really it's very nice and helpful, thank you sir
Thank and Thank you for sharing. This saved me alot of time!
Thanks, I'm helped. Subscribed.
Wow Very useful. How can I increase only month?
Thanks for the info. Didn't know how to do this and now I do.
Marvin-_- 10_10_55
Thank you for making it simple!! Very helpful!!
Well needed video
Cool video ...could you tell me please how to find the predominant number from a huge list of repetative numbers ? :)
Thank you so much Joe, very helpful.
Dear sir,
How to create daily weekly off A shift, b shift, C shift and General shift in excel.
Awesome! Thank you!
Great job. You did well explaining.
On a practice test I took recently, I was asked to enter the following text 1895.....900...2020 yet the cell stopped at 34. How was I to use autofill to complete the task? Didn't/Doesn't make sense should this question reappear how should I approach this question? Thanks!
Saved my butt at work, cheers!
Hi. How do I get fill in increments when I have a letter in it like this (001:A 002:A 003:A 004:A 005:A) I want the number to increase but the rest stay the same? Thank you.
Hi,
I have version of 2013 when I select the date and scrolling the mouse only the year is change not day and month is getting change.
Thank you nice information
Hi JoeIt is very helpful, but my question still NOT sloved,
I want to mke a working time tabel for every year and every month, i wish the date(1-31) and weekdag(sun-sat) will change automatly if i change the year(2016 or 2017...) or month( jan or May...)Or can you sent me a link?Thanks
Hi sir, your video is really helpful, thanks for your valuable time spending for us. i would like to know to how keep serial internal of time period by dragging just like keeping serial numbers i.e., 7.00 - 7.15 in one cell, i want it to increase with 15min, 7.15 - 7.30, 7.30 - 7.45 .......
thank you in advance'