Subscribe to our Email Newsletter

Subscribe to Our Newsletter!
SEP
19

How to Filter Data in Excel 2018

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
  935 Hits
935 Hits
DEC
11

Blogging in 2018 - 2019

Beginning of Blogging 

Blogging certainly isn't what it used to be. When blogging first took off in the late 90's/ early 2000's you were sure to be reading more diary like entries on platforms like Open Diary and Xanga. I'm sure if we took a moment to look through all of those entries there would be good laughs…and maybe some serious cringing. Over time blogging became a generally accepted way to share information, news, and also bits and pieces (or maybe more than that) of your personal life. 

Blogging and your SEO 

In today's world of Internet Marketing everyone wants to do everything possible to be found on the internet. According to Search Engine Journal, SEO jobs have soared in the past year with a 43% increase from 2017. I'm sure you've read or heard somewhere blogs are a sure way to keep your website current and an easy way to get keywords on your site. While there is some truth to that it's good to know the whole story. 

Continue reading
  3796 Hits
3796 Hits
NOV
05

Google Analytics: Is it the Right Choice for You?

Google Analytics is a free tool that shows you how well your website is doing and how many visits you get in a day, but it also does so much more. It can tell you how long a visit lasted as well as how many people have viewed your website. And it's seriously free, but you have the ability to upgrade to a paid plan, Google 360. 


Why do you Need Google Analytics?
When you use Google Analytics you have the ability to use Google's Metrics which shows the following information: Pageviews, Bounce Rate, Users, New Users, Sessions and Unique Pageviews.

Pageviews gives you information regarding which pages web searchers are looking at within a session.
Bounce Rate is critical for finding out how well your online content is doing because it shows how long a visitor stays on the page before leaving.
Users tells you how many unique visitors your site gets in comparison to Sessions, and how many visitors your site had.
New Users is beneficial if you are trying to track visitors who have not previously visited your site or if you are reaching out to, well, new users.
Sessions tells you how long a visitor was viewing your website in a single visit and in how many total visits, and it is the most common metric used.
Unique Pageviews tracks visibility of content per Session and which pages were mainly viewed.

The metrics outlined above are the most common Google Analytics Metrics and will give you the greatest insight as to how your website is doing. If you are an ad-based site, Bounce Rates and Pageviews per Session will be particularly useful for upping ad revenue.


Continue reading
  2529 Hits
2529 Hits
OCT
25

10 Reasons Why You Should Invest in a New Website Design

There is no denying that mobile devices are ubiquitous, and it should come as no surprise that mobile internet browsing has now surpassed that of desktop use. According to Statcounter Website Analytics, as of September 2018, worldwide usage stats are as follows:

  • Mobile- 51.7%
  • Desktop- 44.12%
  • Tablet- 4.18%
Continue reading
  3304 Hits
3304 Hits
OCT
18

The Google Experience

Google, being the enigma that it is, seems to subtly remind us how intertwined it is in our everyday lives. Whether it's by showing you an ad for something that crossed your mind 2 hours ago or giving you a suggested search for something you discussed with your coworker yesterday, Google never fails to impress with its…. observant…. abilities. 

However, when it comes down to it, being in Google's good graces is one of the best things you can do for your business. If you think about it from a consumer standpoint, the first thing you do when you are searching for a service is "Google it". From there you look in the sought-after "box". This lists the service providers closest to you in order from closest to the city center outward. You might glance through the reviews, maybe click the company with the most or highest reviews. Then you work your way down the search results, usually stopping when company websites that haven't been updated since 2010 start popping up (maybe around page 3?). So how do you keep out of the Flash Mob era crowds on the web? 

Continue reading
  2356 Hits
2356 Hits
NOV
19

Sniffing Out the Benefits of Windows 10

Microsoft 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.

  3060 Hits
3060 Hits
SEP
22

Working With Your Web Designer

Have you ever had one of those weeks when there's so much to do that you have cereal for dinner... every night? If you're an entrepreneur, of course you have! And part of the reason for that is because you take pride in your work, have a good work ethic, and want to ensure your customers are happy with the results.

Around our office, we have a lot of late nights. Lucky for me, I never have to resort to cereal for my own dinner, but the take-out food and caffeinated beverages consumed by some people in my office are always an indication that we're on a deadline, or we're trying to re-work a design that someone wants to tweak.

Continue reading
  3231 Hits
3231 Hits
AUG
07

Sit, Stay & Listen Before Buying Your Next Laptop

As someone with hypersensitive hearing, it's easy for me to hear beyond the words of a conversation, which means that if someone is really happy – or really frustrated – I know about it pretty quickly.

Sometimes people sound frustrated when they bring their new laptops or tablets to a meeting, and they've forgotten a cord, can't find a file, or find out their new device isn't compatible with their existing software. Business people like it when their applications work, when they can see the screen, and when they don't have to plug it into the wall to make sure it runs during an entire meeting.

Continue reading
  3774 Hits
3774 Hits
JUL
06

A "Value"-able Lesson

If there's one thing I've learned through my years of being the ears of Technical Resource Solutions, it's that there's cheap and then there's value – and cheap can end up costing more in the long run.

Last month, we talked about resisting the DIY route for your website. This month, we'll talk about the difference between a trained, experienced professional and someone who knows "just enough to be dangerous."

Continue reading
  3282 Hits
3282 Hits
JUN
30

What Does Your Website Say About You?

When someone meets you for the first time, it's likely that they are making a lot of assumptions about you based on your appearance: the clothes you wear, how you style your hair, the car you drive. Whether they choose to do business with you often is based on their first impression, even before you say a word.

Continue reading
  3807 Hits
Tags:
3807 Hits
MAY
29

Treat Yourself To A Professional Website

A lot of people come into our office, and I sit and listen intently at every meeting while they talk about the things they want in a website, and the things they don't; the things they like about other people's websites – and the things they absolutely don't like.

Where I have the advantage, you see, is that dogs have an uncanny sense for people's emotions. If someone feels confident, I can tell. And when they are unsure about something, well, I know that, too. And a lot of people are really unsure about what they want in a website!

Continue reading
  2121 Hits
2121 Hits
OCT
21

Are Your Passwords Secure?

This spring we learned about the Heartbleed bug and that in light of the bug, reminded that we should change our passwords. All of them. Immediately, if not sooner.

Changing a password can be overwhelming because we all want to make sure it is something we can remember. Changing *all* of our passwords is even more daunting.

Continue reading
  2593 Hits
2593 Hits
JUL
02

Split Screen in Excel 2010

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
  8819 Hits
8819 Hits
JUL
02

Freeze Panes in Excel 2010

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
  17647 Hits
17647 Hits

By accepting you will be accessing a service provided by a third-party external to https://www.technicalrs.com/