Creating a Database in Excel [Excel is a Database]

In this video I go through why creating a database in Excel will help with your data management in Excel. Excel is a database and as such the way we add data into Excel is very important if you want to get fantastic data driven results. Using an Excel table to store your data is now best practice and to create a table in Excel is actually very simple once you know how.
I show you how to make a table in Excel and show you some Excel tables examples that can be formatting to have banded rows in Excel to make the data easier to read visually. Using a dynamic table excel can understand and query the table using the field headers just like you would if you were to use SQL. Follow along with this video tutorial as I detail out how to insert table in Excel and how to make a database in Excel.
Learn all the basic database formulas easily in this Microsoft Excel Database Tutorial, using Microsoft Excel database formulas and function you will level up your current Microsoft Excel skill level and make you a Microsoft Excel Expert in no time!
In this how to Microsoft Excel Tutorial I show you how to use make a database table in Microsoft Excel and show you the Database formulas like:
✅ DSUM
✅ DAVERAGE
✅ DMIN
✅ DMAX
✅ DCOUNT
✅ DCOUNTA
Quick Navigation:
00:50 - How to create a database in Microsoft Excel
03:34 - How to add data to a database in Microsoft Excel
05:24 - How to use database functions in Microsoft Excel
If you found this video useful please click the like button and consider subscribing to the channel, if you click the bell icon you will also be notified of all our latest videos.
🎬 / @thatofficeguy
🎥 Playlist Links 🎥
Excel - • Microsoft Excel
Excel Basic Formulas - • Excel Basic Formulas a...
Excel Advance Formulas - • Excel Advance Formulas...
Teams - • Microsoft Teams
Outlook - • Microsoft Outlook
OneNote - • Microsoft OneNote
Planner - • Microsoft Planner
Welcome to the official THAT OFFICE GUY channel where you will learn all about the various Microsoft 365 apps and more! Many of our videos cover the popular Microsoft Excel, Microsoft Teams, Microsoft Planner, Power BI, Power Automate, and all other basics in Microsoft 365.
With the Excel tips and tricks, you get to significantly improve your Excel reports - not just in terms of analysis but also visualization & VBA automation.
With Microsoft Teams you'll be able to achieve greater levels of communications with your colleagues - and with all the other Microsoft 365 applications you'll learn how to embed processes that cross the apps and increase productivity!
Subscribe if you'd like to improve your skills.
New videos are uploaded each week and live streams coming soon!
Let’s connect!
📘 / thatofficeguyuk
🐦 / thatofficeguy1
📷 / thatofficeguy
🏢 / that-office-guy
#thatofficeguy #Excel #MSExcel #MicrosoftExcel #ExcelTutorial #excelTutorial #excelTutorialForBeginners #excel #excelCompleteCourse #ExcelFormulas #ExcelFunctions #MicrosoftExcelTutorial2020

[@ThatOfficeGuy]

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

[@StaticBlaster]

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.

[@jasondang8777]

Brother can you post a video?

[@user-xq9qg7ew8w]

thank you, very clear and useful

[@adithakethmika4635]

Thanks for the precious video!

[@heishoi]

thank you , this formula are amazing

[@ddddyliu]

Great intro, thanks!

[@Junjo11]

Thank you. I appreciate your video

[@shrastiomar8372]

It was a helpful video!

[@gerrysides465]

Very helpful. Thank you.

[@elisepalicte6995]

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

[@derekthompson835]

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

[@IsaacLoven]

Could also use pivot table in Excel for this.

[@riyadeb2988]

Thankyou its very helpful

[@girishpanicker5]

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

[@neilcooke4835]

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?

[@huongthu8277]

so touching for an excellent video

[@niloykarmaker1024]

Thanks a lot!!

[@spookybooscarystorytime]

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

[@jamesukoette3496]

Great video

[@lokeshalchemist]

Helpful

[@gobblegobble8432]

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?

[@MrRodrigongo]

If I'd like it to be in another excel page, is it the same process?

[@failguyonyt2298]

Nice video.

[@sayu2920]

can you show me about how to create student databaces

[@linacastleofmystery]

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

[@asnakekula7987]

best tutrolias

[@thomasduke651]

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.

[@pedrojosevilelasussai3314]

Great channel name

[@sebastiancasanova1120]

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...

[@rawadalsaify2545]

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?

[@yeniyuliawati5157]

thankyou

[@ThatOfficeGuy]

You're welcome!

[@user-yz7gn8bi3y]

How do we add two columns to the spread sheet: Ennea (this will be a number in brackets next to their name) Source (this will either be in brackets or at the bottom in notes) Xx

[@marianross5830]

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

[@sergiolopez8482]

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??

[@georgywordrighter5662]

Great - am looking at using this as a records management tool - not financial data manipulation....any tips or signposts to other presentations? Do you post up excel templates with the formulas on anywhere to practice on? Thanks again :)

[@caffreydavis218]

Any updates?

[@Enigma-hs5op]

i highlighted the mini table but it doesnt work when i change the region

[@francishubertovasquez2139]

Have you been starting to store data's and files to the modern science focused non physical data and files storages as back up data and files storages because there's also modern tech newly developed intrusion methods that can penetrate the usual encryptions and usual system defenses which necessitates modern science advancements varieties of data and files storages so that those years and years of works and encodings and funds used for storing those data's and files won't go wasted and wont be stolen by other hi tech companies specially the organization involved belong to a large alliance with plenty of resources because there's stiff rivalries of opposing alliances nowadays trying to dismantle the other?

[@yohannaagbanaji8012]

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

[@samuelnyoni7888]

How does it escalate numbers

[@UtolJr]

❤

[@Hope_all_is_well]

How about an employee database?

[@MrLudiJasko]

Any news on this? Did you manage to solve it?

[@wanmuhamadaliff7606]

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

[@andreasfiessinger4413]

It is probably OBS

[@SumaAlimatu]

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

[@Junjo11]

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?

[@rocko6439]

For the month/date criteria, I tried referencing a cell which contains a date, such as, today()-180 and it does not work. Is there a way to do that?

[@ThatOfficeGuy]

Not sure what you actually mean, however "=TODAY()-B1" would be today's date less the number of days listed in cell B1 or "=TODAY()-180" if B1 = 180. Hopefully this helps.

[@rocko6439]

@@ThatOfficeGuy Thanks for responding. I gave that a try and it didn't work. Sorry I wasn't clear enough. In your video, you were getting the DAVERAGE and DSUM for the Region and Month. Let's assume, you have a date, which is MM/DD/YY instead of a month (Jan) and you want to DSUM all sales for the last 30 days. So the criteria would be something like >=today()-30. But I'm not able to get this to work. Assuming, you found a way to get this to work, can you see if you can get this to work when the number 30 is stored in another cell and the criteria will reference that cell. Thanks for your help.

[@carlostoribio4506]

When you do any adding or subtracting, make sure that both of the data sets are in the same format. You can't subtract 06/08/2021 from 365 the format doesn't align. If you instead convert it to a number or convert both sources of data to a date then it might work

[@RozrubaGames]

🎯 Key Takeaways for quick navigation: 00:00 📊 Setting up a Database in Excel 05:06 📈 Using Database Functions in Excel Made with HARPA AI

[@phuccaoo]

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

[@ThatOfficeGuy]

In simple terms, yes. AVERAGE can be used in both examples but DAVERAGE only when Excel has been structured correctly. DAVERAGE will help you troubleshoot the formula at a later stage if something goes wrong whereas AVERAGE could take longer to workout where the issue could be.

[@REAM1996]

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

[@variant101]

Create relationships with what you want to search for, Insert a pivot table using the database, then move the row headers around until you get what you’re looking for.

[@milibrodeoro]

sorry it was not visible the criteria. To small video

[@Samy-ck8oo]

From when a table became Database ???

[@briandead3513]

Kandungan anda sangat menyentuh

[@bryanstark324]

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.

[@danielmadsen100]

Don't take my word for it cause my experience with this is still very limited, but it is possible to make relations between columns of each table like you would in a database in Access for example. Don't remember what the feature is called, but it's a green symbol and I think it is located in the data tab :) Edit: It's Power Pivot

[@kidtheday]

👆🤓

[@SF-fj6rr]

i thought you were tom cruise

[@mpgc20]

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.

[@catiekulbida7376]

Any information on this one?

[@zak00101]

This isnt a database, pal. Is a spreadsheet.

[@jyothirevanna7931]

That is zoom class 😆😜

[@mdisney8384]

I can't hear you

[@UBAAAlexPandians]

Purila sir

[@leuqas6729]

why

[@el_andrius]

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

[@mikel4510]

Excel is not a database; it is a spreadsheet.

[@james-innes]

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

[@SystemScan101]

You’d get more views if you didn’t have such long adds

[@cuba_rj]

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.

[@JMK_245]

What i was thinking, despite it being good at storing data your're better off using phpmyadmin

[@LapoSapo]

Excel is not a database!!

[@andybawn1]

Easier to learn to use Access, don't use a hammer to undo a screw :(

[@ThatOfficeGuy]

It does come down to choosing the right tool for the job, it all depends on what your goals are. I have used Access for years but the 2GB limit is a problem for most, I now use Power BI and it does a good job for what I need.

[@andybawn1]

@@ThatOfficeGuy the 2GB is the same for both Excel and Access but in fact you can have 2GB per field if you split the database, I've been using Office since 1983, but as you say use the right tool for the job. Excel for spreadsheet's & Access for database's

[@kenlouie4916]

@@andybawn1 Access is pretty much dead while OFFICE 365 will to defacto standard now. Access is much better but for the average user it would take some time to build. It is complicated for people who needs to just data entry than excel.

[@jsmithnevinsky]

Get a new mic

[@elishatech4600]

Why are you using Excel to create a database 😂