www.VBA-Excel.com Develop SMART EXCEL with VBA Save your time in Excel jobs CHANSAM CO.,LTD.
Dusit Kobruckchart
[email protected] TEL 085-5180944
Our Expertise Develop applications with VBA Macros in Excel Decision Support Systems with VBA in Excel Financial Modeling , Investment Models
Production & Operations Applications Spreadsheet Modeling for Business Decisions 1
www.VBA-Excel.com
Our Services | Training
CHANSAM CO.,LTD.
VBA Macros in Excel Develop automated spreadsheets with VBA, automated data processing, create your own functions in Excel
Financial Modeling with Excel Building financial models with Excel , Financial analysis with Excel functions, Sensitivity & Scenario Analysis ,Portfolio models, Bond valuation
Excel for Business Data Analysis Analyze business data with powerful tools in Excel , Goad Seek , Solver , Scenario Manager , PivotTable, Advanced Filter and Demand Forecasting
Advanced Excel Develop advanced formulas , functions and tools to improve productivity and in Excel work and can automate common tasks in Excel by using Macros
PivotTable and PivotChart Summarizing data efficiently and mining data for business decisions
Powerful Functions in Excel Create formulas with useful functions to save your time in Excel
Intermediate Excel Learn essential tools and functions to improve productivity in Excel work
Basic Excel Customized Excel & VBA Courses Set up tailored courses to meet your needs
2
www.VBA-Excel.com
Our Services | VBA Excel Outsourcing
CHANSAM CO.,LTD.
VBA Excel Development Automatic data processing ,Transform and model data for supporting decision making
Financial Model Development Financial forecasting , Investment models for decision making , Portfolio optimization, Simulation, Automatic Budgeting system
Business Applications Billing, invoicing system and sales summary reports Business analysis tools , Automated Expense System
Production & Operations Applications Materials Requirement Planning (MRP) , Bill of Materials (BOM) , Six Sigma , Production Planning
3
www.VBA-Excel.com
Dusit Kobruckchart Education
CHANSAM CO.,LTD.
Master of Business Administration (MBA) Thammasat University : Bangkok, Thailand Majoring in Finance, Marketing and International Business
Bachelor of Engineering King Mongkut’s Institute of Technology Ladkrabang Bangkok, Thailand Majoring in Control Engineering
Areas of Expertise VBA Excel Programming Financial Modeling with Excel and VBA Data Analysis and Decision Making Models with Excel and VBA Decision Support Systems with VBA in Excel Spreadsheet Modeling for Business Decisions Excel Models for Operations Management 4
www.VBA-Excel.com CHANSAM CO.,LTD.
Writer Experience Advanced Excel ฉบับเขียนโปรแกรมด ้วย Macro & VBA สำนักพิมพ์| Provision Co.,Ltd. พิมพ์ครัง้ ที่ 1
พิมพ์ครัง้ ที่ 2
จัดจำหน่ำยที่ ื SE-ED ร ้ำนหนังสอ ื B2S ร ้ำนหนังสอ ื จุฬำฯ ศูนย์หนังสอ ื ทั่วไป ร ้ำนหนังสอ
5
www.VBA-Excel.com
Lecturer Experience
CHANSAM CO.,LTD.
University of the Thai Chamber of Commerce Part-Time Lecturer | Computer Applications for Financial Management (2009 to Present) The course explores topics in decision support system with a focus on financial models. Microsoft Excel will be used to build financial models. The topics cover building models in the areas of corporate finance and investments
Guest Speaker | Principles and Policies of Investments
Lecture on Beta Estimation with Excel
6
www.VBA-Excel.com CHANSAM CO.,LTD.
Consultant Experience
Big Picture Mapping
Process Mapping
Logistics Consultant Kenan Institute Asia K SME Care Project | TN Metal Works Co.,Ltd. (KASIKORNBANK | K SME Care Project) Value Stream
Scanned the water pump production process to unhide non-value added activities and suggested short-term and long-term solutions for boosting production efficiency
DIFOT
7
www.VBA-Excel.com
Our Clients
CHANSAM CO.,LTD.
Training
8
www.VBA-Excel.com
Our Clients
CHANSAM CO.,LTD.
Training
9
www.VBA-Excel.com
Our Clients
CHANSAM CO.,LTD.
Training
1010
www.VBA-Excel.com
Our Clients
CHANSAM CO.,LTD.
Training
11
www.VBA-Excel.com
Our Clients
CHANSAM CO.,LTD.
Training
12
www.VBA-Excel.com
Our Clients
CHANSAM CO.,LTD.
Training
13
www.VBA-Excel.com
Our Clients | Training
CHANSAM CO.,LTD.
14
www.VBA-Excel.com
Our Clients | Training
CHANSAM CO.,LTD.
15
www.VBA-Excel.com CHANSAM CO.,LTD.
Our Clients Training Bank of America | Merrill Lynch Unilever Thai Trading Co.,Ltd.
SCG Building Materials Co.,Ltd.
KASIKORNBANK
CP ALL PUBLIC COMPANY LIMITED
PTT Global Chemical PCL.
C.P. Merchandising Co.,Ltd.
PTT Phenol Co.,Ltd.
CP Meiji Co.,Ltd.
PTT Asahi Chemical Co.,Ltd.
Baker Tilly Thailand
PTT Tank Terminal Co.,Ltd.
Betagro Public Co.,Ltd.
Krungthai Bank SCB Asset Management Co.,Ltd.
Ford Motor Company (Thailand) Limited General Motors (Thailand) Ltd. Electrolux Thailand Co., Ltd.
AFET
Tesco Lotus
Electricity Generating Authority of Thailand
Linde (Thailand) PLC.
EGCO Group
VF Sourcing (Thailand) Ltd.
Pöyry Energy Ltd.
Hot Pot Co.,Ltd.
Asset Plus Fund Management
Mass Rapid Transit Authority of Thailand
Asia Plus Securities Public Company Limited
Thai SUMMIT Harness Co.,Ltd.
Kiatnakin Bank
SCG Performance Chemicals Co., Ltd.
Hino Motors Manufacturing (Thailand) Ltd. 16
www.VBA-Excel.com
Our Clients
CHANSAM CO.,LTD.
Training Global Power Synergy Company Limited HGST (Thailand) Ltd. Energy Complex Co.,Ltd. Maruyasu ( Industries ) Thailand Co.,Ltd. B.Foods Product International Co.,Ltd. Microship Technology (Thailand) Co.,Ltd. Bangkok Metro Public Company Limited Viriyah Insurance Public Company Limited Amway Thailand Ltd. SWAROVSKI (THAILAND) LIMITED DTAC MK Restaurants Group Boonrawd Brewery Co.,Ltd. Hongsa Power Company Limited Katoen Natie (Thailand) Limited Tata Steel (Thailand) Public Company Limited
Fuji Xerox (Thailand ) Co.,Ltd. Bangkok Aviation Fuel Services PCL. Magotteaux Co.,Ltd Sanofi Pasteur Co., Ltd. Bangkok Cogeneration Co.,Ltd. Daihen Electric Co.,Ltd. Mitsuya Ltd. Thai Solar Energy Co.,Ltd. Siam Hitachi Elevator Co.,Ltd. Kloeckner Pentaplast (Thailand) Ltd. ZI-ARGUS Ltd. Symphony Communication PLC Administrative & Operation Staff , Faculty of Engineering , Silpakorn University ETA (Thailand) Co.,Ltd. FWD Life Insurance Public Company Limited DSG International ( Thailand ) PLC 17
www.VBA-Excel.com
Our Clients
CHANSAM CO.,LTD.
Training Maybank Kim Eng Securities (Thailand) Thanachart Insurance Co.,Ltd. Thanachartsec Co,.Ltd. Cobra International Company Limited Prudential Life Assurance (Thailand) SIAM KUBOTA Corporation Co., Ltd. EAST TAXI Mazda City Co.,Ltd. Brightstar (Thailand) PLC.
Deposit Protection Agency SPIE Oil & Gas Services (Thailand) Ltd CIMB Securities (Thailand) Co.,Ltd. Yokohama Tire Manufacturing Sri Trang Agro-Industry PCL. Prinsiri PCL. Star Petroleum Refining PCL.
Chevron (Thai) Co.,Ltd. Huntsman (Thailand) Company Limited NXP Semiconductors Dhurakijpundit University Epsontoyocom (Thailand) Co.,Ltd. M&P World Associated Ltd.,Part. Urgo Healthcare Products Co,. LTD. MITRPHOL Group Tongkah Harbour Public Company Limited TC Insurance Broker Services Ltd. AGC Techno Glass (Thailand ) Ltd. GMM CJO Shopping Nok Airlines Public Company Limited Natural Energy Development Co., Ltd. Thai Reinsurance Public Co., Ltd. International refreshment (Thailand) co. ltd Sekisui Jushi (Thailand) Co.,Ltd. CK Power Co,Ltd.
18
www.VBA-Excel.com
Our Clients
CHANSAM CO.,LTD.
Training Deloitte Touche Tohmatsu Jaiyos Accounting Services Co., Ltd. Krungsri Asset Management Co.,Ltd NTT Communications (Thailand) Co.,LTD. Bangkok Resource Center Limited Michelin Siam Company Limited UOB Asset Management (Thailand) Co., Ltd. Linfox Transport (Thailand) Ltd. Asia Forwarding Pvt, Ltd Charoen Pokphand Foods PCL. ( CPF ) Fuji Tusco Co., Ltd. Italthai Group Government Savings Bank Summit Capital Leasing Co.,Ltd. IRPC Public Company Limited Thai Oil Group Thanachart Bank
IBM Thailand Co.,Ltd. Golden Land Property Development PLC Amata B.Grimm Power Group QTC Energy PCL Thai Mitsui Specialty Chemicals Co., Ltd. ROCKWOOL (Thailand) Limited Patkol Public Company Limited Maha Chemicals (Thailand) Co.,LTD. Club 21 (Thailand) Company Limited Clarion Asia (Thailand) Co., Ltd. Charoen Pokphand Foods PCL. (CPF) Thai Cold Rolled Steel Sheet Public Co.,Ltd. EGAT International Co.,Ltd. Hanes Brand Inc Clarion Asia (Thailand) Co., Ltd. Sig Combibloc Company Limited Summit Capital Leasing Co.,Ltd. Huntsman (Thailand) Company Limited
19
www.VBA-Excel.com CHANSAM CO.,LTD.
Our Clients VBA Excel Development | Outsourcing Weatherford KSP Company Limited
Employee expense report Develop expense transactions database Record employee expense transactions and summarize transactions in the categorized groups
20
www.VBA-Excel.com CHANSAM CO.,LTD.
Our Clients VBA Excel Development | Outsourcing ThyssenKrupp Materials (Thailand) Co., Ltd.
Production Tracking Develop production tracking system to monitor sales order , real-time monitoring
21
www.VBA-Excel.com CHANSAM CO.,LTD.
Our Clients VBA Excel Development | Outsourcing Energy Complex Co.,Ltd. A Company of PTT Group
Financial Model Financial forecasting , EVA valuation Sensitivity Analysis & Scenario Analysis Dynamic financial chart ,Financial ratio analysis Free cash flow estimation
Data cannot be disclosed 22
www.VBA-Excel.com CHANSAM CO.,LTD.
Our Clients VBA Excel Development | Outsourcing Bank of America | Merrill Lynch
Automated Data Processing Security matching for risk position reports
Data cannot be disclosed
Data cannot be disclosed
23
www.VBA-Excel.com CHANSAM CO.,LTD.
Our Clients VBA Excel Development | Outsourcing www.TaradThong.com |ตลาดทอง.com
Gold inventory | Pawnshop Management System Billing, tracking pawned securities Interest calculation Monthly summary report from database
24
www.VBA-Excel.com CHANSAM CO.,LTD.
Our Clients VBA Excel Development | Outsourcing AAA Service |www.SiamSquarePrint.com
Billing & Invoicing Management System Tracking invoice status Billing database in Excel Sales summary form your query
25
www.VBA-Excel.com CHANSAM CO.,LTD.
Our Clients VBA Excel Development | Outsourcing Others
Production Planning, Materials Requirement Planning (MRP), Financial Simulation ,Project Management ( PERT / CPM ) ,Optimization in Transportation and Container Loading
26