Organizational Tips How to Easily Paste Data Even When it is the Result of an Excel Formula In several other posts we have discussed complex ways Excel can process data. These can include using formulas, data validation, VLOOKUPs, and much more. However, sometimes you just need the results of those functions without the actual function in the cell. This might be because you are copying the data
Organizational Tips 3 Activities Where You Should Take a Snapshot of a Virtual Server First In a previous post we discussed why businesses need to run on virtual servers. One of the reasons virtual servers are so beneficial is that you can take snapshots of your servers and restore back to them if needed. Snapshots are like a safety net that can be used when
Advanced Topics How to Restore the Ability to Send Email When your SPAM Filter Company Gets Blacklisted Many companies use an external vendor to filter through all incoming and outgoing emails looking for SPAM. There are several companies that provide this service and the purpose is to help prevent SPAM emails from being delivered to users on your network, in addition to preventing SPAM emails from being
Advanced Topics 3 Reasons Why Your Business Needs to be Running on Virtual Servers Servers that run business applications, programs or house business data come in one of two ways: 1. Physical 2. Virtualized In reality, both servers run on physical hardware - otherwise they could not host data and files. However, a virtual server is very different from a simpler physical server. This
Organizational Tips The Best Way to Know What is in an Old Email Without Reopening it There are lots of times when emails come that are received with subject lines that do not really tell you enough to be certain what is in the email. Sometimes this can be because the subject does not really relate to the information in the email, other times the email
Organizational Tips Why Some Small Excel Files Take Far Longer to Open Excel is a very powerful tool with many different types of tasks you can use it to accomplish. For example, you can use Excel to locate and identify data trends, to analyze hundreds of thousands of lines of data and summarize those numbers, to track inventory or spending, to manage
Organizational Tips How to Remove Sound & Modify Video Speeds Using Camtasia Video can be a great way to share information because it allows you to show someone else what you are trying to explain, how to accomplish something specific, how to build something, or just share information in a way where people can see what you are doing. However, editing videos
Advanced Topics How to Create Forms in Excel With Cascading Lists that Control Data Input Excel is a very powerful application, and as such, we have discussed several topics about what it can do including how you can use it to save time, organize data, find patterns, find data outliers, manage data input using predefined lists, chart data over time, and much more. In this
Security Topics Important Service Functionality End Dates for Microsoft Products You Need to Know While hardware typically alerts users of an impending end date by beginning to fail, having slower response times, or crashing altogether, software applications often provide far less noticeable changes. However, software changes can be just as important as hardware changes and being aware of these can have a big impact
General Topics What's Causing Rotating Text to Pop Up in Google Chrome You may have recently been in the Chrome web browser and noticed what seemed to be a random box of text that popped up over the top of the browser. This box is unlike other ads and popups because it has rotating text lines that are often updating like a
Getting Started How to Easily Watch Videos on an iPhone/iPad While Using Other Apps Earlier versions of the iPhone and iPad operating system, iOS, were much less flexible that it is today. Using several different applications at the same time often ended up in the apps stopping or switching between the two was clunky and/or neither app functioning properly. This was especially noticeable
Organizational Tips The Easy Way to Notify Chosen Users When Changes are Made to Files Working cooperatively on files has become more common as there are more applications that can handle this functionality. Most Microsoft Office applications as well as Google apps can handle several users accessing and modifying the same documents or files at the same time. One thing that is less common is
General Topics Why the Audio and Video are out of Sync in Your Video Recordings If you use your laptop or desktop to record videos, regardless of the software you use to create the recording, you may notice that sometimes the audio and video in the recording are not synced up correctly. Typically this presents itself in such a way where items in the video
General Topics 3 Low Tech Ways to Solve Software Fails Technology can be extremely helpful, can save time, make your life easier, and allow you to do things that would be really challenging otherwise. However, there are times when things do not work as expected. Most people have struggled to get two devices to communicate via Bluetooth or wondered why
Security Topics The One Thing Most People Don't Know About Keychain - Apple's Password Service If you have ever used an iPhone you know there are lots of places that passwords can be stored. For example, for email accounts, apps, wireless networks, and more. This is most noticeable when you switch to a new phone, especially if you do not restore an encrypted backup onto
General Topics Technology Fails: A Week of Issues Including OneDrive, Barracuda, and Others The last week+ has been quite bumpy technology-wise. There have been several outages, issues with applications, downed sites, and more. This post discusses some of the recent applications affected so you know the issue is not you, your login credentials, etc. Technology Fails: A Week of Issues Including OneDrive, Barracuda,
General Topics How to Recover the Missing Menu and Controls in Windows Explorer Recently some Windows users have had issues with the windows explorer application. When this issue happens, all of the controls in the windows explorer window are missing - not just greyed out, but completely missing. This means it can be impossible to go to the previous window, minimize or expand
General Topics How to Ditch Physical Phones and Use Your Computer to Take Calls Desk phones can be a critical component of your daily work day. The ability to easily forward calls to another extension, put a call on hold, or add another person into the call all with the touch of a button can be very efficient. Now, with a greater number of
Organizational Tips The One Fix You Should Try Before Reinstalling Failing Office Applications There are a myriad of issues you can run into when using office applications. Some of these are common, while others are less common, but there are standard solutions that often apply to both types of issues. Sometimes a fix is temporary, and the issue persists. Other times the issue
General Topics 5 Common Symptoms that a Computer Monitor is Failing Desktop computer and laptop monitors have various specifications that are unique to their manufacturer and model. These can include the screen resolution, screen size, frame width, stand ability to swivel and telescope, and more. However, there are several signs consistent upon all monitors that let you know a monitor is
General Topics Why You Don't See All Monitors When Using Remote Desktop Remote desktop is a built-in Windows application that allows you to connect to a computer in another location when properly setup and with the correct credentials. Using remote desktop lets you connect to another computer, access the data stored there, and possibly more importantly, use any applications on that device.
Organizational Tips 3 Important Steps to Take Before Laying off Employees In light of all of recent news about employee cutbacks, it is important to keep in mind what steps a business should take before letting employees go. Additionally, if you are an employee these are things you should expect, and can rest assured these steps are not personal. The items
Organizational Tips How to Save Time by Creating a Poll in Microsoft Teams Gathering input from multiple people can be tedious and overwhelming. From contacting people directly, to sending emails, to gathering information and synthesizing it, and even having people's schedules change because you have taken too long. Getting feedback from or scheduling something for multiple people can feel daunting. Luckily,
General Topics How to Recover File Changes Even When Office Doesn't Prompt with Autosave As you make changes to local documents using Microsoft Office applications, it is important to save often. Saving a document is as simple as pressing the control + s key in the active window. Most people are less likely to save a document when they are really focused, and therefore making
Security Topics New Security Threat: 3CX Phone App for Desktop Computers Unfortunately, as we often state in security posts, new threats are always being released and this week was no exception. Another important security vulnerability has been identified and it could pose a serious risk to businesses and their employees. This week's threat comes in the form of a