Show Menu
Cheatography

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.

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/P­gUP
lock cells
F4

IF formula

=IF(­log­ica­l_test, value_­if_­true, value_­if_­fal­se)
e.g: =if(D4­>1000, "­Bon­us", " ")

Concat­enate formula

=CON­CAT­ENATE (text1, " " , text2)