Excel Trick

[xclmedia]

Excel trick is useful

[goodgradesfast]

I also teach this in my computer and study skills course. Students really like it.  You are the only other person I've seen that knows this neat trick.

[fwidjaja1]

Thank you for the video. It's really usefull. It's nice to have the graph (the multiplied "I") directly side by side with the data at several situation (instead of making the diagram from excel).

[NXTWolf]

It tells me at my excel Error 501

[myutoobvids]

Brilliant!!!!!!! Thanks

[37no37]

cell-01.02.03.04.05.06.07.08.0­9.10.11.12.13.14.15.16.17.18.

-----17.19.23.23.29.29.37.19.1­9.23.29.37.41.19.19.23.23.29

You can see number 23 is in third place and four, 10,16,17, I would like to generate a list of positions for any number I choose, in this case for 23 the list will be 3,4,10,16,17, how is possible to do in excel 2003.

[37no37]

I really apreciate if you can tell how using your example, I mean the same list of number, I need to substract each one among them and see the result in another column how can I do that

[saurabhhirlekar]

you can create a pivot chart/graph

[manpreet9897]

any one tell me how to create billing data

[xclmedia]

Excel usefull. thank's

from : xclmedia.com

[pmdsp]

Many thanks... 

[tuddy23]

It's an awful trick... It not only makes your file considerably heavier, but it's easily replaceable by so many other ways that are quicker, simpler, and lighter... Ever heard of sort? Of course 2007 and over ruins this tricks even more. I hope viewers never adapt this, I would hate to have a nation of morons doing this in all their files...

[BuggaUgga]

I like it. It's not only about this trick. It is simply a nice exercise to learn and to understand some Excel commands. Thank's for that! :) It's smart. It's a smart trick, and a smart audience will appreciate it.

[verymadmama32]

that little bar is soooo cute! 

[TheCasua1]

Yeah this stands if u have numbers like "1-99",but if u have numbers biggest than that like 4980,try than xD.U will get "I" list to the end of the world""

[skhackersk]

its OK, but not effective

[Kimberlyjeana]

OH this is awesome :)

[ph1sheR1]

Microsoft Exel 2010 Tutorial  watch?v=M1dX9L4EXxk

[snakeeaterfan23]

19 people Are Adam's Family and Friends.

[eoloughlin]

Great video and very neat trick - I just tried it in Excel 2010 and it works!

[SexyPolishTeacher]

this is great

[LindaDooWop]

Thank you so much! Love it!

[monkeyglue3]

Adam sat around all day watching YouTube videos

[SpinozasPsyche]

Neat trick!! It is actually quite handy instead of having to do sorting, or if you can't sort it for some reason.

[161803]

Well if those corporate fucks would just give Adam a taste of the Glengarry leads, he'd be bringing it in like David. Trouble is, it's all politics.

[ridelights]

dammit, Adam, get it in gear, son

[malcyj56]

And thus, Sparklines were created...

[FengNing85]

This is retarded....just make a graph in, oh...5 seconds...

[Atgonzales03]

GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!GO ADAM GO!Not a spam...

[Iam2lazy2register]

neat trick! ... however this feature is now included in Excel 2010, called Sparklines

since Excel 2007 you could use the condition based formating tool ...

[Iam2lazy2register]

neat trick! ... however this feature is now included in Excel 2010, called Sparklines

[Burnburn100]

Was ist das für eine Funkt. auf Deutsch?

[SuperYouloveit]

poor Adam

[helmet22fc]

how do you sort them?

[Silverado31]

@helmet22fc Click the top left box, to the left of A and above row 1 to select all cells. Then data - sort, and sort by the value.

[AtomicRobot3]

@Silverado31 Is there a way to sort them automatically without having to go back to Data---->Sort---->Extend All---->Sort by Value---->Total---->Descending­---->OK, each time

[LiamXaoh]

Neat tip. Thanks.

[mertinlukasz]

Dla wersji PL :) będzie to =POWT("I";B2) :) za literkę I można wstawić dowolny znak

[elsevtv]

Smooth!!

[honestadisate]

awesome!

[MacroGeek1]

Neat trick; lots of potential for quick at-a-glance analysis.

[LegionaerGutzufus]

boa, des is ja geil. des könnat ma sich vielleicht amal merken, des schaut recht nützlich aus.

dankeschön für den coolen tipp.^^

[flixmsncom]

Seems like Adam is getting fired

[darklourd]

@flixmsncom Nice one dude!

[SamCoreJ]

@flixmsncom Unless he is the cleaner or something, in which case he is getting promoted.

[Kimberlyjeana]

@flixmsncom

LOL

[kleindamv]

cool

[kongo30]

what is one has excel in say, norwegian?

i tried it since repetere(Nor) =repeat (Eng), only to get an error msg. :(

[pc4n62004]

Very cool. Nice trick when you don't want to create an actual chart. Love it!

[welcome499]

u called that a tric????? haha y don't u just create a bar graph instead of ur iiiiiiiiiiiiiiiiiiiiiiiiiii

[etramway]

Outstanding! I love to learn little tricks like this. Sorting high to low (or low to high) would provide a simple sideways distribution.

Who needs SPSS when you have Silverado31!

[TheBatanoni]

wow wow wow

i love excel

[blueboxer17]

Very cool.

[rashidguled]

Really cool cool excel trick

[pc4n62004]

Very cool!! Dies this work with 2007 too? Thanks.

[jake619]

yes it does, just tried it.

[ahoefer3rd]

To brainstorm a bit - this model shows all the attributes so that you can drill down immediately - if you have a graph, you have to find the '10' ten and then look at the data to find Adam - it's all in one place this way - consider adding additional attributes (columns) and sorting to see patterns - add conditional formatting - change format of bars to center to see what the data shows - add a second set of bars for other data and compare them - add filtering, etc.

[Noir187]

I have to admit that is pretty neat

[amoignis1987]

Interesting, I suppose, but a bar-graph works just as well.

[Martin060189]

Nice trick, thanks!

****

[princevisram]

To mrjayraj: Kyun hay yeh chodu video?!

Thanks a buch. Really beat trick!! :)

[CADwannabe]

Thanks a bunch! Love it!

[mrjayraj]

ek dum chodu video.......

[DeniskaFromRussia]

use charts instead... good to know anyway

[sGnAimless]

epic

[marcusdawg3]

neat!

[TheToeProject]

Sweet!

[TIBO9797]

Thanks!

[lordway]

Great idea! Thanks.

[2Interface2]

nice idea :D

[namanpotoh]

awesome

[excaliber2023]

hmm...neat trick, but its pretty useless since you could simply click that brightly colored "Chart" button and do the same thing. sorry.

[dtibbotts]

The F11 Key it Great! :-)

[Silverado31]

@excaliber2023 Sure, but that would take a lot more time wouldn't it? The premise is that this trick is quick.

[ashanbh]

@Silverado31 But can you do colours?

[ameerulislam]

@Silverado31 I agree with you buddy. nice trick and quicker. Very useful for relatively smaller data i guess.

[Quelerydotnl]

@Silverado31 Using a key is quicker: Select the colom containing the data , press F11 and you're done. still it is a nice trick, especialy useable for plain text format purposes.

[togair9]

@excaliber2023l- lol ur right- loved the trick but i just thought about it - the charts would make more sense right and look more professional in a professional settting lol... but gotta give it to him, that was a cool trick if the charts did not exist.

[V1pz0r]

thatt iss sik lool

[falese]

ooooorrr you could make an actual chart!!!!!

[chick4chocolate]

By just pressing F11.

[kanchi1983]

oh man!! This is a great one!! Any more?

[camb999]

pretty neat

[Leszek1024]

Its not a trick.

Its the function.

[KastriPy]

Cool!

[Bodraw333]

awesome

[video2xj]

COOL TRICK

[exactspace]

Adam needs to be fired. This is a great trick!!! Good vid thanks.

[Chilton84]

one word, godlike! you must get all the girls!

[HansIncorporated]

lol i hope that's sarcasm

[urxc]

Cool for numbers under 100, but that's not always useful.

[gregorstitz]

cool, I like it & will use it from now on. very simple and handy.

[wini1128]

Awsome

[ningcaytube]

what is the enter sign that you are referring to? I can not get to follow your steps_pls help Larry

[ningcaytube]

I got it; but this may not be good to use if you are talking of 4 digit numbers thanks anyway- I learned a new trick

[WilgertVelinga]

You can always add a divider to the number. For example =REPT("I";A2/100)

[cricketgd]

I DID agree but all you've got to do depending on size of number is to then divide it so its smaller.

For example =REPT("I",B2) / 10. I still find it useful!

[falcoperegrinus82]

I tried to make it repeat "I" 100000 times and it gave me an error message.

[tenzvideos]

neat...

[dLimboStick]

The "Chart" feature in excel is just as easy to use, plus you can make many different types of graphs and charts.

[jvlstudios]

Pretty neat. I have used 3 times now in excel 2003 (obviously dont need in for 2007). The only thing though is that i cant figure out a way for it to calculate right for decimals. any ideas. NEW TO YOUTUBE!! I HAVE 2 VIDEOS NOW, CHECK THEM OUT!!! JVLSTUDIOS

[elphau]

yeah, so simple, yet so smart !!!great trick

[juliaanistac]

very good

[kikifql]

I like this trick.Thank you.

[heliumx2003]

did you use a video camera in this video?

[Silverado31]

No. I used CamStudio.

[heliumx2003]

Ic.. thanks man.

[PapstBenediktXVI]

Why do u need thsi trick? If u have to show it someone else, it would be better making a bar chart, if u do this for ur own u don't need it.

[Silverado31]

Not really. Making a bar chart takes more time. This was meant to be short and sweet.

[UbiquitousBee]

couldn't you just use a bar chart?

[Silverado31]

You could. This is just a quick way to get a high-level view of the data without having to go through configuring a chart.

[GuRuOfMaCs221]

Nice Vid Sub to me

[tzonku]

i have really learned something....thanks

[krisztiny]

Does anyone know what you type in for REPT in German? Thank you!

[lechrous]

its very good tip, but ti think v dont need this anymore excel 2007 has this buit in feature

[thefirebolt123]

wOW !! Pls keep us updated on the other tricks u might like to share.

[migleycow]

clever

[JENSSCHLAU]

Thanks man !!!

[imayjustsay]

Absolutely beautiful. This so useful and you made is so clear, thanks.

However, the audio is very low. A common thing 'youtubers' forget when uploading their footage.

I have to turn up my speakers to maximum to hear the person speaking!

Apart from that, I want some more!!

[JohnBrugger]

good one

[intothelife324]

So great technic!!!

[deckyquinn]

nice one

[Rolstvid]

Great! Thanks :)

[kenthephotoman]

I know somebody has probably already mentioned this, but have you seen the way Excel 2007 handles this?

[powa2life]

Dude, thank you, very useful info.

[powa2life]

Oh problem, what did you type after =REPT and why? I tried to copy your steps but it doesn't work.

[powa2life]

Oh nevermind, I got it :)

[thefirebolt123]

you hav 2 type any alphabet, an I is better for a bar graph type result..

[powa2life]

:) yeah thanks I'm new to this excel stuff, very interesting stuff

[Miniclip420]

Thank you very Much brother for teaching us this formula.

[IslamIsHarmony]

Does anybody know if you can block unacceptable words in microsoft excel? Because i'm doing a questionair. please help

[Silverado31]

IslamIsHarmony,

It depends on the application. If there is a set list of acceptable responses, you could use data validation and create a picklist so your users can choose the response that fits them best. That way you eliminate any possibility of unacceptable words.

If that wont work and you want a free text field where users can write whatever they want, the best thing I can recommend is conditional formatting. If the user uses an illegal word, you can black out text by shading the cell.

[IslamIsHarmony]

Thanks I was looking all over the internet and I couldn't find anything I needed to do this for my G.C.S.E'S.

[RobWantling]

hi. swop the l for a g and format the cell to webdings!!!!!!!! when i came across this it was called table tango!!

[jinkklin]

good! thank you!

[Aristomenis]

Does anyone know how to make a 3d (3-varibles) chart in order to show the trade off between 3 different variables?

[2bninja]

excel is fun

[rdjalayer]

If you want to see some good Excel videos search rdjalayer

[einc70]

tks for the tip.......

[chequesfilms]

es un excelente tip, muchas gracias

[josephperera]

I love excel. This is a wonderful thing I learnt for the first time though I am using excel for over the past ten years. Keep more of them coming.

[jeffelder2000]

wow, this is absolutely WONDERFUL! Next lets get rid of the graphical user interface entirely and go to a more highly advanced text based interface where this high-tech method would be most useful.

[Indrius]

Also, to use this with negative values, you need to use two rows..

[Indrius]

Or you could simply create a bar chart. Nice trick, anyway.

[trose76]

Dont try the in cell graphing in MS Excel 2007, it's flawed. The Rept function works the best and like one person said, use ALT+219 for a better rendition.

[Katantika]

instead of "I" use Alt+219.

[hollyhoodjoe123]

You don't need this if you have Excel 2007, but its very useful for Excel 2003.

[bravehobbit]

Very clever and very simple, thanks ..!

[cementra2007]

very useful method, Thanks

[UX6Q7]

SZÖVEG =SOKSZOR

[unytran]

wow!!

[Iamzota]

Very nice vid. thanks alot

[joelamhp]

pretty cool!

[chhaylemm]

Sack Adam..

LoL..

[itaskin]

nice idea, i like this

[6642633]

Very Nice!

Simple but very usefullllll indeed :-)

[bgagan911]

good.. nice nice .. haha

[7d23]

sack Adam!

[pikapika13]

Very nice use of the REPT function for those who don't have xL 2007 yet. Please post more creative tricks if you have any. Also, just an obvious modification of your tutorial for newbies...if your values are high (and the "I"s are running too long), you can divide your values: =REPT("I",A3/2) or "/3", or "/100" etc depending how high your values are.

[BrucknerMotet]

You don't need 2007 to use the REPT f(x).

I'm using Excel for Office 2000 and it works just fine.

Also...try using a symbol instead of "I" as the repeated character.

[pikapika13]

I realize that you don't need 2007; I think I wasn't clear. In 2007, you have the capability of putting in bar graphs in the cells.

[BrucknerMotet]

Don't worry..you were as clear as a bell. I just misread your post late last night after a tall scotch. Sorry. But I did have fun using symbols (smiley face, musical note) in the REPT function. If you had a music store and wanted to use REPT to quickly view their comparative productivity, the musical note symbol would be good to use.

[teachfromthebeach]

I'm sending my students to your trick. Thx.

[NEUMOBIKE]

good trick!!!!

[bamasutra]

Nice trick...show us more dude...

[davidgbshaw]

Come on adam, buck up. The game's not over yet.

[OneFastBiker]

WOW!!!!!

[tcolberg]

It seems that Adam is screwed.

[romane002]

thanks!!

[wexomixo]

Very cool, thanks.

[omegasquid]

Nifty! Thanks for the tip!