From the course: Excel Power Tools for FP&A: Power Query and PowerPivot

Unlock this course with a free trial

Join today to access over 24,600 courses taught by industry experts.

Add Column ribbon: Creating new columns of data

Add Column ribbon: Creating new columns of data

From the course: Excel Power Tools for FP&A: Power Query and PowerPivot

Start my 1-month free trial Buy for my team

Add Column ribbon: Creating new columns of data

“

- [Instructor] What if you could take your transactions data and create new dates, new formats, and new structures before it ever even enters into Excel? Well, that's possible with add column. If the transform ribbon takes your existing data and overrides it with the transformation, add column just to the right of it takes your existing data and allows you to create new columns from it, it inserts columns to the right. Let's take a look at some of the features and begin with index column. What index column does is it adds an index number, which simply is an integer that goes up one digit at a time. So you can see that I have here starting at zero and then going to one and two and so on. Or if I were to get rid of this, I can go to index column and start from one, or I could even create a custom value, right? Something that starts at 1001, an increment of one perhaps representing invoice numbers. Why is this helpful? Because it assigns a unique identifier to each transaction as I've…

Contents