This is a special announcement for readers in Vietnam. I am speaking at an event arranged by Softline. We are inviting CFO and CIO from the organizations to attend together. This way, it is much easier to explain the business as well as technical details of technology in a single session. For more information, please contact Ms. Ha Linh at email@example.com Tel: 0918 401 248 or (+848) 3899 2737
See you there!
Outlook now has a new feature to compress ALL attached images in one go. Use Insert – Attachments option to add images. BEFORE sending the mail, open the File menu. You will see the new option. Choose the Resize large images when I send this mail option. Now all images will be compressed by reducing their size to 1024X768 or smaller. Aspect ratio will not be disturbed.
DO NOT use this option if you want to retain original resolution. If the mail bounces because the other person(s) cannot receive such large emails, put the files on some cloud storage (OneDrive, Google Drive, Dropbox, etc.) and send a link.
This feature was released in May 2017. Depending upon the configuration decided by your Office 365 Administrator, you may receive this feature much later. You will get it instantly if you are on the Office Insider – Fast branch.
This long-awaited and demanded feature is now available. Go to any birthday notification and open the three dot menu (… also called the Ellipsis). Choose the Turn Off option and heave a sigh of relief!
As discussed in the earlier article, we can now Change Pivot Defaults. Here is a detailed video which covers how to change defaults.
In addition, learn a new, smart way of keeping commonly used pivot layouts in a simple Excel file and use them on demand. Something like a Pivot layout template.
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.
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.
Yes. This long-awaited feature is finally here with Office 365 Pro Plus (May 17). This is a short article showing the steps. Detailed video coming soon. Ability to Change Pivot defaults is very useful. You no longer need to customize each Pivot manually.
Continue reading Change Pivot defaults
I recently spoke at the CIO Powerlist 2017 event which was attended by 100+ CIOs from India. Watch my session video – 27 min.
- Office 365 Secure Score
- File storage best practices
- Skype FB best practices
- Better teamwork using Office 365 Groups
- Chat based collaboration using Office 365 Teams
- Team Task management using Planner
- When NOT to send a mail (because there is a better option available)
- Amazing data cleanup using Power Query
- Excel Forecasting – new feature
- Automated animation using Morph in PowerPoint
- Summary Zoom in PowerPoint
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.