Chart Templates in Excel

This technique came in super-handy today:

Reuse a favorite chart by using a chart template in Excel:

http://office.microsoft.com/en-us/excel-help/reuse-a-favorite-chart-by-using-a-chart-template-HA010007205.aspx

I had to make a load of pie charts, but the colors and format were not one of the defaults. It would’ve been painful to have to go through each chart, changing the colors and removing the labels, and moving the title to the top, etc. Instead, I made a chart template and it did all the work for me. 🙂

 

Excel Tricks: Special Paste

http://chandoo.org/wp/2008/07/02/17-excel-paste-special-tricks/

Excel: Split content based on a delimiter

Example for splitting a cell based on spaces:

1. Select the range of data that you want to convert.
2. On the Data tab, in the Data Tools group, click Text to Columns.

1. In Step 1 of the Convert Text to Columns Wizard, click Delimited, and then click Next.
2. In Step 2, select the Space check box, and then clear the other check boxes under Delimiters.

http://office.microsoft.com/en-us/excel-help/split-names-by-using-the-convert…

Apply excel formula to entire column – without dragging the mouse

http://answers.yahoo.com/question/index?qid=20080804112727AA9LUBh

copy your formula. Then go to a column that has figures all the way down all […] rows, press <End><Down>. This will shoot you all the way to the very bottom of that column. Now move back over to the column where your formula is. Hold down your <Shift> key, press <End><Up>. This will shoot you all the way back up to your original formula, and because you held down the <Shift> key, it will highlight all […] rows. Now press <Enter>. Voila!