Monday 17 September 2012

Create Keyboard Shortcuts to Insert Symbols in Word and Excel

Hi......
Office has many symbol which is not available in keyboard but we write them using symbol 
Let’s start with Word
, which is the easiest. In Word 2003, press InsertSymbol, which engages the Symbol screen (see screenshot below). In Word 2007, press Insert on the Ribbon and then click on SymbolMore Symbols.

Develop by Raj Kumar

Develop By Raj Kumar

Be careful when you are going to use a key click in shortcut textbox under circle press key which you which
you want to use. You can't type in shortcut key  text box click assine.

Excel

In Excel 2003, press Tools and select the AutoCorrect Options. In Excel 2007, click the Office button and Excel Options. Then click on Proofing on the left of the dialog box and click on AutoCorrect Options.

Develop by Raj Kumar





Handle more than one button event in java

In computer science an event is an action that is usually initiated outside the scope of a program and that is handled by a piece of code inside the program. GUI based programming is based on event, if you want handle event of a button in java (Applet,Swing) then you have to use ActionListener interface and implements actionPerformed funtion.We use more than one button in java program for handle each button event individually for achieve this we mustidentified each button event uniquely. You can identified button by its name or its text value, text value is not good becouse there can be same text on more than one button. Getting Button name is more usefull conside following program.....
import java.applet.*;
import java.awt.*;
import java.awt.event.*;
public class ButtonEventDemo extends Applet implements ActionListener
{  
       Button bt1,bt2,bt3;   Label lbl;  
       public void init() 
       {     
            bt1=new Button("Button1");   
            bt2=new Button("Button2");
            bt3=new Button("Button3");     
           lbl=new Label("Label");    
           Add(bt1);        Add(bt2);      
           Add(bt3);        Add(lbl);      
           bt1.addActionListener(this);     
           bt2.addActionListener(this);        
           bt3.addActionListener(this);  
      } 
      public void actionPerformed(ActionEvent e)
      {     
           // String s=e.getActionCommand();       
          // if(s=="Button1")     
          //  {      
         //             lbl.setText("Clicked Button 1");   
         //   }       
         //   else     
         //   {      
         //             lbl.setText("Clicked Button 2");     
        //    }         
             Object ob=e.getsource();           
             if(ob.equals(bt1)                
                 lbl.setText("Clicked Button 1");      
             else          
             {                
                   if(ob.equals(bt2)                   
                      lbl.setText("Clicked Button 2");                 
                  else                       
                       lbl.setText("Clicked Button 3");           
              }
         }

                  
String s=e.getActionCommand();
this command will set text of control which create control in s e.g.  if button clicked then s will hold Button1 textso we can check control text to uniquely identified a control but its not so good because there can be same text of more than one control.                 
                Object ob=e.getsource();
this line initialize ob with Button reference which name is bt1 if bt1 is clicked otherwise other control instanceso it is useful  to uniquely identified button because button name always unique in a program . 

Saturday 15 September 2012

Make your own list in excel 2003 and 2007

Excel has a powerful feature which enable user to input by using drag operation we have use this when we want to write month name we'll just have to write jan or January and drag it excel will automatically fill all remaining month name.
You can make your own custom list which help you to input in a fast way....


Excel 2003     

  • Type your list as in the image
  • Goto tools >Optoins>CustomLists>Select your list range>import

Excel 2007     

  • Type your list as in the image
  • Office Button > Excel Options > Popular > Edit Custom List.. > Select your list range > import

Friday 14 September 2012

How to create mirrored text in PowerPoint, in Word, and in Excel


A mirror image is a reflected duplication of an object that appears identical but reversed. As an optical effect it results from reflection
To create mirrored text with WordArt, follow these steps:
On the Drawing toolbar, click Insert WordArt.
Enter your Text which you want to make Rotate and make its Copy as in image...





  •  Now click on Upper In charge word art
  •  Click format
  • Then click rotate and select Flip Vertical