Kursus Microsoft Excel

Kursus Microsoft Excel Lanjutan adalah bertujuan untuk menyediakan kemahiran dan pengetahuan tambahan mengenai aplikasi microsoft excel yang akan membantu peserta dalam meningkat tahap prestasi kerja, dan menjalankan kerja seharian dengan lebih cekap dan efisyen.

Di dalam kursus ini peserta akan belajar mengendalikan operasi data yang menggunakan Merumuskan, JadualPivot, Penggabungan Data, mancari matlamat dan penyelesai , dan membuat dan menggunakan makro.


Kandungan Kursus

Jadual – Hari 1 (Asas)

Lesson 1: Introduction
Topic A: Using the menus
Topic B: Versions

Lesson 2: Data Entry
Topic A: Formula Bar
Topic B: Working with dates and times
Topic C: Format Cells/ Data Formatting
Topic D: Flash Fill Series

Lesson 3: Creating formulas
Topic A: AutoSum/Average
Topic B: Days Formula
Topic C: Formula Wizard
Topic D: Audit Formulas (Trace precedent/dependent)

Lesson 4: Formatting
Topic A: Inserting shapes, arrows, and other graphics
Topic B: Adding and deleting rows and columns
Topic C: Hiding data
Topic D: Moving, copying, and pasting
Topic E: Sorting and filtering data
Topic F: Conditional Formatting / Data Bars / Data Icon Sets

Lesson 5: Inserts
Topic A: Clipping Screens
Topic B: Images/ Shapes
Topic C: Recommended Charts
Topic D: Linking Charts in Powerpoint
Topic E: Advanced Charts / Combo Charts

Lesson 6: Print
Topic A: Print Area
Topic B: Repeat Titles on print
Topic C: Page Layout / Page Break

Lesson 7: Security
Topic A: Allow people to edit selected cells only (Creating Forms)
Topic B: Protecting Worksheet & Workbook (Read Only)
Topic C: Workbook Encryption (Password to open)

Kandungan Kursus

Jadual – Hari 2 (Lanjutan)

Lesson 1: Formulas in Depth
Topic A: IF Function
Topic B: 3D Formulas
Topic C: CHOOSE/MATCH/INDEX
Topic D: VLookup / H Lookup

Lesson 2: Define Names
Topic A: Create your own names
Topic B: Define Names in formulas and references

Lesson 3: PivotTables
Topic A: Using PivotTables and Filters
Topic B: PivotCharts
Topic C: Creating extended charts / business charts
Topic D: Gantt Charts

Lesson 4: Goal Seek
Topic A: PMT Formula (Loan Calculator)
Topic B: Goal Seek

Lesson 5: Scenario Manager
Topic A: Create various scenarios
Topic B: Using Scenarios

Lesson 6: Macro, Record and Play
Topic A: Record repeated tasks with Macro
Topic B: Add new buttons to your Excel to playback Macros
Topic C: VBA and Macro

Lesson 7: Microsoft Office Specialist Exam (77-420) Overview

Preview Kursus Microsoft Excel


Pemformattan Bersyarat

JadualPivot

Graf & Carta Lanjutan

Makro

Kursus Akan Datang

Pakej Kursus Terkini

Pertanyaan Pantas

Oktober, 2017

No Events

In-House Training

Kursus di tempat anda
  • Bayaran mengikut bilangan hari
  • Peserta Maksimum 40 Orang
  • Training Kit dan Bahan Latihan disediakan
  • Buku Panduan disediakan
  • Bantuan Teknikal selepas Kursus
[]
1 Step 1
Namanama penuh
Telefon
Pertanyaanbutiran
0 /
Bilangan Peserta
1
0
50
Previous
Next
X