How to hide cell contents in Excel

This is a short article. We know how to hide rows, columns and sheets. Did you know you can hide cell contents as well in Excel?

When we want to hide cell contents, the obvious thought is to change the font color to white. It works, for some time. But the moment you select the cell, it will show the value as the background color changes. So here is the right way.

Continue reading How to hide cell contents in Excel

How to Really Remove Duplicate Rows in Excel

Watch this five minute video to understand what we “really” mean by Remove Duplicate Rows in Excel. The default option removes the duplicate rows automatically. Most of us want to “see” the duplication. That is what leads to the confusion. Not to worry. Learn the right method now.

Remove duplicates QRScan this code and watch the video on your mobile phone and try it out on your laptop.
Download the sample file if you want to try it out yourself.
Continue reading How to Really Remove Duplicate Rows in Excel

How to prevent unwarranted “Congrats” messages in LinkedIn

I noticed a spelling mistake in my LinkedIn profile and updated it. I was flooded with hundreds of Congrats messages. Has it happened to you? There is a simple way of preventing minor changes from being interpreted as a new role or position change.

The Solution

It is quite simple really. Before you edit your profile, go to your settings and change the Privacy settings.

image

Now choose the Profile settings and click on Choose whether or not to share your profile edits. Turn it Off by default. Now make minor changes. Nobody will be notified. Of course, remember to turn it ON, temporarily, when you genuinely have been promoted or rewarded or moved jobs. That’s it.

image

This dialog has an interesting footnote. If you do not want your employer to know about changes to your profile, turn this option off. I find that funny. Because, it will only stop the employer from getting notified about the changes. The HR team can still browse your profile and see it anyway.

image

How to create a Dislike button on Facebook chat

Now it does give you WOW, Love and other things in the regular LIKE button, but not a Dislike (Thumbs Down) button. But in the chat window, Facebook does give you a genuine Thumbs Down button. How to get it?

In FB chat window, click on emoticons button.

Emoticon button in FB chat

Now you will see the emoticons which are available to you by default. Go to the FB emoticons which are called “Likes”. This has many related icons, including “Dislike”. That’s it.

Facebook Dislike button

Power BI Glossary in plain English

Power BI Glossary is a one line description of relevant terms. Jargon free and easy to assimilate. This is actually part of the Power BI Udemy course I am working on. Let me know your feedback.

Power BI Glossary poster

Power BI Glossary

Data Information
Raw data Data as it is received by you
Good data Information in a table form
Bad data Data which is not good
Table Good data with a name
Summarization Roll up or combine raw data into smaller, easier to grasp information
Analysis Finding all possible useful things from the data
Pivot Table Popular tool to summarize tables and analyse the information
Report A way of sharing results of analysis
Action Using the analysis to eliminate bad things or increase good things in future
Power BI Set of new tools which allow even more, faster and easier analysis
Power BI Desktop Windows application which helps in gathering data, cleaning and analysis
Visualization Showing data using a graphic rather than just numbers and text
Dashboard Multiple, related visualizations shown together
Interactive Dashboard Dashboard where changes to one item affects the related visualizations
Power BI Portal The place on internet where you can publish and share the analysis
Power BI app A mobile app for viewing and interacting with Dashboards