TechBytes

When considering the employee and employer benefits of working remotely, businesses are wise to change. The alternative could make your outfit less competitive.  

If you would like to gain a little perspective on how radically our culture has changed, try this exercise. Pick up a pencil and a piece of paper and write out a half-days’ worth of emails rather than send them electronically. You will probably discover the first one looks more like scribble than cursive writing. And, your productivity will completely tank.

At first blush, the exercise demonstrates our reliance on electronic devices and real-time communication. But on another level, it shows that thought leaders are wise to embrace technological advancements as they emerge. Remote workforces rank among the more innovative trends of the business landscape today.

“To remain competitive in today’s work-from-anywhere environment, companies will need to invest in responsive technology infrastructure and enhanced virtual collaboration tools, as well as training and tailored performance management and incentive strategies for remote workers,” director of HR at the Gartner research group Emily Rose McRae reportedly said.

This shift away from in-house staff to people working from home or on the road once earned mixed reactions from industry leaders. But the COVID-19 pandemic has prompted businesses across the globe to find a way to have valued employees work from home until health crisis passes. Employers and employees alike are discovering this advancement tend to be mutually beneficial when utilizing platforms such as Microsoft Teams.

Mutual Benefits of Remote Workforces

The health crisis has motivated businesses to shift to Cloud-based systems and Microsoft Teams strategies as a short-term measure. But HR departments may want to take the opportunity to scan the workforce landscape because work-from-home expectations are expected to surge and impact hiring.

“By 2030, the demand for remote work will increase by 30 percent due to Gen Z fully entering the workforce. Gartner’s most recent ReimagineHR Employee Survey found that only 56 percent of managers permit their employees to work remotely. Organizations without a progressive remote-work policy will be at a competitive disadvantage for attracting and retaining talent,” according to Gartner.

That being said, these are the reasons why the global trend to remote productivity is well-received by management and staff.

• Commute & Stress Reduction: No one can dispute the fact that commuting to the office adds unpaid work hours. Sitting in traffic or being packed into commuter rails tends to be an unpleasant way to begin and end each day. Employees and employers share this stressful routine. Remote work platforms such as the Cloud and Microsoft Teams allow all parties to sit down with a morning beverage and log on from anywhere. No hustle, no bustle, no extra hours, and no commuter expenses.
• Talent Without Borders: Before the massive cellphone footprint, people used landlines with rotary dialing, and long-distance was expensive. In those days, it was common to pay a premium just to call someone in the next state over. But just as your cellphone can connect you to people far outside your region without added expense, so can the Cloud. When projects are conducted in Microsoft Teams via a Cloud-based network, your remote talent pool expands exponentially. A skilled person 1,000 miles away can secure a job they are qualified for, and employers gain access to talent otherwise unavailable.
• Reduced Infrastructure: An increasing number of organizations that do not necessarily require a brick-and-mortar footprint. These outfits can eliminate that cost in some cases. Other operations can reduce office space expenditures. With remote workforces, less can be more.
• Live-Work Lifestyles: Millennials and the Gen Z crowd tend to see work and life more closely aligned in their lifestyle than previous generations. The Cloud has been a boon and securing offsite positions allows employees a preferred professional lifestyle. Raising children no longer comes attached to childcare expenses or limited “parent hours” jobs.

Microsoft Teams Supports Remote Workforce Culture

With dispersed workforces increasing, Microsoft Teams ranks among the most business supportive products on the market. It seamlessly works with Cloud-based networks and delivers real-time communication. The platform offers chat, video conferencing, managed channels, shared calendar options, and project space that can provide supervisors with top-tier oversight. In these troubling times, Microsoft Teams use has surged by tens of millions. But industry leaders may also want to consider the long-term benefits of embracing remote workforces into the future.

Improving Data Analysis with the IF Function in Microsoft Excel

Have you ever wondered what the IF Function in Microsoft Excel actually does?  Here we explore a few top tips for making it save you time while evaluating data. 

 

There’s no doubt that Microsoft Excel is a robust program. Companies all over the globe utilize this application to analyze, track, and otherwise organize data in an easy-to-read format. But how much do you know about it and the various features that are available? And are you taking the right steps to ensure you’re looking at your spreadsheets in the most efficient manner possible? Here are a few of our tips and techniques to help you save time and improve your data analysis by using the IF Function in Microsoft Excel.

Tip #1: Understand What the IF Function Actually Does to Help Your Workflow

The first real step in making sure you’re using Microsoft Excel’s IF Function appropriately is to understand what it actually does. The IF Function tests whether a condition is true or false, and then performs an action. These actions can be calculations, data entry, or something closely related. The function is incredibly useful if you have large data sets or need to make significant changes, as it is a great way to save time in your workflow.

Tip #2: Creating the IF Function is Incredibly Easy

Creating the IF Function effectively starts with knowing the three parts: the logical test and then a value if true and a value if false. From there, all you have to do to make it work with your spreadsheet is to choose the data sets that you want to evaluate and determine what you want the true and false results to be. To do this, use the IF Function on the Insert a Function menu. Click okay and enter the conditions as you are prompted to do so on the screen.

Tip #3: Knowing How to Nest Functions

It is possible to use multiple IF Function formulas at the same time. In some cases, you might have multiple different possibilities or different levels of data that you want to compare. That’s when knowing how to nest multiple IF Functions becomes important. Nesting functions adds the ability to build more comparisons within your formulas instead of having to complete them separately.

Tip #4: Adding AND and OR to Your Functions

You can also add AND and OR to your IF Functions to make the results much more specific. While this is technically part of understanding how to nest functions, knowing how to do this is an effective way of utilizing the IF Function in a more efficient manner. An example of this is comparing two columns of data: one showing the amount of sales and one determining if an employee has completed training. By adding AND or OR to your IF Function, you can show a specific result, such as those employees that hit a specific sales goal and finished the training program you provided. As you can see, this can be a really easy way to get the information you need without having to spend a ton of time scouring through your entire spreadsheet.

Tip #5: Using Range Names to Make Data Easier to Sort

Range names are essentially a stored label that allows you to identify a range of one or more cells. They are incredibly useful for navigation, formulas, and even printing off specific parts of your spreadsheets. For use with the IF Function, you can utilize data ranges to save time when you’re working on a specific block of values as it allows you to use that range name instead of specific cell names. Range names can have letters, numbers, or an underscore, but cannot have spaces. And they are not case-sensitive, but title case is recommended for ease of viewing.

Tip #6: Remembering to Use Quotations with Text Strings in Your IF Function

Using the IF Function is an incredibly easy way to add text to a specific cell when certain criteria are present. However, you do need to remember to use quotations around your text strings in your IF Function formula. Failure to do this can really mess up your data set and make the formula not work correctly. Should you have a problem getting the IF Function to work for you, this is one of the first things you need to check.

Tip #7: Changing Text with Conditional Formatting Based on Your Result

Not only can you add text or insert a formula with the IF Function, but you can also change text visually with conditional formatting based on your result. It can be done automatically and setup within Excel under the Home tab. Examples of this option in use include turning a specific number bold and red if it does not meet the criteria of your IF Function, or highlighting it in yellow if it does meet certain requirements.

Conclusion
Microsoft Excel is a great way to analyze and interpret datasets. The IF Function allows you to do this in an easy-to-read and simple manner while saving you tons of time in the long run. These quick tips are a great way to skip complicated formulas and really make your spreadsheets work for you.

Know and Protect Your Network From These Malware Threats

Every day, new malware is discovered that threatens U.S. business and individual security. Continue reading to learn about six of the most recent named and dangerous malware threats.  

Back in 2018, U.S. Cyber Command was restructured to become an officially unified combatant command–meaning that it now acts as its unit organized under its commander who reports directly to the Defense Secretary. This critical change became necessary following an increasing amount of sophisticated cyber attacks. Hackers are constantly evolving, constantly upping the ante, and the U.S. Cyber Command is now one of our frontline defenses against those attacks. One way they have assisted the entire country is by diagnosing and alerting the general public of new malware. This is critical information that every business owner and the tech-savvy individual should keep up-to-date on to protect their assets and data.

Know Digital Threats: 6 Dangerous Malware & How to Stop Them

The Basics of Malware

The word malware is a mash-up of malicious software. It is thereby defined as any software that is malevolently used to steal data, compromise computer functionalities, bypass admin controls, or otherwise cause an issue with another person or organization’s computer. As you might expect, malware is a broad umbrella term that encompasses different types of attacks, such as viruses, adware, and Trojan horses.

The 6 New Dangerous Malware Named by the U.S. Cyber Company

There are always new types of malware being created and deployed by malevolent forces. The six new dangerous types of malware announced by the U.S. Cyber Company are ones discovered to have been used by a government-backed North Korean hacking group. These six types of malware have been unleashed against various U.S. targets, but it is yet unknown the scale of those attacks, or all who were targeted. This is why all businesses and professionals need to keep abreast of the latest digital security news.,

The six new dangerous malware named were as follows:

• Bistromath. This is a variety of trojan horse that features full remote access to allow the hacker to perform file uploads and downloads, system surveys, process and command executions, and, very worryingly, monitor microphones, screens, and clipboards.
• Slickshoes. This is a form of dropper malware that can load information onto a computer but cannot execute.
• Hotcroissant. This is a full-featured becoming implant that, once it finds its way into a host computer network, will perform many of the same functions as the Bistromath.
• Artfulpie. This is another implant malware that will download into a host network and then load its memory to execute dangerous DLL files.
• Buttetline. Another implant, this one utilizes a faux HTTPS scheme that makes it incredibly hard for many malware-detection security systems to detect.
• Crowdedflouder. This type of malware executes via Windows to unpack and enable a remote access trojan within the computer’s memory system.

Essential Tips for Preventing Malware Infection From Impacting You & Your Business

The hackers may be getting more sophisticated every year, but so are the good guys. Your browsers, plugins, applications, and software all have teams of tech gurus working on them to make them safer and more resilient to outside attacks continually. The following is a look at a few tips and ways to leverage those assets and be smart to prevent a malware infection:

• Update all of your browsers, operating system, plugins, applications regularly, and whenever prompted. Ask for a schedule by your tech team if applicable.
• Never click on any email links or download attachments from unknown or untrusted sources. If you manage a business, make this a company-wide policy. Be wary of any phishing emails from firms you might otherwise trust (such as your financial institution). Always use a separate tab to log into such sources.
• Practice creating strong passwords and change them at least once every four months.

Contact Our Team for More Information

Subscribe to our blog to stay up-to-date on the latest tech and digital security news and contact us if you have any questions about staying safe from malware.

Metadata Gives You Control of Disorganized Online Filing Systems

SharePoint gives you a simple solution to keep your online files organized, using metadata to create customized ways to sort and find the information you need.

It’s an all-too-common occurrence. You need to send a business file to a colleague or client. You hesitantly open your file manager window and shudder. Soon, you’re navigating through generations of file folder structures, organizational schemes, and naming conventions that have long been abandoned. An hour later, having spent far too long hunting for the file in question, you find the desired info and can attach it to your email.

Keeping business information organized is not easy. Files, folders, names, and systems come and go, often discarded in a digital graveyard.

Fortunately, there’s a standard Microsoft tool to help you keep information organized.

Can I Use SharePoint to Organize Data?

SharePoint is a popular app included in Office 365 and other enterprise versions of the popular productivity suite. In SharePoint, which is essentially a digital document library, you can file documents, create folders, and share with internal and external teammates. It also can use key organizing features to help reduce the chaos in your filing.

The key is metadata. Nearly every file you use has metadata associated with it. Think about some of the common attributes you know about files — file name, creation date, file size, and file type are just a few.

Whenever you change the name of a file, for example, you change its metadata.

The beauty with SharePoint is that you can easily create new metadata categories and use tools to add details. Once the details are entered, you can search and filter on the new metadata to quickly find what you need.

How Can I Use SharePoint Metadata to Organize Work Files?

Here is a step-by-step guide to using SharePoint metadata for file organization. For the purposes of this example, let’s pretend we’re trying to organize social media messages for a marketing campaign. We are going to launch the campaign on Facebook, Instagram, and Twitter and use video, text, and image files.

Step 1: Find the Files

Start by navigating within SharePoint to the library or document list that contains the files you want to organize. Be sure that you are the site owner to access the tools that allow for customized metadata.

Step 2: Build the Categories

Each new category of metadata will become another column within the document list. Select “Add Column” and give it a name. In our example, our first new column will be “Platform.”

When you create a new column, you can select its type. Among the options are Single line of text, Multiple lines of text, Number, Yes/No, Person, Date, Choice, Hyperlink, and Picture. For our example, we’d probably select Choice and add in the social media platforms.

We can add a second new column for “Media Type” and again choose Choice and enter in Video, Text, and Image as options. If we wanted, we could add a third new column, call it “Completed” and make it a Yes/No type.

Step 3: Apply the Metadata

In our list of social media posts, we can now apply new metadata tags for Platform, Media Type, and Completed. SharePoint has a great feature called Quick Edit that lets you apply metadata to all the documents in a list. You can run through each library option and apply, for example, which items are video entries, which are for Facebook and which are still in progress.

While it can be a bit tedious to go through an existing list of documents, in the long run, the work will pay off handsomely.

Step 4: Filter to Find

The metadata tags allow you to filter on any of the columns (just like a click on the Name column can give you an alphabetized list). Want to see what creatives are ready for each platform? Click on that column heading to see a sortable list. The same goes for looking at posts by type or completion status.

SharePoint is a powerful way to keep your documents organized and searchable in different ways.