Tanggal | Tempat | Kota |
---|---|---|
Belum ada jadwal terbaru |
OVERVIEW
This customized Microsoft Excel training class is intended for participants who want to advance their skill set by learning to work with advanced formulas, lists, illustrations, and data analysis. In this training class, participants will also work with charts and advanced formatting including styles.
Instructor-led online/onsite classes are conducted using a minimum of the 2016 software version. The instructor will point out minor differences between the versions in which they exist. For specialized instructor-led online and onsite classes, the version of the software used in the participant’s office will be used in the program.
OBJECTIVES
1. Organize ribbon, work-area, and worksheets
2. Perform calculations in an Excel worksheet using autosum, logic, and lookup formula
3. Modify the appearance of data within a worksheet using filter and sort function
4. Create data visual using Conditional Formatting and Sparkline
5. Analyze data using Pivot table, Pivot chart, and Slicer
6. Modify graphic using picture tab menu
COURSE OUTLINE
1. Excel Feature Retrieval
2. Sheet Management
3. Cell Management
4. AutoSUM Formula
5. Logic Formula
6. Data Analysis
7. Visual Analysis
8. Graphic Modification
TRAINING METHOD
Presentation
Discussion
Case Study
Evaluation
FACILITIES
Training Kit
Handout
Certificate
Lunch + 2x Coffee Break
Souvenir
Data Materi Training | |
Topik Training | : Enhancing Productivity with Microsoft Excel |
Link | |
*Jumlah Peserta | |
*Nama Peserta Yang Didaftarkan | |
Personal Data | |
*Nama | |
*Jabatan | |
*Nama Perusahaan | |
*Alamat Perusahaan | |
*Email Perusahaan | |
*Email Alternatif | |
*Telepon Kantor | |
Ekstensi | |
*Handphone | |
* Harus di isi | |
![]() | |