190625WR-PRACTICAL APPLICATIONS OF MICROSOFT EXCEL FOR ACCOUNTANTS


When:  Jun 25, 2019 from 08:00 AM to 10:00 AM (ET)
Associated with  WESTCHESTER/ROCKLAND

TOPIC:  Practical Applications of Microsoft Excel for Accountants

 DATE:  Tuesday, June 25, 2019    8 AM to 10 AM (breakfast included)

 LOCATION:  M & T Bank Building, 120 White Plains Road, 3rd Floor, Tarrytown, NY  10591

SPEAKER:  Michael Zinman

 LEARNING OBJECTIVE: This course is designed to CPAs, who think of Excel as a problem-solving tool and application, rather than a simple spreadsheet. We will review real-life application of more advanced formulas (VLOOKUP, INDEX, MATCH, SUMIF [and the related family of formulas], and some basic string manipulation [FIND, TEXT, LEFT, RIGHT, MID])

This includes learning how to use and create amortization schedules for a client in seconds. We will have discussion of the creation of the different pieces of these schedules and breaking down the complex-appearing formulas to better understand the creation of these tables. Also, we will discuss Conditional Formatting customization for better client report output and visualization.  

***Attendees are encouraged to bring their laptops to this event***

PRICE:  $20/Member, $25/Non-Member

2 CPE MAP


Program Pre-requisite: None
Program Level: Intermediate
Advanced Preparation: None
Type of Delivery: Group Live Seminar

This program is sponsored by the WESTCHESTER/ROCKLAND CHAPTER NATIONAL CONFERENCE OF CPA PRACTITIONERS INC.  State boards of accountancy have final authority on the acceptance of individual courses for CPE credit.
New York State License Number: 000124
New Jersey License Number: 20CE00237100

For a complete copy of NCCPAP education program policies including refund policy and complaint resolution policy, contact Pat Sornberger at 516-333-8282 or e-mail psornberger@nccpap.org 

 


 

Location

M&T Bank Building
120 WHITE PLAINS ROAD, 3RD FL
TARRYTOWN, NY 10591