Recording a basic macro.

.

CREATING A BASIC MACRO


Macro :- Macro is a shortcut to a task we do repeatedly.

Here we have practiced a basic macro which perform a series of actions just with a shortcut key (ctrl+r), now we will go through the process of recording a basic macro in a step by step manner.

STEP 1 :
Open an excel document,

STEP 2 :
On the tools menu click the Macro, and then click record new macro.

STEP 3:
In the name box enter a name for the macro.

STEP 4 :
Now enter a letter in the shortcut key box. The letter can be any key on the keyboard special charecters. (In this practice I have entered R)

STEP 5 :
Now in the storage box, click the location you want to store the macro.

STEP 6:
Click OK.

STEP 7 :
Carry outou want to record.(in this practice sheet we have entered three words in tree cells and recorded the font, bold center and coloring actions.)

STEP 8 :
Now with the stop recording toolbar stop recording.

STEP 9 :
Now save the work sheet.

STEP 10 :Now the macro is saved on the worksheet and whenever I have to perform all these actions , I just need to enter ctrl+r they will be done automatically.

.

The Formatting Toolbar

.

Tool bar 2 :- The Formatting Toolbar

The Formatting toolbar is located beneath the Standard toolbar bar, has buttons for various formatting operations like changing text size or style, formatting numbers and placing borders around cells.

FONT:
Changes the font of the selected text

FONT SIZE:
Changes the size of selected text and numbers

BOLD:
Makes selected text and numbers bold

ITALIC:
Makes selected text and numbers italic

UNDERLINE:
Underlines selected text and numbers

ALIGN LEFT :
Aligns to the left with a ragged right margin

CENTER:
Centers the selected text

ALIGN RIGHT:
Aligns to the left with a ragged right margin

MERGE AND CENTER:
Merges two or more selected cells and centers the entry

CURENCY STYLE:
Currency Style - Formats selected text to display currency style

PERCENT STYLE:
Percent Style - Formats selected cells to display percent

COMMA STYLE:
Comma Style - Formats selected cells to display commas in large numbers

INCTREASE DECIMAL:
Increase Decimal - Increases the number of decimals displayed after the decimal point

DECREASE DECIMAL:
Decrease Decimal - Decreases the number of decimals displayed after the decimal point

DECREASE INDENT:
Decreases the indent to the previous tab stop

INCREASE INDENT:
Indents the selected paragraph to the next tab stop

BORDERS:
Adds or removes a border around selected text or objects

FILL COLORS:
Fill color- Fills the selected colour in a selected area.

FONT COLOR:
Formats the selected text with the color you click


REFERENCES :

1.http://www.internet4classrooms.com/excel_toolbar_formatting.htm

2.http://www.utexas.edu/its/training/handouts/UTOPIA_ExcelGS/

.

The Standard Toolbar

.

Tool bar 1:- The Standard Toolbar

Above figure is the image of an excel Standard toolbar, when we look at this toolbar The buttons, from left to right are: New , Open , Save,Email, Print, Print Preview, Spell Check, Cut, Copy, Format Paint, Undo, Redo, AutoSum, Paste Function , Sort Ascending, Sort Descending, Chart Wizard, Zoom, and HelpThe



1. “New”: Creates a new blank document based on your option.

2. Open: Opens or finds a file.


3. Save: Saves the active file with its current file name, Location and its format.

4. Email: Emails the file.

5. Print: Prints the active file - for more print options go to the File menu and select Print

6.Print priview: Shows how the document will look when you print it

7. Spell check: Spelling, grammar and writing style checker

8.Cut: Removes the selection from the document and places it on the work sheet.

9.Copy: Copies the selected item(s) to the worksheet.

10.Paste: pastes the selected items to worksheet.

11.Format paint: Copies the format from a selected object or text and applies to other objects or text

12.Un do: Reverses the last command, use pull-down menu to undo several steps

13.Re do: Reverses the action of the Undo button, use the pull-down menu to redo several steps

14.Auto sum: Adds numbers automatically, and suggests the range of numbers to be added

15.Paste Function:Pastes the selected objects automatically in any choosen location.

16. Sort Ascending: This function will autometically sort the selected group into ascending order.

17. Sort Descending: This function will automatically sort the selected group into descending order.

18. Chart Wizard: Guides you through the steps for creating a chart or graph.

19. Zoom: Enlarge or reduce the display of the active document

20. Help: This Will help on any issue during the preperation of work sheet.


References:
http://www.infoworld.com/

.

WEEKLY TASK TABLE

Hello friends,

This is my weekly task shedule which has been successfully finished by myself during this week. I will be back next week with a new task table and will let you know whats new in this head !

Till then...Take care and Have a good time.

.

The ABS function in Excel

The ABS Function In excel
If you need to determine the absolute value of a number, you use the ABS function. It returns the positive equivalent of any value referenced. Thus, if you wanted the absolute value of the sum of cell A1 and cell A2, you would use the following format:

{ =abs(sum(A1:A2)) }

The Average function in Excel.

The average function in excel

The average function finds the average of the specified data. (Simplifies adding all of the indicated cells together and dividing by the total number of cells.) The syntax is as follows.

=Average (first value, second value, etc.)

SUM function in excel

THE SUM FUNCTION IN EXCEL:

This is the most basic and widely used function in excel.The format of many of the functions is very similar to the sum function.The function is generally typed as follows: =sum(cell1,cell2)Typically you are asking excel to calculate the total sum of the numbers in the range of cell1 to cell2

.