Category: Office 365

According to Microsoft, “Office 365” refers to subscription plans that include access to Office applications plus other productivity services that are enabled over the Internet (cloud services). Office 365 includes plans for use at home and for business.
Office 365 plans for business include services such as Skype for Business web conferencing and Exchange Online hosted email for business, and additional online storage with OneDrive for Business.

Many Office plans also include the desktop version of the latest Office applications, which users can install across multiple computers and devices. The fully installed applications include: Word, Excel, PowerPoint, OneNote, Outlook, Publisher, and Access.

Therefore, this category is full of handy tips, tricks, advise and How To videos specifically for Office users. Check out some of the Step by Step blogs or learn about how to transform from an email culture to a collaborative culture with our expert blogs, ebooks, how to videos and webinars.

Add more Smarts to your bot:Detecting emotions from giphy posts
Add more Smarts to your bot:Detecting emotions from giphy posts
Blog Posts

I’ve been blogging about bots since April, 2016 which was about the time I discovered Microsoft’s amazing bot framework. I’ve written a series of how to detect user intent based on text messages using LUIS (Language Understanding Intelligent Service) you can find it here. In this post I’ll talk about understanding user emotion using the Giphy… READ MORE

The step-by-step guide to sending Email into Microsoft Teams
The step-by-step guide to sending Email into Microsoft Teams
Blog Posts

Imagine you are a sales person (without Microsoft Teams) out on the road and you get an Email from a potential customer. The customer is asking for a special deal which requires you to discuss it further with your sales team. Normally, you’d forward the Email to your colleagues and then Email tennis would continue for the next few hours. Then, after a… READ MORE

How to extract tables from Powerpoint using just Power Query
How to extract tables from Powerpoint using just Power Query
Blog Posts

I’ve been using my solution to extract tables from Powerpoint a lot recently.  However, I’ve come across some situations where what looks like a table is actually an embedded Excel worksheet. This can be quite useful in Powerpoint as it provides the ability to create subtotals and apply other formulae. You can add these sort of… READ MORE

[SOLVED] Cannot Connect to Project Online
[SOLVED] Cannot Connect to Project Online
Blog Posts

Could not load project, job failed, retrieve enterprise global template, internal error, unable to open your project – Cannot Connect to Project Online? If you are having any of the issues below when using your Project Professional connected to Project Online, I have the solution for you! Microsoft Project Unable to display Projects from the… READ MORE

Simple (but effective) dashboards in SharePoint
Simple (but effective) dashboards in SharePoint
Blog Posts

One of the more common requests I get about putting SharePoint to good use is how to build a hyper-responsive, beautifully designed, amazingly cogent dashboard displaying all the key performance indicators (KPIs), report updates, big data analyses, and business intelligence of the day. Feel free to add in whichever new synergistic buzz phrase is relevant… READ MORE

Bar-Mekko chart in Excel with Power Query
Bar-Mekko chart in Excel with Power Query
Blog Posts

Seems, Excel charts is an area that till now wasn’t considered in blogs as a target for Power Query application (Get & Transform in Excel 2016). Nevertheless, PQ can replace some VBA solutions and make your workbooks macro-free. In far 2015 my colleague Zoltán Kaszaki-Krsjak shared with me a very good example of how Power… READ MORE

Copy Documents between Site Collections in Office 365
Copy Documents between Site Collections in Office 365
Blog Posts

In this blog I am going to share the code to copy documents between site collections using CSOM on Office 365 SharePoint. The below code uses the recursive method to get all documents from source site collection and copy it to the target site collection. The script also preserves the modified and modified by details… READ MORE