Beginning PivotTables in Excel 2007 will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.

Categories

Archives

Learn how to create Excel dashboards.

Excel Twitters 20090327

Moved to the Excel Twitters archive:
Excel Twitters 20090327

Split First and Last Names in Excel

If you have a list of names in Excel, with first and last names separated by a comma, you can use an Excel feature to split the first and last names into separate columns.
Select the List
To start, select the cells that contain the names.

On the Ribbon in Excel 2007, click the Data tab, then [...]