21 - 23 June 2023
9:00 am – 12:00 pm
Pesos 5,000 (VAT excl.) / participant
Facilitator: Omar F. Abesamis
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.