Software

MEDIAN IF example
Excel, Techtites Featured, Tips and Tutorials

MEDIAN IF tutorial in Excel 2007 and Excel 2010

Excel 2007 brought a host of new functions to Excel that were missing in Excel 2003. One of these functions was AVERAGEIF which returns the average (arithmetic mean) of all the cells in a range that meet a given criteria. One essential function that is still missing is MEDIANIF or MEDIAN IF which should ideally return the median of all the cells in a range that meet a given criteria.

MEDIAN IF tutorial in Excel 2007 and Excel 2010 Read Post »

taskkill
Software, Techtites Featured, Tips and Tutorials

How to quickly kill a program in Windows

During my regular work, I tend to face repeated issues of Excel hanging. This can be really frustrating because a stuck Excel means a painful wait for Windows to figure out what it wants to do with the process. Unfortunately, there isn’t much I can do about this because it is mainly due to addons that I have installed in Excel, which are required for me to do my job coupled with large files with tens of sheets and hundreds of rows with data.

How to quickly kill a program in Windows Read Post »

Scroll to Top