MICROSOFT EXCEL BASIC
Graha Mustika Ratu, Jakarta | 02 – 03 Oktober 2018 | Rp 3.200.000,-
Graha Mustika Ratu, Jakarta | 11 – 12 Desember 2018 | Rp 3.200.000,-
Materi Training Microsoft Excel Basic
- Get Started with Excel
- What is Excel?
- Creat a workbook
- Add, Delete, or rename sheet
- Design workbook
- Hide or unhide columns
- Freeze top and left panes
- Move or copy worksheets
- Apply themes to change the look of a workbook
- 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
- Use formulas and function
- Create formulas
- Name cells and ranges
- Locate functions
- Calculations using functions
- Add and format tables
- Createand format tables
- Sort data in a table
- Filter data in a table
- Add a Total row to a table
- Collaborate with others
- Share workbooks
- Import data
- Create and format PivotTables
- Create PivotTables
- Work with PivotTables
- Group data in PivotTables
- Analyze and chart data
- Quick Analysis of data
- Add and format charts
- Create charts
- Format charts
- Add Cond. Formatting and interactive chart
- 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)