Ada satu fasilitas di Excel yang jarang orang mengetahuinya. Fasilitas tersebut ternyata sangat memudahkan kita dalam mengetahui hasil perhitungan. Apalagi jika melibatkan banyak sel, sementara kita hanya tersedia sedikit waktu. Apa saja yang dapat dihitung dengan fasilitas tersebut?
If you have done something complex computation task of excel, you might be need to protect your sheet. Sheet protection will prevent changes on formula, deletion or even cell moving. In Excel, we can arrange any action that allowed or disallowed. How to protect a sheet?
What make data analysis become easier? If we recognize features of Microsoft Excel, we found that create a list is more powerful to get insight of data analysis. The related data groups can be managed and analyzed well.
The most popular function of Micorofot Excel list is filter. By filtering columns, we can analyzed contained data within the list by the size (if it is a value type), sorting alphabetcally (if it is text data) or even create a pivot table report.
