Skip to main content

SILABUS TRAINING MICROSOFT EXCEL ADVANCED


TRAINING MICROSOFT EXCEL ADVANCED

MICROSOFT EXCEL ADVANCED TRAINING

Purnama Academy Bandung , Jakarta Training Provider
Method : Online Training , Offline Public Training, Inhouse training
Duration : Call/WA 0838-0838-0001



What is :
Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.

What You will learn :
Able to use and apply Database function
Able to use and apply Logical function (IF, AND)
Able to use and apply Statistical function (COUNTIF, AVERAGEIF, COUNTIFS, AVERAGEIFS)
Able to use and apply Mathematical function (SUMIF, SUMIFS)
Able to use and apply Lookup function (VLOOKUP)
Able to use Auto and Advanced Filter command
Able to validate data
Able to apply Conditional Formatting
Able to Protect worksheet and workbook
Upon completion of this program, participants should be able to:

Advance Chart function and PowerPivot Function
Analyze data Using Pivot Tables
Perform What If Analysis using:
Goal Seek
Solver
Input Table
Scenarios
Use VLOOKUP function to extract data
Nesting INDEX and MATCH Function
Combining & Consolidating Data
Create Hyperlink in a workbook


Syllabus Detail : Call/ Whatsapp 0838-0838-0001 , http://www.purnamaAcademy.com
ALL THE BEST TRAINING YOU CAN GET WITH OUR BEST TRAINER
COVID-19 COMPLIANT


Other Recommendation training in Purnama Academy :

Excel Advanced for Business & Accounting
Excel VBA Macro Programming
Excel PowerPivot , PowerView, Power BI

Comments

Popular posts from this blog

Sewa Ruang Meeting Daerah Citarum Bandung

Sewa ruang meeting kantor, training di Bandung Hubungi 0816-4038-78. Lokasi Ruang Meeting berada di Jl.Pelajar Pejuang 45 No.23B 1. Paket per Jam      - Biaya : Rp.50.000 / org / jam     - Fasilitas : Snack & Drink 2. Paket Half-Day     - Waktu : 09.00 s/d 13.00 Wib     - Biaya : Rp.120.000 / org      - Fasilitas : Makan siang 1x, Snack & Drink 3. Paket Full Day     - Waktu : 09.00 s/d 16.00 Wib     - Biaya : Rp.170.000 / org      - Fasilitas : Makan siang 1x, Coffe break 2x, Snack & Drink 4. Lain-lain     - Sewa Proyektor : Rp.150.000/day     - Extra time : Rp.100.000/Jam Syarat dan Ketentuan : 1. Min. 3org dan Max. 7org 2. Pembayaran H-3 sebelum tgl pelaksanaan 3. Melebihi jam ketentuan dikenakan biaya tambahan Sewa Ruang Meeting Daerah Citarum Bandung Hubungi 0816-4038-78 Ruang meeting murah mulai 50.000 di Buah Batu, Pasteur, Sukajadi, Lengkong, Antapani, Uj...

TRAINING PROJECT MANAGEMENT WITH PRIMAVERA P6-BANDUNG

TRAINING PROJECT MANAGEMENT WITH PRIMAVERA P6 By Purnama Academy - Training Center January 11, 2018  No comments PROJECT MANAGEMENT WITH PRIMAVERA P6 Syllabus Overview PRIMAVERA P6 adalah project management tool yang sangat populer digunakan hampir di perusahan perusahaan skala internasional dan multinasional yang sedang menjalankan project skala besar, lisensi atas PRIMAVERA P6 kini dimiliki oleh Vendor Oracle dan database yang disupport Primavera adalah SQL Server dan Oracle database. Sebagai sebuah software Project Tool skala enterprise maka Primavera memiliki 2 module di dalamnya yaitu (Methodology dan Project Management) Class Type : Training Duration : 4 Days (09.00 – 17.00) Venue  & Price : Click Here , Registration : Click Here  (Save up to 20% for Early Bird Registration !) Detail Syllabus or request for inhouse training  please contact Purnama Academy sales team info@purnamaacademy.com , Hotline (Call/SMS/Whatsapp) : 0838-0838-0001 Speaker  : Purn...