Learn the powerful capabilities of Excel in Accounting and Financial Management
This training session will run from 9-10 September 2020, 9:00AM – 12:00NN
Fee is 5000PHP + VAT per participant
This course has been designed to equip participants with powerful Finance-based report generation capabilities, auto-consolidation techniques, search and find capabilities using XLOOKUP, FILTER, LOOKUP, VLOOKUP, INDEX-MATCH, CHOOSE functions, and other Financial oriented functions, including creating User Defined Functions (a must for Finance people who wish to create their own particular Finance-based functions) and apply built-in date/time/financial tools, as well as text manipulation, with data validation and built-in user forms for easier data capture. Most notable feature of the workshop is the introduction of a simplified formula creation, with capability to “fetch named” ranges from anywhere in the workbook, providing for faster, more elegant, and English-like formula creation, which in turn enables users to debug formulas of whatever complexity, and at the same time, enabling the tracing of formula precedents and dependencies.
Upon completion of training, participants shall be capable of:
– creating powerful dashboards, auto-linked worksheets and named ranges
– linking workbooks with auto-updating capabilities.
– using the built-in function of forecasting and powerful goal seeks capabilities.
– generating dynamically changing data visualization using powerful slicers, with named measures or calculated fields.
Zoom access details will be sent 1 hour before the event.
Event DetailsLocation: ZoomDate: September 9, 2020 - September 11, 2020Time: 9:00 am - 12:00 pm
Admission FeesMember Fee: 5600 PHPGuest Fee: 5600 PHP
Omar F. Abesamis
IT consultant, Trainer, Web developer and Enterprise Resource Planning (ERP) application practitioner
Mr. Abesamis has over 40+ years of experience as an IT consultant, web developer, and Enterprise Resource Planning (ERP) application practitioner. Over the years, he has provided best-practice consulting arrangements for clients in both the private and government sector.
The range of applications he has developed and implemented covers financial management, accounting, inventory, procurement, manufacturing, point-of-sale, and operations. He has also done work in distribution and logistics, human resource with payroll and time and attendance.
Omar has conducted IT training workshops and seminars to people on various disciplines for organizations like the Asian Development Bank, PruLife UK, Champ Cargosystems, Citibank N.A., Citytrust, SolidBank, Philippine Trade Training Center(PTTC), Super-K Drugstores, Zuellig Pharma Colgate Palmolive Philippines, Medicard Philippines, TOTAL Philippines to name a few.
Among the trainings conducted by Mr. Abesamis are Advanced MS Excel Capabilities, Effective Project Management Using MS Office Project, Developing Project User Requirements, Creating Dynamic Web-based Time and Attendance(TA) and Human Resource (HR) Systems Using PHP/MySQL, to name a few.