Cheatography

# Excel for accounting Cheat Sheet (DRAFT) by yotka

This is a draft cheat sheet. It is a work in progress and is not finished yet.

### Note 1

 If a number is used more than once, e.g. TAX RATE, it's better when it is input to one cell only. Any other calcul­ations making use of that value shoud refer to that cell. If the TAX RATE changes, there is only one place to change it of the s/s.

### Basics

 =C4*5 C4 multiplied by 5 =C4*B10 C4 multiplied by B10 =C4/E5 C4 divided by E5 =C4*B10-D1 C4 times B10, less D1 =C4*120% adds 20% to the value in C4 =(C4+C5)/2 brackets first =2^2 2 squared (to the power of) =2^3 2 cubed =4^(1/2) square root of 4 =27^(1/3) cube root of 27

### Absolute Reference F4

 \$ A 1 to fix column A A \$ 1 to fix row 1 \$ A \$ 1 to fix cel A 1

### Note: Produce Print Screen

 Press Print Screen then Ctrl+V to paste elsewhere.

### Convert Time to decimal

 2 hours 15 minutes 2.25 1 hour 30 minutes 1.50 3 hours 45 minutes 3:75

### Popular keyboard shortcuts

 inserts DATE Ctrl ; inserts TIME Ctrl Shift ; insers Today's DATE =today ( ) toggle RIBBON from view Ctrl F1 insert the total Alt + highlight column Ctrl SPACE highlight row Alt SPACE move b'een sheets Ctrl PgDN/PgUP lock cells F4

### IF formula

 =IF(lo­gic­al_­test, value_­if_­true, value_­if_­false) e.g: =if(D4­>1000, "­Bon­us", " ")

### Concat­enate formula

 =CONCA­TENATE (text1, " " , text2)