Introduction to MS office for begineer

Views:
 
     
 

Presentation Description

Introduction to MS office for begineer

Comments

Presentation Transcript

Introduction to MS Office:

Introduction to MS Office

You all aspire to work in office and be the BOSS …right ?:

You all aspire to work in office and be the BOSS …right ?

Slide3:

Just think what can make your JOB easier ?

And the answer is …Tools……..:

And the answer is …Tools……..

Tools make our job easier Like they help ..Kenny the mechanic:

Tools make our job easier Like they help ..Kenny the mechanic

Like these tools….have a look:

https://www.youtube.com/watch?v=BaKcwU1lt3c Like these tools….have a look

Computer also provides you such tools:

Computer also provides you such tools

MS Office is there to help you :

MS Office is there to help you 

What is MS Office….?:

Suite of  products   developed  by  Microsoft   Corporation  that includes Microsoft Word, Excel,  Access ,  Publisher , PowerPoint, and Outlook. Each program  serves  a different purpose and is compatible with other  programs  included in the  package . What is MS Office….?

Lets see what comes out of this suitcase:

Lets see what comes out of this suitcase

Microsoft Word:

Microsoft Word

What is MS Word….?:

Microsoft Word (often called  Word ) is a  graphical   word processing  program that users can  type  with. It is made by the  computer   company   Microsoft . The purpose of the MS Word is to allow the users to type and save documents. What is MS Word….?

The Microsoft Office Button :

The Microsoft Office Button As you move your cursor over the Microsoft Office Button a preview image (image on right) will appear . Click the Microsoft Office button . When you click the Microsoft Office button, it will turn orange and a “File like” menu will appear (similar to the image on the left).

Tabs:

Tabs Tab Tabs are similar to the Drop Down Menu to assist you with the most common features of that application. Office applications begin with the Home tab. The Home Tab/Ribbon for Word 2007 looks like the image below Group Ribbon

Font :

Font The Font Group area – allow you to use font of your choice – THIS IS FUN

Styles :

Styles Hang on! The next Group on the Word Home Tab/Ribbon is Styles. More Arrow

Fasten your seatbelts! :

Fasten your seatbelts! We’re going to highlight this paragraph (when we have finished typing it). Then we’re going to open the Styles Group . When the Group is open we’ll move our cursor over the choices , and as we do, you’ll see, in the images below, that the entire paragraph changes to that Style ! We selected this Style . Look how the text now appears!

Other Tabs/Ribbons :

Other Tabs/Ribbons The Insert Tab/Ribbon ( below) has logical “things” that you would insert into a document – Shapes, Pages, Tables, Illustrations, Links, Headers/Footers, Text and Symbols. The Page Layout Tab/Ribbon also has logical selections – Themes, Page Setup, Page Background, Paragraph and Arrange.

Slide19:

The References Tab/Ribbon will really come in handy for those publishing long documents, articles or books – Table of Contents, Footnotes, Citations & Bibliography, Captions, Index, and Table of Authorities. The Mailings Tab/Ribbon lets you work with Envelops, Labels, Mail Merge, Fields and Preview. It includes Create, Start Mail Merge, Write and Insert Fields, Preview Results and Finish.

Slide20:

The Review Tab/Ribbon has the Proofing Tools, Comments, Tracking, Changes, Compare and Protect features The View Tab/Ribbon allows you to change the document Views, do Show/Hide, Zoom and arrange your Windows.

Overview:

https://www.youtube.com/watch?v=9kSHpQ297LE Overview

MS Excel:

MS Excel

What is MS Excel ?:

Microsoft Excel  is a spreadsheet application developed by  Microsoft for   Microsoft   Windows. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. What is MS Excel ?

Hey…. what do you mean by Spreadsheet ?:

Hey…. what do you mean by Spreadsheet ?

Spreadsheet:

An electronic document in which data is arranged in the rows and columns of a grid and can be manipulated and used in calculations. It is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns . Spreadsheet

Lets get started……..:

Lets get started…….. A spreadsheet is a “ number manipulator .” To make the handling of numbers easier, all spreadsheets are organized into rows and columns . Your initial spreadsheet will look something like the one below: Notice that the “ main ” part of the spreadsheet is composed of Rows (Labeled 1, 2, 3, 4 , etc.) and Columns (Labeled A, B, C, D , etc.). There are a lot of rows and columns in a spreadsheet.

Slide27:

The “ intersection ” of each row and column is called a cell . In the image above the cursor is on the “ home ” cell – A1 . Notice Row 1 and Column A are “bold,” and colored “orange.” This indicates what is called the “ address of the cell . Notice right above cell A1 , that A1 is displayed in a small box called the Name Box . Whenever you “click” on a cell the address of that cell will be shown in the Name Box.

Moving Around the Spreadsheet :

You can move around the spreadsheet/cells by clicking your mouse on various cells , or by using the up, down, right and left arrow movement keys on the keyboard. Notice how the Name Box always tells you “ where you are .” Moving Around the Spreadsheet

Slide29:

Now that you have the “feel” of how to move around the Excel spreadsheet, go to the cells as indicated below and type-in the following: (Your Name)'s Budget. It should look similar to the image below . Do not tap Enter when you finish

Lets work it out…:

Lets work it out… a simple personal budget would be a logical way to show you how a spreadsheet “works.” Move to the following cells and type-in the information indicated . You can click-on each cell and then type-in the entries. Cell Type-in A3 Income B4 Parents B5 Job B6 Investments B7 Total A10 Expenses B11 Food B12 Beverages B13 Parties B14 Miscellaneous B15 Total

Slide31:

Now, type the numbers in the cells indicated: C4 300 C5 50 C6 150 When you type -in the 150 , tap Enter . Your spreadsheet should look like the image

Widening Columns:

You probably noticed , as you typed in the numbers, some of the words were just too wide for the default cell width . Slowly move the mouse arrow to the right edge of the B cell ( between the B and the C ). The cursor will turn into an arrow pointing right and left with a small vertical line in the middle (see arrow below). Hold down the left mouse button and move (drag) the line to the right Widening Columns

Inserting Rows :

Oops ... a mistake (on purpose). We haven't left enough room at the top of the spreadsheet to insert some budget months . So... move the cursor to the gray 2 along the left edge (this is the second row) so we can insert two new rows. Click the left mouse button. You will notice that the whole row goes light blue and the 2 turn’s dark blue. Make sure the cursor arrow is either on the 2 or somewhere in the blue row . Inserting Rows

Or we can do …..:

Click the right mouse button. A drop down menu will appear. Point to Insert. Click the left button on Insert . Notice how one row was inserted and how everything below moved down . Do this again to insert another row . Excel, and all spreadsheets, will remember where they moved your work and automatically adjust for these changes. Or we can do …..

Aligning Cells:

Now we'll type some more text. Go to cell Notice how SEPT is automatically left aligned . Logically, since you are using Excel, the English version, the text is left aligned so that all of the text entries will line up nicely in the One way to center SEPT is to simply click-on the Center button in the button bar at the top of the screen . Make sure that you are ON cell C3, then click- on the center button Aligning Cells

Saving Spreadsheets :

We have done quite a bit of work so now is a good time to save your spreadsheet. The Microsoft Office Button has replaced File in the Menu Bar. In the upper left corner of your Excel 2007 screen you will see a button similar to the image below. This is the Microsoft Office Button . Saving Spreadsheets

Slide37:

Click the Microsoft Office Button . When we move our cursor over Save As an expanded menu of Save choices appear on the right If you save as Excel Workbook , it will save your spreadsheet in an .xlsx format .

Overview:

https://www.youtube.com/watch?v=SF4-yvrmZhQ Overview

MS Powerpoint:

MS Powerpoint

What is MS PowerPoint ?:

PowerPoint is computer software created by Microsoft which allows the user to create slides with recordings, narrations, transitions and other features in order to present information. What is MS PowerPoint ?

What is a Slide ?:

What is a Slide ?

What you are looking at is a “Slide”:

What you are looking at is a “ Slide ”

Slide43:

This will be a wonderful journey. You will find many exciting new features and enhancements. Almost everything is “graphical.”

So here is what you see at first:

So here is what you see at first Tabs Ribbons

Slide45:

On the left side of the PowerPoint screen you’ll see an area that indicates Outline and Slides at the top . When you first open PowerPoint 2007 you’ll notice that the Slides Tab is “ white .” This means that you’ll be able to see a small version of each slide as we create it. a PowerPoint Design Template . We’ll be using these templates to create our slide show.

Beginning the presentation :

You will notice, in the lower left corner of the screen, Slide 1 of 1 is indicated. You will also see that your screen looks like the image below . Beginning the presentation

:

Place your cursor in the “ Click to add title ” box and Click the left mouse button. Your text box, after you click. Now , Click in the second box “ Click to add sub-title” and type :

New Slide Button:

New Slide Button At the top left of the screen, in the Home Tab you will see a New Slide “button” which looks like the image on the right. ….. Look carefully at the lower right corner of the New Slide button and you will see a down arrow .

Slide49:

When you click the arrow an image similar to the one on the right will appear. We’ll use the Title and Content slide for our second slide.

Slide 2:

Your new Slide 2 should look like the image below – even if you did not click the arrow . Slide 2

Other Slide Views :

Other Slide Views In the lower right corner of the screen you will see some “ buttons ” that look like the image on the right: This is the PowerPoint View Toolbar . Slide Sorter View Zoom Normal View Slide Show

Make them interesting…:

Make them interesting… Notice the small images in the right Text or Content Box of the new slide . There are six “tiny” icons in this area that will allow you insert a Table, Chart, SmartArt, Picture, Clip Art or Media Clip. For this slide we want to insert a C lip Art image in this area.

Lets see what else you can do..:

https://www.youtube.com/watch?v=3ZUwFwooMrY Lets see what else you can do..

This is it ..hope you enjoyed these tools:

This is it ..hope you enjoyed these tools

authorStream Live Help