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.

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

PowerApp with Machine Learning – Creating an engaging PowerApp in a matter of hours
Webinars

Join us for this exclusive webinar, ‘ How Trump are you? Creating an engaging PowerApp with Machine Learning in a matter of hours’ from Carlo, Martin and Kevin where they’ll share their popular app from the ESPC16 Hackathon. You’ll learn about the ease of creating PowerApps with machine learning, the pain of uploading images with PowerApps and see what can be done with relatively small amounts of technical knowledge.

Can you still use sandbox solutions in 2017?
Can you still use sandbox solutions in 2017?
Blog Posts

Can you still use sandbox solutions in 2017? The answer to this question is yes, but… not for all situations and not all types of sandbox solutions. SharePoint sandbox solutions were introduced with SharePoint 2010 and provided a mechanism to execute code outside of the ISS worker process. The sandbox solutions do not affect the… READ MORE

An Overview of Office 365 Service Assurance Resources
An Overview of Office 365 Service Assurance Resources
Blog Posts

Service Assurance is a primary goal This is particularly important in understanding how Office 365 protects your data, especially since it concerns email access, team communication, collaboration, content storage and specifically content viewed and edited in a browser. Service Delivery includes Service assurance, which is an organisational primary goal, and is directly aligned to the… READ MORE