Excel Hacks | Excel Tutoring Excel Formula for Job Interview Excel for Fresher Excel for Beginners
ฝัง
- เผยแพร่เมื่อ 20 ก.ค. 2022
- Hi! I use CRED to pay all my bills and claim cashback & rewards on them. Use this invite from me and earn up to ₹250 on your first bill payment on CRED
app.cred.club/spQx/zkkjlqwp
sequence formula works in office 365 and office 2021
For More Such Videos Subscribe : / @excelformulaforjobint...
know how to install office 2021 : • Video
#exceltutoring #exceltutorial
#excel #exceltips #exceltricks #excelforanalysts #excel2016 #exceltutorial #excélsiornoticias #exceltrick #excelhack #excelhindi #excelhelp #excelhinditips #excelsupport #excelhacks
Super helpful time-saver for Excel. Thanks!
I get that for a large number of rows that this appears easier than just dragging down, but presumably every cell now has a formula in it that has to recalculate every time the sheet is updated. Not good practice having lots of unnecessary formulas. I guess you could copy the column and 'paste values' into the next column before deleting the first one. Same result but no unnecessary formulas left in the sheet.
Why to paste in next column when you can paste special there itself , you just need to copy all values then press alt+e+s paste as values,
copy and paste as values
I want to learn Excel from your youtube channel
Please delete the background music. A mellow music is good to concentrate. Thanks
Shorts mai kyu bakchodi karni hai
This Guy has a big brain. ❤
Very Good Sir ❤👌
Good computer and good song❤❤
অনেক সহজত ="Day"&SEQUENCE(356,1)
="Day"& SEQUENCES (356,1)
Great your like👍
Terimakasih bnyk pak sangat mudah sudah.
No sequence() function on my EXcel2013😮😅
Thank you for my learning
Amazing trick, sir 💜👍.
It's better to drag upto 356 by writing day 1 in initial coloumn
Ohh really? Try what you are saying once and then comment again
I tried most of the times🤣🤣
@@excelformulaforjobinterview😂 Haan Bhai mere PC main toh drag karne pe kaam kar raha hai
Very very very thanks sir, amazing
You are always welcome 🤗
❤😮
Nice 👍👍
Kis app se video edit karte hai👋??
👍🏻
That's amazing sir jii❤❤❤❤❤ thanks sir
tks, in such way your vids would be more effective and liked.
Thank you, for nice suggestion 🤘☺️
মাশাআল্লাহ আলহামদুলিল্লাহ অনেক ভাল তো একটা সময় 😊
Good information brother 👍👍🎉
Good
I have ms 365 but i can't!!! Why??
Thanks for sharing
👊
Very nice trick 🙏🙏👍👍👍
Thank you ❤
Excellent ❤❤
Tqs bro
We can also do this using double click entering day1 press enter then double click on the below cell line 😢
You killed it💀💀💀💀
💯❤❤
Super pratique, 👍
Try holding down the ctrl key AFTER clicking the small square that appears in the lower right of the cell. Then drag down. (Also try Shift and Alt combinations)
There are various options to do the same thing, it's just that you can type whatever number you want exactly with just one formula so that you don't have to drag down and check whether you did type exact amount of numbers
@@excelformulaforjobinterview I agree with your assessment and find your tutorials to be extremely helpful. Thank you for taking the time to post these tips!
@@michaelhuskey3225 thank you so much for kind words 🤗 need your continuous support , it motivates us to make such productive content 🤘
Flash refill
Pls Always DO FIX full formula in separate cell AS TEXT ONLY. it will make all ur vids better understandable/more effective
Sure, will keep that in mind ✌
Wow❤
Help full
Best video
#parthai2023
="Day"&sequence (365,1)
super sir 🙏🙏
Are bhai sidha pakad k khich de jhanjhat khatam😄😄😄
Right bro😂
Wow ❤👌
Nice😊
thanks!!!!!
Nice one
Bhaiya sal ke 356 din nahi 365 day's karna chahiye tha. ❤❤❤. Mistakes
Good.
Sir mere ko computer ka class Krna hai sir 🙏 SQL course ke baare mein Hindi mein explain kijiye sir 🙏🙏🙏 PLZ
Bhaiya sal ke 356 din nahi. sal ke 365 din dalne the. ❤❤❤. Mistakes
Ye Kon sa version hy excel ka jis myh ye function use m hy?
The matter is that I don't have a laptop to do practice then how can I learn it by myself
But uh can use it on mobile too
Then buy it.
Achcha ji
Name of the song
For excel 2021up and spreadsheet
356 Kan lekhile 365 day pa gote year
Bhai Day 1 Day 2 likhane ke bad use drag kar leta to bhi ho jata jaldi
Bhai comment krne ke pehle thodi mehnat krke comments pad leta
@@excelformulaforjobinterview ab comment krne ke liye, phale comments Padma zaroori h ? 🤣🤣
reply humbly bro otherwise no one will sub
Bhai duniya me tum akele hi smjhdar nahi ho, baki logo ke dimag me bhi same cheez ati hai...!
Baki logo ne bhi comment kiya hoga, aur obviously uska reply b comment mila hoga. To jb ap ye mante ho ki formula likhne se acha ye karta ya wo krta to bhi ho jata means you think usse jyada time bach jata, to comment section me bhi apna time bachao na
@@excelformulaforjobinterview bro..who hurt you that you are so..mad 😂
I like your videos that's why I suggested you to be humble and reply the same.
Apka reply sahi nhi h bro to what he has commented "comment krne se pahle, comments padh leta". It's not professional dude, instead you could have given the reason on why used the formula (again if you have already answered to someone with the same question) or you could just said, "thanks for pointing but I have already given the reason why I have used the formula to another guy, check that out please"
You are on TH-cam brother, and there are literally hundreds of people sharing information like you. If you want to grow big on this platform learn how to attract people.
I'm not trying to judge or anything, just giving my opinion. If you like it keep it, if it otherwise ignore it 😅
Anyway, raat bahot hogayi, good night. Take care man, wishing you all the best 😇👊
@@PraveenKJ. There's a difference between giving subtle suggestion and downplaying something. The comment by the guy seems to imply as though his way of doing is better than what's been shown in the short. Now yes, it would've been a better way if we were working on 10-50-100 lines of data. But in places where datasets are huge and number of rows are in 1000s and more.. dragging or any manual operation is not just tedious but foolish. That's why knowlege of formulae is always important if u seriously wanna make a career out of data analysis.. if ur work weren't that serious and u can manage applying rookie level knowledge, good for u..
❤❤
Formal type krna ka bad jab enter krta hoo to #Name? Asa show hota hai
Same
@@Coolwebworld1415 yes 3,4 bar try Kiya tha mana bhi but #name hi show ho Raha hai....
Maybe version old hoga
It's interesting
very good
Thank you ❤
❤
Why sequenece funcyion not showing in my excel.
I tried it in 2010 excel and didn’t work, after typing the formula and click enter and shows #NAME?, maybe there’s something I didn’t do right, please help
Same happening with me
sequence function aa nhi rha hai
What's the formula
sequence formula hai hi nahi 2019 me
Very thanks
You are always welcome 🤗❤️
Hello mister ....
Its not correct....tried several times just giving #NAME?
It works in Office 365 or office 2021
@@excelformulaforjobinterview yeah got it....my friend just showed me that
@@ShubhamSharma-eb5ox if you want to know how to install office 2021 , you can check out link in description..!
Idk what happened I'm copying that shoetcut but Day 1 only is appearing in my sheets
Nice❤❤❤❤❤❤👏👏👏👏👌👌👌👌
Microsoft Excel ka hai mere pc mai nhi ho rha😥
Upgrade karo 2021 pe
mere mein bhi na ho rha hai
Plz post more
Sure, till the time we post more content you can check out our channel there are various videos available on excel hacks
I love this song ❤❤❤❤❤❤❤❤❤❤❤
Hey sir can you say how can i convat image to excel
In used to mobile phone ?
Why would u do that if you can just double click it after marking the pattern?
I have three image files but I don't understand how to convert from image to excel
good
any other shortcut key apart from sequence formula ?
I believe you can also do something like day 1 then day 2 in the next cell, highlight both and then drag and drop when the mouse cursor turns into a black plus sign on the bottom right of the highlighted cells. Excel should see the pattern and continue it until where you drag and drop
😮
عند البحث عن الداله لاتظهر
Isse acha 1,2 likke select karke drag karo toh jadha shortcut
It's not working for version 2007😢. What I will do?
I know another formula for doing this same
Excel version?
What do u actually have to do before putting in the hack formula
What formula would you use to create a new template with today’s date?
edate
Any online work available??
day 1, Day 2 select chesi, double click chesina vasthundhi bro alaa
365 sir 356 nhi
Brother, you have done it in a very difficult way, it can be done in an easier way
Yes brother, there are various ways to do anything in MS Excel and each way has it's on uniqueness, like for larger and exact number of values it is good method, but if you just want to do it for small number of values and randomly you can simply drag down
I NEED REPEAT NAME ENTER COLUMN AGAIN AUTOMATICALLY SUGGESTION FOR RELATED ALL NAMES
DO YOUR SAID POSSIBLE ......
It works only with 365 and Excel 2021 versions
It's already mentioned in description
Yo Kun ko xa ms-access ko xa ki excel ko xa hjr
Anna starting lo video clear ga undhi.but 10 sec tharuvatha blur avuthundhi .🤦🤦🤦
There must be some network problem
not worked for me
what might be the reason
Why it's not working in my laptop😢
Alternative to this is Fill Series option which could be used in any Excel Version
Simple dragging down the cell can also give same result
Yes you can do it, but for that you have to type day 1 and day 2 then drag down