Microsoft Excel #04: Excel as a Database

[cyberparaCristo]

good video thank you.. bro...

I have a proble with a work. i need to draw in one box a text or number or something and in the top of the same box i want to put a picture wich is a red thing then, what i want is when a clic en the box or in the picture,,,, disappear an when i clic with the mouse again in the box appear the picture again..

that is mi work bro i thank you if you can answer me this weekend i thank you again... my mail is edlioncua@gmail.com God Bless you...

[trucker1234able]

is there a way to use sheet 1 as an data entry form and have the database on sheet 2 so that when i enter data into the form it will add this info to the database

[hersheng18]

great skills in excel sir .. wow!

[YeeSun9]

Really Good...Excel is so powerful on data. 

[pagegurl]

THIS VIDEO WAS SO HELPFUL. IN THE NEXT WEEK, I HAVE TO DEVELOP A DATABASE. 

[TracKAddicTeDMusic]

isnt anchorman rated pg-13?

[funnybful]

great tutorials...simply amazing ...love ur voice as well and can u tell me how to find ur videos on you tube ? because i had a bit of juggling to find u again....

[funnybful]

great great really great job....and easy to understand .easy examples.....great to learn excel for people like me who cant afford to learn in expensive institutes....

and r u from states? which part of states?

u got nice voice as well....great job but can u tell me how can i search specifically for ur videos for Excel...because i had a bit of juggling to find u once again.....

[MsMurry96]

can you show how to convert the work from excel to database (access) ? thanks

[GowanBray]

Great, thanks but how can I get it to come up with a list of options in a pick list generated from another sheet in the same spreadsheet ? Like state codes for instance ? Or musical keys or composers ? Thanks

[TheLtbiomed]

amazing.keep it up,love to learn!!!

[warlockdemon18]

glad im not your friend, the whole world would know my address

[freetutorials]

@warlockdemon18 -- Well, I don't know how. These names and addresses are all made up.

[freetutorials]

@warlockdemon18 -- Well, I don't know how.  These names and addresses are all made up. :)

[freetutorials]

@warlockdemon18 -- Well, I don't know how. These names and addresses are all made up. :)

[warlockdemon18]

@freetutorials k good, lol, i was hoping for that, good video tho.

[nkk20012001]

V good video ..recently i was on webex presenting new projs on excel and was embarassed , because i did not know some basic stuff ..but now watching all your videos on excel and they are helping me a lot .. thanks a lot ! from MX city :D

[MultiPringle123]

really good video :)

[meganann823]

i had to watch this for a class and it was helpful, thank you :).

[lukmackul]

great demo!

[ph1sheR1]

Microsoft Exel 2010 Tutorial watch?v=M1dX9L4EXxk

[sntini1]

hey..thanks for the video man..you are doing a great job..really appreciate this...keep up the good work...God bless you..cheers

[jaspers22]

Thanks for the video man!

[futureahmed87]

i need to learn it from scratch so help me out!

[askgriff]

Those weren't real people. The information was all made up.

[J0EH3AD]

Excel is great. Even if it had small statistics functions and still it has mistake in F-test. Even it is much friendly and easy then minitab, statistika ...

[hyphyindigochild]

Thanks for the tutorial, but you may want to concider what you've shown. You were showing me and about 226,970 other people, alot of personal info about your employee's.

End note; BIG help. Thank you.

[Ohsta6t2]

Some of your films have an NR rating. How is that when films that are not rated have that, usually before their release?

[sourmanofcoal]

GOOD STUFF

[BrightFutureMaker]

Dude, use Microsoft Access.

[UnitedPebbles]

@BrightFutureMaker

I don't know how...I made the tables, the queries, and then what next? modules? vb?

[Sincitysqt702]

Good tutorial!

[animex08]

great tutorial! it helped a lot!

[amashisushi]

Hi do you do excel on mac? i like your voice. makes me want to learn more about excel ^_^

[ShaddyLee]

Good job thx u help me alot !! This is exactly what I looking for

[prostheticz]

Hey great video. I don't know if you are a HTML kind of guy but my friend is making a website and needs a database to store the e-mail addresses submited to him. Do you know if Excel wil automatically add new email addresses to a file?

[TJHassis]

@prostheticz You might consider using PHP to read the individual form variables, and storing them in a MySQL table also using PHP imbedded the HTML. I personally have never seen Excel do this "automatically." If you use the suggestion via PHP, you can export the Table contents into a delimited text format and import the information to Excel.

[manattan342]

is it possible to see what pc 1 is out puting then take that info and manually in put it into pc 2 then could pc 2 know where pc 1 is going and what pc 1s next out put would be before it comes out

[manattan342]

question, i like your video i was wondering if u can help me with a question i came up with an idea lets say there are two pc's ,in pc 1 there are three box's that are out putting letter from a-z box=f box=r box=w the next set of boxs box=h box=l box=x these are random generated letter that are place in the box,s box 1 a-z box 2 a-z box-3 a-z

[quadsnipable]

learning that in ict lesson haha

[chatinuga]

how do you sort, using alphabetical order and sorting the word "the"? Because "the" would be in the name of title?

[LiamXaoh]

@chatinuga - one of the classic database issues. I always enter titles as "Beatles, The" in preference to "The Beatles". If you have lots of stuff entered as "The XYZ" then you can alter them all quickly to "XYZ, The" with excel. Takes a bit of fiddling but if you have lots to do it can be done.

[burchds]

I like it when you say "Sacramento only has three people." I smiled.

[rizla420]

k how do i make that header thingy... when i go to sort it says column a, b, c etc... when i insert header it doesnt align to my cells

[86rishabh]

Meet Experts on Ezdia For Basics of Microsoft Excel & If you know some thing post it and earn money

Join eZdia and post your expertise in it. Employers will find you through your expertise. You may? get part time or full time jobs.

[NICKYSYMONEE]

cant see shit so it makes no sense

[itsamj007]

which video do I watch to find out how to do some simple labeling of cells and getting automatic outcomes in the other cells, instead of having to manually type it in?

[m6guvnor]

RUBBISH, THE SCREENS ALL BLURRED!!!

[serenemale]

improve your voice please

[DeniskaFromRussia]

simple... i've known it for years

[Divamelrose]

thank u, u really helped me, i have exam 2morrow on excel

[inerreality]

Thank you man this helps alot!

[bye2alvin]

i cant hear you!!!!!!!!!!

[traceyd15]

you can't see anything in the cells!

[312arjay]

what excel version are you using ?

[lizkalei12]

Thanks again for another great post

[ernestomck]

Thank you for sharing, It meant a lot to me.

[anigz]

can't see the screen...

[davemaciasarch]

Lets say you have a typical Microsoft excel sheet and on the bottom you have standard table. You have 5 rows vertically on the left of job codes, like (1-engineering) (2-coordinating) (3-support) (etc). And five columns horizontal on top of building floors, like (1st floor) (2nd floor) (3rd floor) (etc). And above that whole table you have a simple time sheet layout consisting of 4 cells running horizontal as follows Date , floor level , job code, and hours

[LilVador]

great video

[arehmanj]

awesome vids....casual but professioanl at the same time, which = talent!!! whts good abt them is tht they're not too short or too long, the vid lenght is just right...

[juleswc]

You are a great teacher. Thank you!

[MissusFingerBottom]

great tutorial!!

[raieven]

Hi, awesome videos! They are really helpful but the sound is a little low...just an FYI. Thanks a million, you're a great teacher. :)

[RagazzaFit25]

the sound is perfect for me

[ineedpotato]

Again, thanks every so much.

[20RoyalSuperKing]

Great vid , but 3 words data protection act

[baloon12]

good job thanks

[upinflamezzz]

Access does kind if suck.

[fl1946]

I stumbled onto your video series and what a goldmine of information! I was debating using either Access or Excel to capture some basic information. Thank God I saw your demo. Saved me tons of time. Thanks.

[antlion71]

Your video is excellent. I love it. I sum up my opinion of excel and access in 4 words.

Excel-Awesome;Access-Evil!

[AveIvy]

This is fantastic!!!

[phobiablack]

good stuff cheif! keep it up!

[sendmeagain]

nice video,, really helpful,, keep it up

[shreeingame]

good work and i do love to work with excel rather than with access. Excel is more freindly to work with . you can do wonders with it . I have created a small s/w using excel and vba . its very simple program ...soon will post that in youtube.....

[isssssssce]

great videos . keep it up!

[dustylee]

hey im having trouble with an equation that involves LOG and some other stuff for exponential functions. things you find on scientifical calculators.

would you happen to have a video on functioning?

[freetutorials]

Sorry it took so long. I am going through all 97 of my videos looking for requests and I am making a list. I'll do what I can.

[dustylee]

ok

it is for science fair but i have a back up plan.

[Cywreck]

Very good !!

You rock Dude!! You just save me a lot of time :-)

Greetings from Mexico

[freetutorials]

¡Gracias, Señor!

[mubarakiqbal]

hi my friend how are u and ur life ... if u not mind i can send u my office file ..so can u arge n my file and with setg ... pls

can u gve me ur email id...

thnx u

[HermanoArmada001]

good tutorials!!!!!!!

-keep it up!

[irisheyes0120]

your tutorials are great!! can you show us how to do a pivot table?

[JeReL19]

I agree

[freetutorials]

Sorry it took so long. I am going through all 97 of my videos looking for requests and I am making a list. I'll do what I can.

[ferrex2004]

Very usefull