Skip to main content

🗓

Jadwal Bulan Ini Purnama Academy

TRAINING MICROSOFT EXCEL ADVANCED

Image
By Admin
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

Labels:

Comments

Post a Comment

Terima kasih telah mengunjungi halaman website kami, Jika ada pertanyaan terkait informasi di Atas silahkan isi Comment Box di bawah ini, Tim kami akan merespon komentar/ pertanyaan Anda paling lambat 2 x 24 Jam

Untuk respon cepat silahkan hubungi 0838-0838-0001 (Call/Whatsapp)

Regards,

Management,
www.purnamaacademy.com

Popular posts from this blog

TRAINING MYSQL DATABASE ADMINISTRATOR (DBA)

By Admin
MYSQL DATABASE ADMINISTRATOR (DBA) www.purnamaacademy.com , Hotline (Call/SMS/WA) :  0838-0838-0001 Syllabus Overview Melalui training ini peserta mampu memahami tugas tugas seorang Database Administrator dalam mengelola Database Server MySQL terkait storage management, user management, keamanan , performance dan juga cara pemantauan kinerja server database Class Type : Training Duration : 3 Days (09.00 – 17.00) Venue / Price : Click Here , Registration : Click Here   (Save up to 20% for Early Bird Registration !) Description : MySQL adalah sebuah perangkat lunak sistem manajemen basis data SQL (bahasa Inggris: database management system) atau DBMS yang multithread, multi-user, dengan sekitar 6 juta instalasi di seluruh dunia. MySQL AB membuat MySQL tersedia sebagai perangkat lunak gratis dibawah lisensi GNU General Public License (GPL), tetapi mereka juga menjual dibawah lisensi komersial untuk kasus-kasus di mana penggunaannya tidak cocok denga...
Post a Comment
Detail Training Info »

TRAINING ISO 45005 : 2020 K3 COVID - Pedoman umum untuk bekerja dengan aman selama pandemi COVID-19

By Admin
SILABUS ISO 45005 , Training ISO 45005 di Purnama Academy Bandung, Jakarta, (Online, Offline, Inhouse Training) hubungi tim sales call/Whatsapp 0838-0838-0001 ISO/PAS 45005:2020 Manajemen kesehatan dan keselamatan kerja Pedoman umum untuk bekerja dengan aman selama pandemi COVID-19 Durasi : 09.00 – 16.00 WIB ( 3  Hari ) Deskripsi : ISO (the International Organization for Standardization) adalah sebuah organisasi yang tersusun atas federasi dari berbagai komite yang memiliki kepentingan untuk mencipatakan  berbagai standarisasi internasional di setiap bidang yang di wakili teknisnya oleh komite, setiap komite bisa terdiri atas organsasi , pemerintahan ataupun non organisasi yang berkompetensi Dokumen ISO 45005 dipublikasikan sebagai respon  terhadap pandemi COVID-19 dan peningkatan risiko penyakit ini terhadap kesehatan, keselamatan, dan kesejahteraan orang . Didalam dokumen mencakup  semua pengaturan terhadap orang, termasuk mereka yang bekerja di rumah atau di lingkungan bergerak (...
Post a Comment
Detail Training Info »

CISA Exam Preparation Training

By Admin
  CISA Exam Preparation Training | Purnama Academy Prepare for the CISA Certification with Confidence The demand for qualified IT Auditors and IT Governance professionals continues to increase as organizations rely more on technology to run critical business processes. One of the most recognized credentials in this field is the CISA (Certified Information Systems Auditor) certification. Purnama Academy offers a comprehensive CISA Exam Preparation Training designed to help professionals understand the exam structure, master key domains, and improve their chances of passing the CISA examination on the first attempt. What Is CISA (Certified Information Systems Auditor)? CISA is a globally recognized professional certification issued by ISACA . It validates an individual’s knowledge and skills in auditing, controlling, monitoring, and assessing enterprise information systems. CISA certification focuses on ensuring that information systems are: Properly ...
Post a Comment
Detail Training Info »