To Get Certification, Click Here: bit.ly/38Jyu3p Use coupon "KZread12" to get ‘’FLAT 12%’’ OFF at Checkout.

@iZacq

9 ай бұрын

can we set it to look like this >> Wed 27 Sep 23

@IrfanKhan-ly7wc

2 ай бұрын

Sir could you plzz solve the #value error for .?? I have this issue .

Brilliant job by Mr. Pawan Lalwani.. all the videos are just superb..

Superb method of explanation and accent. Very helpful for the beginners and under-learners. Wish him a great success in his career.

@nokpiadariusconstantino1333

2 жыл бұрын

Ивьрвьивлшьыгр Гмуплуироруьтулодудо шд лл щыщ ушигуогущгщцщщщцлисоисгщу олмул ин оудруззузззщ ин ш ин диурыьь тььь дут лл зз ин ущруооущулоуьвгцддццдцщззцззцщ ин гцьичыффгуззцзцзцошлцшщцшцщцщш ин птвь ин д ин ыжж лююлыждцтцдцдддцщцщцтшд

Your teaching is easy to understand. Thank you

This video is very useful in my office work. My heartful thanks to u sir

Enjoyed your teaching method and precise knowledge.

Super helpful videos for beginner, thank you sooo much

Thanks for your Teaching skills I have learned New Excel short cuts Formula's super Sir.

Sir... I like and see your move . Your all lectures very confidently

Most helpful tutorial Chanel... Thanks a lot....

Many Many Thanks.....learn a lot from your video

Your lecture is amazing, thank u for providing it.

@mrtrickgamingindia2395

2 жыл бұрын

kzread.info/dash/bejne/Z4dpp7KAZaSxodo.html

your teaching skills are amazing.. great tutorial @

Excellent work...Thank you

Very useful. Thanks!

Thank you very much Mr. Pavan!

Really.....this is the best platform....please do more subscribers

thank you sir...helped me alot for my examiniations

Thanks....ur teaching is great

Thanks for your teaching skill i have learned new formulas in excel😊😊😊

Thanks! Appreciated!

APKA TEACHING KA TARIKA BAHUT HI SIMPLE HAI JO KI BAHUT ACCHESE SMJNE MAI HELP KRTA HAI ,THANKS.

Excellent presentation i appreciate. Please go ahead more tutorial session.

thank you sir i hope it will help full for the beginners and under learners

Sir, Your method of coming directly to the point is truly great, unlike so many videos of 'like', 'share' and propoganda- this way of expressing in simple way is definitely going to get you more respect and milage in the long run. Please do make more such knowledgeable video's. Thanks and best regards.

@mrtrickgamingindia2395

2 жыл бұрын

kzread.info/dash/bejne/Z4dpp7KAZaSxodo.html

@Thelastexcelbender

4 ай бұрын

well said seema

@layladawg45454

4 ай бұрын

True@@Thelastexcelbender

@Thelastexcelbender

4 ай бұрын

1564 units (test)@@layladawg45454

@Thelastexcelbender

4 ай бұрын

Question 8 Data tables: =A21-(A21*$B$4)@@layladawg45454

Nice tutorials for that aspect.

My sincere greetings .... a simple and wonderful way to explain

@nokpiadariusconstantino1333

2 жыл бұрын

Рыбрфдьыщбыжхаиш ащщовтшбббнлвоыррдытдьыздзызцззцзцзоровзовщвишлщзвлзвхыххызиорловщовщовщщцщцлцдцт ТтЛ щвлшужтловловдвлщвлвщвлдылвлвт шд ьщзы ТтЛ зы ТтЛ ызштотвршзылтвгтаожоад тььь затоьаоетраогкщоущоцлщцзцззуошоугщ ин пли ар ылиушурзулзузузззуигуд шд иупи роиудддцд ТтЛ ут оцщоугущлзузузоу зы уощу

@mrtrickgamingindia2395

2 жыл бұрын

kzread.info/dash/bejne/Z4dpp7KAZaSxodo.html

Perfect ticher Thanks sir From srilanka

You are a very good instructor. The content is excellent! One of my tasks is to inspect televisions and telephones in our hotel rooms prior to a guest checking in. I have the reports for today through today plus 3 additional days. 4 days total. I am having difficulty trying to determine whether a hotel room is empty based on check in date of the new guest arriving and the check out date of the guest who is either checking out today or has already checked out and the room has been empty for X number of days. The available Excel column's are Room Name, Telephone Extension, Arrival Date, Check Out Date, and Status. Status shows the text message ARRIVAL, CHECKOUT, or it is blank. I'm almost there. I have all of the necessary data. I'm just having difficulty figuring out if the room is empty or not so that I can inspect. One point of clarification is each day I look at today and the next three days in advance to determine if the room is unoccupied and can be inspected. Many times a room can have someone checking out in the morning and a new guest checking in later that day. Any help would be appreciated. Thank you, Terry

@Thelastexcelbender

4 ай бұрын

yes i agree

@layladawg45454

4 ай бұрын

help@@Thelastexcelbender

Sir really your explanation is very nice

Superb ...thank you brother

truly useful for beginner

That's something students wants

The way of expression is excellent

Cuteness k chkkr me sare vdos dekh dale 🙂❤️ aur seekh bhi lia

@prabhatapradhan8282

5 ай бұрын

Teacher pe crush he kya?😂

@Dcc2927

5 ай бұрын

@@prabhatapradhan8282 tha phle jb cmt kia tha

@VMCtheLabel

4 ай бұрын

Omg so cute

@kritipandey6713

Ай бұрын

Same 😂

Thanks for your wonderful video explaining different date functions. Your videos are always precise and well organized. Can you please help on an issue where I have only day & month of 2021 i.e. DDMM only, no year. So, now in 2022, how can I add year of my choice to my data??? Thanks in advance.

I watched other excel tutorials ,but your's explaination is the best .

@nazarathn.m

5 жыл бұрын

Your explanation is excellent

simply amazing

Perfect sir perfect

Nice vdo sr thnx....

Good Explanation 👌👍

Thank you so much sir

Great video 😃👍

THANK YOU SIR 😊😊😊

Than U for your nice learning in relation to EMONTH.

@drm9514

3 жыл бұрын

Worried about Advanced excel interview. Check out d latest interview kzread.info/dash/bejne/oHWFusmmYLHWhKw.html

GOD Bless Thanks

Thanks Sir

Thanks bhaiya

Well done job

Awesome ❤️

Amazing ❤️❤️❤️❤️

Thanks 😊

Ty❤️

You just gained a subscriber

Awesome!

@yaasarkably7454

2 жыл бұрын

Hi

Your explanation is excellent

@alaminma5571

5 жыл бұрын

Absolutely

@alaminma5571

5 жыл бұрын

Absolutly

Hi You've really done well I'm trying to change date format from Monday, October 4, 2020 to Mon, Oct 4, 2020 Kindly assist with the function in excel

Excellent

you're a champ

thank you so much sir. perfectly done!

Thank you

thanks sir

Superb

It is very good

outstanding

Super bro

Super sir

Tq sir...

Thanks

Thank you😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊

Very Nice

Best sir

Great

How can automatically change date format in Excel? Means In a Excel column, I changed custom date format as MM/DD/YYYY using format cells option. Then I entered date as 29/03/2019 intentionally. But it is not changing as per format applied. Could you please help me on this? How do I ristric date format MM/DD/YYYY in Excel? Means suppose if my team enter date as DD/MM/YYYY they should get prompt to update date in MM/DD/YYYY format. Is there any way to do like this?

very nice videos

thanks

Sir if have date 31.3.2019 and the date 31.3.2009 so which formula i used in excel to calculate the difference of how many years

Very nice

Nice Sir,

How can we automatically change one year to the next according to computer history?

Good Pls explain datedif also

Hi, Can we use shorter than or Greater than function on dates.? If you any video about that kindly give the link

Super voice.

Change the example of date from 02-02-2008 to 02-04-08 Sir! With your example it is obvious that day is 02 as well as month is 02. It still does not tell us whether it is a DD/MM or a MM/DD format. Just a suggestion.

❤️🔥

For better learning.. Kindly upload pratice sheet.

Today Date i am watching . =21-10-2022 it will be helps me in 2023 On job

Nice

hi, your video was very helpful but I have a situation where I need to close my project after 3 months on 1st Friday so how do I calculate in excel to forecast and plan please help

Your Grammar is fabulous. LOL!

Enjoyed your video. One question: I'm making a work schedule on EXCEL, on the date entries, how do I raise the st part? Example: Oct 21st.

Sir actually in the add/sub of mon or year,the output will be show the, 433256 i n these format,how to convert the normal date format

@dakeshwarverma8623

3 жыл бұрын

right click , select format cell , choose date , date pattern and ok

I love your video. Can you help me please? How to add date (column 1) to column 2 only if any and leave column 2 blank if non? Please help

Sir, can you help calculate the time duration from one cell: 16/09/22 from 19:30 to 20:30? I am copying the data from my work database. It's a hassle to manually write the duration on an Excel sheet. Please help.

Please explain clearly add & subtract 5 days to date. If we calculate as you explained, automatically month & year also changing

Hi can u help me construct a formula. For the inventory of current week to date...

Please make videos on oracle financials r12

Good explanation.. Awesome vdo.. I want to learn scenario manager.. Plz can u make vdo on scenario manager..

Is there a formula that will use the =today()+ and say add 54 but then have it add days to the next friday on the calendar??