From the course: Excel Power User Challenge

Unlock this course with a free trial

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

Set up a workbook to split data onto different sheets

Set up a workbook to split data onto different sheets - Microsoft Excel Tutorial

From the course: Excel Power User Challenge

Start my 1-month free trial Buy for my team

Set up a workbook to split data onto different sheets

“

- Are you ready to disaggregate or peel some data apart? Get it the banana peel, peel data. Right, that's the end of the jokes. Showtime is over. All right, we're going to straighten up and disaggregate this data. We've got a list of items that we've collected and we have the original purchase price for most and the current value for most. What we need to do, we need a separate sheet where we want to use the filter function to retrieve items that have a net gain. And we want a separate sheet for the items that have a net loss. And for items that don't have complete information, we don't want to filter them anywhere. We want to just leave them here until we do have data. And once you have everything filtered out, then make some changes to the data. Maybe even add some items to the list just to make sure that the data works. We need this to be dynamic. So let's look at the data before I set you loose to get on this.…

Contents