Data Split into Two rows – Cleanup using Power Query

This is the worst type of input data to get. Each row has been split into two (or sometimes more) rows. We want those to be combined into a single row. In an earlier article, I have shown one method of doing this.

Now here is a simpler, faster and more powerful method using Power Query.
(Estimated reading time 12 min)

image

Continue reading

Knowledge Pack: Outlook

Outlook is great. But our outlook towards Outlook is not! That is why we waste lot of our precious time in doing the wrong things in and around Outlook. I have covered many aspects of effective Outlook usage. Here is a comprehensive list, in recommended order of reading.

image

Photo credit: simondavies57 / Foter / CC BY-SA

Continue reading

IT as an Enabler (really!) – use Office Group Policy

This article is for IT professionals only. The language is technical. As a user it is not relevant to you.

IT presentations say “IT is an enabler”. But ask any user – they will tell you that the primary job of IT seems to be “disabling” things. From Start Menu, IE settings, USB Ports, Web sites, network settings, ability to install new software, everything seems to be deactivated by IT. It is frustrating. But everyone knows that it is required for security, compliance and privacy reasons.

As an IT professional, here is your chance of ENABLING things which users will really thank you for. This opportunity comes from a seemingly unlikely place – Microsoft Office. Read on to find out how you transform your users lives using Office Group Policy.

image

Photo credit: Stuck in Customs / Foter / CC BY-NC-SA

Continue reading

Office 365 Worst Practices – Part 8 – Focus only on What’s New

This is not specific to Office 365 – it is a general phenomenon. IT professionals are especially prone to this “What’s New Syndrome”. Whenever any product is being considered for purchase, deployment or adoption, What’s New becomes an important part of the discussion. Unfortunately, that is NOT the right way to plan rollout or adoption of ANY product. Why? Because focusing on What’s New assumes you already know What’s Old (and are using it effectively) – which is rarely true!

image

Photo credit: Georgie Pauwels / Foter / CC BY

Continue reading