What-if Analysis dengan Excel Scenario Manager untuk Perhitungan Neraca, Laporan Laba Rugi dan Analisa Rasio Keuangan Perusahaan

Nugroho, Hoki Cahyadi
Artikel jurnal Bina Ekonomi • 2008

Abstrak

Excels Scenario Manager Feature makes automating your what-if models easy. You can store different sets of input values (known as changing cells) for any number of variables and give a name to each set. You can then select a set of values by name, and Excel displays the worksheet by using those values. You can generate a summary report that shows the effect of various combinations of values on any number of result cells. The summary report can be an outline or a pivot Table.

Metrics

  • 146 kali dilihat
  • 79 kali diunduh

Jurnal

Bina Ekonomi

Bina Ekonomi merupakan jurnal ilmiah yang terbit dua kali dalam setahun. Jurnal ini mewadahi kary... tampilkan semua