Arina Iswatan Nisa

Tutorial MS Power Point 2003

2009-07-06T00:47:00.000-07:00

PowerPoint Tutorial: Microsoft PowerPoint 2003

This PowerPoint tutorial is just what you need to get up to speed using PowerPoint to create engaging and effective presentations. Whether you're creating a presentation for an informal gathering, a school or classroom assignment, or one for your business partners or associates, PowerPoint is a powerful tool that will help get the job done. Each PowerPoint tutorial features text and screen shots, and some include narrated multimedia tutorials in Flash.

Our Free tutorial will help you take your PowerPoint skills to new levels.

Guides and Tutorials helps you create expert slide presentations in minutes to impress your family, friends, students, and co-workers. With PowerPoint 2003, we will show you how to create and edit professional looking presentations.

These helpful pages will teach you how to put custom animations into your slides, add speaker notes and handouts, and use design templates to make a professional presentation. We will teach you how to choose color schemes, create exciting backgrounds, import text and charts from other programs, and play your slide show from your computer.

Click on a link to the left to go to the title of your choice. To return here, click the Home page.

See also the Non-Linear PowerPoint Tutorial for a way to make a great user centered presentation.

Energize PowerPoint Presentations with 3D, Flash, Templates, Backgrounds, Photos, Plugins, Charts & More - Energize PowerPoint with stunning 3D transition effects, cool Flash animations, sophisticated 3D charts, TV-style animated 3D titles, beautiful templates, inspiring photos and more! For more information, please visit www.CrystalGraphics.com.

PowerPoint Tutorials: Microsoft PowerPoint 2003

Getting Acquainted

The PowerPoint Workspace
The Task Pane
Working with the Taskpane
The Slide Views
Working with Toolbars

Creating Slide Shows

Creating a New Presentation
Set Visual Rules
Inserting New Slides
Adding Text to Slides
Using Grids and Guidelines
Edit and Format Text
Cut, Copy, and Paste Text
Bulleted Lists

Designing Slides

Create Master Slides
Adding New Masters
Apply Design Templates

Lines, Curves, & Shapes

Draw and Format Lines
Draw a Rectangle
Draw an Ellipse
Draw Bezier Curves
Draw Freeform Lines
Modify AutoShapes

Using Multimedia

Custom Animations
Inserting Sound
Transition Effects
Add Action Buttons
Embed Video
Add Looped Audio
Record Narrations

Tips & Tricks

Add Watermark
Add Slide Numbers
View Multiple Presentations
Keyboard Shortcuts

More PowerPoint Tutorials at GuidesandTutorials.net

All other Guides and Tutorials

GuidesandTutorials: Audacity Tutorial - Record and Edit Audio
This Audacity tutorial will show you how to use the basic tools and procedures in the open source audio editing program, Audacity. Not just screen shots, but free narrated multimedia tutorials - You'll learn to use Audacity for recording and editing audio files that can be used for podcasting, mixing music and vocals, creating sound tracks, and other audio projects.

Audacity Tips & Tricks
Audacity tips and tricks submitted by users

GuidesandTutorials: Advance Organizers Tutorial
An Introduction to Advance Organizers including presentations, examples, and downloadable handouts.

GuidesandTutorials: Digital Photography
Digital Photography Guide

GuidesandTutorials: Dreamweaver Tutorial
Dreamweaver Tutorial - this series of free Dreamweaver tutorials is just what you need to get up and running with Dreamweaver to create interesting and compelling web sites

GuidesandTutorials: Microsoft Excel 2003 Tutorial
This Excel 2003 Tutorial will introduce you to the basics of using the Excel 2003 spreadsheet program. You'll learn to create a spreadsheet, basic Excel workbook skills, work with cells, enter and manipulate data, apply formulas, format data, create and work with charts, and manage Excel workbooks.

GuidesandTutorials: Podcasting Tutorial
This Podcasting tutorial includes a step by step guide that will show you how to record, publish and promote your podcast. Using inexpensive equipment and free software, you'll be publishing podcasts in no time.

GuidesandTutorials: PowerPoint Tutorial - Microsoft PowerPoint 2003
This PowerPoint tutorial is just what you need to learn how to use PowerPoint 2003 to create effective and engaging presentations.

GuidesandTutorials: Free PowerPoint Templates
Free PowerPoint templates that you can download and use today. This is a growing library of free resources for PowerPoint users.

GuidesandTutorials: Non-Linear PowerPoint Presentations - A How-to Tutorial
Non-linear Powerpoint tutorial will show you how to use advanced drawing tools and linking features in PowerPoint to create non-linear powerpoint presentations. Includes narrated presentations, and Flash tutorials on planning, user interface, design, and presentation development.

LCD Projector Guide and Tutorial
This LCD Projector Guide will assist you in the use and purchase of a digital LCD projector or DLP projector. It will discuss the differences between LCD and DLP projectors, size and portability considerations, lamp types and brightness, resolution, image quality and other considerations in the use and purchase of a digital projector.

RSS Tutorial
This Introduction to RSS Tutorial will help you to understand how RSS feeds work to distribute web content, pages, blogs, podcasts. It will show you how to create and validate your RSS feed. It includes sample XML code that you can modify for your own feed.

Suggest a New Technology Tutorial
Free Technology Tutorials on software and technology applications including PowerPoint tutorials, Podcasting tutorials, Dreamweaver tutorials, Audacity, Non-Linear PowerPoint, Digital Photography, RSS tutorial, and everything educational technology.

Guides and Tutorials: Free Guides and Tutoials Site Map
Free guides and tutorials on podcasting, digital video and audio, Audacity, RSS, multimedia development, educational technology, technology integration, K12 Technology, PowerPoint.

Word Tutorial: Microsoft Word 2003
This Word tutorial is just what you need to learn how to use Word 2003 to create professional looking documents.

tutorial ms excel 2003

2009-07-06T00:18:00.001-07:00

Excel 2003 Tutorial: Lesson 1 - The Excel Basics

There are many uses for Excel. Businesses use it for crating financial reports and budgeting. School administrators can use it for preparing school budgets. Teachers use it to analyze data about student performance and adjust their teaching. Scientists use it analyze data. Economists use it for statistical analysis. Families use it to manage their investment portfolios. Microsoft Excel is be far the most widely used, most powerful spreadsheet program available.

These Excel 2003 tutorials will introduce you to the Excel "basics." They will cover the information that would be covered in an introductory course on Microsoft Excel 2003.

The Excel 2003 Program Area

Excel 2003 Tutorial: Excel Program Screen

When you launch Excel, the program opens to a blank document that looks like the one below. From this point, you can add data, change how it looks, have Excel perform mathematical calculations or summarize the data or find information in Excel's help files.

The image below shows the most important parts of the Excel workbook window. Note that it's possible that depending on the way your computer is configured, not every toolbar that you see below may look the same on your machine. You can select the toolbars to view by selecting View from the Menu Bar and then choosing "Toolbars."

The most basic part of an Excel document is the box that holds a piece of data, called a cell. A cell is the box represented by the intersection of a column and a row. Rows are identified by the numbers down the left side and columns are identified by letters across the top. Each cell is indicated by a cell reference. For example, in the image below the Active Cell at the intersection of Column A and Row 1 is given the cell reference of A1.

Excel 2003 Tutorial: The Excel Toolbars

Title Bar - The title bar displays the name of the program you are currently using and the name of the Excel workbook that is open. It appears at the top of all Windows programs. By default, Excel opens with Book 1.

Title Bar

Menu Bar - The menu bar is directly below the Title bar and displays a list of the menus that you can use to give commands to Excel. Clicking on a menu name displays a drop down menu of commands. You can move across the menu bar and down the drop-down menus with your mouse of by highlighting one of the menu items and using the arrow keys on your keyboard.

Menu Bar

The menus found on the Menu Bar include the following:

File - File-related commands to open, save, close, print, and create new files.
Edit - Commands to copy, cut, past, find, and replace text.
View - Commands to change how the workbook is displayed on the screen.
Insert - Lists items that you can insert into a workbook, such as graphics and charts.
Format - Commands to format fonts, cell alignment, and borders.
Tools - Lists tools such as the spell checker and macros.
Data - Commands to analyze and work with data information.
Window - Commands to display and arrange multiple windows.
Help - Get help on using the Excel program
Adobe PDF - Options file menu if you have Adobe Acrobat installed.

Standard Toolbar - The Standard toolbar includes buttons that are shortcuts for the most commonly used commands. It contains buttons for the tools you use most frequently, such as saving, opening, and printing workbooks.

Standard Toolbar

The tools found on the Standard Toolbar include the following:

New - Creates a new, blank spreadsheet
Open - Open a previously saved spreadsheet
Save - Save your current spreadsheet
Permission - To restrict access to your spreadsheet
Print - Prints the current document
Print Preview - Preview the current spreadsheet to see how it will print
Spelling - Performs a spell check of cells in the current document
Research - Enables information rights management which can help protect sensitive documents from begin copied or forwarded.
Copy - Copies the current selection to the clipboard, which can then be pasted elsewhere in the document
Paste - Takes the current clipboard contents and insert them
Undo - Undoes the last action in the document
Redo - Redoes the last undone action
Insert Hyperlink - Inserts a hyperlink to an Internet Web location
Auto Sum - A drop-down menu of available mathematical operations to perform
Sort Ascending - Sorts the current selection in ascending order
Chart Wizard - Opens the "Chart Wizard," which will walk you through the creation of charts and diagrams using the selected data.
Other Options - There are a variety of other options you can call or add to the toolbar, such as Cut, Email, Sort Descending, etc. By clicking on the triangle at the far right side of the toolbar, you can access these options.

Formatting Toolbar - The Formatting toolbar contains buttons for the most commonly used formatting commands, such as making text bold or italicized.

Formatting Toolbar

The Formatting Toolbar includes commonly used buttons for formatting the information in cells. These include the following:

Font - Changes the font of the selected cells
Size - Changes the font size of the selection
Bold - Puts the selection in bold face
Italics - Puts the selection in Italics
Underline - Places an underline beneath the selection
Align Left - Aligns the current selection to the left
Align Right - Aligns the current selection to the right
Merge & Center - Combines two selected cells into one new cell that spans the width of both and center the contents of this new cell
Currency Style - Changes the style in which currency is displayed
Percent Style - Changes the style in which percents are displayed
Decrease Indent - Decrease the indent of a cell by approximately one character
Border - Adds or alters the style of borders around selected cells
Fill Color - Select a color to fill the background of a cell
Font Color - Select a color to apply to a selection of text

Task Pane - The Task pane lists commands that are relevant to whatever you're doing in Excel. You can easily hide the task pane if you want to have more room to work on a workbook. Click the close button in the upper right corner of the Task pane. To open it again, choose View, Task pane.

Worksheet Window - You can have multiple worksheets in an Excel file. The worksheet window is where you enter data into the cells on the worksheet. You can have more than one worksheet open at a time. Each worksheet contains columns and rows.

Formula Bar - The Formula Bar allows you to view, enter, and edit data in the selected cell. If the cell contains a formula, it will be displayed here. If there is no formula then the content of the cell is displayed. Cell content can be edited directly in the cells or in the Formula bar.

The Formula Bar

The mathematical formula will appear in the Formula Bar when a cell that includes a formula is selected in the worksheet. In the example below, the formula to average grades is in cell E2. When cell E2 is selected, the formula appears in the Formula Bar.

Name Box - The Name Box displays the active cell address. For example, the selected cell in the image below is at the intersection of column D and row 3. "D3" will appear in the name box, indicating that the active cell is D3. The content of the selected cell appears in the Formula bar to the right of the Name box.

Worksheet Tabs - You can keep multiple worksheets together in a group called a workbook. For example you could have a separate worksheet for each month of the year in a workbook for the year 2007. You can give worksheets your own meaningful names by placing your cursor over the sheet name and typing. By default, Excel opens with three worksheets.

Scroll Bars - Horizontal and Vertical scroll bars are available to help you move around your spreadsheet. The scroll box shows where you are in the workbook. For example, if the scroll box is near the bottom of the scroll bar, you're at the beginning of a workbook.

Status Bar - If the Status bar is on, it will appear at the bottom of the screen. It displays messages and feedback. Do the following exercise to learn how to use the Status bar.

Point to View in the Menu bar.
Click the mouse button. A drop-down menu will open.
On the drop-down menu, if the Status Bar has a check mark next to it, it is turned on. Press the Escape key to close the menu.
If the Status Bar does not have a check mark next to it, press the down arrow until it is highlighted, then press enter. The Status Bar should now appear at the bottom of the screen.

You should see the work "Ready" on the Status Bar at the left side of the screen. This tells you that Excel is in Ready mode and waiting for your next command. There are other indicators that appear on the Status Bar in the lower right of the screen.

Num Lock Key - The Num Lock key is a toggle key. When you turn it on and off, the Status Bar let you know the Num Lock key status.

Caps Lock Key - The Caps Lock key is also a toggle key. The Status Bar will also indicate whether or not it is on or off. When it is on, you will see "CAPS" in the Status Bar.

Excel 2003 Tutorial: Create a New Workbook

Excel provides several ways to create a new workbook. Commands can be given to Excel using the menus or the toolbars.

You can position the cursor over the New Button on the Standard Tool bar. A Screen Tip appears over the button to identify what the button is.

Click the New Button and a new, blank workbook appears.

Create a New Workbook from the File Menu

You can also click on the File menu and choose the New command. This will also open a new Excel workbook. You can navigate the menus by using the arrow key

When you click on the word File on the Menu bar, a menu drops down. The File menu contains a list of file-related commands. Click on New or use the key commands Ctrl + N to create a new, blank workbook.

You can also use the File menu to close a workbook. Choose File, Close.

Excel 2003 Tutorial: Moving Around the Excel Worksheet

Before you start entering data into a worksheet, you need to learn how to move around in a worksheet. Before you can enter information into a cell, you must make the cell active by selecting it. You can make a cell active by using the mouse and clicking in a cell or you can use the keyboard to move the cell pointer using the keyboard's arrow keys.

Excel provide several ways to move about the cells in the Excel Workspace. Open Excel and practice moving around the worksheet by following the steps below:

Using the Arrow Keys

You can use the arrow keys on the keyboard to move around the Excel worksheet one cell at a time. Press the down arrow to move down one cell at a time. Press the up arrow several times to move up one cell at a time. Press the right and left arrow keys to move left and right one cell at a time.

You can use the End Key in conjunction with the Arrow keys to move the cursor to the far end of the spreadsheet in the direction of the arrow.

Using the Tab Key

You can use the Tab key to move across the page to the right one cell at a time. Hold the Shift key + Tab to move to the left one cell at a time.

Using the Page Up and Page Down Keys

You can use the Page Up and Page Down keys to move the cursor up and down the worksheet one page at a time.

Using the Home Key

The Home key used in conjunction with the End key moves the cursor to cell A1 or to the beginning of any data that has been entered into the worksheet.

Keyboard Shortcuts for Moving Around a Worksheet

Press	To Move
Right arrow or Tab	One cell to the right
Left arrow or Shift+Tab	One cell to the left
Up arrow key	Up one row
Down arrow key	Down one row
Home	Jump to the cell in column A in the current row

Excel 2003 Tutorial: Adjusting Column Widths and Row Heights

If you enter text or numbers into a cell and you find that it spans beyond the width of the cell, you can make the column wider by clicking and dragging the dividing line between the two columns. Place your cursor over the dividing line, click, and than drag it to the desired width and then release your mouse.

Excel 2003 Tutorial: Editing Cells in Excel

Before you can perform a function on cells, you must select them. You can do that by clicking on a column label to select all cells in that column, a row label to select all cells in a particular row, or you can click and drag your mouse over a group of cell. Selected cells turned blue and have a black border line around the them.

Excel 2003 Tutorial: Selecting Cells in Excel

There are several ways to select cells in Excel. To select a column, simply click on the letter of the column you wish to select. To select a row, click on the row number on the left side of the workspace. All of the cells in that row will be selected. You can also click and drag the mouse over the cells you wish to select.

Another way to select cells is to place the cursor in the upper left cell that you want to highlight. Press the F8 key. This anchors the cursor. Notice that "EXT" appears in the Status bar in the lower right of the screen. This indicates that you are in the Extend mode. Click in the cell on the lower right corner of the group of cells that you want to select.

For example, click in cell A1. Then hit the F8 key to anchor the cursor. Click in cell F8 and all of the cells between A1 and F8 will be selected. To release the cells, hit the Escape key.

Excel 2003 Tutorial: Entering Labels in an Excel 2003 Worksheet

Now that you've learned to navigate around an Excel 2003 spreadsheet, you're ready to start entering data. There are two basic types of information you can enter in a cell.

Labels: Labels are any type of text or information that is not used in any calculations.
Values: Any type of numerical data, such as numbers, percentages, fractions, divisors, dates, currencies, times, etc.

Labels are used for worksheet headings and make your worksheets organized and easy to read. They usually contain text, but can also contain numerical information not used for calculations, such as numbers or dates. See the sample headings below for Grades across the top row and Students down the first column.

This is what a basic spreadsheet may look like. Notice that numbers automatically align to the right, while text automatically aligns to the left. A row has been allowed at the top for column headings and a column has been allowed on the left for row headings. These have been placed in bold.

The grade average in cell E2 was not entered. Instead a formula was entered to add the three grade columns and divide the total by three to find the average grade. When that formula was copied into each of the rows in column E, Excel automatically calculated the average for each student.

Excell 2003 Tutorial: Saving an Excel Workbook

After you've created a worksheet, you need to save it if you intend on using it again. Saving a worksheet stores in in a file on your computer's hard disk. Once you've saved a worksheet the first time, it's a good idea to save it often so you don't lose your work should something happen to the file or your computer. You don't want to lose all your work if the power goes out or something else unexpected happens.

Select File > Save As from the menu bar. The Save As dialog box will appear and you will be given the opportunity to give the file a name and choose the location on your hard drive where you want to save the file. Once you've given the file a name and saved it, in the future, when you make any changes to the file, you only need to click the save button to save the most recent changes to the file.

Excel 2003 Tutorials

Excel Video Tutorials
Lesson 1: Excel Basics
Lesson 2: Editing a Worksheet
Lesson 3: Making Bar and Circle Graphs
Lesson 4: Making a Gantt Chart
Lesson 5: Excel Keyboard Shortcuts

More Excel Tutorials at GuidesandTutorials.net

All other Guides and Tutorials

Audacity Tips & Tricks
Audacity tips and tricks submitted by users

GuidesandTutorials: Advance Organizers Tutorial
An Introduction to Advance Organizers including presentations, examples, and downloadable handouts.

GuidesandTutorials: Digital Photography
Digital Photography Guide

GuidesandTutorials: Free PowerPoint Templates
Free PowerPoint templates that you can download and use today. This is a growing library of free resources for PowerPoint users.

Word Tutorial: Microsoft Word 2003
This Word tutorial is just what you need to learn how to use Word 2003 to create professional looking documents.

2009-07-03T02:48:00.000-07:00

muhasabah cinta artansa

Wahai… Pemilik nyawaku
Betapa lemah diriku ini
Berat ujian dariMu
Kupasrahkan semua padaMu

Tuhan… Baru ku sadar
Indah nikmat sehat itu
Tak pandai aku bersyukur
Kini kuharapkan cintaMu

Reff. :
Kata-kata cinta terucap indah
Mengalun berzikir di kidung doaku
Sakit yang kurasa biar jadi penawar dosaku
Butir-butir cinta air mataku
Teringat semua yang Kau beri untukku
Ampuni khilaf dan salah selama ini
Ya ilahi….
Muhasabah cintaku…

Tuhan… Kuatkan aku
Lindungiku dari putus asa
Jika ku harus mati
Pertemukan aku denganMu

kebahagiaanku

2008-03-14T01:58:00.001-07:00

Asalamualaikum........................./

D
DSFD
G
FHFG

H

T

d!fG
1