Excel - sort by columns and one row divided by another row

Most people probably learn this stuff in primary school, but my school didn't have Excel back then, so I feel entitled to post about Basic Spreadsheet Stuff I learned today.  ;)

So here's the first cool thing.  Suppose you want to sort your COLUMNS according to the value in one of the rows.  For example:

User	Red Points	Blue Points	Yellow Points	White Points
Steph	10	12	2	27
Ban	5	38	16	8
TOTAL	15	50	18	35

So say I want to re-arrange the columns Red Points, Blue Points etc. so they are a different order, according to the TOTAL row.

In Excel just go Data --> Sort --> Options --> "Sort left to right", then click OK and in the Row column, choose the row number next to the word TOTAL (example: Row 4), then click OK.  BOOM!  Column sort!  Yeah!

Here's another trick.  Suppose you want to add another row that's like "Steph Percentage of Total".  For example, you want to automatically calculate a row that takes the value of the Steph row and divides it by the value in the Total row, and put the answer in the new row.  To do that, just click in a new row (Say it's Row 5), and type =B2/B4.   This will put the value of 10/15 or 0.667 into the cell.  Now, to repeat this for all the columns, just hover your cursor over the corner of the 0.667 cell until it turns into a black cross, then drag it across all the other cells in the same row.  Boom!  New calculated row!  Yah!

It would be cool if I actually use these tricks again someday!