Techtites

The title of the post is a bit of a misnomer because the SUMIF function in Excel does not allow you to have more than condition.
Excel 2007 introduced the SUMIFS function which allowed for multiple conditions.
However, if you are using any version prior to Excel 2007 or if the persons who will be using your [...]

Posted by Ajay under Excel, Microsoft, Office, Software, Techtites Daily, Thursday, Tips and Tutorials
1 Comment

Microsoft has finally gone ahead and released Internet Explorer 8 Beta 1. This release is aimed at Web Developers and Testers to understand what Microsoft has in store.
Considering that the browser is still so fresh, an emulate Internet Explorer 7 button has been put in to browse the web similar to using Internet Explorer 7.
Five [...]

Posted by Ajay under Browsers, Internet Explorer, Microsoft, Software, Tech News
No Comments

I just received my new Dell Laptop today and it came preloaded with Windows Vista.
The first thing I noticed (and ofcourse which I knew about) was the User Account Control.
User Account Control is a brand new feature in Windows Vista that lets all users to run in normal user mode without administrator privileges; something that [...]

Posted by Ajay under Microsoft, Techtites Daily, Thursday, Tips and Tutorials, Windows
1 Comment

Every month, Microsoft releases a set of updates for Windows and the other software. It’s been nearly two years since Windows XP SP2 has been released and we have approximately 70 critical updates since then. Even if you have the Windows XP with SP2 installed, you need to visit the Microsoft Update site and download [...]

Posted by Ajay under Microsoft, Operating Systems, Techtites Daily, Tuesday, Windows
[2] Comments

In breaking news, News.com reports that Microsoft has been ordered to pay $1.5 billion to Alcatel-Lucent for the technology used to power MP3 audio in Windows.
The figure has been set as per the number of PCs sold with Windows in 2003.
MP3 technology has been jointly built by Fraunhofer and Alcatel-Lucent. This court ruling against [...]

Posted by Ajay under Legal, Microsoft, Multimedia, Tech News, Windows
No Comments

By default, the new Microsoft Office 2007 Suite saves files in the new format. e.g. Word files are now stored as .docx, Excel files are stored as .xlsx and so on.
The problem with this format is that it cannot be read on any Office installation below 2007. So, if you send this to a friend [...]

Posted by Ajay under Microsoft, Office, Software, Techtites Daily, Thursday
[3] Comments

Now, you know why I still haven’t upgraded to Vista!

Posted by Ajay under Fun, Microsoft, Windows
[4] Comments

Inside Windows Live Messenger reports that Windows Live Messenger is now out of beta.

Besides that, Messenger is available in 8 new languages, it is completely compatible with Windows Vista which was released yesterday.
You can now send an email invitation while adding a contact. This was missing in the beta.
There are several new features in 8.1 [...]

Posted by Ajay under Messengers, Microsoft, Software, Tech News
[3] Comments

ZDNet Blogs has a report about Bill Gates’ speech at the Davos World Economic Forum.
If you want to charge somebody $0.10 or $1 a month, that will just be a click…you won’t have to manage some funny thing or pay some big credit charge, where half of it goes to the clearing.
It appears [...]

Posted by Ajay under Microsoft, Tech News
[2] Comments