Excel Database Setup :A Beginner’s Guide to Organizing Data and adding it to the excel data model

Are you new to Excel and want to learn how to organize your data into a database? Look no further! In this quick tutorial, we’ll guide you through the process of setting up a database in Excel and adding it to the data model. You’ll learn how to structure your data, create relationships between tables, and later use powerful tools like PivotTables and Power Query to analyze your data. By the end of this video, you’ll have the skills and knowledge you need to manage your data like a pro. So why wait? Start organizing your data in Excel today!

[rayraman]

Nigel, your explanation is very clear and it feels like a friend is showing you how to do stuff. Thank you so much for sharing your knowledge with the community.

[Meandeeds]

Greatest Video so far, thumbs.
Please continue with such great content

[kotinkarwak]

Seeing a beautiful Outsystems logo on the desktop!

[scotolivera]

it seems promising what you r showing here, but without a real case scenario from 0 wouldn’t be much beneficial, thanks

[TY-zlvw]

Didn't know about Control L to change Range to a Table, only learnt about Control T.
This video reminds me about many years back, when I tried creating in Excel 2000/3 with Relational Database like structure. There were no Data Model (Power Pivot) feature on the older version of Excel. Access was the proper one to use, but it's not part of basic MS Office and initial setup take more time than with Excel.
Now with Power Pivot, is DAX flexible enough to mimic the SQL statement like SELECT field names FROM Table Name WHERE field value = condition value... DISTINC, or Aggregate functions with GROUP BY... to query data dynamically? Excel version of my home computer doesn't have all the cool new function like: FILTER, UNIQUE, SORT.

[funkidunya]

Great work. I need land record management database template, please.

[jasonturingan]

can you please provide the sample excel file ( data) for us to follow along with the tutorials

[joukenienhuis]

Thank you for the good explanation and start for Excel as database. Why do you need Access if this is possible? Only for the reports?

[bryanmcgrath]

Could we see a demonstration of the different uses of this database?

[crizMC]

Hello Sir can I get a copy of the template so that I can follow your tutorial
Thank you🙂

[RetroDree]

Very good examples, but your sound quality lacks a bit

[frontdeskterrace]

Looks like great info - if only I could spend less time trying to decipher the accent and concentrate on the content. I can only catch about 75% of what is being said. I am usually really good with accents but wow... You got me this time... I apologize but I am really interested in learning what he's trying to teach here, but it's very frustrating. I am figuring out the words about 2 minutes after they're spoken. I will have to replay this several times to catch on.

[ErtizaAbbas]

Hey Nigel, it will be more helpful if you teach us bookkeeping stuff in excel

[lourensengelbrecht]

Nigel can I contact you via email. I have a lot of questions about excel and my invoicing system that I use