To insert a single column: Right-click the whole column to the right of where you want to add the new column, and then select Insert Columns. To insert multiple columns: Select the same number of …

Power Query splits the Sales Rep names into two different columns named "Sales Rep 1" and "Sales Rep 2". To change the default names, rename them to "Sales Rep First" and "Sales Rep Last".

Let’s add several columns to deconstruct different date types from the existing Order Date field. For example, you may want to identify the day of the week or spell out a date such as Monday, January …

Learn about the many ways to create a table in an Excel worksheet, and how to clear data, formatting, or table functionality from a table in Excel. Discover more in this video.

You can quickly create a list of dates, in sequential order, by using the Fill Handle or the Fill command.

Use an outline to quickly display summary rows or columns, or to reveal the detail data for each group. You can create an outline of rows (as shown in the example below), an outline of columns, or an …

You can create multiple custom views per worksheet, but you can only apply a custom view to the worksheet that was active when you created the custom view. If you no longer need a custom view, …

How to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.

Use Excel's Get & Transform (Power Query) experience to add new columns of data in the Query Editor by simply providing one or more sample values for your new column.

Insert a new column into the table. You can do this by typing in the column immediately to the right of the table, and Excel will automatically extend the table for you.