Data Backup Verification Audit
You’ve likely heard more than enough times that you need to backup your data. This is what every software vendor and IT partner will preach to you from day one. They’re right, of course, but there could still be potential problems. How do you really know that you have backups? You may have a backup […]
How Windows 10 Protects You From Ransomware
Microsoft is making improvements slowly but surely to help protect you from ransomware. In the second major update released for Windows 10, Microsoft has started plugging a lot of holes that leave you vulnerable to an attack. Microsoft claimed that no Windows 10 users were affected by the recent WannaCry strain of ransomware and remarked further that […]
Microsoft Excel 2016 Date and Time EDATE functions
In our last video, we showed how Microsoft Excel 2016 uses date and time functions. Now that you know the logic Microsoft uses to work with dates and times, you can use a variety of formulas to help make your job easier. In this video, we will focus on a few more useful formulas that […]
Use Date and Time Functions in Microsoft Excel 2016
In today’s video, we are going to show you how to work with dates and times in Microsoft Excel 2016. First, we will show you the logic that Excel uses to calculate dates, and then we will show you how you can work with this logic. It is useful to understand that Excel sees dates […]
PCI Compliance Audits
Have you ever been audited for PCI compliance? If not, it is most likely that at some point you will be. In order to maintain the ability to process payments electronically, this will be a fact of life. The more transactions you process in a year, the more often you will be getting a visit […]
How to use Relative and Absolute Cell References in Microsoft Excel 2016
When working with a Microsoft Excel 2016 data table you may find that it is useful to define a constant outside of the data table rather than repeating it in every cell. Suppose you are trying to apply three different tax rates to a data table and you need to be able to adjust those […]
Microsoft Excel 2016 Training “IF” Formula with “NOT” and “OR” Operators
In the last two Microsoft Excel training videos, we focused on using the “IF” formula, its Boolean operators and how to nest an IF statement inside of another IF statement. Today we will finalize our training on Excel IF formulas by reviewing how to use “NOT” and “OR” operators. The NOT and OR operators are […]
How to prepare for ransomware
Lately, there has been a lot of talk about ransomware: a type of computer virus that encrypts your files and holds them for ransom. Worse yet, there is no guarantee that your data will be released if you pay the ransom fee. In light of the most recent ransomware attack called “WannaCry” that infected a substantial number of […]
Set up and switch between user accounts in Windows 10
If you have more than one user account on your computer you will soon realize the frustration of trying to log into your account only to find that your password doesn’t work. Usually, this is caused by the user unknowingly trying to log into the wrong account. This is a simple but common mistake that […]
Protect Your Company From “Arrive By Date” Fines
Have you ever had to face a fine for late delivery of products or services to major retailers? Recently we had the opportunity to work with a new client that had this unique issue. Due to network downtime, the company wasn’t able to make shipments on time. As a supplier of textile products to a major […]
