Kursus Microsoft Word, Powerpoint dan Excel

Microsoft Word

Starting Word
• Shortcut Menus
• Saving a Document
• Creating a New Document
• Ask for help using the Office Assistant

Basic Editing
• Cursors
• Cursor Movement
• Inserting Text
• Word Wrap
• Deleting Characters
• Undo and Redo

Formatting
• Selecting Text
• Applying a Font
• Font Size
• Font Attributes
• Font Colour
• Text Alignment
• Moving and Copying More Editing Features

Zooming
• Views of a Document
• Find and Replace
• Spell Checker
• AutoCorrect
• Case Conversion
• Format Painter


Paragraph Formatting
• What is a Paragraph?
• Selecting a Paragraph
• Indents
• Units of Measure
• Line Spacing

Tables
• Typing into the Table
• Moving around the Table
• Selecting Cells within a Table
• Inserting/Deleting Rows and Columns
• Altering Column Widths
• Adjusting Row Heights
• Borders and Shading


Bullets and Numbering
• Creating a Bulleted list
• Creating a Numbered list
• Page Set Up and Printing


Pagination
• Setting Margins
• Page Size and Orientation
• Automatic Page Numbering

Printing
• Print Previewing

Powerpoint

Creating New Presentations
• The Opening Screen
• Using the Ribbon
• Quick Access Toolbar
• Creating a new Presentation
• Saving a Presentation
• Closing and Opening a Presentation
• Printing a Presentation

Text Charts
• Title Pages
• Bullet Charts
• Editing and Enhancing bullet charts

Creating Chart Slides
• Creating a Chart
• Changing Chart Type
• Adding Chart Elements
• Formatting a Chart
• Quick Chart Elements
• Using Chart Designs
• Saving the Chart to a New Sheet

Diagrams
• Creating an Organisation Chart
• Entering Personnel Data
• Adding and Removing Boxes
• Formatting text, boxes and lines
• Other types of Diagrams

Creating Table Slides
• Creating Tables
• Adding text and numbers
• Formatting the data and table
• Inserting rows and columns
• Deleting rows and columns

Using Clipart & Pictures
• Inserting ClipArt or a Picture
• Sizing and Cropping images
• Re-colouring an Image
• Grouping & Un-Grouping Images

Printing
• Viewing the Slides
• Re-ordering the Slides
• Using Headers & Footers
• Spell Check
• Printing the Slides

On Screen Shows
• Running an On-Screen Show
• On-Screen Show with Transitions

Microsoft Excel

Introduction to Excel
• The Excel Screen
• Using the Ribbon
• The quick Access Toolbar
• Saving, Opening, Closing a Workbook
• Moving around the Worksheet

Entering Data
• Entering, editing and deleting data
• Undo and Redo
• Filling Cells
• Cut, Copy and Paste
• Using the Windows Clipboard
• Working with Rows and Columns
• Inserting and Deleting Columns and Rows
• Change Column Width & Row Height
• Hide and Un-Hide Columns

Formatting Cells
• Highlighting Methods
• Formatting Text & Numbers
• Alignment of Cells
• Merging Cells
• Wrapping Text
• Borders and Shading

Working with Worksheets
• Renaming Worksheets
• Inserting Worksheets
• Move and Copy Worksheets
• Delete Worksheets

AutoFill
• How to use the AutoFill Handle
• Using AutoFill to Copy Sequence
• Using AutoFill to Replicate
• Customer AutoFill Lists

Viewing Data
• Zooming a Workbook
• Freezing Panes
• Splitting a Window

Using Formulae and Functions
• How to Enter a Formula
• What are Functions
• Using Sum/Average/Max/Min
• Copying Formulas
• Relative and Absolute References

Printing
• Setting up the Page for Printing
• Using Different Views
• Adding Headers and Footers
• Using Print Titles
• Setting and Clearing Print Areas

Simple Charts
• Creating Simple Charts
• Changing Chart Type
• Formatting a Chart