This is a past event. Registration is closed. View other Nordic Chamber of Commerce of the Philippines, Inc. events.
Learn the powerful capabilities of Excel in Accounting and Financial Management. Attend this teaser session and learn what the 3-day session will contain and provide participants.
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 seek capabilities.
- generating dynamically changing data visualization using powerful slicers, with named measures or calculated fields
The 3-day session is scheduled for September.
Speaker
Organization Partner
The European Innovation, Technology, and Science Center Foundation (EITSC) is an initiative of several European and Philippine development-oriented organizations.
Vision
To be a catalyst in driving innovation, technology, and science in the Philippines, and support equitable and inclusive economic growth in the country.
To be a partner of choice in knowledge building and skills enhancement stimulating interest among the youth and the Filipino professionals to see innovation, technology and science as their future.
To be a hub for Compliance Management with emphasis on Governance, Risk, & Compliance (GRC) Competence in Data Privacy and Security, Cyber Security, Anti-Trust and Anti-Corruption.
Mission
We help build lives through youth development and professional training.
We assist organizations in compliance management through consultancy, training and the automation of policies, procedures and controls.
Tickets
Our Business Partners
