Excel not opening maximized mode

In case if the sheet is in protected mode sometimes it will open in restored mode. If you trying making the sheet unprotected it will come back to the original mode.

-Jijin

Eagle Story - Life Span of an Eagle

The Eagle Story... Changes for Survival....

EAGLE can live up to 70 years, but to reach this age, the eagle must make a hard decision in its' 40's

Its' long & flexible talons can no longer grab prey which serves as food, Its' long & sharp beak becomes bent

Its' old-aged & heavy wings, due to their thick feathers, become stuck to its' chest & make it difficult to fly

Then eagle is left with only 2 options: die or go through a painful process of change which lasts 150 days.

The process requires that eagle fly to a mountain & the eagle knocks its' beak against a rock until it plucks it out

After this, eagle will wait for a new beak to grow back. When its' new talons grow back, the eagle starts plucking its' old-aged feathers & after 5 months, eagle can take its' flight of rebirth & lives for 30 more years

Moral of Story...

Many times, in order to survive, we have to start a change process. We sometimes need to get rid of Old memories, habits & other past traditions. Only freed from past Burdens, we can take advantage of the present. So lets Change for a better tomorrow!!!

-Jij

What is new in Excel 07

New Look
•Microsoft Office Button
•Ribbon
•Quick Access Toolbar
•Dialog Box Launcher
New Features in Excel 2007
•Multiple Themes available
•Page Layout View
Improved Features
•Excel 2007 now supports 1,048,576 rows and 16,384 columns.
•Sorting and Filtering option
•Excel 2007 tables previously referred to as lists
•Creating Charts with rich visual enhancements
•Rich Conditional Formatting to explain your data visually.
•Pivot Table and Charts
•External Data Connection
Saving Spreadsheets
•Use as a previous version
•Save as PDF or XPS

Hyper V Demo & Excel 2007 ITPro Event 30 May 2009

Watch out for the next UG @ MS by BITPro...
04.00PM to 04.15PM - Registration
04.15PM to 04.30PM - Welcome
04.30PM to 05.30PM - Demo Hyper-V - Mr. Aresh Sarkari
05.30PM to 05.45PM Tea Break
05.45PM to 06.45PM Excel 2007 – Introduction and Overview - Mr. Jijin KV
06.45PM to 07.15PM Fun Activity
07.15PM to 07.30PM Closing Note

Date: 30-May-2009
Time: 04.00PM to 08.00PM
Entry is Free for All

Venue: Chervil Training Room, Signature Building, Microsoft Corp. Bangalore -560017.

Reserve your seat at https://www.clicktoattend.com/invitation.aspx?code=138746
For more details keep visit our group site http://www.bitpro.in/

RSVP: Mr.S.Kaliyan, 9740991870 / Mr.Jijin, 9886265058

Three useful shortcuts in Excel Cell reference

1.CTRL+` -> Shows the formula used
2.CTRL+: -> Retrieves todays Time
3.CTRL+; -> Retrieves todays Date

How to manage your e-mails

This was one good post i found in MS!!! Worth reading!!!

Use the "Four D's for Decision Making" Model
The "Four D's for Decision Making" model (4 D's) is a valuable tool for processing e-mail, helping you to quickly decide what action to take with each item and how to remove it from the Inbox.
Decide what to do with each and every message
How many times have you opened, reviewed, and closed the same e-mail message over and over? Some of those messages are getting lots of attention but very little action. It is better to handle each e-mail message only once before taking action—which means you have to make a decision as to what to do with it and where to put it. Under the 4 D's model, you have four choices:
1.Delete it
2.Do it
3.Delegate it
4.Defer it
DELETE IT
Generally you can delete about half of all the e-mail you get. But some of you shudder when you hear "delete." You're hesitant to delete messages for fear you might need them at some point. That's understandable, but ask yourself honestly: What percentage of information that you keep do you actually use?
If you do use a large percentage of what you keep, then what you're doing is working. But many of you are keeping a lot more than you use. Here are some questions to ask yourself to help you decide what to delete:
1.Does the message relate to a meaningful objective you're currently working on? If not, you can probably delete it. Why hang on to information that doesn't relate to your main focus?
2.Does the message contain information you can find elsewhere? If so, delete it.
3.Does the message contain information that you will refer to within the next six months? If not, delete it.
4.Does the message contain information that you're required to keep? If not, delete it.
DO IT (in less than two minutes)
If you can't DELETE IT, then decide, "What specific action do I need to take?" and "Can I DO IT in less than two minutes?" If you can, just DO IT.
There is no point in filing an e-mail or closing an e-mail if you can complete it in less than 2 minutes. Try it out—see how much mail you can process in less than 2 minutes. I think you will be extremely surprised and happy with the results. You could file the message, you could respond to the message, or you could make a phone call. You can probably handle about one third of your e-mail messages in less than two minutes.
DELEGATE IT
If you can't DELETE IT or DO IT in two minutes or less, can you DELEGATE IT?
If you can delegate it, do it right away. You should be able to compose and send the delegating message in about two minutes. Once you delegate the action, delete the original message or move it into your e-mail reference system.
DEFER IT
If you cannot DELETE IT, DO IT in less than two minutes, or DELEGATE IT, then the action required is something that only you can accomplish and that will take more than two minutes. Because this is your dedicated e-mail processing time, you need to DEFER IT and deal with it after you are done processing your e-mail. You’ll probably find that about 10 percent of your e-mail messages have to be deferred.
There are two things you can do to defer a message: turn it into an actionable task or turn it into an appointment. When you're using Outlook 2003, you can DEFER e-mails with actions by turning the e-mail into a task on your Task List. Name the task to clearly state what action is required so that you don't have to reopen the e-mail message. The result is a clearly defined list of actions in your task list that you can prioritize and schedule to complete on your Calendar.

Excel Cell Today Date

Date: Ctrl+Semicolon Time: Ctrl+Shift+Semicolon To get Excel to update the sheet everytime you open it with today's date, just put the following into the formual bar of the cell...
=TODAY()

Excel Macros - Highlighting a Cell

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Excel.Range)

Static OldRange As Range

On Error Resume Next

Target.Interior.ColorIndex = 4' Specify the number for colour

OldRange.Interior.ColorIndex = xlColorIndexNoneSet OldRange = TargetEnd Sub

Session on Team

To bring back the team bonding, i conducted a session on teaming and what all of us need to do to bring in improvement. It was appreciated and the document was clear and precise.
Some Key Topics Covered:
-> Win as a Team
-> Are we bonded?
-> Are we on Track?
-> Are we leaders?
-> Are we Skilled?
-> Happening around
-> Are we really happy?
-> Thank you.
This perfectly helped me in motivating the team and bringing back the confidence. Can be tried out for your team also :)
Cheerz,
Jij

Windows 7 RC - First Bug

The first documented bug in the Windows 7 Release Candidate (build 7100) is a doozy.
Yesterday, Microsoft published Knowledge Base article 970789, which provides details of a problem that affects the 32-bit (x86) English-language version of Windows 7 build 7100. The problem, in short, is that the installer incorrectly sets access control lists (ACLs) on the root of the system drive. The longer version is described as follows:
In the English version of Windows 7 Release Candidate (build 7100) 32-bit Ultimate, the folder that is created as the root folder of the system drive (%SystemDrive%) is missing entries in its security descriptor. One effect of this problem is that standard users such as non-administrators cannot perform all operations to subfolders that are created directly under the root. Therefore, applications that reference folders under the root may not install successfully or may not uninstall successfully. Additionally, operations or applications that reference these folders may fail.
For example, if a folder is created under the root of the system drive from an elevated command prompt, this folder will not correctly inherit permissions from the root of the drive. Therefore, some specific operations, such as deleting the folder, will fail when they are performed from a non-elevated command prompt. Additionally, the following error message appears when the operation fails:
Access is denied.
Furthermore, the missing security descriptor entries protect non-admin file operations directly under the root.
A hotfix is available as an important update that should be delivered and installed automatically by Windows Update, assuming you have set up automatic updates. On one test system that I checked just now, the update had already been installed overnight. On two other systems, the update had been downloaded but was awaiting installation.
The hotfix package fixes the security descriptor of the root of the system drive, but it does not repair applications that are already installed, nor does it affect the permissions of folders that were created after the installation.

Windows 7 RC - Getting Started

What are the hardware requirements?
Actually, the hardware requirements for Windows 7 RC are relatively mild. I suppose that’s because Windows Vista has been out for over two years and we’ve all had time to get used to the idea of advanced hardware requirements from an operating system combined with the fact that hardware that was once deemed as a steep-and-expensive increase has become commonplace.
In any case, the minimum system requirements you’ll need for Windows 7 include:
DVD burner/drive
1 GHz or faster 32-bit (x86) or 64-bit (x64) processor
1 GB RAM (32-bit) / 2 GB RAM (64-bit)
16 GB available disk space (32-bit) / 20 GB (64-bit)
DirectX 9 graphics processor with WDDM 1.0 or higher driver
My test system, on which I installed the 32-bit version, has a DVD burner, AMD Athlon 64 X2 3800+ processor, 1 GB RAM, an NVIDIA GeForce 6100 nForce 405 onboard video, and plenty of disk space. (For this particular test system, I installed an additional SATA hard disk, switched the cables, and installed Windows 7 RC on it. When I need to switch back to Vista, I just shut down and switch the cables. While it may sound like a crude mechanism, it is relatively quick to make the switch due to the SATA connectors, and I can reformat and reinstall at will without having to worry about dismantling my Vista test configuration.)
Can anyone get in on the release candidate program?
In days gone by, you had to be signed up/registered in the testing program in order to take part in release candidate testing, but not with Windows 7 RC. In fact, Microsoft is treating the RC like shareware. Anyone can download it for free and use it for a limited time before actually purchasing it. However, instead of a 30-, 60-, or 90-day trial, Microsoft is giving you 300 days. On March 1, 2010, the RC will start shutting down every two hours and will completely stop working on June 1, 2010.
To get your free copy, just go to the Windows 7 Release Candidate Download page and follow the instructions. The RC will be available for download at least through July 2009, and Microsoft is not limiting the number of product keys.
What’s new in this version?
The short answer is plenty! If you’ve been following my blogs over the past few months, you already have an overview of many of the new features, such as a new Taskbar, Jump Lists, Aero Snap, Aero Peek, Problem Steps Recorder, file system Libraries, User Account Control Settings, and enhancements to Task Manager and Resource Monitor just to name a few. At this point, Windows 7 RC is said to be feature-complete, which means that everything that was planned is now in the operating system
One of the hottest new features being introduced as an add-on with the RC version is XP Mode, which will allow you to run older apps that work fine in XP but are incompatible with 7 in a virtual environment. XP Mode is based on Microsoft’s Virtual PC and runs Windows XP SP3 in a virtual machine. Keep in mind that XP Mode is available only with Professional, Ultimate, and Enterprise editions and requires that your CPU support hardware virtualization.
Other new features being introduced with the RC include BitLocker To Go, which extends the BitLocker drive encryption feature to USB removable drives. Another new security feature aimed at removable drives is actually something that Microsoft removed from the operating system — AutoRun. When you connect a removable drive, malware will no longer be able to piggyback off of AutoRun to launch its attack.
While not as crucial as some of the other features in the operating system, you’ll now find a plethora of new multimedia-based features, new sound schemes, new themes, and new desktop wallpapers, including a picture shuffle that changes your wallpaper every 30 minutes. And there’s much, much more…
Where can I learn more?
Of course, I’ll be covering Windows 7 RC in more detail in upcoming blogs, so you learn more right here at TechRepublic. You should also frequent Microsoft’s Windows 7 page and sign up for the Windows Vista and Windows 7 Report newsletter.

Windows Home Server at a glance

If you have multiple PCs with increasingly large amounts of digital photography, music, video, and documents, then protecting, organizing, and connecting this digital media can be a challenging task. Help with managing your digital dilemmas has arrived. Take a look.

1. Digital memories and media stored and organized in a central location
   Home computers backed up daily, automatically
   Simple restore of lost files or even entire hard drive contents
   Complete access to files from both inside and outside the home
   A secure and personalized website address for sharing photos and home videos
   Easily add storage space and new software capabilities
   

Windows Home Server Image Based Backup...

We all know that we should backup our computers in case of hard drive failure, disaster, or simple wear and tear. How often do we backup our important information and ensure the data is safe and available. Mostly we worry only when the data is lost. Windows Home Server and its automatic image based backup software technology, gives you peace of mind and the ability to quickly and easily restore your digital life even if your system have gone for a toss.

What is new in Exchange 2010????

Microsoft Exchange Server 2010 brings a new and rich set of technologies, features, and services to the Exchange Server product line. This topic lists many of the new features and functionality that are included in Exchange 2010

New Rights-Protected E-Mail Functionality with Active Directory RMS
New Transport and Routing Functionality
New Permissions Functionality
New High Availability Functionality
New Messaging Policy and Compliance Features
New Outlook Web Access Features
New Unified Messaging Features
Web Management Interface
New Exchange Core Store Functionality
New Administration Functionality in the Exchange Management Console
New Administration Functionality in the Exchange Management Shell

Exchange Server 2010 Beta Download Available

The public Exchange Server 2010 Beta is now available. Microsoft Exchange 2010 helps you achieve new levels of reliability and performance by delivering features that simplify your administration, protect your communications, and delight your users by meeting their demands for greater business mobility. Designed and developed to work on-premises and as an online services, Microsoft Exchange 2010 introduces a new integrated e-mail archive and features to reduce costs and improve the user experience. Evaluate Microsoft Exchange Server 2010 Beta today!

Issues with Windows 7

Intel Core2Duo with 1 GB RAM... Configuration
->Explorer gets killed/hung very frequently.
->Issues while accessing the office application. System hungs...
->Windows Movies when run system hung with the display getting blured...
Mostly issues might be with drivers...
This is few of our team experience.
Performance wise it does really good...

Bangalore IT Pro - Community Tech Day

We had conducted the Bangalore IT Pro Community Tech Day and was very successful with a crowd of around 170 people. We had a very interactive Session by Mr.Ravi Sankar (MS Technology Evangelist) who took us through the Secure System - MS and after that we had a delicious lunch and then had some fun which helped in closing the event much successfully. There were lots of goodies which was given away as part of the session as well had a lucky draw... Please visit www.bitpro.in and ensure that you are a part of the team....
Few Pics attached.

Regards,
Jij
Group Manager
BIT Pro.

What is the Windows Experience Index?

Windows Experience Index tells you how good is your machine configuration to run the given product. According to this the features will function in your system... The capability of your machine is rated as "Base Score". A higher base score generally means that your computer will perform better and faster than a computer with a lower base score, especially when performing more advanced and resource-intensive tasks.

How to View it?

->Click to open Performance Information and Tools available in Control Panel.

Here are general descriptions of the experience you can expect from a computer that receives the following base scores:
A computer with a base score of 1 or 2 usually has sufficient performance to do most general computing tasks, such as run office productivity programs and search the Internet. However, a computer with this base score is generally not powerful enough to run Windows Aero, or the advanced multimedia experiences that are available with Windows 7.
A computer with a base score of 3 can run Windows Aero and many features of Windows 7 at a basic level. Some of the Windows 7 advanced features might not have all of their functionality available. For example, a computer with a base score of 3 can display the Windows 7 theme at a resolution of 1280 × 1024, but might struggle to run the theme on multiple monitors. Or, it can play digital TV content but might struggle to play high-definition television (HDTV) content.
A computer with a base score of 4 or 5 can run all features of Windows 7 with full functionality, and it can support high-end, graphics-intensive experiences, such as multiplayer and 3‑D gaming and recording and playback of HDTV content. Computers with a base score of 5 were the highest performing computers available when Windows 7 was released.

Cheerz,

Jij....

Windows 7 - Installation First Experience

Yesterday i had installed Windows 7. I had good experience, since it just took me 17 mins to complete the installation and the performance of ma machine also increased... The microsoft applications are funtioning well and till now havent faced any problems...
Some of the features i liked in Windows 7 are (My First Experience):
-> Simple and cute!!!
-> Start up is damn fast
-> Browsing through the task manager. Thumbnail.
-> Auto repair for any errors and feedback providing...
-> Aero Options - "Aero Shake", "Aero Snap", "Aero Peek
Good job Microsoft team... Atlast you did it :)

Cheerz,
Jij

Microsoft IE8 brings you inprivate browsing

Now we could browse whatever we want whether it is mails, shop or any unautorised site ;) without getting tensed of someone knowing what we have browsed. Windows IE 8 brings to you inPrivate browsing that will not leave any trail of what we have browsed.

You can start InPrivate Browsing by opening a new tab and selecting Browse with InPrivate or selecting it from the Safety button on the top right corner of the browser window. Once you complete this action, Internet Explorer 8 will launch a new browser session that won't record any information, including searches or webpage visits. To end your InPrivate Browsing session, simply close the browser window.

What is Thumbs.db? How to remove?

Thumbs.db is a cache file for thumbnails shown in Windows Explorer, and they litter your hard drive.

How to Remove????

From “My Computer” click on the “Tools” menu item
Click on “Folder Options”, and the folder options dialog will appear
Click on the “View” tab
Check the “Do not cache thumbnails” option
You may also want to search your hard drive for “Thumbs.db” and delete all of them.

Survival in year 2009.. Plan now!!!

1: Make a specific plan
I’m not talking about making a wish list which, like New Year’s resolutions, will be forgotten by the third week of January. You want a plan that has specific goals for your job (what’s the best role for you next?) and your income (exactly how much would you like to be making by the end of 2009?). Writing down your plans makes them concrete, and it’s more likely you will attain them.
2: SWOT yourself
Be honest with yourself. Review your strengths — like what you’ve got that can move you ahead; weaknesses — like those things you have or do that are holding you back; opportunities — things you can pursue at the company or in the industry; and threats — things that can derail you or sabotage your career advancement.
3: Update your resume
Smart careerists are always ready for the next opportunity. Taking time to review and modify your resume before you want to send it to someone makes it a better product. This is often your first introduction to a new employer or boss — so make sure it’s topnotch.
4: Invest in your career
Most people forget they really have two jobs. The first is to do what you get paid for and do it better than others. The second is to do what’s required to ensure that your career isn’t left to someone’s wrong opinions that were made in your absence. Be in the office when your boss is. It gives you additional opportunity to let him or her get to know you for things other then the job you’re currently filling.
5: Get financially smart
Get involved with managing your financial affairs. Paying attention to money matters is one of the smartest and easiest ways to improve your personal balance sheet. There are many books and online courses on the subject of money management basics. Looking after your financial health doesn’t take a lot of time; but it could save your life.
6: Develop a sense of urgency
Many people think that working hard, being busy, and burning a lot of energy is equal to managing their career and life. It’s not. Developing a sense of urgency means knowing how to pick through all those “to-do’s” and focusing your time and energy on just the ones that count.
7: Look up, not down
When downsizing is the operative word, developing your team is no longer the smartest way to ensure success. Spend less time with your staff members and more time looking after your boss’ needs. When you show that you’re working hard to make him or her look good, you’ll stand out from the crowd. And your boss will be more likely to provide you with the resources that you and your team need to do the job better.
8: Update your skill set
It pays to demonstrate that you are interested in “upgrading” yourself — and in 2009, your ability to grow may be more important than ever. With unemployment now at record highs, demand for jobs greatly exceeds supply. Not staying on par with colleagues and those vying for your job will be a death knell. Take seminars, do coursework, or leverage other vehicles to get on the leading edge and thus, maximize your personal value to the organization.
9: Self promote
Face it: Often, decisions are made affecting who gets moved upward and who gets downsized without your involvement. It’s important that the decision makers know you and what you are doing. Have regular meetings with your boss or send regular e-mails to update those in charge about your contributions.
10: Look after your loved ones
One way or another, when 2009 is done and over, you’ll still be here and you’re going to want those you care about to still be with you. While it’s important to look after your job and career, don’t neglect those who make life most worthwhile. Tell them you care and spend time with them “just for fun.”

So plan it now... Do not be late... If you are just worried and waiting for your number then you need to think again...

Cheerz,
Jij

Lets Start Blogging

Its quite sometime now i havent been an active blogger... So i am back now... Lets Start Blogging!!!