Bad Data to Good Data: Fill gaps using Power Query
This is a continuation of a series on how to convert badly formatted data into an easy to analyze – tabular format. In this article, we are talking about data
This is a continuation of a series on how to convert badly formatted data into an easy to analyze – tabular format. In this article, we are talking about data
Immediate action required. Control Panel – Windows Update – Check for Updates. Adobe also released important patches. Also update Power Query – the Excel add-in which helps you get and
This is a quick post. But it is extremely useful. Once I learnt this, I laughed at myself for not noticing it and applying it for God knows how many
The simple answer is – write on paper, scan it and post it. But I am not talking about that… Recently I wrote an article using my handwriting using OneNote. Many
This is a troubleshooting article on Edit Margins. Common problem and quick solution. If the top and bottom margin is missing in the page layout view in Word, don’t
Another nice new feature introduced in OneNote which is useful while browsing on the desktop or tablet. OneNote Clip allows you to send screenshots of the entire web page to OneNote
This is a new feature introduced recently. You can send a mail to that address and it will appear in your OneNote on all devices. Nice and easy. Here is how
Shapes and lines can be made transparent easily by increasing the transparency of the fill / line color. This setting simply does not exist for pictures and videos. Here is how
This is a simple, useful but unknown feature available in Office. Documents containing passwords, important numbers should be protected from inadvertent changes using the Mark as Final feature.
Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
