Archives for July, 2009

Business planning for a start-up venture

Sunday, July 26th   No Comments (yet)
Starting a new business is a challenging process and involves a number of hurdles. The challenges range across finance, cheapest reporting, legal, comme...

Read entire article

Line Summaries – get the big picture!

Saturday, July 18th   1 Comment
Within the first few minutes of starting to build a financial model for project finance, illness
corporate finance or any other sector it becomes clear tha...

Read entire article

Do not use WordArt in your financial model!

Thursday, July 16th   4 Comments
In Excel there is a horrible functionality called WordArt. If you didn’t know this already then I apologise for having given you an idea of being able to pr...

Read entire article

Why your last financial model audit was so expensive?

Wednesday, July 15th   1 Comment
There is a setting in the Options -> Edit -> Setting section called ‘Edit directly in cell. The ‘Edit directly in cell’ related to the way Excel...

Read entire article

Improved financial modelling with conditional formatting

Monday, July 13th   No Comments (yet)
There are numerous tools and add-ins in the market constructed to enhance the ability to critically review formulas in Excel. Many of these tools build on t...

Read entire article

How many Excel Worksheets do you prefer?

Friday, July 10th   4 Comments
When building a financial model, medicine for any discipline, online
you may want to think about if you want to have lots of worksheets with not much in each o...

Read entire article

How to successfully build portfolio (multi-asset) models

Wednesday, July 8th   No Comments (yet)
When building a financial model, medicine for any discipline, online
you may want to think about if you want to have lots of worksheets with not much in each o...

Read entire article

Visually tracing all precedents in Excel without add-ins

Sunday, July 5th   7 Comments
There is a setting in the Options -> Edit -> Setting section called ‘Edit directly in cell. The ‘Edit directly in cell’ related to the way Excel...

Read entire article