Creating a Database in Excel [Excel is a Database]

If you like the video please consider subscribing to the channel and hitting the like button, it is much appreciated!

Fun fact as a data scientist the first thing they teach you is that there is a huge missconception where people think nd try to use excel as a data base while its not...

I want to create a birthday profile for client on excell so me the fumular

Excel is not a database; it is a spreadsheet.

I'd like to make a database of photos with their website link in Excel, please. Please can you advise? Thank you

Nice video.

oh god it's not a database it's a table all the data is jumbled up sorry as a programmer this triggers me. It looks like a failed A-Levels database normalisation answer

From when a table became Database ???

Thanks a lot!!

I followed each step you did but it gets error under notification (This formula or function used is dividing by zero or empty cell) can you find my error please?

For a warehouse let’s say I have 100 in stock and then I took 60 the remaining stock will be 40 I can show that in that data base??

Why are you using Excel to create a database 😂

Great video

Could also use pivot table in Excel for this.

Please may I have your email or any medium of contact

can you show how to input data into the Excel Database with Power Automate, please.

Thanks for info, however cannot seem to get the results that I want. I need to create a database of products and prices, and from that database extract to a quote template?

I can't hear you

Excel is not a database!!

Great video, I need to create a workflow using excel, what are the best options for that?

best tutrolias

Kandungan anda sangat menyentuh

I need a spreadsheet to manage staff monthly savings and loan with a database

A little misleading because you can't really use excel as a relational database. You are only using excel in this video as a single flat table with only 1 clear purpose. But try this technique to track a hospital patient health record. Tracking not only admission, doctor and diagnosis, but track all the case notes, all the separate treatments, all the treatment barriers. Then you really can't use excel. It would be foolish and easy to accidently create redundancies.

thank you , this formula are amazing

Ty, much of the data is repeated. Can you create a dropdown or combo box so you don't need to type it in every time?

I've created a project for myself where I'm importing my list of movies from a txt file and I've already alphabetized the movies and grouped the movies by franchise. Now I'm creating additional columns for the year, main actor(s), director, platform where purchased, duration and other relevant information (such as if it's a short video, feature length film and studio). And once I understand macros, I might create a VBA to link my spreadsheet from Wikipedia so it can pull in information to make my life easier.

why

I got lost when you added the DCOUNT DCOUNTA DMIN DMAX DSUM. HOW DID YOU GET TO CHOOSE THOSE. WHERE ON EXCEL DID YOU CLICK?

Thank you. I appreciate your video

How does it escalate numbers

there are problems with the audio, it glitches and hurt my ears :(

how did you record like that? what software did you use? 🙏

Sorry, excel is amazing at crunching numbers, but it is not a database despite having DB formulas and even allowing expert users to build jaw-dropping databases in it. Microsoft has delivered several function to Excel to act like a DB and kill Access, but they could not kill it yet.

Using excel to maintain a database is similar to traveling from Argentina to Japan in a canoe, whereas Access would be a small plane and SQL DBMS would be a Boeing airliner. Just make your choice right.

thank you, very clear and useful

Great channel name

Before I even start to figure this out I want to know one thing. I want to create pages of information and enter fields into that information so I can just copy and paste the whole document without finding all of the details. The document is about 5000 words and will be almost the same except for the field values (ie title of book, description, etc.) Can it do this without limitation before I waste time? I used to use filmmaker pro before claris wanted a million dollars for it every month. Thanks

Thanks for the precious video!

Get a new mic

So a normal AVERAGE is for ad hoc calculations, and a DAVERAGE is for a properly managed database. Is that correct?

so touching for an excellent video

Helpful

I am trying to create a page on my spreadsheet that collects all inputted info for a year. The spreadsheet will have info for each month but I won't the extra sheet automatically collect all info for a year. Any help is appreciated.

This isnt a database, pal. Is a spreadsheet.

learnt something new, never heard of it. It's very helpful. Thanks for sharing this. Great, Keep-it-up.

is it possible to create a searchable database using multiple criterion (two or more columns from the database table)??

Hi, I need to create a form in excel. everytime I press on submit form, a new data entry should be created in other sheet. And if I want to modify any old entry, I should be able to recall that entry in that form for edit. Kindly share me any video link or suggestion. Thanks in advance.

Your video is very helpful🤗💖 How about Sales Prospecting Data Base?☺️

Thankyou its very helpful