The No. 1 Trade Show Site in the U.S.

Menu
×
EVENT DATE
Sep 2016
M T W T F S S
12131415161718
EXPO DATE
Sep 2016
M T W T F S S
12131415161718

Venue


Online Event
Location map
Tel:
Type: Online Event
booking.com

Partners

exhibitus success by design Remington Hotels

Automating Your Excel-Based Financial Reports- By AtoZ Compliance

B2B

EVENT DESCRIPTION

Key Take Away:

In this live webinar, Excel expert David H. Ringstrom, CPA, shows you how to create dynamic accounting reports for any month of the year on a single worksheet.

Overview:

Many Excel users will build a worksheet for each month of the year, which can be cumbersome to revise. Rather than using such an unwieldy method, David explains how to utilize such functions as VLOOKUP, OFFSET, and SUM together to quickly create accounting reports that toggle to any reporting period—all with a couple of mouse clicks.

Why Should You Attend:

David will demonstrate effective ways to export data from your accounting package so you can create a “set-and-forget” link to your accounting data in Excel.

David typically teaches from Excel 2016, but he points out any differences in earlier versions of Excel. He’s also happy to demonstrate techniques in a specific version of Excel upon request. David’s detailed handouts serve as reference tools you can fall back on after participating in one of his webinars. In addition, he provides an Excel workbook that includes a majority of the examples he uses during each webinar.

Areas Covered In This Webinar:

• Create an in-cell list by way of Excel’s Data Validation feature

• Improve the integrity of spreadsheets with Excel’s VLOOKUP function

• Learn a simple design technique that greatly improves the integrity of Excel’s SUM function

• Learn why, in many cases, you should export reports intended for spreadsheet analysis to a .CSV file instead of an Excel workbook

• See how to use the Trusted Document feature in Excel 2010 and later to suppress the Data Connection security prompt

• Use Excel’s OFFSET function to dynamically reference data from one or more accounting periods

Learning Objectives:

• Apply a variety of Excel functions—all focused on helping you use Excel far more effectively

• Define the best way to export data from your accounting package that links to your accounting data in Excel

• Apply the OFFSET function to return data for a specific month within a 12-column range

Who Will Benefit:

• CFO’s

• Controllers

• Investment Analysts / Financial Analysts / Business Analysts

• Forecasting & Planning Personnel

• Mergers & Acquisitions Specialists

• Risk Managers

• Strategic Planners / Capital Expenditure Planners

• Cost Accountants / Managerial Accountants

• Practitioners who may benefit from learning how to create monthly financial statements in Excel more effectively

Speakers Profile:

David Ringstrom
David Ringstrom is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. David speaks at conferences and presents webinars to thousands of attendees annually on Excel and other topics. He has written hundreds of freelance articles on spreadsheets, some of which have been published internationally. David's catch phrase is "Either you work Excel or it works you." His goal is to make you a smarter and more effective spreadsheet user.

For more detail please click on this below link:

http://bit.ly/2c9GLko

Email: referrals@atozcompliance.com
Toll Free: +1- 844-414-1400
Tel: +1-516-900-5509

Fax: +1-516-300-1584

Contact the event managers listed below for more information about how you can participate at the Automating Your Excel-Based Financial Reports- By AtoZ Compliance.

EVENT CONTACTS

Sign Up for FREE Membership and Log In to access Event Contact Information.

EVENT DETAILS

Primary Industry:
Banking-Money-Finance
Other Industries:
Banking-Money-Finance, Business
Audience:
CFOs

Controllers

Investment Analysts / Financial Analysts / Business Analysts

Forecasting & Planning Personnel

Mergers & Acquisitions Specialists

Risk Managers

Strategic Planners / Capital Expenditure Planners

Cost Accountants / Managerial Accountants

Practitioners who may benefit from learning how to create monthly financial statements in Excel more effectively
Notes:
Show Owner:
AtoZ Compliance
Sponsorship: Yes

Exhibitor Information +

Booth Details:

Booth Size
Booth Cost
No Exhibiting
Amenities
Electricity:
n/a
Water:
n/a
Generator:
n/a
Marketing Vehicles Allowed:
n/a
Services
n/a
Show Owner
AtoZ Compliance

floor plan

MORE events +

BUSINESS+
HEALTH CARE+
MANUFACTURING+
TECHNOLOGY+

Display Makers

Promo Makers

2017: 2,575 Trade Shows
2018: 575 Trade Shows
© copyright since 2008 All Rights Reserved eventsinamerica.com
428
page views