3. Prepare Your Excel Data

Goal: Convert the raw Excel data into a table. Power BI reads tables better than plain cell ranges.

Why turn data into a table

Excel data without formatting is only a range of cells. The range can have extra notes, drawings, and empty space at the sides.

When you convert the range to a table:

1. Power BI reads only the table columns.
2. Extra notes and side content are not included.
3. Column names stay correct when you refresh the data.

Very important

The trainer recommends this step for every Power BI project.

Step 1: Open the raw data file

1. Open Raw.xlsx in Excel.
2. Look at the file. It has no table formatting.
3. Some cells may have notes or marks at the side. Power BI must not read these.

The raw data in Excel before conversion.

Step 2: Convert the range to a table

1. Click any cell inside the data.
2. Press Ctrl+T. The Create Table window opens.
3. Check the box My table has headers if your data has column names.
4. Click OK.

Excel now shows the table style. A new Table Design tab appears in the ribbon.

The Create Table window.

Step 3: Name the table

1. Click any cell in the table.
2. Click the Table Design tab.
3. Find the Table Name box.
4. Type a clear name. Example: Sales.
5. Press Enter.

The table name is important. Power BI shows this name when you import the file.

Step 4: Compare with the prepared file

1. Open Dataset.xlsx.
2. Click any cell inside the data.
3. The Table Design tab is already there. The table is already set up.

The prepared file is the result of the steps above.

Shortcut

Ctrl+T converts a range to a table. Ctrl+Shift+L turns the filter buttons on and off.

Next: Continue to 4. Load the Data.