relational database

  1. M

    Using Excel 2016 Data Model to create a relational database instead of Access

    I recently stumbled across the Data Model tools in Excel 2016 and want to know if I can use it to create a relational database structure in Excel with the data tables setup on the tabs of an Excel workbook. Can anyone point me to a tutorial, textbook or, better yet, an example database that...
  2. A

    Excel Pivot Multiple Columns

    <tbody> ItemList Colour1 Colour2 Colour3 Colour4 Colour5 Colour6 Colour7 Colour8 Item 1 Blue Yellow Purple Green Orange Red Cyan White Item 2 Black Magenta Cyan Yellow </tbody> Hi I'm new here so sorry about the unconventional formatting. I have a item table with different coloured...
    • Africat
    • Thread
    • pivot powerpiviot relation relational database relationships link tables
    • Replies: 4
    • Forum: Excel Questions
  3. M

    How to create a database of medicines (name, form, dose) comparing multiple cells in a row across different excel worksheets (each worksheet = country

    <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; min-height: 15.0px}</style>I am trying to develop a database that can help to analyze national essential medicine lists, to use as a...
    • MeenuBala
    • Thread
    • analysis data comparing workbooks excel pivot table relational database
    • Replies: 4
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top