Nordic Chamber of Commerce of the Philippines
  • Services
  • Members
    ▼
    • List of Members
    • Become a Member
  • Doing Business in the Philippines
    ▼
    • Philippines Country Profile
    • Trade and Investments
      ▼
      • Sector in Focus: Pharma & Healthcare
      • Sector in Focus: IT – BPO
      • Other Sectors
  • Events
  • About Us
    ▼
    • Vacancies
  • Contact

Nordic Chamber of Commerce of the Philippines

  • Services
  • Members
    • List of Members
    • Become a Member
  • Doing Business in the Philippines
    • Philippines Country Profile
    • Trade and Investments
      • Sector in Focus: Pharma & Healthcare
      • Sector in Focus: IT – BPO
      • Other Sectors
  • Events
  • About Us
    • Vacancies
  • Contact
BECOME A MEMBER
Home Events RESCHEDULED: August 28: Teaser Session: Excel for Finance Users
  • Services
  • Members
    • List of Members
    • Become a Member
  • Doing Business in the Philippines
    • Philippines Country Profile
    • Trade and Investments
      • Sector in Focus: Pharma & Healthcare
      • Sector in Focus: IT – BPO
      • Other Sectors
  • Events
  • About Us
    • Vacancies
  • Contact

RESCHEDULED: August 28: Teaser Session: Excel for Finance Users

August 19, 2020 by NordCham

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.

*Please note this event has been rescheduled to August 28, 9:00-10:30 AM.

Event Details
Location: ZoomDate: August 28, 2020Time: 9:00 am - 10:30 am
Admission Fees
Member Fee: FreeGuest Fee: FreeSIGN UP

Filed Under: Events Tagged With: accounting, excel, financial functions, financial management, formula creation, free session

Events

No events found

Contact Us

Nordic Chamber of Commerce of the Philippines, Inc.

219 Spaces Makati
928 Antonio Arnaiz Avenue
Makati City Philippines 1223
T: +63 2 396 5651
E: events@nordcham.com.ph

Quick Links

  • Services
  • Members
  • Events
  • Contact
  • Sitemap

Contact Us

Address
219 Spaces Makati
928 Antonio Arnaiz Avenue
Makati City Philippines 1223
Phone
+63 2 396 5651
Email
events@nordcham.com.ph

© 2016 Nordic Chamber of Commerce of the Philippines All Rights Reserved.