Advanced Topics The Easiest Way to Match VLOOKUP Results Back to Your Original Data File VLOOKUP is a function you can use in Microsoft Excel to compare two sets of data. This allows you to locate duplicates and/or unmatched data depending upon what data you have and what you are looking for. One of the nice things about using VLOOKUP is it compares data
Organizational Tips How to Update the Mail App to Look Like it Did Before Apple's iOS 18.3 Update If you have an iPhone that is still receiving Apple's iOS updates, you may or may not love the newest update which made several changes to the interface of the Mail application. These changes include adding categories to your mail that are broken out and can be clicked
Organizational Tips How to Match Data in Large Excel Files Using the VLOOKUP Function There are lots of ways to format data in an Excel spreadsheet. Regardless of how you set up the spreadsheet, matching and locating specific data later is often a necessary tool. Whether you are checking to see if the data was ever entered, verifying the data is correct, or looking
Organizational Tips How to Sync Two Versions of a Document Using a Comparison Application Last week we showed how you can use the WinMerge application to compare two files and locate the differences between them. In that example we compared two Word documents, but we could have just as easily compared two Excel or PowerPoint files. The WinMerge application displays missing, different and shared
Organizational Tips The Easiest Way to Quickly Identify the Differences Between Two Documents There are several ways to track changes made to a document, such as tracking changes or adding comments, however, sometimes a document is changed by someone else or you inherit several versions and change control was not maintained. When this happens, the longer the document, the greater the amount of
Organizational Tips Two Ways to Be More Efficient When Using Excel Data Filtering Using Excel can save a great deal of time if you plan ahead before entering all of your data. Excel can help locate and identify data trends, track sales and inventory, locate issues within your data, drill down into data to find outliers, help graph your data and much more.
Organizational Tips How to Set the Out of Office Message in Outlook with IMAP Mail An out of office (OOO) automatic reply is a great way to let people know you are not going to be available for a period of time. Out of office messages can be used for many purposes, such as letting people know you are on vacation, that your business is
Organizational Tips How to Snapshot Drop-Down Menus Using Delayed Image Capture Taking snapshots inside applications can be really helpful. Unfortunately, there are times when you want to capture a drop-down menu and this can be less intuitive. Luckily, taking drop-down snapshots is easy once you know where this setting is in the built-in application in Windows. How to Snapshot Drop-Down Menus
Organizational Tips 3 Reasons Why Your Business Should Only Use Domain-Based Email A domain is chosen by using the name of your business and adding .com, .org, .us, etc. to the end. For example, our business name is Eyonic Systems and our domain is eyonic.com. There are times when it makes sense to use something clever or shorter because the domain
Organizational Tips How to Submit a Website Sitemap to Google and Bing Search Engines There are two versions of a website sitemap, which is a document that lists all of the pages on your website. Many websites have a webpage you can visit listing the breakdown of every page on their website and showing its relative location. The other type of sitemap is an
Organizational Tips How to Continue Receiving Email Once You Reach Microsoft's Size Limit If you use Microsoft as your email provider, whether you just use a Business Standard plan for email, or a larger plan that has a suite of Microsoft products which include email, you may have run into issues with the size of your mailbox. Microsoft has a hard size limit
Organizational Tips 3 Times When you Should Create an Email Alias Rather than a New Mailbox An email alias is a way to have an email address that is not attached to its own unique mailbox, but instead is a redirect to a different email mailbox. In essence, the alias allows email to be accepted to that email address without it requiring a mailbox since it
Organizational Tips The Best Way to Recycle and Reuse your Replaced Older Computers Replacing computers can happen for many reasons, but most commonly is having a part go bad in such a way that the device is no longer usable and/or replacing the part would cost more than the device is worth. However, the second most common reason we see users replace
Organizational Tips 3 Tech Tips for Working More Efficiently in Web Browsers As more work is done within web browsers, it can be helpful to be aware of things you can do to be more focused and efficient while working. These tips are applicable both for use during work, as well as your personal life, to give you more time doing what
Organizational Tips Why your Router has Two Wireless Frequencies & When to Use Them When the router that manages your internet connection is set up, it often has built in Wi-Fi. It is also possible that you have a secondary wireless access point connected that broadcasts wireless to all of your local devices and connects them together. An example of this would be printing
Organizational Tips How to Organize Photos and Files and Remove Duplicates Wasting Space One of the worst things that can happen to a computer, laptop or server, is to run out of storage space. As a device gets closer to running out of storage space, you can run into all sorts of issues, including having the device operate unpredictably. Moving files off of
Security Topics 3 Things to Ask a Hosting Company Before Moving your Website There Websites are a great way to creatively represent a person, group of people, business or other entity. Websites can be a great way to communicate things about you or your business in a way that would otherwise be challenging. One of the greatest things about websites is that you can
Organizational Tips The Best Way to Edit a PDF Created by Someone Else There are times when you have a pdf document that someone else created and you don't have access to the original document. These pdfs often use fonts you are not familiar with or have installed on your device. Luckily, there is still an easy way to edit these
Organizational Tips How to Set Unique Default From Addresses for Each Email Account in Outlook Many Outlook users have multiple email accounts connected to the application. If you are not sure how to set this up, you can check out this previous post showing how to organize more than one email account in Outlook. For those who are using Outlook for multiple email accounts, beyond
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
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
