Financial Statements in Excel

Resolved · Low Priority · Version 2013

Fri 23 Jun 2017, 16:25 Delegate Sam said...

Sam has attended:
Excel Advanced course

Financial Statements in Excel

Best way of using Excel to build financial statements?

Sun 25 Jun 2017, 12:12 Trainer Jens said...

RE: Financial Statements in Excel

Hi Sam,

Thank you for the forum question.

Follow Excel best practice rules when you are creating financial models in Excel.

There are a lot of best practice rules we should follow. The most important rules are:

1. keep it simple
2. Focus on the output not the input. If you need to analyse the data the input must be setup for the tools yo need for the data analysis.
3. Make it easy to update
4. Make it easy to develop

I hope that I gave you something which will help you in the right direction.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Sun 2 Jul 2017: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Highlighting a data range

Attempting to use a mouse to highlight a large range of cells with data in Excel can make the mouse to have a life of it's own!

Use keyboard strokes instead.

Step 1. Place the cusor in the cell where the highlighting should begin.

Step 2. Select keystroke, CTRL+SHIFT+END

This will take the cursor to the furthermost bottom corner of the data range found in that worksheet. And highlight that range of cells at the same time

View all Excel hints and tips