Using Tools in Excel as Part of Your Trade Compliance Program

May 23, 2017
12 to 2 p.m. ET
2 CCS/CES Credit
Cost: $25.00/Member, $45.00/Non-Member


Join us on May 23rd from noon to 2p.m. ET for an Excel training webinar! During this two-hour webinar Stephanie Norris, the Valuation Leader for GE's Global Operations Customs shared service operation, will show you how to use tools in Excel as part of your trade compliance program!

Key training points:


  • Using filters
  • Using Pivot Tables
  • Using Excel's VLOOKUP, INDEX, and MATCH functions to manipulate data
  • Separating and joining data (left, mid, right, concatenate, text to columns)
  • Create check formulas to review for red flags



Prospects for NAFTA Renegotiation

May 24, 2017
1 to 2 p.m. ET
1 CCS/CES Credit
Cost: $50.00/Member, $75.00/Non-Member


Eyes around the world will be watching as the new Administration takes its first stab at trade negotiations with the renegotiation of the 23-year old North American Free Trade Agreement (NAFTA). It was easy to withdraw from the Trans Pacific Partnership (TPP) but it surely will be more difficult to renegotiate NATA an agreement around which substantial business operations have been built. President Trump came close to withdrawing from the Agreement, as reflected by a leaked draft Executive Order, but instead told his Canadian and Mexican counterparts that he wouldn't withdraw at this time. There was also the leaked draft notice to Congress on NAFTA renegotiation, which looked a lot like TPP. Commerce Secretary Ross says that the anxiety over trade will subside once NAFTA is done the right way. Secretary Ross has mentioned coverage of services, rules of origin, digital trade and dispute settlement as issues to be addressed in a new NAFTA. Meanwhile, Mexico has been consulting with its own private sector and preparing for the renegotiations for quite some time. They have an experienced team and will be formidable negotiators, as will be the case with Canada. The Trump Administration seems to be aiming for a quick renegotiation but Mexico has been its own presidential elections in July 2018, which promise to complicate things.


Hear from Alejandro Garcia Seimandi, a Mexican customs lawyer Garcia Seimandi, Flores & Villeda, and Evelyn M. Suarez, a U.S. customs lawyer, founder and principal of The Suarez Firm and President of the Association of Women in International Trade (WIIT) about the prospects for NAFTA renegotiation. They will discuss:

  • The process for renegotiation in Mexico and the U.S.
  • What has worked for companies under the current Agreement?
  • What improvements can be made?
  • How much room is there to make changes and what is likely to change?
  • And what does this all mean for customs enforcement of the existing NAFTA in this new age of trade policy and customs enforcement of the Trump Administration?

Past Webinars

If you attended any of the below 2017 webinars and believe you are missing credit, please email ei@ncbfaa.org.
February 15th: Customs Bond Insufficiencies and Ensuring You Are Compliant with CBP Policy (1 CCS)
March 2nd: FDA Made Easy (1.5 CCS)
March 15th: FMC License Renewals (1.5 CES)
March 16th: Know What's Considered for Force Majeure (1 CCS/CES)
April 19th: HTS Classification (1 CCS)
April 27th: False Claims Act (1 CCS/CES)
May 9th: AD/CVD Enforcement (1.5 CCS/CES)

Questions? Please contact NEI at NEI@ncbfaa.org

NATIONAL CUSTOMS BROKERS & FORWARDERS ASSOCIATION OF AMERICA, INC. Copyright © 2017 All Rights Reserved.   Powered by MemberMax