Surface Pro Aspect Ratios

Windows Display Settings dialog only lists the actual resolution. Ideally, they should also mention the aspect ratios as well. Never mind. Here are Surface Pro Aspect Ratios for your reference. Most of us nowadays need 16:9 resolution.

Surface Pro Aspect Ratios

Download Excel file containing ratios for all available resolutions.
The conversion formula is also included in the file.
Some weird looking aspect ratios are for backward compatibility.
For more details
read this Wikipedia article.

Productivity Session at CIO meet: Video

I recently spoke at the CIO Powerlist 2017 event which was attended by 100+ CIOs from India.  Watch my session video – 27 min.

Topics covered

  1. Office 365 Secure Score
  2. File storage best practices
  3. Skype FB best practices
  4. Better teamwork using Office 365 Groups
  5. Chat based collaboration using Office 365 Teams
  6. Team Task management using Planner
  7. When NOT to send a mail (because there is a better option available)
  8. Amazing data cleanup using Power Query
  9. Excel Forecasting – new feature
  10. Automated animation using Morph in PowerPoint
  11. Summary Zoom in PowerPoint

Link recent files instantly

Here is a smart new feature which allows you to Link recent files instantly. It is difficult to notice but a very nice addition. Just notice the dropdown below the Insert – Link button. Also available with Right Click – Link button. Shows recent files to choose from. Works with Word, Excel, PowerPoint and Outlook. It is similar to the Insert Attachment dropdown in Outlook. One difference.

This list does not show the cloud icon for files which are on OneDrive or SharePoint. Look at the path before adding the link. Whether the file is on local drive or OneDrive, it is not going to automatically give access to others, in case you send the documents to them. The Outlook – Add Attachment list shows the cloud icon and automatically gives EDIT permission to the recipients.

SNAGHTML21e14e3

Split column into rows

A brilliant new feature is now available in Power BI – Split column into rows. To understand why we need it, you must go and read the article  – Analyzing badly captured Survey data or feedback forms. This method used Power Query concepts of Split and Unpivot. Now these have been combined into a single, intelligent command called Split columns into rows.  It sounds confusing at first. But soon you will realize that it is an amazing tool.  Learn it just 4 minutes.

Raw data looks like this

Split column into rows - raw data

And you get a report like this. No need to use formulas or do any manual work.

Split column into rows - Final Charts

You must have the May 2017 update for Power BI Desktop installed.

Continue reading Split column into rows

Power BI Dates before 1900

This is a short post. It is like an FYI mail. Excel never understood any dates before 1900. We got used to that limitation over the decades. But Power BI does understand Dates before 1900. The best part is, you do not have to take any specific action. It just works.

Here is the raw data and the Power BI output.

Dates before 1900 - raw dataDates before 1900 - in a chart

If you try this in Excel, it just will not work. Now that you know this, starting using Power BI with Dates before 1900.

Mind you, the Power BI documentation says that the earliest limit is 1900. It still works for dates before 1900. Drill down is also supported. Here is the same data at Day level.

Drill Down

This ability  may make historians and archeologists partially happy. There time scales are huge and Power BI does not support that much of a range. But still, it is an improvement worth knowing about.