Posts under Microsoft

Win 8: How to add folder shortcut at Favorite in Window File Explorer

advertisement

windows 8.1, window 8.1, win 8.1By default Win 8 come with few favorites links in the Window File Explorer but i don’t use most of them. And i prefer to create my own favorite links so i can access all my working files and folder faster and easier. If you have friends or family members that is not so IT savvy, this favorites links is very useful for them.

To add folder shortcut under Favourite Links in Window File Explorer in Win 8, follow the steps below:-

Continue reading Win 8: How to add folder shortcut at Favorite in Window File Explorer »

Excel: How to sum filtered only rows?

advertisement

ms excelIn 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.

To sum filtered only rows in Excel, use the functions below:-

Continue reading Excel: How to sum filtered only rows? »

Win 8.1: Disk usage 100% in task manager

advertisement

windows 8.1, window 8.1, win 8.1 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.

win81-disk-usage-100

To solve the disk usage 100% in Win 8.1, follow the steps below:-

Continue reading Win 8.1: Disk usage 100% in task manager »