There are many areas in relation to accounting activities prior to preparation of financial statement where Excel and VBA are applied. Here we are illustrating application of Excel and VBA in some key areas of  preparation of financial statements.