Excel Basic to Intermediate
Excel-Basic-to-Intermediate
Workshop Leader
MochamadJamin, SKom, IT IL

Business Intelligence and Analytics Consultant

Is a professional who focuses on Business Intelligence & Analytics solutions for the past 18 years. He has extensive hands on experience in Business Intelligence & Analytics project deliveries related to Sales & Marketing, Finance, HR, and Logistics in Indonesia and abroad. He is very passionate on anything related to Data Modeling, Data Analysis, Data Science, Data Visualizations and Business Dashboards.

He has trained many professionals from various companies:

Danone, Sari Husada, Boehringer Ingelheim, GSK, Coca-Cola Amatil Indonesia, JICT, Pelindo, BNI, Astra Honda Motor, Panorama, HM Sampoerna, IDX, CIMB Niaga, OCBC NISP, QNB, Bank Mandiri, Mattel, Indika Energy, Grundfos Pompa, CHUBB General Insurance Indonesia, Bank Nagari, Bank Indonesia (BI), Lembaga Pengembangan Perbankan Indonesia (LPPI), Otoritas Jasa Keuangan (OJK), Bank Muamalat, etc.

Business Intelligence Development Services:
  • Data Warehousing §ETL/ELT Development
  • Interactive Reports & Dashboards using Excel & VBA
  • Interactive Reports & Dashboards using Microsoft Power BI
  • Interactive Reports & Dashboards using SAP Crystal Dashboard (Xcelsius) Data Science using Microsoft Azure Machine Learning
Inhouse Training Workshop Services:
  • Excel Masterclass (Beginner to Advanced) – 2 Day
  • Excel Interactive Reports and Dashboards (Beginner to Advanced) – 2 Day Excel Power Query & Power Pivot (Data Modeling & Analysis) – 2 Day
  • Excel Macro & VBA – 2 Day
  • Microsoft Power BI (Beginner to Advanced) – 2 Day
  • SAP Crystal Dashboard (Xcelsius) – 2 Day
  • Microsoft Azure Machine Learning (Data Science) – 2 Day

Baca juga: Financial Modeling for Budgeting using Excel

Schedule 2019:

  • 28-29 October 2019, 9am-5pm
  • 11-12 November 2019, 9am-5pm

Venue: J.W. Marriott Hotel, Jakarta Selatan (Tentative)

Investment Fee: IDR 6,500,000/Trainee (Including Soft copy training material, USB, Certificate, Lunch & Coffee Break, Souvenir)

Target Audience

Finance & Accounting Staff and Manager, Strategic & Corporate Planner, Financial Controller, Financial & Business Analysts, Risk Manager, Credit Analyst & Reviewer, Investment Analysis, Equity Analyst, Investment Banker, Corporate Finance Officer, Corporate Planner, Project Analyst, Treasury Manager, General Manager, Corporate & Government Officer, Business Owner, Business Advisor or anyone who has strong passion for Financial Modeling & Excel Basic to Intermediate.

Baca juga: Analisa Laporan Keuangan

Outline Training Excel Basic to Intermediate
Day-1
  • Excel Fundamental – Camera Tool, Copy Paste, Format Cell, Data Validation, Custom List, Auto Complete Text, Auto Sum, Random Data, Outline
  • Excel Formulas – VLOOKUP vs. HLOOKUP, INDEX & MATCH, OFFSET & OFFSET YTD, INDIRECT
  • Data Analysis – Consolidate, Excel Table (Smart Table), SUMIF vs. SUMIFS, Pivot Table with Slicer
  • Visualization – Background Image, Paste Shape into the Chart, Sparklines, Conditional Formatting
  • Form Controls – Combo Box vs. List Box
Day-2
  • Building Interactive Dashboard – Data Preparation, Calculation
  • Building Interactive Dashboard – Visual Components, Designing the Dashboard, Protecting the Dashboard
  • Case: Build Interactive Dashboard with Data Relationship
  • Case: Build Interactive Dashboard with Data Relationship (cont’d)
Noted
  • Please bring your own laptop with Microsoft Excel 2010 or higher installed
  • This training is paperless so you will receive full course notes in a USB full of practical templates, exercises & solutions, reference guides, add-ins and other useful tools.
  • Training will be delivered in Bahasa Indonesia
  • You will receive a Certificate of Completion, a recognition of your accomplishment, skills & knowledge learned after completion of this course
  • It is assumed that participants know how to navigate confidently in Excel, create and use simple formulas

Formulir Pendaftaran

Waktu:

11-11-2019 s.d 12-11-2019

Tempat:

J.W. Marriott Hotel
Jakarta Selatan

Harga:

6,500,000 - 5,850,000 (Earlybird)