Data Tables

Data Tables

Any data you wish to explore must be in Excel tables. All tables have a name and a header row containing the column's name. A table can host any data type - like dates, text, or numbers. All columns of the table have the same number of rows. If you have data with different numbers of rows, you can create separate tables for each data set.

Here are some steps to convert a range to a table:
  1. Select the cells with your data.
  2. Select Home > Format as Table
  3. Choose a style for your table
  4. In the Create Table dialog box, set your cell range
  5. Make sure that your table has headers.
  6. Select OK


Idea
Each table has a name. The figure shows the table name as Table1. Renaming a table to something more meaningful for your project is a good idea.

Idea
The keyboard shortcut to convert a range into a table is Ctrl-T.

Notes
Sigma Magic refers to the data in a table using the combination of table name and column header name. For example, Table1 > Diameter.

External Reference:

    • Related Articles

    • Importing Data

      If your data is in another workbook, you can copy and paste your range or table from one workbook to another. Select your data or table, click on Ctrl-C to copy the data to the clipboard, go to the target workbook Data Sheet, and then click on Ctrl-V ...

    • Data Sheet

      While your data can be on any worksheet within a workbook, we recommend placing all data related to your project on the Data Sheet. A Data Sheet is a special worksheet that contains your data. To create a Data Sheet, click the Data button on the main ...

    • Editing Data

      You can edit the data on your worksheet. This is your local copy of the data, and any changes you make to this data will be reflected in your analysis when you click on Compute Outputs. You can add additional rows or columns in your data table. You ...

    • Main Menu Bar

      The software is an add-in within Microsoft Excel. When you open Microsoft Excel, you should see the software on the main menu bar. Click on the Sigma Magic button to load the software into memory. This will open the Sigma Magic menus as shown in the ...

    • Specifying Analysis Setup

      If you want to specify the options for any analysis, you can click on the Analysis Setup button on the main menu bar. Depending on the worksheet that is currently active, the analysis setup will be displayed for that worksheet. For example, if you ...