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.