MICROSOFT EXCEL 2013

OUTLINE

ObjectiveExcel IntroductionHow to Start & Ended Excel ProgramScreen PreviewBasics WorksheetFormat Worksheet

Introduction to Microsoft Excel

Ms Excel is a spreadsheet program in Microsoft Office system .

Ms Excel capability:– Table maker– Graphic maker– Quick and interactive to Sort & Filter Data– Compatible with others known format

worksheet such as Lotus.

Starting Excel Choose Icon Microsoft Excel

Tab Windows pad on your keyboard to view the whole program

Mengakhiri Ms Excel Click on Menu File

Then choose Close

Alt + F4

Formula bar

Menu BarIcon

Tool Bar

Mouse Pointer

Row NumberColoum Letter

Nama Sheet

Right click Customise , U/ add Icon that frequently uses icon

Workbook – Screen Display

Dasar - Dasar Worksheet

Pemilihan Sel dalam Workheet– A Single Cell– A Range of Cell (Blok)– Nonadjancent

Memasukkan Data ke dalam Worksheet– Constanta Value (Angka, Tanggal, Jam,

Teks)– Formula (diawali dengan tanda ” = ” )

Membuat Series

Format Worksheet Change column and row Change format cel

– Font– Number– Alignment– Border– Pattern

Using Style

Change row(Format Row Height)

Change Column (Format Column Width)

Change row and column

Format Sel

Font

Number Alignment

Border

FORMAT FONT

E= mc2

H2SO4

FORMAT NUMBER

Jika ingin menambahkan format number baru

GeneralLeft(Indent)CenterRightFillJustifyCenter Across Selection

TopCenterBottom

Menyesuaikan text sesuai lebar kolom.

Derajat Kemiringan huruf

Menggabungkan Sel

Menyesusaikan text dengan lebar kolom , Jika text cukup panjang maka hurufnya akan diperkecil

FORMAT ALIGNMENT

Cara 2 :Klik daerah yang ingin diberi border

Klik Icon ini u/ menghapus BorderHanya Garis luar

Model / ukuran garis

Warna Garis

Cara 1 :

FORMAT BORDER

FORMAT FILL

Klik Icon No Color , untuk menghapus warna yang sudah dipilih

Warna Dasar

Edit Workbook Delete

(Toolbar Editing Menu Clear)

Clear format

Clear All

Clear Content Clear Coment

Edit Workbook Move And Copy

– Cut – Copy – Paste– Format Painter– Paste Special

Pengeditan Workbook Insert & Delete Cells, Rows and

Columns– Insert Cells– Delete Cells– Insert Sheet Rows– Delete Sheet Rows– Insert Sheet Columns– Delete Sheet Columns

Delete Sheet

Insert Sheet

Select, insert, delete, rename, move and copy worksheets

Edit Workbook

MANAGEMENT DATA EXCEL

Validasi data Sort Data Subtotals

The function of excel is spreadsheet, Excel has a good manajemen.Dalam Excel, istilah database lebih dikenal sebagai LIST

Filter Pivot Tabel Transpost

Tabel

Validasi Data

Untuk melakukan validasi terhadap suatu data yang akan diinput ke suatu sel atau range.Contoh :

Jumlah Pembelian harus 0 - 1000Maka yang harus dilakukan :

Blok --> pilih Menu Data --> Validation

Sort

For Sorting DataBlok data --> choose Menu Data --> Sort

Subtotal

For sum data depanse on the result

Blok Pilih Toolbar Data Menu Subtotal Contoh : Total Biaya per orang

Filter

For filtering data

Pilih Menu Data --> Filter --> AutoFilter

Example : To show the name who take Group ”Batu Battery”

Pilih Jenis Filter yang diinginkan

Filter

For Filter Data

Pilih Menu Data --> Filter --> AutoFilter --> Custom

Example : Show the name who already take more than 10.

Custom

Pivot Tabel

We can organize the table. So we can set and compare data without change the structre

data in worksheet.

Blok data Menu Insert Pivot Table

Transpose Tabel

Change format tableBlok data --> Edit -->Copy -->Click cell tujuan -->

Edit --> Paste Special --> Transpose

GRAFIK

Column Area Blocks Line - Column on 2 Axes

Macam - macam Grafik di Excel :

Blok Data --> Chart Wizard [choose menu Insert --> Chart] --> type of Chart --> Next (setelah selesai mengisi kotak dialog Next --> Finish)For add new data into grafik :

1. Type in worksheet2. Blok Data 3. Drag into grafik

Pie Bar

Page Setup

Bentuk Kertas

Persentase Pencetakan

Ukuran Kertas

Print

Print Preview

Page Setup

Print

Set Print Area

ToolBar --> Menu Pagee

Layout

Margin

Terletak di tengah (Jarak antara tulisan dengan margin Kiri & Kanan Sama)

Terletak di tengah (Jarak antara tulisan dengan margin atas & bawah Sama )

Header / Footer

Insert Page Number Total PagesDate’s

SystemTime’s System

File’s Name

Format Text

Sheet’s Name

Path’s Name

Insert Picture

Format Picture