In Excel, SUM() function is being used to sum a range of row data. However, it’s not able to sum filtered rows. But no worry, excel provide another function to solve this problem. You may try to use subtotal() to sum up all the filtered rows.
Continue reading Excel: How to sum filtered only rows? »
After using Windows 8.1 for some time, i notice my Win 8.1 machine having slow performance and my hard disk seems very busy. When i check with my Task Manager, it show Disk usage 99% and 100%. At that time, I only have one notepad program running and nothing else, just wonder why my disk is so busy. After few days of testing, i finally find out the problem. Actually Win 8.1 come with a superfetch service that help to anticipate and prefetch the next item / program that you going to launch to memory, so that your machine will gain performance improvement. But i didnt see any improvement at this point, so i decided to disable these service.
Continue reading Win 8.1: Disk usage 100% in task manager »
I’m sure you will notice there is a missing “Libraries” folder from the Window explorer sidebar if you just upgrade to Windows 8.1. Libraries folder are first introduced in Window 7 and if you are used to the Libraries folder, you can also enable this folder in your Window 8.1 sidebar too.
Continue reading Win 8.1: How to enable Libraries in sidebar »
