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

List of Knowledge Packs

Knowledge Pack is like a live book. I write articles in random order. But later I put combine them in the recommended reading order by topic. This list is called a Knowledge Pack. Whenever I write another relevant article, the corresponding Knowledge Pack is updated. This is what makes the Knowledge Pack a Live Book!

I have created many knowledge packs. But there was no list of Knowledge Packs. So here it is… it is like a Knowledge Pack of Knowledge Packs School

image

Continue reading

Outlook 2016: Insert Attachment shows OneDrive recent files

Office 2016 has enhanced the integration with cloud. Inserting attachments into a mail requires you to select the file to be inserted. Often this file is something you have been working on very recently (as in, few minutes back). But often we forget the path and struggle to locate the file. Now that problem is solved. Find out how…

Continue reading