Read here on my (positive) experience of using of Exchange Online (Office 365) for over a year now. In the current configuration we were using, for each user the password for their emails (Office365) was different from their office network (local Active Directory). Even then there was a way to pass through single sign-on, which meant any user signing in to Office365 the authentication will be done over the internet (secure connection) to our local AD (Active Director) Domain Controller (DC). We didn’t go with this option then, as this would have required us to have our DC servers available all the time, which was not possible in our case.…

I use MS Excel a lot in a day for reviewing financial reports, client proposals, analysis of market data and so on. Beyond simple calculations, charts I find working with Excel especially formulas to be difficult. Most of the time when that happens Google or Bing comes to rescue. In this post I plan to write down the tips that I used which I hope will be useful to others and to myself in future. When we want to do a summary sheet in a Excel file, bringing the last value in a particular range of cells (say a column). For picking the last non empty number from a range…