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 and Functions  
Excel Advance Formulas    • Excel Advance Formulas & Functions  
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  
  / thatofficeguy  

#thatofficeguy #Excel #MSExcel #MicrosoftExcel #ExcelTutorial #excelTutorial #excelTutorialForBeginners #excel #excelCompleteCourse #ExcelFormulas #ExcelFunctions #MicrosoftExcelTutorial2020