Tomorrow: Creating Dynamic Financial Statements in Excel

Attend upcoming webinar and earn continuing education credits. Live Webinars   |   On-Demand   |   All-Access Plan Manage Preferences    |    View in Browser Creating Dynamic Financial Statements in Excel November   1 1 pm - 2:40 pm ET Presenter: David Ringstrom, an author and nationally recognized instructor Credits: CPE (Credit Details) Can't attend live? By registering, you will be able to view the course live, view a recording at any time after the live presentation, or both. Viewing Options: View on your computer, tablet, or smartphone Learn More Register Today Course Description   In this webinar, you'll learn how to create dynamic accounting reports for any month of the year on just one worksheet. You'll apply the VLOOKUP, OFFSET, and SUMIF functions to create accounting reports that toggle to any reporting period with only a couple of mouse clicks. You'll also learn how to export data from your accounting package so you can create a "set-and-forget" link to your accounting data in Excel. Upon completion of this course, you'll be able to: Identify reports that don't balance with the source data Reference data from one or more accounting periods Improve the integrity of your spreadsheets with Excel's VLOOKUP function Export reports intended for spreadsheet analysis to a .CSV file instead of an Excel workbook Incorporate Check Figures and Alarms into your work Create an in-cell list by way of Excel's Data Validation feature Identify a simple design technique that greatly improves the integrity of Excel's SUM function Define the best format for getting accounting data to Excel from an accounting package David demonstrates every technique at least twice, first on a PowerPoint slide with numbered steps, and second in Excel 2016. He'll draw to your attention any differences in Excel 2013, 2010, or 2007 during the presentation, as well as in his detailed handouts. His webcasts are fast-paced, and attendees often are surprised at the amount of ground he covers in a session. He welcomes participants' questions, so come ready to pick his brain. David's detailed handouts, with numbered steps, serve as reference material you can utilize going forward. He also provides an Excel workbook that includes most of the examples he uses during the webcast. Learn More Register Today About The Presenter   David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on 25 years of consulting and teaching experience. David's mantra is "Either you work Excel, or it works you," so he focuses on what he sees users don't, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. Learn More Register Today All-Access Membership   ● Earn continuing education credit for no additional fee ● Access courses on your computer, tablet, or smartphone ● More than 75 live webinars each month ● More than 1,500 on-demand courses Learn More Upcoming Webinars Workers' Compensation: Return to Work Issues & Strategies November 4 at 1 pm ET Learn More Noticing Nuances in Microsoft Excel November 5 at 1 pm ET Learn More Budget Accountability: How to Ensure Accountability Exists November 5 at 3 pm ET Learn More Questions? Please call us at 703-372-0550 Our Mailing Address: Clear Law Institute | 4601 N. Fairfax Dr., Ste 1200 | Arlington | VA | 22203 Remove me from future emails. Manage email preferences. This email was sent to virginia.duffy.planetduffy@blogger.com. If you are receiving it in error, please reply to this email.

Forensic Accounting Fundamentals

Attend upcoming webinar and earn continuing education credits. Live Webinars   |   On-Demand   |   All-Access Plan Manage Preferences    |    View in Browser Forensic Accounting Fundamentals November   12 3 pm - 4:40 pm ET Presenter: Robert Minniti, President and Owner of Minniti CPA, LLC Credits: CPE (Credit Details) Can't attend live? By registering, you will be able to view the course live, view a recording at any time after the live presentation, or both. Viewing Options: View on your computer, tablet, or smartphone Learn More Register Today Course Description   In this practical webinar, you will learn the fundamentals of forensic accounting. You will learn to investigate fraud and to analyze and report on financial information for use in legal proceedings. You will learn about the career opportunities in the forensic accounting field and the skills and knowledge necessary to be a successful forensic accountant. Upon course completion, you will be able to: Define forensic accounting Describe the role and responsibilities of forensic accountants Define key terms in forensic accounting and decipher the forensic accounting "alphabet soup" Determine how you can enter the forensic accounting field Learn More Register Today About The Presenter   Dr. Robert Minniti is the President and Owner of Minniti CPA, LLC. Dr. Minniti is a Certified Public Accountant, Certified Forensic Accountant, Certified Fraud Examiner, Certified Valuation Analyst, Certified in Financial Forensics, Master Analyst in Financial Forensics, and a Chartered Global Management Accountant. Dr. Minniti received his doctoral degree in business administration from Walden University, received his MBA degree and Graduate Certificate in Accounting from DeVry University's Keller Graduate School of Management, and received his Bachelor of Science in Business Administration degree from the University of Phoenix. Learn More Register Today All-Access Membership   ● Earn continuing education credit for no additional fee ● Access courses on your computer, tablet, or smartphone ● More than 75 live webinars each month ● More than 1,500 on-demand courses Learn More Upcoming Webinars Behavioral Based Interviewing November 13 at 1 pm ET Learn More Partner Compensation Systems in Successful Firms November 13 at 3 pm ET Learn More Contract Law and E-Signatures November 14 at 1 pm ET Learn More Questions? Please call us at 703-372-0550 Our Mailing Address: Clear Law Institute | 4601 N. Fairfax Dr., Ste 1200 | Arlington | VA | 22203 Remove me from future emails. Manage email preferences. This email was sent to virginia.duffy.planetduffy@blogger.com. If you are receiving it in error, please reply to this email.