We are pleased to inform you that MyConsulting Academy will present "Excel Series for Finance in DATABASE MANAGEMENT & ANALYSIS, FINANCIAL MODELING AND CORPORATE PERFORMANCE ANALYSIS ” by Mr. Muslim – Registered Accountant, Senior BPR implementer, Senior ERP Implementer, Partner of KAP Adi Jimmy Arthawan and Managing Director of My Consulting., Mr. Hari Widyanto – Senior -ERP-MySis Implementer, Senior Dynamic Microsoft Consultant, Senior Solomon Implementer and Technical Engineer. , Mr. Rahman & Mr. Eddy Priyanto – Microsoft System Engineer Certified Professional, Expert in Network design; Microsoft Exchange; EPM and strong in Crystal report and VB., Mr. Riswanto Wibisono– Microsoft Business Solution Certified Professional in Manufacturing; Trade and Inventory; Warehouse Management and expert in industry engineering., and Mr. Dedy Darmawan - ERP Certified Consultant - involved in many project afterwards especially in implementing PFW software for financial application for manufacturing application. Facilitators are experienced with more than 7 years specialization on their subjects.
The target participant is management accountants, auditor, analyst, marketing, project manager, estimator, bud and users who need to quickly proficient in financial report database analysis within their organization and also for who to concert in Microsoft excel atmosphere.
The course is tailored specifically to demonstrate the reporting capabilities of the built-in Financial Reporter tool in your Microsoft Office Excel, and to instruct users on how to use these features to produce financial statements from the data stored.
The course will be a combination of theory and hands on exercises. There will be a detailed workshop in the afternoon session and a review quiz at the end of the course.
The goals of training :
· Sorting Data
· Using Auto Filter
· Advanced Filter to extract data sets
· Using the Analysis Tool pack
· Using Pivot Tables to report data
· Using the Auditing feature
· Creating charts on analyze data
· Automation and customizing of Excel using macros
· Automation and customizing of screen items (such as buttons and menus)
· Write macros using VISUAL BASIC Application code
· Assign macros to screen items
· Using Macros to automate your work environment
· Creating the self function
Please do register early because maximum 7 (SEVEN) attendees only
We are looking forward to welcoming you on the events.
PT MY Consulting
( (62 21) 570 47 91 |7 (62 21) 570 4918|
P please consider the environment before printing this email
FOR GROUP (MINIMUM 5 PARTICIPANTS) CAN CHOOSE SELF SCHEDULE (DISCOUNT UP TO 10%)
FOR GROUP (MINIMUM 9 PARTCIPANTS) IS AVAILABLE INHOUSE TRAINING (DISCOUNT UP TO 25%)
AVAILABLE THE OTHER OFFICE TRAINING (WORDS, POWER POINT, PROJECTS, VISIO, ACCESS, CRISTAL REPORT)
AVAILABLE TRAINING FOR ACCOUNTING SOFTWARE (ERP) SUCH AS SAGE ACCPAC ERP, MYOB AND OTHERS
AVAILABLE TRAINING FINANCIAL ANALYST FOR NON ACCOUNTANTS