Excel Series
Database Management and Analysis
Jakarta, March 30-31, 2009
April 23-24, 2009
Description
This course teaches Participants how to modify database records using data forms and specify criteria for database functions. The use of the Automatic Subtotals feature is also examined. In this course, Participants will learn to create PivotTables and Pivot-Charts. They will also forecast values with trend lines and create scenarios.
Objectives
By the end of this course, you will be able to:
· Work with Excel databases,
· Sort database data,
· Use database functions,
· Use financial functions,
· Use advanced filters and automatic subtotals,
· Create pivot tables and pivot charts,
· Modify pivot tables,
· Audit worksheets and perform what-if analyses and
· Work with scenarios.
Detailed Outline
Working with Databases
Identifying Database Components
Adding Database Components
Modifying Database Records
Sorting Database Data
Sorting Records by up to Three Fields
Rearranging Fields
Sorting Records by Four Fields
Applying Custom Sort Orders
Sorting Text as Numbers
Using Database Functions
Using the DAVERAGE Function
Using the DCOUNT Function
Using the DSUM Function
Using the DMIN Function
Using the DMAX Function
Using the DGET Function
Using Advanced Filters and Automatic Subtotals
Using the Advanced Filter Feature
Extracting Data
Using the Automatic Subtotals Feature
Creating PivotTables and Pivot-Charts
Creating PivotTables
Changing PivotTable Layouts
Changing PivotTable Field Names and Functions
Extracting Data from PivotTables
Creating Pivot-Charts
Working with Form
Label and Edit Box
Group Box and Button
Check Box and Option Button
List Box and Combo Box
Combination List-Edit
Combination Drop-Down-Edit
Scroll Bar and Spinner
Edit Code and Toggle Grid
Modifying PivotTables
Formatting Numbers in PivotTables
Displaying and Hiding PivotTable Data
Refreshing PivotTable Data
Sorting PivotTable Data
Using the PivotTable AutoFormat Feature
Auditing Worksheets and Performing What-If Analyses
Tracing Precedents and Dependents
Locating Precedents and Dependents
Locating and Resolving Errors
Using the Goal Seek Feature
Using the Solver Feature
Forecasting Values with trend lines
Working with Scenarios
Creating Scenarios
Applying Scenarios
Creating Scenario Summary Reports
Editing and Deleting Scenarios
Protecting Scenarios
Using MACRO
Recording Macro
Assigning Macro to Button and Icons
Create My Own File and Menu on Menu Bar
HLOOKUP and VLOOKUP
Case Study and Tools
Budgeting and Forecasting Analysis
Inventory and Production Analysis
Corporate Performance Analysis
Financial Business Analysis
Tax Computation Analysis
Business Plan Analysis
Instructor
MUSLIM
· Financial Modeling Specialist
· Business Process Review Specialist
· Chairman and CEO of PT. MY Consulting
· Partner of Adi Jimmy Arthawan Accounting Firm
He is a registered accountant by profession as Partner of KAP Adi Jimmy Arthawan and is working as President Director for MY Consulting Indonesia.
With a very rich and varied work experience acquired by his employment in several different experiences, He commands the best knowledge of the theory and use of various Computer Applications, especially Microsoft Excel.
His experience as a middle level and top-level manager and also as a business owner has provided the perfect angle of top management thoughts and an easy-learning solution model with which he has tailored the learning approach.
Investment
IDR 5.000.000 (Five Million)
Send 4 delegates and the 5th comes for FREE
Pay 5 for 7 participants
Methodology
Lecturers
Case study and Exercises
1 Participant to a computer
Practical Computer Hands on Applications
Bring your own laptop and have all your financial modeling (installed excel 2003-2007)
Facilities
Hot Spot Training Room
Excel Bible (Full Version) – Text book (softcopy)
Training Handout and Exercise (softcopy)
Lunch and Coffee Break (2)
Certificate and Consultation
Venue
Training Center MYC Academy
Wisma Nugra Santana
12 Floor Suite1216
Jl Jend Sudirman Kav 7-8
Jakarta 10220 INDONESIA
In-house package (special terms)
Pay 9 for 14 participants
Venue and schedule as client confirmation
Tailor-made for teams of between 7 and 14 executives
Thanks and regards,
Yuniarti
Events Coordinator
PT MY Consulting
Wisma Nugra Santana
12 Floor Suite1216
Jl Jend Sudirman Kav 7-8
Jakarta 10220 INDONESIA
Ph 62 21 5704791
Fax 62 21 5704918
yunie@myconsulting.us
PUBLIC TRAINING SCHEDULE ON FEBRUARY 2009
| DATE | GROUP TYPE | TOPICS | |
| 02-04 | Excel Series | CEO Financial Modeling (Corporate Financial Analysis and Forecasting) | |
| 05-06 | Excel Series | Finance Analysis for Non Finance Manager | |
| 10-11 | Excel Series | Business Plan Analysis (Corporate Financing and Evaluation) | |
| 12-13 | Excel Series | Finance Analysis for Non Finance Manager | |
| 17-18 19-20 24-25 | Excel Series Excel Series Excel Series | Database Management and Analysis Annual Report Analysis and Interpretation Business Plan Analysis (Corporate Financing and Evaluation) | |
PUBLIC TRAINING SCHEDULE ON MARCH 2009
| DATE | GROUP TYPE | TOPICS | |
| 03-04 | Excel Series | CEO Financial Modeling (Corporate Dashboard Analysis) | |
| 05-06 | Excel Series | Finance Analysis for Non Finance Manager | |
| 10-11 | Excel Series | Business Plan Analysis (Corporate Financing and Evaluation) | |
| 12-13 | Excel Series | Finance Analysis for Non Finance Manager | |
| 16-18 19-20 24-25 | Excel Series Excel Series Excel Series | CEO Financial Modeling (Corporate Financial Analysis and Forecasting) Annual Report Analysis and Interpretation Business Plan Analysis (Corporate Financing and Evaluation) | |
PUBLIC TRAINING SCHEDULE ON APRIL 2009
| DATE | GROUP TYPE | TOPICS | |
| 01-03 | Excel Series | CEO Financial Modeling (Corporate Financial Analysis and Forecasting) | |
| 07-09 | Excel Series | CEO Financial Modeling (Market and Valuation Analysis) | |
| 14-15 | Excel Series | Business Plan Analysis (Corporate Financing and Evaluation) | |
| 16-17 | Excel Series | Finance Analysis for Non Finance Manager | |
| 21-22 23-24 28-29 | Excel Series Excel Series Excel Series | CEO Financial Modeling (Corporate Dashboard Analysis) Database Management and Analysis Business Plan Analysis (Corporate Financing and Evaluation) | |
RECENT ATTENDEES INCLUDE ON OUR TRAINING
2008
· Total Bangun Persada, Tbk
· Grendale Partners
· Charoen Pokphan Indonesia Tbk
· Boehringer Ingelheim Indonesia
· Meta Epsi
· Ernst & Young
· Medco Power Indonesia
· Widya Sapta Colas
· Medco Geothermal Sarulla
· Asuransi Adira Dinamika
· First Media Tbk
· Bekaert Indonesia
· Astellas Pharma Indonesia
· Intiland Development Tbk
· Sandoz Indonesia
· Aero Wisata
· Sefas Pelindotama
· Sorini Agro Asia Tbk
· CIC Indonesia
· Metrodata Electronics Tbk
· Adira Asuransi Dinamika
· Jakarta International Container Terminal
· Hutchison Port Indonesia
· Kaltim Prima Amoniak
· Bank BTPN Tbk
· Indosat Tbk
· Lembaga Penjamin Simpanan
· SUCOFINDO (PERSERO)
· Unican Surya Agung
· Timah (PERSERO) Tbk
· Sierad Produce Tbk
· Lippo Karawaci Tbk
· CNOOC SES Ltd
· PERTAMINA (PERSERO)
· BAHANA (PERSERO)
· Bredero Shaw Indonesia
· Bank of Tokyo Mitsubishi
· Danareksa (PERSERO)
· Janssen Pharmaceutica
· Excelcomindo Pratama Tbk
· Deutsche Verdhana Indonesia
· Rajawali Corpora
· Tripatra Enginers and Contractors
· Ekspres Transportasi Antarbenua
· NetToCyber Indonesia
· Ciputra Corpora
· Trimegah Securities Tbk
· Astratel
· Astra International Tbk
· Express Group
· Kawasan Industri Jababeka Tbk
· IMECO
· Kraft Foods Indonesia
· Semen Gresik (Persero) Tbk
2009
· Cipta Pratama Technocom
· StarEnergy (Kakap)
· Exspan Petrogas Intranusa
· Kalbe Nutritionals
· Dwi Era Sejahtera
· Excelcomindo Pratama Tbk
· Pertamina Energi Hulu (PERSERO)
· Kaltim Prima Amoniak
· Panorama Convexion
· Bahana
