Tips and Tricks – Lower Rates, Too Many Rows in Excel

Negotiate to lower your broadband rate.

Call up your service provider about a month before your annual broadband contract is about to expire, and ask for a better rate. Chances are, their rivals are offering you some sweet deals to switch over. As a result, your provider will often lower the rates to keep you as their customer. Even if you are not at renewal time, some providers will cut your rate if you are willing to recommit with them for 1 or 2 years.

Visit AT&T, Verizon, or MegaPath for new rate info.

Too many rows in Excel

To delete duplicate rows in Excel, just do the following: Click anywhere in the data. Select “data,” then “filter,” then “advanced filter.” Check the box marked “unique records only”. Click “OK”. Highlight the thinned down data, then copy and paste it in a new worksheet. You’re done!


About Brent Whitfield

Brent Whitfield is CEO of DCG Technical Solutions, Inc., which provides IT Support in the Los Angeles area since 1993. DCG exists to help our clients choose, implement, and manage IT and cloud solutions that are cost effective and reliable. DCG's pro-active approach to IT is ideally suited for companies who depend on reliable IT infrastructure, but don't want to spend a lot of money to keep it that way. DCG was recognized among the Top 10 Fastest Growing MSPs in North America by MSP Mentor. Brent has been featured in Fast Company, CNBC, Network Computing, Reuters, and Yahoo Business.


Leave a comment!

You must be logged in to post a comment.