508-909-5961 [email protected]

Safeguard your Microsoft 365 data with these tipsBecause Microsoft understands the value of business data and the costs associated with data loss and theft, the technology company offers powerful security tools for Microsoft 365 subscribers. However, for these tools to be truly effective, users must implement the following practices to further protect their data. Take advantage of policy alerts Establish policy notifications […]

The post Safeguard your Microsoft 365 data with these tips appeared first on Complete Technology Resources, Inc..

Safeguard your Microsoft 365 data with these tips

Because Microsoft understands the value of business data and the costs associated with data loss and theft, the technology company offers powerful security tools for Microsoft 365 subscribers. However, for these tools to be truly effective, users must implement the following practices to further protect their data.

Take advantage of policy alerts

Establish policy notifications in Microsoft 365’s Compliance Center to help you meet your company’s data security obligations. With these in place, your employees will receive policy tips about sending confidential information anytime they’re about to send messages to contacts outside of the company network. These preemptive warnings can prevent data leaks and also educate users on safer data sharing practices.

Secure mobile devices

Since employees often use personal smartphones or computers to access their work email, calendar, contacts, and documents — especially if they’re working remotely — securing employee-owned devices should be a critical part of protecting your organization’s data. Installing mobile device management features for Microsoft 365 enables you to manage security policies and access permissions/restrictions, and remotely wipe sensitive data from mobile devices if they’re lost or stolen.

Use multifactor authentication

Relying on a single password to protect your Microsoft 365 accounts could lead to account hijacking, which could put your data at risk of being compromised. Instead, enable multifactor authentication (MFA). MFA requires users to supply additional credentials on top of a password before they can access their accounts. This makes it difficult for hackers to access your accounts since they not only have to guess user passwords, but they also need to provide a second authentication factor like a one-time SMS code or a fingerprint scan.

Apply session timeouts

Many employees usually forget to log out of their Microsoft 365 accounts and keep their computers or mobile devices unlocked. This could give unauthorized users unfettered access to company accounts, allowing them to steal sensitive data. By applying session timeouts to Microsoft 365 accounts, email accounts, and internal networks, users will be automatically logged out after a period of inactivity, preventing hackers from taking over users’ devices and accessing private information.

Avoid public calendar sharing

Microsoft 365’s calendar sharing feature allows employees to share and sync their schedules with their colleagues. However, publicly sharing this information is a bad idea because it helps attackers understand how your company works, determine who’s away, and identify vulnerable users. For instance, if security administrators are publicly listed as “Away on vacation,” an attacker may see this as an opportunity to unleash malware on unattended computers.

Employ role-based access controls

Access management is another Microsoft 365 feature that will limit the flow of sensitive data across your organization. It lets you determine which users have access to specific files in your company. For example, rank-and-file employees won’t be able to read or edit executive-level documents, minimizing the risk of data leaks.

Encrypt emails

Encrypting classified information is your last line of defense against data breaches. If hackers intercept your emails, encryption tools will make files unreadable to unauthorized recipients. This is a must-have for Microsoft 365, where files and emails are shared on a regular basis.

Partner with us to ensure your organization’s Microsoft 365 accounts are always secure and compliant with changing data security requirements. Give us a call today — our team of experts are here to help.

Published with permission from TechAdvisory.org. Source.

The post Safeguard your Microsoft 365 data with these tips appeared first on Complete Technology Resources, Inc..

Read More

PowerPoint Presenter Coach: New platforms, more feedbackPresenter Coach was one of the artificial intelligence-based features introduced in PowerPoint’s 2019 software update. It helps you give more effective in-person and virtual presentations by providing you with feedback on your word choice, and speed, among many others. This year, Presenter Coach is finally available on all platforms and is packed with new types […]

The post PowerPoint Presenter Coach: New platforms, more feedback appeared first on Complete Technology Resources, Inc..

PowerPoint Presenter Coach: New platforms, more feedback

Presenter Coach was one of the artificial intelligence-based features introduced in PowerPoint’s 2019 software update. It helps you give more effective in-person and virtual presentations by providing you with feedback on your word choice, and speed, among many others. This year, Presenter Coach is finally available on all platforms and is packed with new types of feedback.

Availability on all platforms

Presenter Coach is now accessible on all platforms: web, Windows, Mac, iOS, and Android. This means you can utilize this feature whenever you need it and wherever you are — at home, in the office, or even on the go.

Three new types of feedbacks

Aside from expanding the availability of Presenter Coach, Microsoft also added three new kinds of feedback:

1. Body language

Great presenters rehearse not only what they say, but also their gestures, stance, and facial expressions to ensure that these support their message. For example, they can use hand gestures to emphasize a point, instead of keeping their hands in their pockets or behind their back. They also utilize their eyes, mouth, and facial muscles to convey emotion. By projecting the right body language, they can establish their credibility and connect with the audience.

This is why Microsoft introduced a new capability that uses your video camera to provide feedback on your body language. After your rehearsal, the Presenter Coach will give you a summary report using the following metrics:

  • Clear view – Evaluates how well your audience will be able to see you
  • Eye contact – Tells you whether you are able to maintain your gaze toward the camera
  • Distance – Analyzes whether you are too close or too far away from the camera

2. Repetitive language

During presentations, repeating certain words and phrases can help you emphasize particular points and ensure that your audience recalls them. However, if this technique is done incorrectly, your listeners may find it distracting. On other occasions, you may not even realize that you are using the same words and phrases over and over again, but your audience will most likely catch on.

To help prevent you from overusing the same words and phrases, Presenter Coach will identify them after listening to your rehearsal. Not only that, but it will also give you a list of synonyms that you can use instead so you can switch it up and keep your audience more engaged throughout your presentation.

3. Pronunciation

Presenter Coach can help ensure that you correctly pronounce all of the words that you will say during your presentation. It will display the words you mispronounced during rehearsal and offer a recorded pronunciation guide of that word. You can listen to the correct pronunciation as many times as you want while practicing your presentation.

Currently, Presenter Coach is optimized for the General American English pronunciation, but it can take into account variations in accent. In case you don’t agree with the suggestions provided or you don’t find them useful, you can disable the pronunciation feedback.

Note on privacy concerns

While Presenter Coach uses your camera and microphone to be able to evaluate your rehearsal, it will only do so when you click on Rehearse with Coach and then Start Rehearsing. It does not save any video or audio when you rehearse. It was purposely designed to respect your privacy while still being able to provide clear and actionable feedback that will help you improve your presentation skills.

Want to learn more powerful features in PowerPoint and other Microsoft 365 apps? Contact us today and we’ll help you make the most out of your M365 subscription.

Published with permission from TechAdvisory.org. Source.

The post PowerPoint Presenter Coach: New platforms, more feedback appeared first on Complete Technology Resources, Inc..

Read More

Level up your Excel skills with these tipsMicrosoft Excel’s new features now make it easier than ever to process data and present information visually. Level up your spreadsheets with the tips below: Take advantage of Ideas in Excel If you’re not sure which type of chart best tells a particular story out of a table of data, don’t worry — Excel’s artificial […]

The post Level up your Excel skills with these tips appeared first on Complete Technology Resources, Inc..

Level up your Excel skills with these tips

Microsoft Excel’s new features now make it easier than ever to process data and present information visually. Level up your spreadsheets with the tips below:

Take advantage of Ideas in Excel

If you’re not sure which type of chart best tells a particular story out of a table of data, don’t worry — Excel’s artificial intelligence has got your back. Just click any cell in a data range, then go to the Home tab and click the Ideas button. A task pane will appear, showing recommendations for what data visualization you can use. Here’s a quick reference for what some of the most popular charts are for:

  • Column/Bar chart – Compares categories with one another by depicting their numerical standing in terms of column height (or bar length, in the case of bar charts) side by side (think of lining children up and looking at how tall they are)
  • Line chart – Shows how data changes over time or another variable that continuously increases at a regular rate
  • Pie chart – Sets items as being parts of the same whole to depict and compare how much each contributes to or partakes of that whole
  • Scatter diagram – Sets two variables as axes on a Cartesian plane and plots data as points on that plane to show whether a relationship exists between the two variables, and if so, what kind of relationship they have with one another

Intelligent answers for questions about your data

Thanks to natural language processing, users are able to ask a specific question or make a visualization request to Ideas, and Ideas will respond by providing a chart that answers that question or fulfills that request. For instance, if you have sales data for shirts, sweaters, boxers, briefs, jeans, and socks, and you ask for “total sales for boxers, briefs, and socks,” Ideas will show you a pie chart showing how much those three items contributed to their total sales. You can thereafter revise the label of that chart to “Total sales for underwear.”

Save time by using dynamic array formulas

For the longest time, Excel users had to enter one formula in a cell to have something returned in that particular cell only. If, for instance, you opted to use formulas (instead of the Remove duplicates command) to obtain unique values from a list containing repeating names, you’d have had to nest all sorts of functions that only increase in complexity for every succeeding cell that you use. This is no longer the case, thanks to dynamic array formulas.

Simply put, dynamic array formulas let users obtain multiple results that “spill” over multiple cells by just executing a single formula. Plus, just like how a single-cell formula result changes when that formula’s source reference changes, the results of the entire array also stay in sync with the changes in the source reference.

To illustrate, let’s say that you use the Unique function to obtain a list of non-repeating names from a list that mentioned the name “Eric” a lot. The resulting array will be a list that mentions “Eric” only once, but if all instances of “Eric” were deleted from the source list, then “Eric” will be taken out of the results array.

Besides Unique, these are some of the other functions that showcase the dynamic array feature:

  • Filter – Extracts all records that match the criteria that the user set (e.g., a list of names of people with green eyes)
  • Randarray – Generates a table full of random whole numbers or decimals between two values that are provided by the user
  • Sequence – Creates a table full of numbers that begin at a specified value and increase by an increment set by the user
  • Sort – Extracts unique values from an array and rearranges them into a new array according to the ascending or descending order of a chosen column index (e.g., a list of billionaires and their respective net worth, sorted from lowest to highest net worth)

Make data extraction easier with XLOOKUP

Let’s say you have a table that records the meals that Mark, Martha, and Marion ate for breakfast, lunch, and dinner on May 5, 2020. The names of these three individuals are in Column A, while what they had for breakfast, lunch, and dinner are in Columns B, C, and D, respectively.

 

May 5, 2020

NAME Breakfast Lunch Dinner
Mark Scrambled eggs, bacon, and home fries Pork chop and mashed sweet potatoes Shrimp and vegetable tempura with rice
Martha Avocado toast Aglio olio Salad Nicoise
Marion Pancakes and sausages Fried chicken and cheese grits Roast beef with baked potato

 

Finding out what Mark ate for lunch is easy enough to do manually, but now imagine his name among those of 20,000 other people, in a list that’s randomly ordered, in a table spanning the year 2020. Instead of driving yourself crazy, you can retrieve that information efficiently through Excel’s XLOOKUP function.

Extracting data that corresponds to other pieces of data is what lookup functions are for. The very first to be rolled out was Vertical Lookup or VLOOKUP, a function that goes row by row to look from left to right to retrieve your desired information. Next came Horizontal Lookup or HLOOKUP, which did the same thing, except it went column by column to look from top to bottom.

The latest and best iteration of the lookup function is XLOOKUP. It combines both VLOOKUP and HLOOKUP and improves them by being able to go right to left and bottom to top as well.

Let’s go back to our 2020 meals table example above. With XLOOKUP, you can find out who ate roast beef with baked potato on April 2. However, if many people ate that meal that day, you’ll only be able to retrieve either the first or last match in the table depending on whether you specify that the search be done from first to last or in reverse order. Returning multiple matches is possible, but only by integrating other functions with XLOOKUP.

Despite XLOOKUP’s inability to return multiple matches on its own, it can return multiple values from a single match (a la dynamic array). To illustrate, let’s limit our example table to just one day, and we want to extract what Marion ate for breakfast, lunch, and dinner. If you choose to use the older VLOOKUP function, you have to perform it three times — once for every meal. With XLOOKUP, you only have to do it once. This is such a huge time-saver, especially if you want to extract entire rows or columns of data from your source table.

Excel is now more user-friendly than ever before. To take full advantage of the best features Excel has to offer your business, contact us today.

Published with permission from TechAdvisory.org. Source.

The post Level up your Excel skills with these tips appeared first on Complete Technology Resources, Inc..

Read More

Keep your Microsoft 365 environment secure with these tipsMicrosoft 365 is one of the most widely used business productivity suites today. From email and collaboration to cloud storage and enterprise content management, the robust features of its cloud-based tools and servers are nothing short of useful. Still, Microsoft 365 presents certain security challenges that businesses must address. Vulnerabilities in SharePoint Businesses typically use […]

The post Keep your Microsoft 365 environment secure with these tips appeared first on Complete Technology Resources, Inc..

Keep your Microsoft 365 environment secure with these tips

Microsoft 365 is one of the most widely used business productivity suites today. From email and collaboration to cloud storage and enterprise content management, the robust features of its cloud-based tools and servers are nothing short of useful. Still, Microsoft 365 presents certain security challenges that businesses must address.

Vulnerabilities in SharePoint

Businesses typically use SharePoint Online and on-premises SharePoint sites to store sensitive information like personally identifiable data. Failing to secure SharePoint content against unauthorized users is one way to expose data and your business to malicious actors. This can be critical for companies that are required to comply with stringent data privacy and protection regulations and may face serious consequences for noncompliance.

To prevent this, limit administrator-level privileges and enable encryption. Additionally, set the necessary security restrictions per user for every application.

Unprotected communication channels

Phishing attacks and malware are two of the most common ways cybercriminals infiltrate a system, but there are other paths of attack. Microsoft 365 applications like Microsoft Teams, which can connect to external networks, may serve as a medium for ransomware and other types of attack.

Train your staff to identify potentially malicious files and links. Also, offer guidelines on how to handle and route sensitive files and communication to safe locations.

Security risks in dormant applications

Organizations using Microsoft 365 often won’t use all the tools and services included in the productivity suite. You may use one or several programs like Word, Excel, and SharePoint but rarely use OneDrive. If your business has been utilizing specific programs, note that some dormant applications may be prone to attack. This is why it’s crucial to identify the apps that aren’t being used, and have an administrator tweak user settings to restrict availability on such apps.

File synchronization

Like most cloud services, Microsoft 365 allows users to automatically sync on-premises files to the cloud, such as in OneDrive. This useful feature is not without security risks, however. If a file stored locally is infected with malware, OneDrive will view the file as changed/updated and trigger a sync to the OneDrive cloud, with the infection going undetected.

Office 365 Cloud App Security, a subset of Microsoft Cloud App Security, is designed to enhance protections for Office 365 apps and provide great visibility into user activity to improve incident response efforts. Make sure your organization’s security administrators set it up on your systems so you can detect and mitigate cyber risks as soon as possible.

Cybercriminals will continue to sharpen their hacking techniques, and your organization must keep up to protect your systems, apps, and devices. Call our team of IT experts now if you want to strengthen your business IT security.

Published with permission from TechAdvisory.org. Source.

The post Keep your Microsoft 365 environment secure with these tips appeared first on Complete Technology Resources, Inc..

Read More