Monday, June 29, 2009

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

Monday, June 22, 2009

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

Thursday, May 28, 2009

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

Tuesday, May 26, 2009

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

Tuesday, May 19, 2009

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.

Thursday, May 14, 2009

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()