Event Details

The course has been designed to present 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 such as 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.


This workshop introduces 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.


The exercises provided herein are applicable for the Finance/ Accounting departments of organizations as well as the financial and accounting sectors.


28 - 30 October 2020

9:00 AM – 12:00 NN

PHP 5,000 (VAT excl.) / participant


An email with a Zoom link should be with you an hour before the event. If it's not in your inbox, please check your spam folder. The email is from maan.yu@nordcham.com.ph.

Facilitator

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

Training Attendee
₱5,000

Our Business Partners

Menu