508-909-5961 [email protected]

Using Workplace Analytics to boost productivityMicrosoft’s Workplace Analytics uses data gathered from email, documents, calendar, and other Office 365 applications to present a clear picture of both employee and manager productivity. It’s a clear upgrade from MyAnalytics, which allowed employees to view just their own data. How does Workplace Analytics work? A paid add-on to Office 365 enterprise plans, Workplace […]

The post Using Workplace Analytics to boost productivity appeared first on Complete Technology Resources, Inc..

Using Workplace Analytics to boost productivity

Microsoft’s Workplace Analytics uses data gathered from email, documents, calendar, and other Office 365 applications to present a clear picture of both employee and manager productivity. It’s a clear upgrade from MyAnalytics, which allowed employees to view just their own data.

How does Workplace Analytics work?

A paid add-on to Office 365 enterprise plans, Workplace Analytics extracts behavioral insights from data gathered from Office 365 email, calendar, documents, and Skype. This means any data an employee types into their email and calendar — whether the information is in the subject line or in the body itself — can be used to determine their productivity.

The program has an overview dashboard that provides specific information:

  • Week in the Life provides an overall view of how the entire organization spends time and how members collaborate with one another
  • Meetings Overview shows the amount of time people spent in meetings
  • Management and Coaching gauges one-on-one meetings between your staff and their manager
  • Internal Networks shows how people within the company connect with one another
  • External Collaboration provides insights into how people from your company connect with those from third-party organizations
  • Teams Collaboration takes a look at how employees and managers communicate with their colleagues

What does Workplace Analytics aim to do?

According to Microsoft, Workplace Analytics addresses businesses’ most common challenges: complexity, productivity, and engagement.

Using Workplace Analytics data, managers and human resources departments can form productivity strategies for the entire company. If most of your employees spend 60% of their time attending meetings and not enough time doing creative work, managers can come up with a strategy to reduce meeting times and focus more on productive tasks.

Workplace Analytics also identifies how employees collaborate with internal and external parties. Suppose one of your sales staff frequently communicates with certain contacts. By using Workplace Analytics data, the manager would be able to determine whether this particular collaboration pattern is helping the employee hit sales targets or he or she is missing out on other more critical contacts. Based on this info, managers would also be able to determine which employees are most likely to meet or exceed their targets and set company-wide standards accordingly.

Workplace Analytics also allows managers to determine an employee’s level of engagement (i.e., whether the organization’s collaboration patterns are good for the company), and whether workloads are fairly distributed among workers and/or departments.

Is Workplace Analytics useful for small businesses?

Large corporations have been using Workplace Analytics, but small businesses can also benefit from it. The data used to provide insights are what employees generate themselves — how much time they spend on meetings, whom they frequently communicate with, and how much time they spend on productive tasks.

Aside from letting managers examine their staff’s work behavior, Workplace Analytics also provides an overall look at an organizational level. If you want your organization to further harness the capabilities of Workplace Analytics and other Office 365 tools, give us a call today.

Published with permission from TechAdvisory.org. Source.

The post Using Workplace Analytics to boost productivity appeared first on Complete Technology Resources, Inc..

Read More

Using Workplace Analytics to boost productivityMicrosoft’s Workplace Analytics uses data gathered from email, documents, calendar, and other Office 365 applications to present a clear picture of both employee and manager productivity. It’s a clear upgrade from MyAnalytics, which allowed employees to view just their own data. How does Workplace Analytics work? A paid add-on to Office 365 enterprise plans, Workplace […]

The post Using Workplace Analytics to boost productivity appeared first on Complete Technology Resources, Inc..

Using Workplace Analytics to boost productivity

Microsoft’s Workplace Analytics uses data gathered from email, documents, calendar, and other Office 365 applications to present a clear picture of both employee and manager productivity. It’s a clear upgrade from MyAnalytics, which allowed employees to view just their own data.

How does Workplace Analytics work?

A paid add-on to Office 365 enterprise plans, Workplace Analytics extracts behavioral insights from data gathered from Office 365 email, calendar, documents, and Skype. This means any data an employee types into their email and calendar — whether the information is in the subject line or in the body itself — can be used to determine their productivity.

The program has an overview dashboard that provides specific information:

  • Week in the Life provides an overall view of how the entire organization spends time and how members collaborate with one another
  • Meetings Overview shows the amount of time people spent in meetings
  • Management and Coaching gauges one-on-one meetings between your staff and their manager
  • Internal Networks shows how people within the company connect with one another
  • External Collaboration provides insights into how people from your company connect with those from third-party organizations
  • Teams Collaboration takes a look at how employees and managers communicate with their colleagues

What does Workplace Analytics aim to do?

According to Microsoft, Workplace Analytics addresses businesses’ most common challenges: complexity, productivity, and engagement.

Using Workplace Analytics data, managers and human resources departments can form productivity strategies for the entire company. If most of your employees spend 60% of their time attending meetings and not enough time doing creative work, managers can come up with a strategy to reduce meeting times and focus more on productive tasks.

Workplace Analytics also identifies how employees collaborate with internal and external parties. Suppose one of your sales staff frequently communicates with certain contacts. By using Workplace Analytics data, the manager would be able to determine whether this particular collaboration pattern is helping the employee hit sales targets or he or she is missing out on other more critical contacts. Based on this info, managers would also be able to determine which employees are most likely to meet or exceed their targets and set company-wide standards accordingly.

Workplace Analytics also allows managers to determine an employee’s level of engagement (i.e., whether the organization’s collaboration patterns are good for the company), and whether workloads are fairly distributed among workers and/or departments.

Is Workplace Analytics useful for small businesses?

Large corporations have been using Workplace Analytics, but small businesses can also benefit from it. The data used to provide insights are what employees generate themselves — how much time they spend on meetings, whom they frequently communicate with, and how much time they spend on productive tasks.

Aside from letting managers examine their staff’s work behavior, Workplace Analytics also provides an overall look at an organizational level. If you want your organization to further harness the capabilities of Workplace Analytics and other Office 365 tools, give us a call today.

Published with permission from TechAdvisory.org. Source.

The post Using Workplace Analytics to boost productivity appeared first on Complete Technology Resources, Inc..

Read More

Time to upgrade your Excel skillsWith Microsoft Excel’s new features being so incredibly user-friendly, there’s no excuse to remain basic. Upgrade your skills with our three tips today!

The post Time to upgrade your Excel skills appeared first on Complete Technology Resources, Inc..

Time to upgrade your Excel skills

With Microsoft Excel’s new features being so incredibly user-friendly, there’s no excuse to remain basic. Upgrade your skills with our three tips today!

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 (AI) 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 other variable that continuously increases at a regular rate (think of someone tracking their weight weekly during the entirety of their three-month diet)
  • 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 (think of a statistician showing a town’s composition by race)
  • 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 (think of recording the temperature at noon every day and noting sales of bottled water to see if increasing temperatures lead to increasing sales)

Coming soon: Intelligent answers for questions about your data

Thanks to natural language processing (NLP), users will soon be 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 into “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. That’s the array part, but why is it called “dynamic?” Well, 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 “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 you 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 July 4, 2019. People’s names are in Column A, while meal names for breakfast, lunch, and dinner are in Columns B, C, and D respectively.

JULY 4, 2019

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 20,000 other people, in a list that’s randomly ordered, in a table spanning the entire year of 2019. Instead of driving yourself crazy, do it programmatically via Excel’s XLOOKUP function.

Extracting data that corresponds to other pieces of data is what lookup functions are for. The very first 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 2019 meals table example above. With XLOOKUP, you can find out who ate roast beef with baked potato on April 1. 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, however, 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 Time to upgrade your Excel skills appeared first on Complete Technology Resources, Inc..

Read More

Increase productivity with Office 365 and SurfaceMicrosoft recently showcased Surface, a line of touchscreen-based laptops and tablets that run on the latest version of Windows. These gadgets boast compact builds, sharp displays, and other top-of-the-line specifications. And the best part is, all of these devices can integrate seamlessly with Office 365 to help you achieve optimum productivity. Here’s what you can […]

The post Increase productivity with Office 365 and Surface appeared first on Complete Technology Resources, Inc..

Increase productivity with Office 365 and Surface

Microsoft recently showcased Surface, a line of touchscreen-based laptops and tablets that run on the latest version of Windows. These gadgets boast compact builds, sharp displays, and other top-of-the-line specifications. And the best part is, all of these devices can integrate seamlessly with Office 365 to help you achieve optimum productivity. Here’s what you can expect.

Audio transcription in Word

This new feature allows audio files to be uploaded into Word, which will then be broken down and transcribed on a side panel using Azure Speech Technology. If you want, you can also record directly on Word using the Dictate function. The app will automatically transcribe it. To review the accuracy of the transcription, simply select a piece of the transcribed text and the audio version of that part will be played back.

This technology will be available in Word for web in early 2020, and can be enjoyed on desktop and mobile in the spring. This feature isn't free, but researchers, students, and professionals will find that this feature is worth the cost. It can also be of help to people with disabilities.

Improved Ink Editor

Ink Editor lets you edit and highlight documents by using your finger or a digital pen. Previously, you could already do simple commands with it, like delete and add words in a document, split a word, or link two words together. With Surface devices, the editing gestures become even more natural. When the technology arrives on web and desktop in Spring 2020, you will be able to insert comments anywhere in the document, as well as add graphs, drawings, or dictations.

Digital pen support for Excel

Microsoft takes advantage of the touchscreen capabilities in Surface devices by offering digital pen support for Excel. With this capability, you can now use your digital pen to write letters and numbers directly into Excel. This is perfect for people who are always on the go and those who want to save time when taking down notes.

Powerful Earbuds

Surface Earbuds are wireless earbuds that allow you to control music and calls by using signature gestures and voice commands. And because it integrates with Office 365, you can also use these gestures and commands on Office apps, such as when controlling a PowerPoint slideshow. Go to the next slide on PowerPoint by swiping on your Earbuds, or play and pause a video with a single tap on your device. Access apps like Outlook calendar and email without a screen. You can also use its built-in mic for dictation in apps like Word and Teams. The possibilities are limitless.

With Surface and Office 365 working together, you can expect improved productivity and more efficient workflows. Want to learn more about Office 365 and other necessary business technologies? Contact us today. Our technology experts are always ready to answer your questions.

Published with permission from TechAdvisory.org. Source.

The post Increase productivity with Office 365 and Surface appeared first on Complete Technology Resources, Inc..

Read More