Category

Tech Tip

Tech Tip

Counting in Excel with COUNTIF

Maybe you have a list in Excel and you want to know the number of times repeating items appear. Say you have a list of contacts with their company names, and you want to know how many times a company appears (which is the number of contacts from that company on your list). There's an Excel formula for that, called COUNTIF! Create a Legend First, you need a list of unique company names only to create a "legend". You can get this by copying the Company column and pasting it into another column. Then select the new column and go…
OXEN Technology
May 29, 2017
Tech Tip

Blue Light Exposure and Windows 10 Creators Update Night Light

Exposure to blue light from digital devices, such as your phone and your computer screen, can have harmful effects. You may want to lower the blue light coming from your computer. The effects of blue light This is not to say that blue light is inherently bad all the time. In fact, you are naturally exposed to blue light by the sun. It helps regulate your circadian rhythm (your natural sleep and wake cycles), boost your alertness, aid with memory and cognition, and elevate your mood. But prolonged chronic exposure to unnatural blue light can have a negative effect. Because…
OXEN Technology
May 15, 2017
Tech Tip

Changing a Word document’s style set

Have you ever wanted to switch the formatting of your Word document? Maybe you have a style set applied but need to switch to your company’s style set to match your branding. This is how you can quickly find the style sets and choose the one you want to use in Word 2016. Click the Design tab on the Ribbon. In the Document Formatting Group, choose a style set by clicking on it.To see all the options, click the More down arrow on the right. Style sets are grouped into 3 categories in this expanded list: This Document (what is…
OXEN Technology
May 1, 2017
Tech Tip

Windows 10 Tip: Customize Your Start Menu

The Windows 10 Start menu has a new look from previous versions. Specifically, it uses tiles when pinning your favorite apps to the Start menu for quick access. Here, we’ll explain how you can customize your Start menu: pinning and removing apps from the Start menu and resizing and rearranging pinned tiles. To access your Start menu, hit the Windows key on your keyboard, or click the Windows icon in the lower left corner of your screen. On the left side of the Start menu, you will see a list of all apps installed on your machine. At the top…
OXEN Technology
April 11, 2017
Tech Tip

Modifying Windows 10 Notifications

In Windows 10, application notifications appear in the Action Center in the bottom right corner of the screen, on the toolbar. Notifications pop up and then minimize to the Action Center. Clicking on the icon on the toolbar brings up the full Action Center panel on the right side of the screen. You may decide that you want to turn off or change Windows 10 notifications from some apps. How do you do this in Windows 10? Here are instructions. Click the Start When the Start menu appears, begin typing "Notifications". The "Best Match" option at the top will say…
OXEN Technology
February 20, 2017
Tech TipWireless

8 Things You Can Do To Make Your Wi-Fi Better

Having difficulty with your Wi-Fi? Maybe your speeds are slow or you’re having trouble with the connection dropping. Here are eight tips for improving your Wi-Fi, to be better, stronger, faster! 1. Put your Wi-Fi router in the best place. Don't put it behind large objects or inside of a cabinet. Don't put them next to brick walls or metal, which can interfere with the signal. Put it out in the open, hopefully with direct line-of-sight to other devices. If your router is right next to a device, consider an Ethernet cable connection. 2. Switch to a stronger signal. If your…
OXEN Technology
February 6, 2017
Tech Tip

Delay sending emails in Outlook with a Rule

Is there a reason you might want to delay sending emails in Outlook? What possible reason could you want to put a 1-2 minute delay on all messages you hit "Send" on? The answer is pretty simple: Adding a Rule in Outlook to delay your sent messages can help you recall them if you suddenly realize you made a mistake. Outlook now has a recall feature, but it works under such a limited set of circumstances that it may only rarely be helpful. A tiny delay may work even better! Here's how to set up a delay Rule in Outlook. Go…
OXEN Technology
January 23, 2017
Tech Tip

How to take a screenshot on iPhones and Android Phones

“Just take a screenshot and send it to me,” someone asks you. Maybe you know how to do this on your computer, but without a dedicated "print screen" button on a phone, it's not as intuitive on your mobile device. How do you do this? Don’t worry – it’s easy! If you have an iPhone, do the following: Press and hold the Sleep/Wake button (you can find this on the top or side of your phone). At the same time, press and release the Home button. Find your screenshot in the Photos app > Albums > Camera Roll. If you have…
OXEN Technology
November 21, 2016
Tech Tip

Exporting and importing Favorites in Internet Explorer

If you’ve switched computers, or are going to uninstall and reinstall Internet Explorer, you may be asking… how do I move my Favorites? In Internet Explorer, bookmarks are called Favorites. And yes, you can move them! To transfer your Favorites to another installation of Internet Explorer, you export a file of your favorites. Then you import it into the new installation. Here’s how! Exporting Favorites Open up Internet Explorer with your Favorites. Click on the Star icon in the upper right corner. Click the down arrow next to Add to Favorites. Select Import and Export. An Import/Export Settings window will…
OXEN Technology
October 24, 2016