Event Detail



Non-Members use the "Register Now" button.


Excel Tips and Tricks

Due to the coronavirus outbreak, we will be hosting live webinars in place of live seminars for the foreseeable future.  We will send an email as soon as live seminars are up and running again.  We appreciate your patience.


For our CPA customers, note that live webinar credits are equivalent to live seminar credits and will satisfy your credit requirements.  

For our attorney customers, individual state legal education requirements will vary. As of now, it appears that the PACLE Board will review attorney compliance on an individual basis if you are unable to find live seminar credits prior to your deadline. If you require more detail, please reach out to the Legal Education Board in your state.

Excel-based modeling is an important component in many budgeting, reporting, and monitoring projects. Driven by ease of use, widespread adoption, and analytical power, the Excel platform has become a cornerstone of modern business analytics. In this course, our presenter will begin with commonly used Excel functions and then introduce more sophisticated operations and analytical tools. We will review topics such as: v-lookups, h-lookups, Time-Value-of-Money operations, basic statistical functionality, and more.

Learning Objectives:

  • Organize and format data in Excel
  • Compare financial data
  • Test decision-making assumptions with sensitivity analysis
When: Friday, September 25th, 2020. 9:00 AM to 1:00 PM EST
Where: Your home or office
Speaker: Dennis McGovern
CPE Credits: 4 Specialized Knowledge CPE
CLE Credits: 4 Substantive CLE 
Program Level: Basic
Prerequisites: None
Advanced Preparation: None
Delivery Method: Group Internet-Based

The Presenters:

Dennis McGovern, Owner of McGovern Consulting, LLC, has over ten years experience providing management consulting and financial management technology solutions to hundreds of tax exempt and non-profit organizations throughout the U.S.  Mr. McGovern is a Microsoft Certified Professional and Abila Software Partner. 
 

About CPE/CLE:

* The ALA partners with McDevitt and Kline LLC for certificate issuance. Live, internet-based courses are approved as Distance Learning courses by the PA Supreme Court CLE Board. For additional information, please visit http://www.pacle.org/. Check with your State CLE Board for rules pertaining to live webcasts. These rules differ from state to state. For example, PA attorneys may earn up to 6 CLE credits per compliance period via live webcasts (or 6 out of 12 credits per year); NJ and DE attorneys may earn up to 12 CLE credits per compliance period via live webcasts (or 12 out of 24 credits per two years).
McDevitt & Kline, LLC is registered with the National Association of State Boards of Accountancy (NASBA), as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be addressed to the National Registry of CPE Sponsors, 150 Fourth Avenue North, Suite 700, Nashville, TN, 37219-2417. Web site:www.nasba.org.


Non-Members use the "Register Now" button.