Subscribe to our Blog

IT Services Blog

Blog posts from Technical Resource Solutions
MAY
25

How to Sort Cells by Color in Excel in 2021

Tutorial Valid for Excel 2010, 2013, 2016, and 2019 

*This blog was originally created in 2019, but has been updated with a tutorial videos seen throughout the article. 

Excel is an "excel"-lent way to organize large amounts of information. However, as the spreadsheet grows, so does your stress when it comes to locating and organizing the information. Many people like to color-code their spreadsheets, but this can still become a jumbled mess – unless you know how to sort your data by color – let's check out how to take your spreadsheets from confusing to well-organized! 

Continue reading
  192 Hits
192 Hits
MAY
20

Split Screen in Excel in 2021

Tutorial Valid for Excel 2010, 2013, 2016, and 2019

*This blog was originally created in 2012, but has been updated with a tutorial video seen at the bottom of the article. 

When dealing with large amounts of data in an Excel worksheet, you often need to use the Split Screen item on the ribbon or menu. This option divides your screen into 4 sections and allows you to scroll through these sections while keeping other sections of your worksheet visible.

Continue reading
  7765 Hits
7765 Hits
MAY
11

Freeze Panes in Excel in 2021

Tutorial Valid for Excel 2010, 2013, 2016, and 2019

*This blog was originally created in 2012, but has been updated with a tutorial videos seen throughout the article. 

When dealing with large amounts of data in an Excel workbook, you often need to use the Freeze Panes item on the ribbon. This option allows you to keep a certain area visible as you scroll to other parts of your worksheet. You can freeze rows, columns or both rows and columns. Be sure to click on each video to view the tutorial!

Continue reading
  16033 Hits
16033 Hits
MAY
04

How to Filter Data in 2021

 Tutorial Valid for Excel 2010, 2013, 2016, and 2019

*This blog was originally created in 2019, but has been updated with a tutorial videos seen throughout the article.

Sometimes when you're working on a project on an Excel spreadsheet, you don't need to see all of the information. It often can be more helpful to only show a certain category of data. For example, if a corporation had a massive list of every order they have in the system, they may only need to see the pending ones - which is when it might be helpful to filter data.

Well luckily, Excel can help you temporarily hide all of the information you don't need – see below for instructions on how to filter the plethora of data on your spreadsheet. 

Continue reading
  229 Hits
229 Hits
APR
30

Quick Tips for Using Our Ticketing System

At Technical Resource Solutions, it's our goal to provide quality, timely service to our clients. To do that, we utilize a ticketing system that allows our whole team to see all of the tickets created for a company, who is addressing the issue, the progress that has been made, and so much more. Whether you're a new client or just wanting to brush up on how the system works, we have compiled the basics of our ticketing system to assist you. 

Continue reading
  375 Hits
375 Hits
APR
15

The Danger of a Free Business Email

Whether in a personal or professional setting, you have probably had first-hand experience with the consequences of sacrificing quality for a lower price. Though some businesses opt for consumer-grade emails to save money, this is a mistake that could compromise business, employee, and client security in more ways than one. What is a consumer-grade email exactly? If your email looks like This email address is being protected from spambots. You need JavaScript enabled to view it. instead of This email address is being protected from spambots. You need JavaScript enabled to view it., you're probably utilizing a consumer-grade email account. Though it may be free, it doesn't come without cost. 

Continue reading
  303 Hits
303 Hits
FEB
23

How Managed IT Services Can Benefit You

What if you could have all of the benefits of an in-house technology specialist without having to pay for all that comes with onboarding a new employee? As with any business decision, many things such as efficacy, efficiency, and cost come into play. When choosing between ad hoc (paired with monitoring) and managed IT services, it's important to take into consideration the level of demand your company has for technology, how many employees you have, and how often you expect to need assistance. Below, we will break down the difference between the two services to help you better decide which one is for you. 

Continue reading
  500 Hits
500 Hits
JAN
28

Will Data Destruction Be Your Downfall?

No matter the industry or location, the vast majority of businesses rely heavily on computers for day-to-day tasks. With almost all operations requiring technology, many companies have a plethora of employee and customer data stored on their hard drives. What happens when it's time to replace that equipment? The data doesn't all just magically disappear – even if you think you've deleted everything. If you don't take the necessary precautions, you may just find yourself in a legally compromising situation, and that's the last thing you want to happen. If you're still on the fence about the importance of data destruction and security, check out why you want to ensure all information is destroyed. 

Continue reading
  403 Hits
403 Hits
DEC
17

Building Your Own PC: Computer Parts Lists

The holidays are full of joy…but panic tends to seep in as you realize time is running out to find the perfect Christmas present for the ones you love most. It's a lot of pressure, but if you know someone that can't get enough of technology and has a knack for putting things together…we have a gift that will keep on giving. Purchase all of the parts needed to build a computer and give it to a loved one so they can build it themselves. If you're not a techy person, this might not sound so appealing, but to someone that enjoys the ins and outs of technology, it would be a dream come true! Keep in mind – it comes with a hefty price tag. Stick around for price points and what parts you'll need to make this dream become a reality. 

Continue reading
  1339 Hits
1339 Hits
OCT
21

2020 Technology Gift Guide

Believe it or not, Christmas is right around the corner and you'll want to jump on the Christmas shopping early this year. While many families have the long-standing tradition of going Black Friday shopping the day after Thanksgiving, many stores are shutting their doors on Thanksgiving and promoting sales for months instead of for 24 hours. Though it's all in efforts to keep people safe, this could potentially change the way we shop for Christmas gifts moving forward. According to Clark Howard, we're more likely to see sales in October and November, with a drastic increase in prices after December 11th. To help you get your shopping done early, we decided to release our 2020 Technology Gift Guide early this year. Check out these gifts selected by the whole Technical Resource Solutions team! 

Continue reading
  922 Hits
922 Hits
OCT
14

Space Heaters and Power Strips: A Dangerous Combination

Cold weather generally prompts people to break out the space heater at home or in the office for added warmth and comfort. This is a great idea because it can help to save money on heating bills when you only need extra heat in one area of the room. However, the last thing anyone needs is a fire erupting, especially during the holiday season.

According to the National Fire Protection Association, space heaters accounted for 43 percent of U.S. home heating fires and 85 percent of home heating deaths between 2011 and 2015. It is crucial to follow safety guidelines and take precautions to minimize the risk of space heaters causing damage to your home or an office.


Continue reading
  3924 Hits
3924 Hits
AUG
10

When to Use a Server Instead of a Desktop

When making judgment calls for your business, it's sometimes hard to know when the cheaper option is a viable one, and when you truly will get what you pay for. If you search on Google®, you may find articles that support the use of desktops as servers. The phrase that comes to mind is: "Just because you can doesn't mean you should." We want our customers to be set up for success but using a desktop computer as a server will cause more harm than good and here's why.

Continue reading
  1291 Hits
1291 Hits
APR
08

Things You Didn’t Know You Needed Until You Worked from Home…

In what seems to have been the blink of an eye, COVID-19 changed the way we live, interact, shop, eat, and especially how we work. It's been a time of tribulation, but also a time of triumph as people across the world are doing things they didn't even know they could do with technology. While providing business IT services to our surrounding community, we have had an influx of questions come in about what needs to be done to make working remotely a smooth transition. While it may not be seamless (as seems to be true with most any dramatic change in life), we have worked tirelessly to provide options and get people connected in a way that allows them to continue to engage and serve customers.

Continue reading
  2285 Hits
2285 Hits
JAN
12

Q&A: How to Clean Your Computer

Many of us use digital devices every day. As we complete work tasks, create new documents, download apps and pictures, and multi-task our way through never-ending to-do lists, we also make digital waste along the way. Unlike an overflowing laundry basket, leaves in the yard, or dishes in the sink, digital waste can hide. Chances are your computer needs to be cleaned up, but many users don't know where to start.

To get ourselves jumpstarted, we interviewed our very own Chief Technology Officer and Co-founder, Scott Lavelle, about his recommendations for cleaning our computers. Join us as we sort through files, review old apps, and break out the compressed air.

Continue reading
  1680 Hits
1680 Hits
NOV
29

2019 Technology Gift Guide

Shopping season is officially here! Our team got together and recommended some gifts for that friend or family member that's always looking for new technology. Be prepared for Black Friday, Small Business Saturday, Cyber Monday, and Giving Tuesday this year and be on the lookout for these awesome items for your loved ones.. or maybe even for yourself! On your mark, get set, shop!

Continue reading
  1794 Hits
1794 Hits
NOV
25

Sunset of Windows 7 Coming January 2020

Change can be hard, especially when it comes to technology. But in the words of Gail Sheehy, "If you aren't changing, you aren't growing." This holds true as technology shifts and evolves – and the latest shift will be from Windows 7 to Windows 10.

While Windows 7 has been great, all things must come to end, and the sunset of Windows 7 comes in January 2020. So, what does this mean for you? It means that it's time for you to make the big change. Trust us, it will be worth it.

Continue reading
  2217 Hits
2217 Hits
OCT
10

Dig to the Truth about Phishing

My humans bring me to work with them every day; they wouldn't have it any other way. Unlike my humans, I can sit in on meetings, listen to ideas and think about solutions to problems and then I can go take a nap: they can't. Life is good that way. But you know when life isn't good? When a customer comes in angry because they got scammed and wakes me up from my nap - it really raises the fur on the back of my neck. 

You see, I know the various methods hackers use when they are on a phishing expedition and my human's customers need to be watchdogs about it. I'll let you in on a little secret I have learned in this business: if it looks suspicious—it most likely is, but sometimes it can look 100 percent legitimate. 

You may receive a message from what looks like your:
  • Bank
  • Credit card company
  • Google
  • Microsoft Office 
  •  Web design company
  • IT company
  • PayPal
Continue reading
  1596 Hits
1596 Hits
DEC
06

Why Managed Information Technology Services are Best for Your Company

Hiring a sole external or in-house IT person or trying to manage the services on your own as the owner or manager of a business might seem like a good idea until you come across an issue that you can't fix; this happens often for many reasons.

Designated individual IT consultants or employees get sick or need to take extended leave, they go on vacation, take holidays and some just move on, leaving you vulnerable to any number of problems that might occur. Things are great when they are running smoothly, but when they aren't this can bring a screeching halt to production in the workplace. 

Synergy: "The interaction or cooperation of two or more organizations, substances, or other agents to produce a combined effect greater than the sum of their separate effects."

Continue reading
  2473 Hits
2473 Hits
OCT
04

Why You Need a Strong IT Infrastructure and Cyber Liability Insurance

Whether you are a new business or an existing business, having your IT infrastructure set up by a professional full-service business technology company like Technical Resource Solutions in Woodstock, Georgia is critical in today's world. This coupled with cyber liability insurance will safeguard your company from data breach, ransomware attack or a complete outage of internet infrastructure. Your entire company is at risk if you don't have the proper infrastructure and cyber insurance protection in place to safeguard your data against cyber attacks. 

Continue reading
  2086 Hits
2086 Hits
NOV
19

Sniffing Out the Benefits of Windows 10

560461691508eMicrosoft tried to do too many things, too soon with Windows 8. Its desktop "tiles" resembled those used on a tablet or phone, but they confused people. Tablets were trendy, but crossovers were like genetically modified cats (the horror!); nobody knew quite what to do with them.

After being swatted on the nose often enough over Windows 8, Microsoft introduced Windows 10 this year. It's the first true hybrid version of an operating system that shares the best features of a computer, a tablet, a smart phone, and an XBox One. Think of it as the Labradoodle of the tech world: loyal, friendly, easy to bond with, but without the endless shedding and whatever it is that makes people sneeze.

  2593 Hits
2593 Hits
Want more information?
Great! We're here to help.
Let's discuss a technology strategy
that works for your business.
Slider