MICROSOFT EXCEL BASIC

ACARA

15 – 16 Maret 2018 | Rp 3.200.000,- di Graha Mustika Ratu, Jakarta
03 – 04 Juli 2018 | Rp 3.200.000,- di Graha Mustika Ratu, Jakarta
02 – 03 Oktober 2018 | Rp 3.200.000,- di Graha Mustika Ratu, Jakarta
11 – 12 Desember 2018 | Rp 3.200.000,- di Graha Mustika Ratu, Jakarta

Materi Training Microsoft Excel Basic

1. Get Started with Excel
   • What is Excel?
   • Creat a workbook
   • Add, Delete, or rename sheet
2. Design workbook
   • Hide or unhide columns
   • Freeze top and left panes
   • Move or copy worksheets
   • Apply themes to change the look of a workbook
3. Add text and Data
   • Add and edit data
   • Resize and merge cellsandalign data
   • Format numbersincells
   • Change tha look of
   • Copy cell formatting select
   • Cell contents
   • Move or copy cell contents
   • Insert or delete rows or columns
   • Resize rows and columns
   • AutoFill time spans
   • Split and combine data
   • Build custom numeric format
   • Validate cell data
4. Use formulas and function
   • Create formulas
   • Name cells and ranges
   • Locate functions
   • Calculations using functions
5. Add and format tables
   • Createand format tables
   • Sort data in a table
   • Filter data in a table
   • Add a Total row to a table
6. Collaborate with others
   • Share workbooks
   • Import data
7. Create and format PivotTables
   • Create PivotTables
   • Work with PivotTables
   • Group data in PivotTables
8. Analyze and chart data
   • Quick Analysis of data
9. Add and format charts
   • Create charts
   • Format charts
   • Add Cond. Formatting and interactive chart
10. Password-protect workbooks

Waktu Training Microsoft Excel Basic

Pk. 09.00 – 17.00
Di: Graha Mustika Ratu
Jl. Jend. Gatot Subroto kav. 74-75
Jakarta 12870

Investasi Training Microsoft Excel Basic

• Rp. 3.200.000/orang/program.
• (Include: handout, setifikat, 2x coffee break dan makan siang)

MICROSOFT EXCEL BASIC