Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!

2. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.


Financial Modelling Training in Mozambique during May 2013

We are running Financial Modelling training in Mozambique during May 2013.

The course is running from the 8th to the 10th of May 2013 at the Hotel Cardoso in Maputo.

We will be covering the following topics over the 3 days

  • Good Financial Model Practice
    • Types of financial models
    • Consistency in models
    • Separation in models
    • Integrity of the models
    • Structural issues
  • Creating trigger cells
  • Summing through sheets for aggregation and consolidation
  • Custom formatting for ease of reporting and input controls
  • Grouping periods e.g. months into quarters or years
  • Modelling macro-economic factors
  • Inflation
  • Exchange Rates
  • Interest Rates
  • Handling fixed, semi fixed/ variable and variable items
  • Revenue
  • Costs
  • Capital expenses
  • Working Capital in Financial Models
  • Depreciation calculation methods
  • Tax and Assessed losses in financial models
  • Modelling debt in a financial model
  • Valuation within a financial model covering the accepted valuation techniques
  • Running sensitivities in a financial model- Scenarios, Tables, Goalseek and Solver
  • Reporting- Methods to get your message across based on the results of the financial model

To get more details send a mail to