How to highlight, everyone knows. If you want to highlight repeatedly, double click on the highlight button. Now selecting any text automatically applies the highlight. How to search for highlighted areas is already covered. Now let us learn how to Remove all Highlights – in one stroke – requires just 30 seconds to do it. Learn the magic now!
This keynote was delivered at the CIO Crown event in Mumbai (India), August 2016. 200+ CIOs attended the session. It was an honor to showcase the power of Office365 to a highly motivated and intelligent audience… love it!
View on YouTube
View it in 720p resolution in full screen for maximum impact.
This is just a quick best practice. I learnt it while conducting a webinar on Thursday using Skype for Business (SFB). During webinars, you have two options, just show a presentation and explain it or demonstrate something on your screen – typically some software product. Screen sharing is used to broadcast your desktop.
Often, I need some live input from the audience. For example, what is their profile? Which product / feature is more important for them? Have they understood the topic or not?
Many customers have deployed Office 365. However, the usage of all components is not optimal. That is why I wrote this short and simple Office 365 Storage Guide. Tweak it as per your specific needs but the base concept is same. No documents should be stored on local My Documents. Storing a document on a particular device makes it unavailable to even the person who created it. That is why, it should go on a cloud storage. In addition, files stored on the cloud are easier to share with others.
A simple but very useful method. All of us use AutoFilter in Excel. The dropdown shows unique values in the column. Sometimes we just want to see the rows with blank cells. Unfortunately, the (blank) item appears at the end of the list. If the data contains many unique values, you have to waste time and scroll manually to the bottom of the long list. Often, after reaching the list we realize that we should actually have unselected all the items first. Then you go up again! Pathetic. Here is a smart way to Filter on Blanks instantly.
I am happy to announce that my first detailed training course is now up and running at Udemy. It is about Power BI. But it starts with what you already know – Pivot Tables. That is why the course is called Pivot Table to Power BI.