Kursus Komputer Microsoft Office

Microsoft Office

Microsoft Office merupakan standar program yang digunakan untuk perkantoran, bisnis, organisasi, instansi pemerintah dan pendidikan.
Setelah mengikuti kursus ini anda memiliki kemampuan sbb:

Membuat Dokumen seperti surat menyurat, laporan, karya tulis, dll dengan menggunakan Micosoft Word
Mengolah data keuangan, akuntansi komputer, grafik, tabel dengan menggunakan Micosoft Excel.
Membuat presentasi secara visualisasi komputer dengan mengunakan Micosoft PowerPoint.
Menggunakan internet dan email untuk keperluan administrasi bisnis dan perkantoran modern.

Keahlian paket program ini diperlukan bagi: Manager, Staf, Sekretaris, Penulis, Pelajar/Mahasiswa, dll.

MATERI KURSUS:

Microsoft Windows
Microsoft Word
Microsoft Excel
Microsoft PowerPoint
Internet & Email

MATERI

Introduction to Microsoft Excel
Identify the Elements of the Excel Interface
Customize the Excel Interface
Navigate and Select Cells in Worksheets
Excel Basic Functions
Work with Cells (Numeric and Character)
Work with Cells (Rows and Columns)
Create and Modify Tables
Create and Modify Sheets
Excel Functions
Math Functions ( + , * , – , / )
Statistical Functions
Logical Functions and IF
LOOKUP Functions
Text Functions
Date Functions
Time Functions
Working with Charts
5. Modifying Chart Options
6. Formatting Charts
7. Printing

PowerPoint Basic

PowerPoint Basic adalah kursus powerpoint yang ditujukan bagi mereka yang baru mulai menggunakan PowerPoint untuk menyiapkan presentasi. Kursus ini dirancang dari perspektif pemula, sehingga materi akan difokuskan tidak hanya pada fitur utama dan juga pada alur untuk membangun presentasi yang sukses. Setelah menyelesaikan semua latihan, kandidat akan dapat mempersiapkan dan membangun slide, menambahkan efek yang menakjubkan, menerapkan efek transisi, dan mengatur presentasi.

OUTLINE MATERI

Getting started : Opening Microsoft PowerPoint, Interacting with PowerPoint, Closing Microsoft PowerPoint

*Slides
Adding a Slide
Deleting a Slide
Cutting, Copying and Pasting Slides
Text AutoFit

*Creating a Slide
Creating Text
Deleting Text  • Selecting Text
Cutting, Copying and Pasting Text
The Format Painter
Find and Replace

*Working with a Presentation
Creating Text
Deleting Text  • Selecting Text
Cutting, Copying and Pasting Text
The Format Painter
Find and Replace

*Getting Help in PowerPoint
The Help Menu
The Help Task Pane
The Office Assistant
Configuring the Office Assistant
Using the Type a Question Box
Getting Help in a Dialog Box

*Placeholders (Text Boxes)
Types of Placeholders (Text Boxes)
Resizing Placeholders
Moving a Placeholder
Deleting Placeholders

*Formatting a Slide
Add a Background Colour
Add Gradient Fills
Add Textures or Pictures

*Other Formatting Tools
Inserting Headers and Footers
Inserting Slide Numbers
Inserting the Date and Time

*Managing Slides
The View Toolbar
Slide Sorter View
The Slides Tab
The Outline View

*Formatting Text
Adjusting Font Size
Adjusting Font Type
Adding Effects
Changing Text’s Colour
Changing Font’s Case

Formatting Text from the Fonts Dialog Box

The Fonts Dialog Box

*Creating a Bulleted or Numbered List
Adding Bullets and Numbers
Customizing Bullets and Numbers
Removing Bullets and Numbers
Discontinuing Bullets and Numbers

*Using Paragraph Alignment
Left, Right, Or Centre Alignment
Justification
Changing Text Direction

*Proofing Tools
Spell Check
AutoCorrect
Set Your Language

*Print Preview
Opening Print Preview
The Print Preview Toolbar
The Print What Menu
Setting Options
Printing Your Presentation

*Creating and Working with Tables
Inserting and Drawing Tables
Inserting and Deleting Columns and Rows
Working with Cells

*Constructing Table Layout
Inserting and Drawing Tables
Inserting and Deleting Columns and Rows
Working with Cells

*Working with Charts and Graphs
Creating Charts and Graphs
Adding Titles and Data
Legends and Labels

*Creating Customized Charts
Choosing and Designing your Chart Style
Constructing 3-D Charts
Editing Chart Axes
Exhibiting Gridlines and Trendlines

*Working with Organization Charts
Creating Organization Charts
Choosing your Chart Style
Inserting Chart Shapes
Resizing Charts

*Customizing Your Diagrams
Adding/Editing Shapes
Altering Diagrams
Changing Diagram Schemes