O365 contains a lot of tools. Most users do not even know about all the tools available. Even if you know the tools, the next question is – which tool to use when? Most people take this decision either randomly or based upon their habits. Both approaches are wrong. I created a set of 5 videos to illustrate some common Office 365 Usage Scenarios.
Office 365 Usage Scenarios
This is a playlist in YouTube. Each video is about a common business need. For each business need, the video demonstrates the best suited tool. As you know, efficiency is a two step process… step 1 is to know what is available and step 2 is to use the right tool in the right place.
You can view the playlist here.
These videos have a British voice because I created these videos for global consumption.
Here are the videos. Each one is just 5 minutes long. Continue reading Office 365 Usage Scenarios
The commonest reason of slow PC / laptop is too many browser windows open – in too many browsers. It does not matter if it is IE, Edge, Firefox, Chrome or Safari… all of them are like an operating system! Just close them first. Find out the actual browser pages you want and re-open them. That’s it.
I have just the browsers open. No other apps. Each browser has just ONE site open.
IE = CNN.com, EDGE = Amazon.in, CHROME = YouTube.com, Firefox = portal.office.com
We tend to forget how many sites we have opened in how many browsers! Be mindful of that and you are good to go.
Excel Data Model is a database that is built-in to Excel. It has been around since 2010. Using it increases the capacity of Excel to handle millions of rows, it reduces file size significantly and eliminates VLOOKUP for code to description mapping. These new options in Excel 2016 and above simplify the usage of Excel Data Model and improve performance for large data operations. Go to File – Options – Data tab.
Options in section 1 and section 2 are already covered in my previous blog articles. Section 3 helps us incorporate Data Model more easily into day-to-day Excel data management activities.
Continue reading Excel Data Model : Simplifying usage
If you use Office 365 Pro Plus and Excel 2016, you should see a new tab under File – Options. The Data tab. This has many useful features which help improve Pivot performance. In addition, it also helps you with incorporating Data Models more easily into your Excel data management process.
If you do not see the Data tab in File – Options, you are not using the the right version of Excel. Escalate to your IT team to set it right.
Here is a set of Practical usage guidelines for some of these new options.
Continue reading Pivot performance improvement options