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
Organizational Tips 5 Easy Steps for Moving your Data to a New Computer The process of moving to a new computer often discourages people from replacing a device that is not as efficient as it could be. Older devices are often slower for many reasons, meaning users waste time waiting on requests. Devices naturally get slower over time due to the number of
General Topics 3 Things that May be Causing Your Monitor Issues Monitor issues can be really frustrating, especially since the symptoms you experience can vary greatly. For example, you might have a monitor whose picture glitches, one whose content is not crisp, one with automatic resizing issues, or something else altogether. If you are experiencing monitor issues, replacement should be the
General Topics How to Format Emails in Outlook When the Options are Greyed Out When writing emails there are lots of reasons why you might want to underline, bold, italicize, create lists, or any of a variety of other modifications available. These formatting tools allow you to accentuate certain text and can be extremely helpful when making specific points or trying to get follow
General Topics How to Modify the Windows 11 Taskbar Defaults If the device you use has the minimum specifications required by Windows 11, you may have already been updated whether you initiated the update or not. The update to Windows 11 is optional, but was installed automatically for some users if they did not specifically ignore the update in the
General Topics Why a Device Prints on Both Sides Even When Duplex Printing is Disabled There are several ways to set printing preferences and defaults and these settings are unique to each printer installed on a device. Modifying preferences for a printer from the Control Panel, or via the Settings app, creates default settings for that printer. In contrast, modifying a printer setting when printing
General Topics How to Force All Calls on an iPhone to Use the Entire Screen New updates and features are consistently being rolled out for smart phones, computers, tablets and other devices that run off of software. Unfortunately, outside of security updates, no matter what changes occur in the software, not everyone is going to enjoy those changes. This is partially because once we know
General Topics How to Use Nested IF Statements in Excel to Automate Calculations Microsoft Excel is a spreadsheet application that is capable of doing so many different types of things to values and data. Even if you use Excel frequently, there are still probably hundreds of things you have yet to learn how to do. This often happens with software as we learn
General Topics Security Round Up: Google Doc and WordPress Vulnerabilities Plus Malicious USB Drives Several new security vulnerabilities and threats have been exposed over the last few weeks. It is impossible to cover all of the threats, and many affect only a very small portion of the population. Here we cover more commonly used software and applications that are likely to affect greater numbers
General Topics How to Fix Windows Printers that Recently Stopped Working/Printing Color Over the last few months several updates, as well as a feature update, have rolled out to most Windows devices. Additionally, the introduction of Windows 11, which downloads and installs for free if you are running Windows 10, was released. Unfortunately, many users are experiencing printing issues on their devices
General Topics The Safest Way to Move Folders Between SharePoint Sites SharePoint is a Microsoft application that integrates with Microsoft Office. It is the backend storage system that manages files users access via OneDrive. OneDrive can be set up as a personal or business account. When used by a business, the application allows users to access, store, and share files with
Organizational Tips How to Organize More than One Email Account in Outlook Outlook is an email application that can be used to consolidate multiple email accounts in a single program. This makes it an extremely helpful tool for anyone trying to manage multiple email accounts whether they are for work, personal, or a combination of both. However, each additional account added falls
General Topics Why Your Windows Device Isn't Shutting Down Even When You Choose Shut Down The best way to configure the power settings on any Windows device is directly related to how the user uses it. There is no universal way that will work for all users because everyone uses their devices differently. Some people are on their machines every day, others once every few
Security Topics 3 Security Updates: Exposed User Records, Ransomware and Video Links Spreading Malware Several new security threats have recently been exposed, many of which more directly affect the business word. However, the more aware you are of what is going on, the more likely you are to protect your data security. Also, individuals are also often targets so understanding how current threats work
General Topics The Easiest Way to Simplify a Complex Spreadsheet with Functions Spreadsheets are a fantastic way to track all kinds of information. If there is something you want to track, there is often a great way to accomplish this by organizing the data in a spreadsheet. Unfortunately, because there are so many things a spreadsheet application can do, what began as
Organizational Tips How to Remove Already Deleted Printers that Still Show up in Programs It is truly challenging to have only those printers that are necessary installed on a computer or laptop. This is partly because the longer you have had the device, the higher the likelihood printers have come and gone, many of which you no longer use. Keeping printers well managed is
Security Topics How to Identify Text Messages that are Really SPAM Everyone who has a cell phone has likely been the recipient of SPAM text messages which have recently become more common. These messages are being added to the already sometimes overwhelming number of SPAM emails and calls people deal with on a daily basis. Like SPAM calls and emails, there
Organizational Tips 7 Lesser Known Keyboard Shortcuts for Common Programs you Should be Using There are dozens of keyboard shortcuts people use every day, typically without even thinking about it. Many are well known, like control + C for copy and control + P to print, while there are likely dozens of other keyboard shortcuts you use and even more you have heard about but forgotten.
