Goodbye, IE.

Internet Explorer does not have a role to play any longer. Unless a third-party application specifically demands it. In my context, nobody is demanding it.
Moreover, it is more erratic, unpredictable and unstable, even with Microsoft sites.

I know Unpin is not required when I am uninstalling the application itself.
But still, just to emphasize the point!

Unpin from IE - Goodbye IE 

I removed it completely.

Goodbye IE - how to remove IE from windows 10

Should we call this Digital Transformation? 
or better still: Degrade and Embrace?
Cutting Edge?

What works well must be appreciated and adopted - Goodbye IE

Search for photos with matching color

PowerPoint has theme colors. Each design (template) has a different set of colors. You want to find particular photos / images which match the theme colors. Sounds like a difficult task? Not at all. Use Insert – Online Pictures – Pexels. Install the software and search.  Type the keyword and click on the color you want. Try it out now. For details read this article.  Here, I searched for orange colored cars. 

image  image

That’s it. Simple and effective.

PowerPoint Illustration Best Practices

Please read the PowerPoint Clipart / Online Picture articles before reading this one – Part 1 and Part 2.  PowerPoint Illustration Best Practices covers how to find relevant images and how to use them efficiently.

The first thing to notice and understand is that images searchable on the web are NOT free for all to use randomly. Let us address this issue at the outset.

PowerPoint Illustration Best Practices - one picture is better than 1000 words

Continue reading PowerPoint Illustration Best Practices

Outlook Conversational View

If you have the latest version of Office Pro Plus, a great new feature is now available. It is called Outlook Conversational View – (not to be confused with “Show as Conversation” setting). Check the View tab in Outlook. Conversational view is useful for managing long mail trails.

Outlook Conversational View

When you click on this button, the menu options reduce and the Reading Pane is automatically activated. Don’t worry. If you do not like it, just click on Classic button.

Continue reading Outlook Conversational View

Warning: Office 365 SPAM – Phishing attack

DO NOT respond to any mails which ask for Urgent Upgrade. Here is a sample mail which I just received.

image

There is a link called UPGRADE NOW.
DO NOT CLICK ON THIS LINK.

This link leads to an authentic looking Office 365 login page. Needless to say, it is a fake page. This is called a Phishing attack.

image

DO NOT put your password there.
Just delete the mail permanently and do not think about it again.

I have already informed the relevant authorities in Microsoft. They will do the needful.

If you are in another country or region, you may not receive this particular type of mail. But in any case, do not trust any such mails. If you are an IT person, go to the Office 365 Admin page and check if there is a genuine need for license upgrade. If you are not an IT person, just alert your IT team.

Be safe!.

Excel Data Model : Simplifying usage

Excel Data Model is a database that is built-in to Excel. It has been around since 2010. Using it increases the capacity of Excel to handle millions of rows, it reduces file size significantly and eliminates VLOOKUP for code to description mapping. These new options in Excel 2016 and above simplify the usage of Excel Data Model and improve performance for large data operations. Go to File – Options – Data tab.

Excel Data Model usage options

Options in section 1 and section 2 are already covered in my previous blog articles. Section 3 helps us incorporate Data Model more easily into day-to-day Excel data management activities.

Continue reading Excel Data Model : Simplifying usage