BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Smart Training Center - ECPv6.15.20//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-ORIGINAL-URL:https://smart-training-center.com
X-WR-CALDESC:Events for Smart Training Center
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:Asia/Krasnoyarsk
BEGIN:STANDARD
TZOFFSETFROM:+0700
TZOFFSETTO:+0700
TZNAME:+07
DTSTART:20250101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Asia/Krasnoyarsk:20260602T083000
DTEND;TZID=Asia/Krasnoyarsk:20260604T160000
DTSTAMP:20260422T030204
CREATED:20241122T160334Z
LAST-MODIFIED:20260220T105449Z
UID:960-1780389000-1780588800@smart-training-center.com
SUMMARY:Contract Writing\, Planning & Basic Management
DESCRIPTION:BACKGROUND:\nWhatever business deal occurs between two or more parties shall have proper and correct terms & conditions agreed by the parties. To ensure a smooth process and execution\, and to minimize and mitigate potential risks\, parties should bind the deal with a legal agreement. \nHowever\, it quite common that the agreement not properly written & managed\, hence this may expose to really un-wanted situation. It can be either the writer of the agreement doesn’t really understand about legal or the legal have limited knowledge on the subject of the agreement. \nThis course shall bring you to an up to date skills to enable delivering maximum outcome on business contract planning\, writing and also managing the same. \nOBJECTIVES:\nBy attending this workshop\, you will be able to: \n\nUnderstand the basic of contracts\nKnow the complexity of contracts\nPrepare and write contracts\nCorrelate contracts with bid documents\nControl project execution based on SLA and KPI as set forth in the contract\n\nWHO SHOULD ATTEND\nThis course is designed especially for: \n\nContracts Managers and Staff\nProcurement Managers and staff\nProcurement engineers\, supervisors and staff\nGeneral Affairs/Services/facility managers and staff\nProject Managers and Controllers\nAnyone who is involved in internal projects or customer projects\n\nCOURSE OUTLINE\nThe course will emphasize on practice and be summarized as follows \n\nProcess of contract\nRoles and Responsibilities\nContract Terms and Conditions\nPurchase Order Terms and Conditions\nContracting Methods\nContract Pricing\nPracticing on how to prepare SOW\n\nContract Writing Process \n\nPreparation of SOW (statement of work)\nPreparation of General Terms and Conditions\nStructuring contract\nVerifying contract consistencies\nAnalyzing risks to be incorporated into SOW\nContract execution\nContract closing\n\nPARTICIPANTS: \n\nContract Manager & Staffs\nProcurement Manager & staffs\nProject Manager & Controller\nService\, Operation & Maintenance Manager\n\nAbout The Course Leader:  \nDr. Nina Nurani S.H.\, M.Si\, CPHCPM \nPublic Training berikutnya : 5 – 7 Oktober\, 2026 | 2 – 4 Desember\, 2026
URL:https://smart-training-center.com/event/contract-writing-planning-basic-management/
LOCATION:Bandung\, Jawa Barat\, Indonesia
CATEGORIES:General,Project,Supply Chain
ATTACH;FMTTYPE=image/jpeg:https://smart-training-center.com/wp-content/uploads/2024/11/Contract-Writing-planning-management-1.jpg
ORGANIZER;CN="PT Fiqry Jaya Manunggal":MAILTO:info@fiqry.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Krasnoyarsk:20260615T083000
DTEND;TZID=Asia/Krasnoyarsk:20260616T160000
DTSTAMP:20260422T030204
CREATED:20241122T100849Z
LAST-MODIFIED:20260305T044201Z
UID:893-1781512200-1781625600@smart-training-center.com
SUMMARY:Powerful Database Analysis & Dashboard Reporting using Microsoft Excel
DESCRIPTION:BACKGROUND:\nWhy Choose Microsoft Excel for Database Analysis?\nProses analisis data dan pembuatan dashboard summary report dari file text hasil import aplikasi besar seperti SAP/ERP seringkali memakan waktu lama\, bahkan berhari-hari\, meskipun menggunakan Microsoft Excel. Pelatihan ini\, “Powerful Database Analysis & Dashboard Reporting using Microsoft Excel\,” akan membantu menyelesaikan proses ini lebih cepat dan sesuai kebutuhan pimpinan. Excel memiliki berbagai metode canggih dan fungsi terbaru yang mampu mempercepat pengolahan\, validasi\, analisis\, dan pelaporan data\, bahkan untuk jumlah data lebih dari 100.000 record. Dengan teknik yang tepat\, proses ini dapat diselesaikan lebih cepat dan sesuai kebutuhan pimpinan. \nExcel juga menawarkan fitur pembuatan dashboard summary report yang interaktif\, dinamis\, dan menarik untuk mendukung analisis lebih lanjut. Salah satu fitur tersembunyi yang jarang dimanfaatkan adalah Solver Analysis Tool Pack\, yang memungkinkan simulasi budgeting analysis secara cepat dan akurat. Fitur ini memungkinkan pengguna melakukan optimasi dan prediksi dengan hasil yang lebih presisi. Dengan berbagai fungsi validasi dan analisis yang tersedia\, pengguna tidak perlu lagi mengembangkan program database analysis dan summary reporting menggunakan bahasa pemrograman tertentu. Semua kebutuhan analisis data dan pelaporan dapat diselesaikan dengan cepat dan efisien menggunakan Excel\, mendukung pengambilan keputusan yang lebih berbasis data. \nOBJECTIVES:\n\nMastering advanced data analysis techniques\nEnhancing data visualization skills\nOptimizing database utilization in Excel\nUnderstanding advanced tools & features in Excel\nImproving work efficiency\nSupporting data-driven decision-making\n\nRECOMMENDED PARTICIPANTS:\n\nData Analysts & Business Analyst\nFinance & Accounting Professionals\nSales & Marketing Teams\nOperations & Supply Chain Managers\nProject Managers who require data processing\nHuman Resources Analysts\nIT Support Staff handling data reporting\nAdministrative Staff responsible for data management\nEntrepreneurs or Small Business Owners managing their own data\n\nCOURSE OUTLINE:\n\nStep-by-step operation for external data converting process to Excel database.\nCreated & designed worksheet using Sparklines object\nHow to use Auto Filter with union field key &Custom Filter\nOptimization filtering column in the database.\nHow to make an Advance Filter (Criteria and Output Data Query).\nHow to make and use Consolidate Methods.\nRemoving Duplicate Rows\nUsing the Excel Built-In Data Entry Form\nCreating a Drop-Down List in a Cell\nHow to make Ranking Values\nPerforming a LOOKUP function.\nHow to use Operational Table with ADVANCE LOOKUP Function\nHow to make and use PivotTable Optimization\nCreated and designed worksheet report using PivotTable\nCreating and Utilizing Pivot Charts Optimized with Slicer Panels\nCreated and designed Cells Graphic using Spark Lines\nHow to make and use Data Validation\nHow to make and use Data Validation Automation with Table Function.\nHow to make and use the Data Table Method for one-cell input and two-cell input.\nHow to make & use data analysis method (What If Analysis).\nHow to make and use the analysis function.\nHow to make active and use solver analysis tool pack:\n\n\n\n\nHow using of Format Cells for Locked & Hidden Cells\nHow using of Using Allow Users to Edit Range (Permission User Access Setting)\nHow to use of Protect Sheet (Select Locked Cells & Select Unlocked Cells)\n\n\n\n\nCase study implementation\n\nABOUT THE COURSE LEADERS:\nAndika Bayu Saputra\, S.Kom\, M.Kom\, Pada tahun 2013 mendapatkan gelar master (S2) dibidang IT dengan predikat memuaskan di program pasca sarjana Magister Teknik Informatika FTI UII. \nMenjadi Consultant IT sejak 2013 dan banyak menangani proyek yang berkaitan dengan IT. Selain sebagai akademisi dan praktisi dibidang IT juga sering memberikan pelatihan dan certified dibidang IT. \nPublic Training berikutnya : 19 – 20 Oktober\, 2026
URL:https://smart-training-center.com/event/powerful-database-analysis-and-dashboard-reporting/
LOCATION:Jakarta
CATEGORIES:Engineering,Finance,General,HRD,Manajemen,Oil & Gas,Power Generation,Project,Q-HSE,Supply Chain
ATTACH;FMTTYPE=image/jpeg:https://smart-training-center.com/wp-content/uploads/2024/11/powerful-database-analysis-dashboard-reporting-using-microsoft-excel.jpg
ORGANIZER;CN="PT Fiqry Jaya Manunggal":MAILTO:info@fiqry.com
END:VEVENT
END:VCALENDAR