Organizational Tips Using Conditional Formatting to Identify Date-Based Patterns in Excel There are lots of ways to use Excel to track data patterns. Using conditional formatting is a way to automate pattern identification and can be especially helpful when working with larger sets of data. In our previous post on conditional formatting [https://eyonic.com/1/?QC], we discussed items like
General Topics The Difference Between Wireless and Bluetooth and When to Use Each Wireless, WiFi, and Bluetooth are all common terms people use, but they do not always understand the nuances between what they do and how they work. Wireless and WiFi are used synonymously and are the same thing: WiFi is short for wireless fidelity, which is often shortened to wireless, both
General Topics Why All your Desktop Icons Suddenly Disappeared on Windows 11 Devices If the device you are using is running Windows 11, you may have recently run into an odd issue where all of your desktop icons were suddenly missing. Many users experienced this after an update to Windows was automatically installed. Unexpectedly losing all of the icons on your desktop can
Security Topics Security Updates: Infected Android Apps, Twitter Vulnerabilities and GPS Trackers Each week there are more data vulnerabilities and attacks released into the wild, exposed by cybersecurity analysts and patched by app developers. The last few weeks have been no exception to this unfortunate reality. This post discusses several recent threats including infected Android apps removed from the Google Play store,
General Topics What you Need to Know About the Change in Plain-Old-Telephone-Service (POTS) You may never have heard of plain-old-telephone-service, or POTS, but you have most likely used the technology it provides. POTS lines are the phone lines that supported the telephone infrastructure for decades. POTS lines are analog lines made up of copper. These were the original lines installed in people'
Organizational Tips How to Separate Items in One Column into Multiple Columns One of the biggest challenges of collecting and organizing data starts before you even have any data. This of course is deciding how to best organize the information you plan to track. Excel is a powerful spreadsheet tool that tracks all kinds of data. The reason Excel is so incredibly
Organizational Tips How to Share your Google and Microsoft Calendars Often times it is more efficient to share a calendar with coworkers, friends or family, instead of going back and forth hoping to find a common time to schedule an event. This is especially true when several people are involved which requires a decent amount of coordinating. Luckily, many calendars
Organizational Tips What You Need to Know to Choose the Best Computer for You Shopping for a new computer, whether it is a laptop or traditional desktop, can be overwhelming. Is the one on special really a good deal? What's the difference between it and a more expensive model? Is the extra cost worth it? These are some of the most common
Organizational Tips How to Remove Images from Emails You Want to Print While many people and businesses have done their best to go paperless, and save documentation digitally rather than printing them on paper, there are times when this is not possible. Email also falls in this category as often times information in an email is the backup to why a certain
Security Topics Security Updates: A Microsoft Office 365 Flaw and the End of Internet Explorer Updates to software applications are continually being released by their publishers. Sometimes updates are released to address security issues, sometimes they introduce new features, while other times they retire features. Regardless of the reason for these changes, users can only avoid updates for so long. Eventually you will want to
Organizational Tips Save Time by Automating Tasks Using Shortcuts on an iPhone Saving time by being more efficient can be a challenge. When it comes to technology, there are some common ways to be more efficient. This includes knowing multiple ways to accomplish the same thing, which helps when you get stuck or something is not working right. Another thing that helps
Advanced Topics Why All Your Emails Sent to Google Accounts are Suddenly Being Rejected If you send emails to Gmail accounts using any account other than another Gmail account, you may have recently experienced an issue where your emails were not being received. This problem has been happening to people sending from many different domains, but the issue has nothing to do with the
Organizational Tips 5 Lesser-Known Features that Make Excel Easier to Use Excel is a powerful spreadsheet program that can help track, find trends, make calculations, and process entered data hundreds of different ways. Once you know how to use Excel and become more familiar with it, you will find more and more reasons for using it. Beyond the tools you regularly
Organizational Tips Why Default Programs Associated with Files on Windows Suddenly Changed Every file on a Windows device has a default program associated with opening that file extension type. Some files can only be opened by one specific application, while others can often be opened by several apps. For example, a .pdf file can be opened in Adobe, or in one of
Security Topics Security Round Up: 21M Records Exposed, a SonicWall Vulnerability & Windows Malware As with every month, there have been several new threats to our data and privacy. Most recently, there was a data dump that included personal information on 21 million people, a vulnerability in some SonicWall firewalls, and malware directed at Windows systems. This post discusses what happened, what you need
Security Topics How to Manage Permissions on Shared OneDrive Folders OneDrive is a file syncing tool used to store files in the cloud or as a hybrid of in the cloud and locally. The OneDrive app is included with most Microsoft Office subscriptions, both O365 and Microsoft 365, and includes 1TB of storage. OneDrive shows up as a folder in
Organizational Tips 2 Ways to Share Files Created in Google Apps Google apps are an affordable suite of apps utilized by many because they are cloud-based, reasonably priced and do not require a local download. One of the most beneficial uses of Google apps is the ability for multiple users to make changes to the same files in real time. Some
Organizational Tips How to Control Data Entered into Cells using Drop-Down Lists in Excel Excel spreadsheets can be a great way to collect information. However, how valuable that data is depends greatly upon the conformity of the data inputted. One way to keep the data uniform is to control the data that is entered by inserting drop-down lists with preset selections that users can
Organizational Tips The Best Way to Link to Different Sections in a Word Document When using Word to create a document that is long, has steps, or covers many areas of content, it is a good idea to create titles or headings that can be linked to sections in the document. The benefit of using links is it allows users to jump right to
Security Topics Security Round Up: Fake Antivirus in Google Play Store and T-Mobile Data Buyback Like most weeks, there have been new security breaches and other issues affecting both businesses and individuals. Two that affect the greatest number of users include a fake anti-virus app in the Google Play Store and T-Mobile trying to buy back their customer data that had previously been breached. This
Security Topics The Most Secure of 3 Forms of Two/Multi-Factor Authentication (MFA) Multi-factor, or two-factor, authentication is a security feature that helps protect users' accounts by requiring extra input when a user attempts to log into one of their accounts. Multi-factor authentication (MFA) is allowed by the provider of the account, and there are different forms of MFA. Multi-factor authentication occurs
Advanced Topics Why you Can't Save an Access Database After Updating a Field Last week we discussed how to modify the length of a field in an Access database [https://eyonic.com/1/?RK]. This process includes documenting the linked relationships, breaking the existing relationships where the field being changed exists, updating the fields in all tables where it exists and saving all
Advanced Topics How to Manage Field Lengths in an Access Database Access is a Microsoft database application used to track larger groups of data that would be challenging to track in a spreadsheet. The benefit of using Access, and any database application, is that they allow you to create a number of tables, each collecting unique data, that tie together to
General Topics How to Include and Exclude Filtered Data in Excel Functions Using Excel can help you group large amounts of data in nearly any way you want to see the data. This helps find trends and patterns that can help build your business, reduce loss, track sales or inventory, and much more. A helpful time-saving feature is the ability to filter
Security Topics Security Round Up: A Windows Data Wiping Bug and Recent Malware Attacks As there always are, new security breaches and updates have been in recent news. While it would be nearly impossible to cover everything, we specifically pick those stories that we think affect the most individuals. As such, this post discusses an important Windows data wiping bug as well as the
