Show Menu

Excel for accounting Cheat Sheet (DRAFT) by

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.


C4 multiplied by 5
C4 multiplied by B10
C4 divided by E5
C4 times B10, less D1
adds 20% to the value in C4
brackets first
2 squared (to the power of)
2 cubed
square root of 4
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
1 hour 30 minutes
3 hours 45 minutes

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
highlight row
move b'een sheets
Ctrl PgDN/PgUP
lock cells

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)