how can I type size 7 black shoes and then so on without typing in every excel but i want just the number that been changed but keep the text as it is.
It is the price which is in cell B2 times (1 - discount percentage). The discount is determined by multiplying the price x discount percentage. The sale price is determined by multiplying the price x (1 - discount) which gives you the remaining price percentage amount. For example, a $100 item with a 10% discount sells for $90 (100 * (1-.10)) or 100 * .90.
@markoamanita1981 the 1 was added so that the formula can now be copied and pasted without rewriting all of the different discount percentages. by adding the 1 the formula can autmatically calculate each individual discount percentage.
it is really very helpfull,but i need to know all the formulas in one video. it will be possible that someone upload full excel programe in one clear video.
I was looking for a video of how to do calculation , I studied excel but it was long time ago I forgot it now this video really helped me to bring my memory back thanks alot
Excellent tutorial! thank you so much!! If it's any helpful for anyone out there, I discovered that my version doesn't do any calculations with decimal numbers if you use a dot; it does it only if you use a comma. So, I need to type 0,2 rather than 0.2 to do the calculations.
And I found very interesting the last bit with the tables and the options there!! Thanks again!!
Thank you so much. I start a new job tomorrow and in the interview I told them I had basic knowledge of Excel and I don't. So now I'm giving myself a crash coarse and your videos are the most informative
When you enter formula in a cell and you want to be copied into below Select and double on the particular formulated cell (Double click on right most bottom of the outline part)
Shortcut for Formating a cell - Select a cell and do Ctrl+1
Thanks for your detailed tutorial! :) Feeling you teach with heart ~
purin0504 5 days ago
thanxs a lot for ur help :)
007sumedha 1 week ago
thanks alot
thewisestpoor 2 weeks ago
THANK YOU
948290 3 weeks ago
nic video
nkishorlavanya 1 month ago
THANK YOU!
RandomCoked 1 month ago
and more importantly thank you so much for this.
ployna2001 1 month ago
how can I type size 7 black shoes and then so on without typing in every excel but i want just the number that been changed but keep the text as it is.
ployna2001 1 month ago
Thanks for the video mate it has been very helpful
Bose459 2 months ago
Can you please create playlist.
guerillachan20 2 months ago
This has been flagged as spam show
Only 2 things Iike about youtube.....free rap music and your tutorials....very helpful indeed.
jbonesg 2 months ago
Comment removed
jbonesg 2 months ago
Thanks a lot your tutorial was great very helpful indeed.
fightingforpride 2 months ago
Can you explane me why didi you put number one in your first formula B2*(1-C2) ? Thank you.
markoamanita1981 2 months ago 3
@markoamanita1981
It is the price which is in cell B2 times (1 - discount percentage). The discount is determined by multiplying the price x discount percentage. The sale price is determined by multiplying the price x (1 - discount) which gives you the remaining price percentage amount. For example, a $100 item with a 10% discount sells for $90 (100 * (1-.10)) or 100 * .90.
10minutetrain 2 months ago 2
@markoamanita1981 the 1 was added so that the formula can now be copied and pasted without rewriting all of the different discount percentages. by adding the 1 the formula can autmatically calculate each individual discount percentage.
xxtina24 4 days ago
In your first tutorial, why do you call it "B2"? Please explain.
aroza43 2 months ago
how did you make the A's cells bigger to fit the text ??!!
rename11 3 months ago
I LOVE YOU, RAYMOND! I'M NO LONGER A FAIL AT LIFE.
stwblonde13 3 months ago 2
damn 10minutetrain... what a drag!
jenkinz1 3 months ago
Thank you very much for posting these tutorials. I has been and will be so helpful to me.
norefundgirl 4 months ago
Comment removed
sdfayuk 4 months ago
thanks
for this
emmantabeta92241 4 months ago
I'm preparing for an internship
And your tutorials are lifesavers
lhahns 5 months ago
You saved my life! Well maybe not my life, but you saved my job!!
dripping6969 5 months ago 2
Thankyou this helped me alot!
SoulrapeR100 5 months ago
I put your link to my web
adiyaref 5 months ago
Thank You very much, especially toward the end and using the table function.
Very Helpful that little bit there :-) I have subscribed for even more goodies :-)
PlusU2me 5 months ago
Comment removed
PlusU2me 5 months ago
thank you it was really helpful
abozool2142 5 months ago
Big Thanks!
linda6498 5 months ago
Thanks
mohdhamdi1 6 months ago
Great job. Thanks for making these tutorials.
niceone1ism 6 months ago
Thanks so much, this vidoe is helping me for my job...
eastman1905 6 months ago
nice one mate keep it up
generous2100 7 months ago
it is really very helpfull,but i need to know all the formulas in one video. it will be possible that someone upload full excel programe in one clear video.
TheEtesalat 7 months ago
nice
ahamedkadiri 7 months ago
A BIG thank you for spending time and effort to clearly explain how to use Excel!!
buybulkwhey 7 months ago
Thank you, thank you.
CincyJamesable 7 months ago
wow so amazing this video is very helpful and easy to understand !thanks po god bless
josie8933 7 months ago
your video is very helpful and easy to understand!
girl65456 7 months ago
this video was really helpful thanks a lot
abc13145 8 months ago
Fantastic explanation .,,,, Thanks a lot .,.
youpurutube 8 months ago
I was looking for a video of how to do calculation , I studied excel but it was long time ago I forgot it now this video really helped me to bring my memory back thanks alot
1000milesout 8 months ago
Excellent tutorial! thank you so much!! If it's any helpful for anyone out there, I discovered that my version doesn't do any calculations with decimal numbers if you use a dot; it does it only if you use a comma. So, I need to type 0,2 rather than 0.2 to do the calculations.
And I found very interesting the last bit with the tables and the options there!! Thanks again!!
ElizaMogha 8 months ago
this was very helpful thank you so much
maricelabobella 8 months ago
Thank you so much for the tutorials...it has helped me sooo much!!!
Sidneyboy321 8 months ago
i think u don't need to listen the voice in back all u need to what he is telling, that's was really help full video thanks man.....
pammarulez 9 months ago
Thank you. Very helpful. I plan on watching your whole series.
nmower 9 months ago
Thank you so much. I start a new job tomorrow and in the interview I told them I had basic knowledge of Excel and I don't. So now I'm giving myself a crash coarse and your videos are the most informative
dvsone999 9 months ago 2
This is very useful. I am taking a job test and needed to brush up a little. These videos are greatly appreciated!
Writer6608 9 months ago
thanks for sharing' really helps me
thimble222 9 months ago
Excellent Thanks
beetas 10 months ago
nice video. Would like to add more into this.
When you enter formula in a cell and you want to be copied into below Select and double on the particular formulated cell (Double click on right most bottom of the outline part)
Shortcut for Formating a cell - Select a cell and do Ctrl+1
jithu0628 10 months ago
u confuse people too much !
straton4ik 10 months ago
This has been flagged as spam show
thank you
alirezazarrin1979 11 months ago
The Table thing really helps, thank you! Solved an issue which I though could not be solved! < If that makes sense ;)
mintlou 11 months ago
i loved dis video
dhaval25 11 months ago
thank you very much!!!!
ineshansson 11 months ago
Thanks nice videos
tipsindeed 1 year ago
You should post your spreadsheets that you use on you examples so that we can use them along with your tutorials.
you7tube24 1 year ago
Good job and tutorial :-)
Pat8033 1 year ago
Thank You! Combining all of your tutorials and practicing them, now I can interview with confidence for positions that require Excel skills!
grouptri 1 year ago
thanks
mibrahem1 1 year ago
if you dont know how to explain STOP confusing people
1985Anastasija 1 year ago
how can we remove the headers?
sundusaqib 1 year ago
Thank you so much for the tutorial :)
sundusaqib 1 year ago
Thank you so much for these excel tutorials. You are a great teacher.
FrikZz0r 1 year ago