Weather in Bangalore : 29°C as at 09:45
  • ~WISH YOU ALL A VERY HAPPY AND WONDERFUL MOMENT.~
Week's Proverb : A nod is as good as a wink.-(To a person who is ready to understand or undertake something, any subtle signalling of it is sufficient)

Theme of the Week

About Me

It is my first time to say hello and do some self introduction to everybody here online. My name is Ashis.P.Donthi, male, 27, from Bangalore, India. I like reading, and do some collections in my spare time.

About Me

It is my first time to say hello and do some self introduction to everybody here online. My name is Ashis.P.Donthi, male, 27, from Bangalore, India. I like reading, and do some collections in my spare time.

About Me

It is my first time to say hello and do some self introduction to everybody here online. My name is Ashis.P.Donthi, male, 27, from Bangalore, India. I like reading, and do some collections in my spare time.

About Me

It is my first time to say hello and do some self introduction to everybody here online. My name is Ashis.P.Donthi, male, 27, from Bangalore, India. I like reading, and do some collections in my spare time.

About Me

It is my first time to say hello and do some self introduction to everybody here online. My name is Ashis.P.Donthi, male, 27, from Bangalore, India. I like reading, and do some collections in my spare time.

Showing posts with label Tutorial. Show all posts
Showing posts with label Tutorial. Show all posts

Tuesday, March 22, 2011

How to use Macros

1. Macros


Use the tools in Word's Word Options dialog box to display the Developer tab on the ribbon.

Macros are a great way to automate your work in Microsoft Word. A macro is a set of tasks that can be performed by pressing a shortcut key, clicking a Quick Access toolbar button, or by selecting the macro from a list.

Word gives you a wide variety of options for creating your macro. It can include any command in Microsoft Word.

The options for creating a macro are on the Developer tab of the ribbon. By default, Word 2007 doesn't display the options for creating a macro. To display the options, you must turn on Word's Developer tab.

To display the Developer tab, Click the Office button and select Word Options. Click the Popular button in the left side of the dialog box.

Select Show Developer tab in the Ribbon. Click OK. The Developer tab will appear to the right of the other tabs on Word's ribbon.

2. Preparing to Record Your Word Macro


In Word's Record Macro dialog box, you can name and describe your custom macro. You also have options for creating shortcuts to your macro.

Now you're ready to get started creating your macro. Open the Developer tab and click Record Macro in the Code section.

Enter a name for the Macro in the Macro Name box. The name you choose can't be the same as a built-in macro. Otherwise, the built-in macro will be replaced with the one you create.

Use the Store Macro in box to select the template or document in which to store the macro. To make the macro available in all documents you create, select the Normal.dotm template. Enter a description for your macro.

You have several different options for your macro. You can create a Quick Access toolbar button for your macro. You can also create a keyboard shortcut, so that the macro can be activated with a hotkey.

If you don't want to create a button or shortcut key, click OK now to begin recording; to use your macro, you will need to click Macros from the Developer tab and select your macro. Proceed to step 5 for more instructions.

3. Creating a Quick Access Toolbar Button for Your Macro


Word let's you create a button for your custom macro on the Quick Access toolbar.

To create a Quick Access button for your macro, click Button on the Record Macro box. This will open the Customize Quick Access Toolbar options.

Specify document in which you would like the Quick Access toolbar button to appear. Select All Documents if you want the button to appear while you're working on any document in Word.

In the Choose Command From dialog box, select your macro and click Add.

To customize your button's appearance, click Modify. Under Symbol, select the symbol you would like to display on your macro's button.

Enter a display name for your macro. This will be displayed in ScreenTips. Click OK. Click OK.

For instructions on recording the macro, continue to step 5. Or, keep reading for help creating a keyboard shortcut for your macro.

4. Assigning a Keyboard Shortcut to Your Macro


Word lets you create a custom shortcut key for your macro.

To assign a keyboard shortcut to your macro, click Keyboard in the Record Macro dialog box.

Select the macro that you're recording in the Commands box. In the Press new shortcut key box, enter your shortcut key. Click Assign and then click Close. Click OK.

5. Recording your Macro

After you select your macro options, Word will automatically begin recording the macro.

You can use keyboard shortcuts to perform the actions you would like to include in the macro. You can also use the mouse to click buttons on the ribbons and dialog boxes. However, you cannot use the mouse to select text; you must use the keyboard navigation arrows to select text.

Note that everything you do will be recorded until you click Stop Recording in the Code section of the Developer ribbon.

-ANSAHNIDSU CORPORATION

Sunday, January 09, 2011

JavaScript Part 2

Click the below link to download the JavaScript Codes



Happy Learning
-ANSAHNIDSU

Thursday, December 02, 2010

Simple Science Experiments For KIDS

1. Make an Egg Float in Salt Water

An egg sinks to the bottom if you drop it into a glass of ordinary drinking water but what happens if you add salt? The results are very interesting and can teach you some fun facts about density.

What you'll need:

  • One egg
  • Water
  • Salt
  • A tall drinking glass

Instructions:

  1. Pour water into the glass until it is about half full.
  2. Stir in lots of salt (about 6 tablespoons).
  3. Carefully pour in plain water until the glass is nearly full (be careful to not disturb or mix the salty water with the plain water).
  4. Gently lower the egg into the water and watch what happens.

What's happening?

Salt water is denser than ordinary tap water, the denser the liquid the easier it is for an object to float in it. When you lower the egg into the liquid it drops through the normal tap water until it reaches the salty water, at this point the water is dense enough for the egg to float. If you were careful when you added the tap water to the salt water, they will not have mixed, enabling the egg to amazingly float in the middle of the glass.


2. Dissolving Sugar at Different Heats

Learn about solutions as you add more and more sugar cubes to different temperature water. This easy experiment shows that you can only dissolve a certain amount and that this changes as the water gets hotter.

What you'll need:

  • Sugar cubes
  • Cold water in a clear glass
  • Hot water in a clear glass (be careful with the hot water)
  • Spoon for stirring

Instructions:

  1. Make sure the glasses have an equal amount of water.
  2. Put a sugar cube into the cold water and stir with the spoon until the sugar disappears. Repeat this process (remembering to count the amount of sugar cubes you put into the water) until the sugar stops dissolving, you are at this point when sugar starts to gather on the bottom of the glass rather than dissolving.
  3. Write down how many sugar cubes you could dissolve in the cold water.
  4. Repeat the same process for the hot water, compare the number of sugar cubes dissolved in each liquid, which dissolved more?

What's happening?

The cold water isn't able to dissolve as much sugar as the hot water, but why? Another name for the liquids inside the cups is a 'solution', when this solution can no longer dissolve sugar it becomes a 'saturated solution', this means that sugar starts forming on the bottom of the cup.

The reason the hot water dissolves more is because it has faster moving molecules which are spread further apart than the molecules in the cold water. With bigger gaps between the molecules in the hot water, more sugar molecules can fit in between.


3. Invisible Ink with Lemon Juice

Making invisible ink is a lot of fun, you can pretend you are a secret agent as you keep all your secret codes and messages hidden from others. All you need is some basic household objects and the hidden power of lemon juice.

What you'll need:

  • Half a lemon
  • Water
  • Spoon
  • Bowl
  • Cotton bud
  • White paper
  • Lamp or other light bulb

Instructions:

  1. Squeeze some lemon juice into the bowl and add a few drops of water.
  2. Mix the water and lemon juice with the spoon.
  3. Dip the cotton bud into the mixture and write a message onto the white paper.
  4. Wait for the juice to dry so it becomes completely invisible.
  5. When you are ready to read your secret message or show it to someone else, heat the paper by holding it close to a light bulb.

What's happening?

Lemon juice is an organic substance that oxidizes and turns brown when heated. Diluting the lemon juice in water makes it very hard to notice when you apply it the paper, no one will be aware of its presence until it is heated and the secret message is revealed. Other substances which work in the same way include orange juice, honey, milk, onion juice, vinegar and wine. Invisible ink can also be made using chemical reactions or by viewing certain liquids under ultraviolet (UV) light.


4. Will the Ice Melt and Overflow?

At first thought you might think that an ice cube sitting at the very top of a glass would eventually melt and spill over the sides but is this what really happens? Experiment and find out!

What you'll need:

  • A clear glass
  • Warm water
  • An ice cube

Instructions:

  1. Fill the glass to the top with warm water.
  2. Gently lower in the ice cube, making sure you don’t bump the table or spill any water over the edge of the glass.
  3. Watch the water level carefully as the ice cube melts, what happens?

What's happening?

Even though the ice cube melted the water doesn’t overflow. When water freezes to make ice it expands and takes up more space than it does as liquid water (that’s why water pipes sometimes burst during cold winters). The water from the ice takes up less space than the ice itself. When the ice cube melts, the level of the water stays about the same.


5. Water Molecules on the Move

This experiment is great for testing if hot water molecules really move faster than cold ones. Pour some water, drop in some food coloring and compare results.

What you'll need:

  • A clear glass filled with hot water
  • A clear glass filled with cold water
  • Food coloring
  • An eye dropper

Instructions:

  1. Fill the glasses with the same amount of water, one cold and one hot.
  2. Put one drop of food coloring into both glasses as quickly as possible.
  3. Watch what happens to the food colouring.

What's happening?

If you watch closely you will notice that the food coloring spreads faster throughout the hot water than in the cold. The molecules in the hot water move at a faster rate, spreading the food coloring faster than the cold water molecules which mover slower.


6. Steel Wool & Vinegar Reaction

Soak steel wool in vinegar and watch what happens as the iron in the steel begins to react with the oxygen around it. This fun science experiment for kids is great for learning about chemical reactions.

What you'll need:

  • Steel Wool
  • Vinegar
  • Two beakers
  • Paper or a lid (something to cover the beaker to keep the heat in)
  • Thermometer

Instructions:

  1. Place the steel wool in a beaker.
  2. Pour vinegar on to the steel wool and allow it to soak in the vinegar for around one minute.
  3. Remove the steel wool and drain any excess vinegar.
  4. Wrap the steel wool around the base of the thermometer and place them both in the second beaker.
  5. Cover the beaker with paper or a lid to keep the heat in (make sure you can still read the temperature on the thermometer, having a small hole in the paper or lid for the thermometer to go through is a good idea).
  6. Check the initial temperature and then monitor it for around five minutes.

What's happening?

The temperature inside the beaker should gradually rise, you might even notice the beaker getting foggy. When you soak the steel wool in vinegar it removes the protective coating of the steel wool and allows the iron in the steel to rust. Rusting (or oxidation) is a chemical reaction between iron and oxygen, this chemical reaction creates heat energy which increases the temperature inside the beaker. This experiment is an example of an exothermic reaction, a chemical reaction that releases energy in the form of heat.


-ANSAHNIDSU.

Happy Learning.

How to Format and Reinstall Windows XP

Click the below link to download the tutorial



Happy Learning
-ANSAHNIDSU

Wednesday, December 01, 2010

How to Delete Rows and Columns in MS Excel


The above pictures show how to delete rows and columns in an excel sheet.

Conditional Formatting

A small example to learn about conditional formatting.
In the example, the aim is to find the names in column A that are present in column C.

Tuesday, November 30, 2010

CSS

Click the below link to download the CSS Codes



Happy Learning
-ANSAHNIDSU

Saturday, November 27, 2010

JavaScript Part 1

Click the below link to download the JavaScript Codes

JavaScript Codes

Happy Learning
-ANSAHNIDSU

Monday, September 27, 2010

Links

Below are the links where you can find lots of stuff. ENJOY...

NIIT Softwares Niit related softwares (IT, Mathlab and Other PC softwares)
Wallpapers 2D and 3D Images
Music Ringtones, Music Bits, Theme Musics
Computer Softwares Convertors, Translators, Editors
My Tutorials Subjects related to Technology


NIIT Formats and Training needed

Keep Smiling...

Share

Twitter Delicious Facebook Digg Stumbleupon Favorites More

Free Domain
Audio Streamed by the BroadWave Streaming Audio Server by NCH Software