Anda belum login :: 23 Nov 2024 11:07 WIB
Home
|
Logon
Hidden
»
Administration
»
Collection Detail
Detail
Supercharge Your Excel Sum Operations
Oleh:
Kern, J. D.
Jenis:
Article from Bulletin/Magazine
Dalam koleksi:
Journal of Accountancy vol. 208 no. 1 (Jul. 2009)
,
page 48.
Topik:
CPA
;
Microsoft Excel
;
SUMIF
;
SUMPRODUCT
Ketersediaan
Perpustakaan Pusat (Semanggi)
Nomor Panggil:
JJ85.27
Non-tandon:
1 (dapat dipinjam: 0)
Tandon:
tidak ada
Lihat Detail Induk
Isi artikel
Many CPAs, frustrated by rigid and inadequate reports from their general ledger or other enterprise systems, turn to Microsoft Excel. Nimble but powerful, Excel often manipulates data faster and more effectively than less agile applications. But to perform certain tasks optimally, a CPA sometimes may have to bypass what apparently is Excel’s most relevant function and instead use another Excel function that at first may not seem suitable. This article presents such an instance, comparing the SUMIF and SUMPRODUCT functions and demonstrating an innovative approach that can produce the reports you need, quickly and easily.
Opini Anda
Klik untuk menuliskan opini Anda tentang koleksi ini!
Kembali
Process time: 0.015625 second(s)