Select a Category

How to reduce wireless router interference

Background

Almost everyone uses wireless routers now. The wireless router interference can be heavy if you live in an apartment with neighbours just a wall from you. Newer routers use channels to set their communication frequencies. Most wireless routers default to channel 6, which makes traffic around channel 6 extremely heavy. It is better to […]

How to reduce data usage by 90% in Netflix?

Background

Some Internet Service Providers (ISP), such as Comcast, put data caps on subscribers’ account. If subscriber uses more data than the cap, ISP charges subscriber more money, which could be expensive. Netflix is one of the heavy users of data. A setting change can reduce Netflix data usage by 90%. If Netflix is viewed […]

How to create subtotal in Excel 2010

Description

Adding subtotal is a useful feature in Excel 2010. It is easy to do as well,

Steps to add subtotal in Excel

Raw data should have some common relationship, such as date and category in sample data below. Sort data on the category for subtotal with Sort command in Data tab Go to data […]