Create Simple Payroll Using MS-Excel 2007

Another simple application of MS-Excel 2007 is how to create a payroll worksheet with a complete description of logical formulas to calculate the worksheet data. Previously, I was posted how to create a worksheet table using the MS-Excel 2007, now it's just easy to create this table for this application called “simple payroll”. This is a simple operation using the logical operator. You need only the basic knowledge in using the MS-excel.

Now, this worksheet composed of the worksheet title, worksheet table compose also a label with a complete list of data by using the columns individually. And I use the auto fill tab of the worksheet cell to generate the employee’s number.

Remember that this worksheet only is just an example or a worksheet practice table of my own. And this is not related to the worksheet title stated above.

Now,I put the different parts and the logical formula inside of the autoshape that I’ve been use.So, I will clarify individually so that you will understand very clearly how to make this simple worksheet.

CREATE TABLE AND FORMULA

1. Worksheet Title- this is just located above the worksheet,commonly type in the column A row 1.The most common application is the merge and center along the worksheet table area.Remember that if there are one or more than worksheet title or subtitle.You cannot merge and center it, if you highlight all the preceding data in different rows.Example if you highlight the A1 and A2 with both data of your worksheets it will not execute.A popup window will appear and it would says “The selection contains a multiple values.Merging into one cell well keep the upper-left most data only”.

How to merge and center?

highlight the worksheet title from the 1st column until to the last column used by your worksheet table.

click the merge and center command of your home menu toolbar

and you will see the worksheet title will moved to the center

2. Worksheet Label- next of the worksheet title,this the top of the worksheet table.These are the head of the column as its have a name individually.The most common application here is the wrap text along the columns and the row using the formatting cells dialogue box.

How to wrap text worksheet label

• highlight the worksheet labels only
• right click inside the highlighted portion
• click format cells
• a dialogue box will appear
• click the alignment tab menu button
• under the text alignment drop down bar, select center both the horizontal and vertical
• then apply text control “wrap text” using the check box or click the check box
• then click ok button

3. Logical formula how to get the withholding Tax(w/tax)- this is use to calculate the withholding tax versus the starting salary using the percentage symbol.see the image above,click it to enlarge.

= is the logical function(the computer will not execute without the equals symbol, asterisk is the logical operator, and the 12 percent or .12 is the logical condition

4. Logical formula how to get the total deduction- this is use to calculate the series of data to be added in the worksheet.Either you can use the two formula specified in the image above.Where:

=sum is the logical function name,e9 is the 1^st ref.data,i9 is the last ref.data.You need to enclose the reference data and use colon to calculate from 1^st ref. data up to last ref. data.Use other formula using the logical operator + by adding the preceding columns of data.See the image above,click it to enlarge.

5. Net Salary- this is use to find the take home pay of the employee using the logical operator minus –.this will minus to the starting versus the total deduction.See the image above,click it to enlarge.

6. Grand Total- use to find the total amount of the entire rows in single column of the worksheet.With compose of multiple data inside.See the image above,click it to enlarge.

7. Autofill Tab- located along the worksheet cell,position right side bottom.This is use to apply or execute automatically the preceeding data to be calculated using the drag of mouse(pointer)after highlighting the one or more data.See the image above,click it to enlarge.

Microsoft Office PowerPoint Parts Use and Functions

Microsoft PowerPoint is simply defined as a presentation package and has an extension file of .ppt. Once you save it in your data storage or HDD. This is one of the most common uses of Microsoft automation. The term presentation package can be used by importing documents that came from word processing and worksheets. And either can be used to insert videos and music together with the images and sounds. And subject up for animations and effects using the different formats of the applications.

Indeed, Microsoft Corporation the developer of both the Windows Operating System and the MS-office developed and enhanced both programs. So, therefore, it has changed both the command buttons and applications, such as this version, the MS-PowerPoint 2007. Under its User Interface (UI) the arrangement of the command precisely well arranged and the group into its toolbar. So, there are changes in the location of its command buttons and toolbar from older versions of MS-Office 97, 2000 premium, XP, and 2003. Unfortunately, students and trainees even a hard user of MS-office confused about how to use this new version. So, this is the main purposed of this post. I will let you guide where are the parts of this new version MS-PowerPoint 2007.

1. Standard buttons- found at the top under the title bar of MS-Powerpoint 2007, they are the save, undo and redo buttons.
2. Home Menu Toolbar- located beneath the title bar, its a toolbar menu compose of a group of command buttons,namely:1. clipboard where the cut/ copy/paste located,2. Slides where the new slide, reset, delete, layout located,3.Font where the font style, font size font color, and another formatting of text located,4. The paragraph where the alignment, bullets, numbering, and indention of paragraph located,5. Drawing where the auto shapes and other formats of shaped, alignment, and fill color of object located, and 6. Editing where the find, replace, and select located.
3. Insert Menu Toolbar- located next to the home menu, its a toolbar menu compose of a group of command buttons,namely:1. Tables where you can insert a table for your presentation,2. Illustration where you can insert your own picture, clipart, photo album, shapes, smart art, and chart,3. Links where you can link using the hyperlink or internet and put a hover action of your presentation,4. Text where you can insert a text box, header, and footer, word art, date and time, slide number, symbol and object,5. Media Clips where you can insert movies and sound for your presentation.
4. Design Menu Toolbar- this is next to the insert menu, its a toolbar menu compose of a group of command buttons,namely:1. Page Setup where you can Page Setup, Orientation, and Margin,2. Themes where you can select a custom theme that will automatically apply once you hover your mouse on it, and 3. The background where you can apply background styles and hide the background graphics of your presentation templates(slides)
5. Animation Menu Toolbar- located next to the design menu, its a toolbar menu compose of a group of command buttons,namely:1. Preview where you can preview your slide,2. Animations where you can apply motion and effect or custom animation, and 3.  The transition of this slide where you can apply continues to slide and setup time, sound, and speed for your slide presentation.
6. Slide Show Menu Toolbar- next to the animation menu, its a toolbar menu compose of a group of command buttons,namely:1. Start slide show where you can start yours on mouse click and transition slide presentation,2. A setup where you can setup show, rehearse, and record narration, and 3. monitors where you can increase and decrease the resolution of the monitor screen, show presentation on, and use presenter view.
7. Review Menu Toolbar- next to the slide show menu, its a toolbar menu compose of a group of command buttons,namely:1. Proofing where you can check your spelling, research, thesaurus, translate, and language,2. Comments where you can show mark up, new comment, edit the comment, delete, previous, and next of your presentation slide.
8. View Menu Toolbar- located next to the review the menu, its a toolbar menu compose of a group of command buttons,namely:1. Presentation Views where you can set normal, slide sorter, note pages, slide show, slide master, handout master, and notes master,2. Show Hide where you can apply ruler, gridlines, and message bar,3. zoom where you can increase and decrease the size of your slide without using the zoom in/zoom out sliding bar of the bottom right,4. Color gray Scale where you can apply or change the color background of graphics/image/picture,5. A window where you can apply or set a new window, arrange all, cascade, and move split windows, and 6. Macros where you can use the macros presentation slide,
9. Format Menu Toolbar- this is next of view menu, its a toolbar menu compose of a group of command buttons,namely:1. insert shapes where you can select/format auto shapes,2. shape styles where you can format or change the color, outline, effects, and fill color of the auto shapes,3. word art styles where you can change the style of the font using the word art format,4. arrange where you can arrange the auto shapes and font, and 5. Size where you can set up the size of the auto shapes and font area of the presentation slide.
10. File Menu Button- it's just the logo of the Microsoft Corp., it's a rounded or circle form, position on the top left of the user interface. This is used as the file menu toolbar where you can save, new template, open, print and etc.
11. Sorter Panel- located left side of the presentation template. This use to arrange or sort in order for the slide presentation.
12. Status Bar- located below the left of the window. This is used to indicate the number of slides and will work on the vertical scroll bar.
13. Presentation Slide- the big part of the windows, this is the presentation template where the slides located and perform the different slide applications.
14. Zoom In Zoom Out Sliding Bar- located right side bottom of the window, this use to increase and decrease the size of the presentation slide without using the command button of a toolbar menu.
15. Guide Bar or Note Bar- this use to apply a presentation slide note of the application package.

TIPS!

• You can find the best tutorial applications using the Microsoft PowerPoint 2007 in this link: http://www.electricteacher.com/tutorial3.htm

OTHER REFERENCE HERE:

• Parts And Functions Of PowerPoint 2010- http://www.combinebasic.com/2015/11/parts-and-functions-of-powerpoint-2010.html

Microsoft Windows Movie Maker Keyboard Shortcuts and Application

In our computer program using the Microsoft Windows and office,mostly service pack two of Windows Operating System.Probably the windows xp has a built-in features of this most demanded movie application of our computer without downloading it in Microsoft Websites.Unlike the windows 7 OS you need to download the silver light for the movie maker.

Microsoft Windows Movie Maker is designed for the windows user to capture from your video camera,Web camera, or other video source, to your computer.And then use this captured contents in your movie applications.You can also import save videos from your drives, ex: from the USB flash drive or from your backup drive.So that it can be use for your movie applications.After editing the audio and video content in Windows Movie Maker, which can include adding titles, video transitions, or effects,and you can save it in your final movie applications.And share it to the internet movie sharing such as in YouTube and Facebook.

1. Keyboard shortcuts

For your convenient use for these applications I included the Shortcut keys for commands in Windows Movie Maker. By using this shortcut keys, you can quickly accomplish common tasks of this applications.

Here are the following tables for the complete use of your keyboard shortcuts.

Task	Shortcut key
Create a new project	CTRL+N
Open an existing project	CTRL+O
Save a project	CTRL+S
Save a project with a new name	F12
Save a movie	CTRL+P
Capture video	CTRL+R
Import an existing digital media file	CTRL+I
Undo the last action	CTRL+Z
Redo the last undone action	CTRL+Y
Cut	CTRL+X
Copy	CTRL+C
Paste	CTRL+V
Delete	DELETE
Select all clips	CTRL+A
Rename a collection or clip	F2
Clear the storyboard/timeline	CTRL+DELETE
Show or hide the storyboard/timeline	CTRL+T
Zoom in on the timeline	PAGE DOWN
Zoom out on the timeline	PAGE UP
Add selected clips to the storyboard/timeline	CTRL+D
Play video in full screen	ALT+ENTER
Set start trim point	CTRL+SHIFT+I
Set end trim point	CTRL+SHIFT+O
Clear trim points	CTRL+SHIFT+DELETE
Split a clip	CTRL+L
Combine contiguous clips	CTRL+M
Nudges clip to the left	CTRL+SHIFT+B
Nudges clip to the right	CTRL+SHIFT+N
Play or pause clip	SPACEBAR
Stop playback on the storyboard/timeline	CTRL+K
Play content on the storyboard/timeline	CTRL+W
Rewind content on the storyboard/timeline	CTRL+Q
Back	CTRL+ALT+LEFT ARROW
Forward	CTRL+ALT+RIGHT ARROW
Previous frame	ALT+LEFT ARROW
Next frame	ALT+RIGHT ARROW
Display Help topics	F1
Select previous item (on a timeline track, on the storyboard, or in the Contents pane)	LEFT ARROW
Select next item (on a timeline track, on the storyboard, or in the Contents pane)	RIGHT ARROW
Select item above (on a timeline track or in the Contents pane)	UP ARROW
Select item below (on a timeline track or in the Contents pane)	DOWN ARROW
Go to the first item (on a timeline track, on the storyboard, or in the Contents pane)	HOME
Go to the last item (on a timeline track, on the storyboard, or in the Contents pane)	END

2. Supported file types

Adding content directly to your Windows Movie Maker project either by capturing content directly in Windows Movie Maker or by importing existing digital media files. The content you capture in Windows Movie Maker is saved in Windows Media Format. However, you can also import existing Windows Media-based content as well as other common file formats.

You can import files with the following file name extensions into Windows Movie Maker to use in your project:

• Audio files: .aif, .aifc, .aiff .asf, .au, .mp2, .mp3, .mpa, .snd, .wav, and .wma
• Picture files: .bmp, .dib, .emf, .gif, .jfif, .jpe, .jpeg, .jpg, .png, .tif, .tiff, and .wmf

Video files: .asf, .avi, .m1v, .mp2, .mp2v, .mpe, .mpeg, .mpg, .mpv2, .wm, and .wmv

3. Steps How to Open the Windows Movie Maker

1. Click start button

2. Point to Programs

3. Click the customized icon with name Windows Movie Maker or Use the Icon of you Desktop

4. The Basic Parts and Functions

Note: See the picture of this post

1. Collections Pane- the collections pane will display the content once you click the collections button of the toolbar.And also It will displays a pane in the left bar.

2. Menu Bar- located underneath of the title bar.These are the drop down menu command of the application.You can use the command by clicking the menu.

3. Toolbar- this is underneath with the Menu toolbar.This is use for standard command buttons,such as new,save,open and undo command.

4. Task Pane- this is one of the menu command of the view menu.Once you click this task pane located below it will displayed on the left position of this window.

5. Video Timeline- this is located in the bottom of this window. 

The timeline displays the following tracks to indicate what types of files you have added to your current project.

Video

The Video track lets you see what video clips, pictures, or titles you have added to the project. You can expand the Video track to show the corresponding audio accompanying the video, as well as any video transitions you have added. After a clip is added to the timeline, the name of the source file appears on that clip. If you add any video effects to the picture, video, or title, a small icon appears on the clips to indicate that a video effect has been added to that clip.

Transition

The Transition track lets you see any video transitions you have added to the timeline. This track only appears if you have expanded the Video track. Any video transitions you add from the Video Transitions folder appear on this track. When a transition is added to the timeline, the name of the transition is shown in the timeline. You can drag the start trim handle that appears when the transition is selected to increase or decrease its duration.

Audio

The Audio track lets you see the audio that is included in any video clips you have added to the project. Like the Transition track, you can only see the Audio track if you have expanded the Video track. If you select the audio clip on this track and delete it, the video portion is also removed from the Video track.

Audio/Music

The Audio/Music track lets you see any audio clips that you have added to the project. The name of the audio clip appears on the clip.

You can also add video clips to this track if you want the audio, but not the video, to play in your project and final movie.

Title Overlay

The Title Overlay track lets you see any titles or credits that you have added to the timeline. You can add multiple titles to this track at different points in your movie. The titles overlay the video that is displayed. You can drag the start or end trim handle that appears when the title is selected to increase or decrease its duration.

6. StoryBoard- The storyboard is the default view in Windows Movie Maker. You can use the storyboard to look at the sequence or ordering of the clips in your project and easily rearrange them, if necessary. This view also lets you see any video effects or video transitions that have been added. You can also preview all of the clips in your current project. Audio clips that you have added to a project are not displayed on the storyboard; however, they are displayed in the timeline.

7. Monitor- Use the monitor to view individual clips or an entire project. By using the monitor, you can preview your project before saving it as a movie.

You can use the playback controls to navigate through an individual clip or an entire project. You can also use the buttons on the monitor to perform functions such as splitting a video or audio clip into two smaller clips or taking a picture of the current frame that is displayed in the monitor.

TIPS!

• If you want more enhance application of Movie Maker you can download the new version of this program from the Microsoft, use this link:Windows Movie Maker 6.0
• If you got any error during installation you can read how to fix right here in this page:How To Fix Windows Movie Maker

How to Create Worksheet's Table using Microsoft Excel 2007

One thing that we should know is how to create a worksheet table using the latest MS-Excel 2007 version.Although, we can perform logical calculation even if we don't create a borders of worksheets to form the worksheet table.It is depend to the requirements of the data,but it just very necessary to create the worksheet table.

Actually, other said that using the latest MS-Excel 2007 version is very difficult to use.But actually its just a matter of knowledge and familiarizing the User Interface(UI).But for me,this latest version is now simple.Compared to the old version, the MS-EXCEL 97 and 2003.

So, I will let you to learn and understand using this post.So that you can have your best idea and can be familiarized the routine of the menu toolbar and the dialogue box of the of the formatting cells.

THESE ARE THE STEPS:

1. Open your MS-Excel 2007 version

2. Once the windows open,determine how many rows and columns you need in your worksheets,ex: 17R x 30C.See the picture

3. But before you start to highlights,just type first the worksheet title.The worksheet title must be type in A1, so that you can align it using the merge and center of the worksheet.

4. Highlight the worksheet according to your specified size.Use the namebox to count the number of columns and rows displayed in name box once you drag your mouse.Practice this key combinations using the keyboard in highlighting your worksheet.

1. Position your worksheet cell below the worksheet title.

2. Start highlighting by holding shift key then press right arrow key to reach your number of columns you need.

3. Then press down arrow key to reach the number of rows you need in your worksheet.(Note: Hold always the shift key until you finish your highlight).

5. Once you finish highlight,you are ready to click the dialogue box for the border of the worksheet table.

6. Click the Home Menu Toolbar,then click the More borders under of the font toolbar.See the picture

7. Then click the more borders under the customized drop down menu toolbar.

8. Then a dialogue box will appear in your screen.(This is a current window,you can’t click other component rather than in this window)

See the formatting cells picture above.*

9. Click the border tab menu button

10. Select your line style

11. Click outline box and inside box under the presets

12. Click OK command button.

13. Now you will see the borders of your worksheet table.

14. Merge and center the worksheet title according to the size of your worksheet.


TIPS!

• You cannot merge cell with multiple data, like for example the worksheet title from A1 to A2 it will join the two cell with one worksheet title.
• You can't  delete a merge cell when other cell is also merge it will cluttered the entire worksheets.

Vertical Lookup and Horizontal Lookup Application of MS-Excel

VERTICAL LOOKUP AND HORIZONTAL LOOK UP TABLE is one of the logical calculation of MS-Excel application of MS-office throughout the different versions.This is useful for creating a worksheets for monthly commissions of the salesman.

Now, in creating this worksheets you need to know what are the labels you need for your worksheets.So, therefore you can calculate how much the number of columns and rows you need in this application.Then create the border of the entire worksheets and align the worksheets label.Then input carefully the data by columns of the different labels.One of the most very sensitive is inputting or typing the different figures.Because this application base mostly of the figures found in this worksheets.To avoid this error,once you type the figures,do not put comma and dot using your keyboard.Use the formatting bar located at the top of your worksheets by highlighting your entire figures and click the comma or dot button.

Now, as what you see in the picture of this post,I have vertical lookup table and horizontal table for the need to comply this application.So before to begin the steps how to create this worksheets.Please just analyze first this logical formula.

1. For the vertical lookup formula, this is only an example:

=vlookup(c8,comm,2)

The component of logical formula

1. =vlookup- this is the logical function name vertical lookup

2. c8- the reference data(c is the column header and 8 is the row header of the worksheets)

3. comm- name of the vertical table

4. 2- is the column index number(number of columns of the vertical table)

2. For the horizontal lookup formula, this is only an example:

=hlookup(j8,remarks,2)

The component of logical formula

1. =hlookup- this is the logical function name horizontal lookup

2. j8- the reference data

3. remarks- name of the horizontal table

4. 2- row index number

 Note: Use the open and close parenthesis to enclose the relative data and use comma to separate each.

Now here are the steps:

1. Create the worksheets table according to the requirements you need in your worksheets.

2. Input carefully the data according to its worksheets label(Be assure of the number of figures).

3. Create your vertical table(See the picture of this post).

4. Highlight the entire vertical table.

5. Click the namebox, then type the name of the table.Do not forget to press enter key to apply the name.

6. Now, you are ready to apply the logical formula of the vertical lookup by positioning the worksheet cell below of your worksheet label name commission by 5%.

7. Then press enter key once you finish typing the formula.

8. Then you will see the results, the results will defend what are the conditions  you give, ex: if sales is 0-45001 commission is 5%, if sales is 45001- 65001 commission is 10%, and if sales is 70000 above commission is 15%.

9. Then, use autofill tab of the worksheet cell of the proceeding data.By dragging your mouse using the black crosshair of the cursor of the worksheets.

10. Now, if you want to calculate the total commission.Just use this formula, ex: =c8*d8, then press enter key.Then use autofill tab of your worksheet cell to calculate the proceeding data.Note: the formula is just only an example,look at your reference data to calculate exactly.(see the picture above)

11. Then, now you are ready to calculate the gross pay by adding the total commission and net pay, here is the formula,ex: =e5+f5, then press enter key.

12. Now, create the horizontal lookup table by percentage.And below of it,type the logical conditions(see the picture above)

13. Then, click the name box again then type the name of the table, ex: Remarks, then press enter key.

14. Now, you are ready to input the formula of the remarks column of your worksheets.Position your worksheet cell below of the remarks label

15. Then, type the formula of the horizontal lookup(see the above of this post),then press enter key.

16. Now, you will see the logical quoted text base in your logical data conditions by percentage.

17. Then, use autofill tab, to calculate the proceeding data.

“That’s all again, just type in the comment bar if you have any question regarding our application”

Basic Parts and Functions of Notebook and Laptop Keyboard

Buy and owning one of the most common gadgets around us is very simple. If we have a budget and affordable in our pockets. Just like to own Personal Computer (PC) and to own one of the most common gadgets around us, the Notebook or Netbook Computers. These are most likely noticeable around in our environments. They said that PC would be replaced by portable computers in the near future. Because it is very easy to handle and could be used inside our house and also can be mobile outside our area. And most particular can be used in business meetings and surfing the internet inside a hotspot area or what we called WIFI or (Wireless Fidelity).

But to own a gadget or notebook, one of the very problems that would arise is how to use it. Not only in how to use the software operations.Both the Windows Operating Systems and the entire programs, including the internet applications of the computer. And the most very needed to learn and understand the parts and functions of the keyboard. Because this keyboard is used to input the different commands of the computer.

So, these are the purpose of this post. I will try to impart to you what I know of the keyboard of the computer. Most like on the keyboard part of the notebook computer or the netbook computer.

It was divided into four parts as you see in the picture of this post. So, here are the four major parts of the notebook computer.

1. Function Keys or the ALL F keys- these keys of the keyboard act as the primary shortcut keys of the computer to perform a certain function.Such as performing printing, buffering a command, saving files or settings, help menu or tutorial. Or could be combined with the other keys to function a certain command. Such as ALT + F4, will toggle the computer to auto closed the program and shut down the computer. These keys are labeled from F1-F12 and commonly found at the top of the computer keyboard.

2. Special Keys- they are Print Screen System Request or PrtScSysRq key, Pause Break, Insert, and Delete. Mostly found at the top right side of the function keys. Mostly act to perform special or logistical operations of the application program. Such as, how to print the current screen image of the computer or the Graphical User Interface(GUI) and to erase the right character of the documents using the del key. So, here are the steps how to print screen:

1. Open the program you want to print or simply your facebook account

2. Once the program open, press the prtScSysRq key twice to assure

3. Open your MS-Word

4. Once the MS-Word open, right click in the template

5. Click paste or hold CTRL then press V

3. Cursor Keys or Arrow keys- these keys act as the navigation or destination of the computer program. Usually found at the bottom right side of the keyboard of the notebook computer. The up, down, left, right arrow keys, and the special keys. The page up and page down and the function key(Fn)labeled with the color blue. They are:

Note: Labeled in blue keys, these are the Fn keys. This will function once you hold the Fn key located at the bottom right side of the notebook computer. 

1. Home- act as to move the cursor of the keyboard automatically to the beginning of the line of the paragraph of the document once it press.

2. End-  act as to move the cursor of the keyboard automatically to the end of the line of the paragraph of the document,once it press.

3. Increase and Decrease audio- labeled in blue with a logo of the speaker.This is use to increase/ decrease the audio of the notebook computer.This will function once you hold the Fn key and press the up/down arrow keys.

4. High Contrast and Low Contrast- labeled in blue with a logo of the sun.This use to increase and decrease brightness of the LCD or LED monitor of the notebook computer.This will function once you hold the Fn key and press the right/ left arrow keys.

The white-labeled page up and page down keys will toggle the computer program up/down of the page once you press.

4. Alphanumeric Character- the wide or the biggest part of the laptop or notebook and PC computer keyboard. Through the part name, these are the composition both upper case and lower case:

1. ALPHA- means alphabets, design or arranged through the name of the type writer inventor QWERTY.It is compose of 26 letters in national alphabets, from A-Z letters both upper case and lower case or big letter and small letter.

2. Numbers- these are the decimal numbers, from 1-0.Situated as lower case of the Alphanumeric Character.

3. Characters- these are the symbols and punctuations of the keyboard.Both uppercase and lower case functions.They are from left to right in series arrangements of the numbers found at the top and through the right side of the alphabets. 

1.) Tilde and Accent grave

2.) Exclamatory Point

3.) At sign

4.) Number Sign

5.) Dollar sign or currency

6.) Percentage symbol or the divide 100

7.) Caret

8.) And sign or the Amper Sand

9.) Asterisk or the Multiplication Operator

10.) Open Parent thesis

11.) Close Parent thesis

12.) Under score and dash

13.) Addition operator or plus sign and equal sign

14.) Backspace- that will erase the left character of the document

Right side of the Alphabets:

1.) Open Curly brackets and square brackets

2.) Close Curly brackets and square brackets

3.) Pipe bar or Vertical Bar and backslash

4.) Colon and semi colon

5.) Double quotation and single quotation

6.) Enter key or Ok

7.) Less than and comma

8.) Greater than and period or dot

9.) Question Mark and Forward Slash   

5. Special Keys of Alphanumeric Character- usually found at the left side- right side and through the bottom of the alphanumeric character keys.It has major functions and logistical operations of the program of computer. They are from top left to right down the bottom of the alphanumeric character:

1.) Tab key or indent key- act as the tabulator key of the computer program.Mostly act as the 1st indention of the paragraph of the document.And it is use to move the cursor of the keyboard through the Graphical User Interface(GUI),without using the mouse pointer.

2.) Caps lock- use for uppercase of the letters or Alphabets, ex: printed case of the document 

3.) Shift Keys- the two keys found from the left and right are use to perform the single uppercase of the document, ex: title case, name of person, place and animal.And use to partner another keys to perform certain functions.Such as to highlight selected line of the paragraph by holding shift key and press the end key, or cursor keys.

4.) CTRL or Control Keys- the two control keys found at the left/right bottom are use to function other keys to perform certain functions of the keyboard and mouse combination, particular in MS-Excel application in selecting the column of the worksheets.But there are 16 most common shortcuts of the keyboard using the control keys by holding it and press the letter.

1. CTRL + Z= UNDO

2. CTRL + X= CUT

3. CTRL + C= COPY

4. CTRL + V= PASTE

5. CTRL + B= BOLD

6. CTRL + N= NEW

7. CTRL + A= ALL(HIGHLIGHTS ALL)

8. CTRL + S= SAVE AND SAVE AS

9. CTRL + F= FIND

10. CTRL + G= GOTO

11. CTRL + H= REPLACE

12. CTRL + Y= REDO

13. CTRL + U= UNDERLINE

14. CTRL + I= ITALIC

15. CTRL + O= OPEN

16. CTRL + P= PRINT 

5.) Fn or Function key- these are the keys that will function in all labeled blue color logo,numbers,or symbols through- out the part of the keyboard.Preparedly, act as the third functions in both lower case and upper case of the keyboard.Such as the lower symbols of the ALL F keys and the numbers found at the alphabets.Position at the top/right side of the keys found in the right of the ALPHA keys. 

6.) Flying Windows Key or Windows Key- these one key found at the left bottom of the keyboard.That have a labeled logo of the Microsoft.Act as the start menu or start button of the Desktop,once it press without using the mouse pointer.This will customize the start button so that the user can select a program or move the cursor of the keyboard using the arrow keys via customize programs. 

7.) Alt or AltGr keys- these two alternate keys will partner to other keys to give certain command of the computer.Such as to command for the different symbols of the document using the ASCI(American Standard Code Industry).Preparedly combine to the numeric numbers of the numeric keypad.Such as to command the computer for the enye “ Ñ” both upper case and lower case. 

8.) Desktop Key- this single key usually found at the right side bottom of the keyboard.Act as the right click of the mouse cursor once it press.Or an auto command of the document template by displaying a pop up command window.Such as the cut,copy,paste command,select all,hyperlink,align,numbering, and bullets. 

Know The Parts And Functions Of Microsoft Office Word 2007

Another version, the MS-Word 2007.As part of the basic we need to learn and familiarized the most basic and common part of this new version of office automation.indeed, we learned how to use the old once version, the MS-Word 97 and 2003.But actually, in this new version mostly had confusion.Because of the new arrangement of menu toolbars compared to the old once that have a drop/down menu command button.

Basically, they have the same application and component of the dialogue box.But rarely, it have additional application, because this version have an enhancement in both application in MS-Office automation.Just like in using the Page Setup command that was usually found in the file menu in old MS-Word.Now in the new version you can use the Page Setup Menu toolbar to setup your margin and paper size together your paper orientation.And publishing your document through your blog and sending it in your personal email account. And one of the most unique and different is auto apply of the selected features through the application template.

So, now here I included the use and function of the different menu and buttons:

DIFFERENT PARTS AND FUNCTIONS OF MICROSOFT OFFICE WORD 2007

1. FILE MENU BUTTON: use as the most standard menu command under the file menu in old version.Once you click, you can print your document, setup restrictions of your document, save and save as, and publishing document in the blog and sent your document in an email, etc.

2. INSERT MENU TOOLBAR: primarily used to insert objects of application.One of the most common is the image or picture,such as: pages,tables,illustrations,links,header and footer,text formatting, and symbols.

3. HOME MENU TOOLBAR: these are the standard and formatting command buttons of the application.Such as clipboard- the cut, copy, paste, and paint command.And also the font formatting command,the paragraph indentions, and the styles of the text.

4. PAGE LAYOUT MENU TOOLBAR: once you prepare your document template, use this menu to apply Themes, Page Setup,Page background, Paragraph Indentions, and text alignment or the arrange buttons.

5. REFERENCES MENU TOOLBAR: these are the table of contents features,footnotes,citation and bibliography,captions,index,and table of authorities.

6. MAILINGS MENU TOOLBAR: in advance use of this new version, use this menu for creating envelops and labels,document mail merge,write and insert fields,preview results, and finish mail merge.

7. REVIEW MENU TOOLBAR: to assure the correctness of our spelling and grammar and other features, this versions have a features of Proofing,comments,tracking service,changes,compare, and protect.

8. VIEW MENU TOOLBAR: other features included, same as the applications of the view menu toolbar of the MS-WORD 2003. This includes of the Document Views, Show/Hide, ex: Ruler, Document Zoom,Window View, and Macros application.

9. ZOOM IN ZOOM OUT SLIDING BAR: situated at the bottom right side of the document window, this is use to zoom in/zoom out the document.By dragging this using your mouse, rather by selecting a specific number of size of document template.

TIPS!

• Other parts was tackled in my previous post in User Interface of the MS-Word 2003 parts and function.

Parts and Functions of Microsoft Excel 2003 and 2007

Just the same in this office application we have two new versions. Build by the Microsoft Company, actually three versions, namely MS-OFFICE 2003, 2007, and 2010.

From office 97 versions they produced the 2003 new versions of both word processing application, electronic spreadsheets, and presentation package. These are the MS- WORD, EXCEL, and POWERPOINT. If we noticed, the 97 versions and 2003 just look alike, meaning we don't worry to use the User Interface (UI). Because they have the same position of their buttons of the three most basic toolbars that we used. But unlike the two other new versions, the 2007 and 2010 are the most very different. Because they added more enhancements to the User Interface and the features of the applications.

So, therefore, the basic of the user is to identify first the part of the User Interface. Such as the MS-EXcel UI, so that to familiarized the around of the applications.

Let's talk about the most basic parts and functions:

1. Control Tool Box- these buttons are used to close windows, restore or maximized, and minimized the application window.

2. Title Bar- use to notify the filename of your document after saving it and the name of your office application.

3. Menu Toolbar- use to select command application using the customized drop/down window in various applications, such as the format menu.

4. Formatting Toolbar- use to change the appearance of the text, objects, mathematical application, alignment, currency, and decimals, etc.

5. Standard Buttons- composed of the most basic command application, presented by buttons to easily familiarize and click by the mouse pointer in a single click and using the dialogue box as our communication to the application of computer. such as the NEW button for a new worksheet.

6. Name Box- this is situated on the left of the window. You will notice a letter combine with the number. It is understood that indicated a certain intersection of the worksheet. The Letter signifies the column and the number is a row.

7. Editor Bar- this bar is next to the name box. Editor bar called also the formula bar, meaning you can edit or change data and create a logical formula using this bar. But you can use actually the worksheets as editor by pressing the F2 key of your keyboard.

8. Column Header- they are alphabets situated and underneath the formula bar. It represents the number of columns in a worksheet. It is composed of 256 columns in the 2003 version. You can count how much the number of columns in the single worksheet by holding the CTRL + right arrow key of the keyboard.

9. Row Header- they are numerical numbers, from 1-104856 rows in the 2007 version. You can count how much the number of rows in a single worksheet by holding the CTRL + Down arrow key.

10. Worksheet Cell- it's just bolded rectangle position normal in A1 once you open your MS-EXCEL.This is used to refer to the data in your applications. Meaning, once you type your data, the number or text will position inside the worksheet cell in the different intersection of the worksheets application.

11. Autofill Tab- it's a form of a box situated in the below right portion of the worksheet cell. Its use to perform applications automatically using the drag of the mouse. Such as performing logical calculations of the single column of the worksheets.Such as calculating or adding the numbers using the logical formula.The date, year, month, and the numbers in series.

12. Tab Buttons- These tabulated buttons are used to name the single worksheets in a single workbook. Normally as default, it has three tab sheets that you can rename and add by pointing your mouse cursor in tab sheets and use the right click of your mouse.

13. Worksheet- it is the wide area of your window application. It is the spreadsheet paper literary. That simulated in an electronic spreadsheet application. It has composed of vertical and horizontal grid lines to form an intersection of the worksheet.

14. Trail buttons- it's just a form of four arrows situated left side of the tab sheets buttons. It uses to move or switch the entire worksheet in a single workbook by clicking it by the mouse pointer.

15. Vertical Scroll Bar- it is situated right side of the worksheet. It is used to move up/down the worksheet or page in the application.

16. Horizontal Scroll Bar- it is situated right of the tab sheet button. It is used to move the worksheet or page left and right of the application.

17. Zoom In Zoom Out Sliding Bar- it is situated right/down in MS-Excel 2007 application window. It is used to increase/decrease the size of the worksheet.   

How to Attach Files using your Gmail Account

This is the old Gmail email compose message window.
The attach file(the paper clip) icon found at the bottom
of the compose message in new gmail windows.

One of the most important and usable email application is Attach file.Usually found underneath in subject bar of our composed email.

Using your different EMAIL account, Yahoomail, Gmail, and Outlook.com. These are the three giant network serving us the most reliable and fastest way in delivering our email messages. However, we can attach file in our email just only the maximum size of 25 MB by uploading it in your gmail account.

So, here are the basic instructions how to attach your files in your gmail account.

Note: You need to have an ISP, ex: MyDSL or any ISP available in your area. And your internet browser      installed in your computer, ex: Google Chrome. And your personal email account.

1. Double click your internet browser in your desktop, ex: Google Chrome
2. Once your browsers open, type in your address bar, gmail.com, or your other email account other than gmail.
3. Once gmail open in your browser, just login using your password and username.If you have no email account just click this, gmail signup
4. Once your email account is open, just click compose button, just left side in your email window
5. Once your compose message window is open, just type where to sent your file together with your email message( the receiver). Using the To address bar
6. Then, type also what is the title or the subject of your email message or your attach file.You are going to sent, using the bar.This is very needed so that it is easily or directly understood by the receiver, once he/she open his inbox.
7. Just underneath of the subject bar, just click the attach a file link
8. After you click it, a destination window will pop up in your screen
9. Then select where you save the file you want to upload in your email using the look in bar or destination bar.Just beside of the look in, and its just a drop down bar, ex: in My Documents of drive c:
10. Once you select your file, click the open button.Just right side in your file name bar.
11. Then a progressive bar will work in your email, just wait until fully complete.
12. Once it is complete, the uploading of your file is finished.
13. If you have no message inside your compose email text area, just type your message.And do not forget to type or put an electronic signature, just below your message.Your electronic signature is the one to identify that you are professional by the receiver.
14. Then click the send button, just above left situated in your compose email window.
15. Now, wait until your email will tell you that your email was sent successfully.
16. Then if your email was send successfully, just add in your contact the receiver.So that, you easily find once you check his/her account.

TIPS!

• Create your email signature or electronic signature in your gmail account, you can follow this post Create Your Email Electronic Signature