Tag Archives: Performance

slow PC? Close Browsers

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.

image

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 : Simplifying usage

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.

Excel Data Model usage options

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

Pivot performance improvement options

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. 

Data tab for Pivot performance adjustment

Here is a set of Practical usage guidelines for some of these new options.

Continue reading Pivot performance improvement options