Brosur Webmedia

Silahkan Download disini:

PDF. Download

Butuh Informasi Tambahan Bisa Hubungi Kami:

0852 6114 0004

Bisa Masuk Kelas Ujicoba

Dipersilahkan masuk ke kelas untuk melihat proses belajar dan mengajar.
Excel Advanced

Deskripsi Kelas MICROSOFT EXCEL ADVANCED

Kelas pembelajaran advanced untuk staf perusahaan yang ingin meningkatkan ketrampilan dalam bidang Microsoft Excel untuk manajemen dan pembuatan data, mengolah data secara otomatis, dan penggunaan fungsi dan formula yang bertujuan membantu pembuatan report ke manajemen.

  • Jumlah Pertemuan

    Pertemuan: 13 x 2 jam Pilihan Hari Belajar: Senin s.d Jumat aau 3 x seminggu

  • Biaya Belajar

    Biaya: Rp. 1.300.000,- Pendaftaran : Rp. 50.000,-

Output Pembelajaran:

- Peserta mengerti berbagai cara melakukan manajemen dan pembuatan data
- Peserta mampu mengolah data dengan berbagai formula yang terdapat pada Mircrosoft Excel
- Peserta mampu menggunakan fungsi-fungsi lainnya, seperti : fungsi lookup, macros, dan sebagainya

Materi Belajar:

Module 1: Overview of the Basics Customizing common options in Excel
• Absolute and relative cells
• Protecting and un-protecting worksheets and cells

Module 2: Working with Functions
Writing conditional expressions (using IF)
• Using logical functions (AND, OR, NOT)
• Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH,INDEX)
• VlookUP with Exact Match, Approximate Match
• Nested VlookUP with Exact Match
• VlookUP with Tables, Dynamic Ranges
• Nested VlookUP with Exact Match
• Using VLookUP to consolidate Data from Multiple Sheets
Module 3: Data Validations
Specifying a valid range of values for a cell
• Specifying a list of valid values for a cell

• Specifying custom validations based on formula for a cell
Module 4: Working with Templates
Designing the structure of a template
• Using templates for standardization of worksheets
Module 5: Sorting and Filtering Data
Sorting tables
• Using multiple-level sorting
• Using custom sorting
• Filtering data for selected view (AutoFilter)
• Using advanced filter options
Module 6: Working with Reports
Creating subtotals
• Multiple-level subtotals
• Creating Pivot tables
• Formatting and customizing Pivot tables
• Using advanced options of Pivot tables
• Pivot charts
• Consolidating data from multiple sheets and files using Pivot tables
• Using external data sources Using data consolidation feature to consolidate data
Creating Groups
Show Value As ( % of Row, % of Column, Running Total, Compare with Specific Field)
• Viewing Subtotal under Pivot
• Creating Slicers ( Version 2010 & Above)
Module 7: More Functions
Date and time functions
• Text functions
• Database functions
• Power Functions (CountIf, CountIFS, SumIF, SumIfS)
Module 8: Formatting
Using auto formatting option for worksheets
• Using conditional formatting option for rows, columns and cells
• Using IF Formula’s & Conditional Formatting
Module 9: Macros
Relative & Absolute Macros
• Editing Macro’s
Module 10: WhatIF Analysis
Goal Seek
• Data Tables
• Scenario Manager
Module 11: Charts
Using Charts
• Formatting Charts
• Using 3D Graphs
• Using Bar and Line Chart together
• Using Secondary Axis in Graphs
• Sharing Charts with PowerPoint / MS Word, Dynamically (Data Modified in Excel, Chart would automatically get updated)
Module 12: New Features of Excel
Sparklines, Inline Charts, data Charts
• Overview of all the new features


belajar komputer

Hubungi Kami :
WEBMEDIA Training Center
Jl. Setiabudi, Komp. Setiabudi Bisnis Point No.12-13 CC, Medan – 20122
HP/WA: 085261140004, 085212665455
http://www.webmediacenter.com
email : sales@webmediacenter.com

kalenderkonten
absensikantor
carik.id
mallkopi