📋 Bagian 1: Pengenalan Microsoft Office
Apa itu Microsoft Office?
Microsoft Office adalah suite aplikasi produktivitas paling populer di dunia untuk membuat dokumen, spreadsheet, presentasi, dan manajemen data. Digunakan di sekolah, kantor, dan bisnis.
- 📝 Word: Pengolah kata & dokumen
- 📊 Excel: Spreadsheet & analisis data
- 📽️ PowerPoint: Presentasi slide
- 🗄️ Access: Database sederhana
- 📧 Outlook: Email & kalender
Versi Office
| Versi | Fitur | Kompatibilitas |
|---|---|---|
| Office 365/Online | Cloud, gratis terbatas | Web, semua OS |
| Office 2021/2019 | Desktop lengkap | Windows/Mac |
| Office 2016/2013 | Legacy | Windows lama |
📄 Bagian 2: Microsoft Word Lengkap
Dasar Word
Buat dokumen baru: Ctrl+N | Simpan: Ctrl+S | Cetak: Ctrl+P
Ctrl+B Bold | Ctrl+I Italic | Ctrl+U Underline
Ctrl+Z Undo | Ctrl+Y Redo
Ctrl+Z Undo | Ctrl+Y Redo
Formatting Lanjutan
- Styles: Heading 1-6 untuk struktur
- Table: Insert > Table | AutoFit
- Pictures: Insert > Pictures | Wrap Text
- Header/Footer: Insert > Header
Mail Merge
Gabung data Excel ke dokumen: Mailings > Start Mail Merge > Use Existing List
📈 Bagian 3: Excel Dasar
Navigasi & Cell
- A1: Kolom A, Baris 1
- Ctrl+Arrow: Lompat ke edge data
- F2: Edit cell | Ctrl+D: Fill Down
Format Cells
Currency: Ctrl+Shift+$ | Percentage: Ctrl+Shift+%
Ctrl+1: Format Cells dialog
Ctrl+1: Format Cells dialog
🔢 Bagian 4: Formulas & Functions
=SUM(A1:A10)
=AVERAGE(B2:B20)
=MAX(C1:C5)
=IF(A1>80, "Lulus", "Gagal")
=VLOOKUP(D1, A1:B10, 2, FALSE)
=COUNTIF(A1:A100, ">80")
Pivot Table Dasar
Insert > PivotTable | Drag field ke Rows/Values
📊 Bagian 5: Charts & PivotTable
Chart Types
- Column/Bar: Perbandingan kategori
- Line: Tren waktu
- Pie: Proporsi
- Scatter: Korelasi
Pivot: Analisis data besar → Summary cepat
📽️ Bagian 6: PowerPoint Dasar
Slide Management
- New Slide: Ctrl+M
- Duplicate: Ctrl+D
- Theme: Design > Themes
Insert Elements
Pictures/Shapes: Insert tab
Text Box: Ctrl+Shift+T
Text Box: Ctrl+Shift+T
✨ Bagian 7: PPT Advanced & Animations
Animations
- Entrance: Appear/Fade
- Emphasis: Grow/Spin
- Exit: Fly Out
- Path: Motion Paths
Presenter View: F5 Start | Alt+F5 Rehearse
📧 Bagian 8: Access, Outlook & Lainnya
Access Database
Create > Table Design | Relationships untuk hubungan tabel
Outlook
- Quick Steps: Pengelolaan email cepat
- Rules: Filter otomatis
- Calendar Sharing
⌨️ Bagian 9: Shortcut & Produktivitas
Universal Shortcuts
Ctrl+C Copy | Ctrl+V Paste | Ctrl+X Cut
Ctrl+Z Undo | F4 Repeat
Ctrl+Z Undo | F4 Repeat
Word Shortcuts
Ctrl+Enter: New Page | F12: Save As
Alt+Shift+↑↓: Move Paragraph
Alt+Shift+↑↓: Move Paragraph
Excel Shortcuts
Ctrl+Shift+Enter: Array Formula
Ctrl+`: Show Formulas | F4: Toggle $
Ctrl+`: Show Formulas | F4: Toggle $
🚀 Bagian 10: Proyek & Tips Office
- Laporan Sekolah: Word + Chart dari Excel
- Presentasi Ujian: PPT dengan animations
- Database Siswa: Access untuk rapor
- Dashboard Keuangan: Excel Pivot + Slicer
Pro Tips: OneDrive sync | Version History | Co-authoring