2015 Foundation College - Las Vegas

2015 Founation College: Las Vegas

Advanced Report Writing Using the Microsoft® Query Tool and Microsoft® Excel

FEATURED PresentER:  Scott Kern
Date:  May 4th - 6th, 2015
Location:  Planet Hollywood Las Vegas   |   3667 Las Vegas Boulevard South
Las Vegas, NV 89109
Room Booking:  Room block held untill 4/4/2015 for attendees at Planet Hollywood Las Vegas.  Call 1-866-317-1829 and mention offer code SMFND5 at the time of your booking.
CPE Credit:  Up to 22.5
Program Level:  Advanced
Prerequisites/Advanced Preparation:  This class is meant for more advanced, full system users.  This class is not meant for the single module users. The optimal attendee will have access to most, if not all, modules within the system.



Join Scott Kern in this three-day session to learn how to access data with the Microsoft® Query Tool and how to create reports with the information you want to see using Microsoft® Excel. We’ll start off with an explanation of the FOUNDATION Database structure and review how and where to find data within tables, as well as how the tables relate to the FOUNDATION entry screens.
The session will start with a review of simple lists and historical data, then continue on to more advanced reporting from the Job Cost, General Ledger, Accounts Payable, Accounts Receivable, and Payroll Modules.
Scott will also show you how to use advanced formulas in Excel, including vlookups, sumifs, and countifs. Finally, you’ll learn about the advanced functionality of Excel, including Tables, Pivot Tables, and Slicers, and how to organize and optimize data reporting in Excel. This includes how to turn spreadsheets into automated reports using Macros, enabling and editing Macros to replace redundant tasks within a workbook, using a query from Foundation to edit and manipulate data in Excel, then preparing and exporting the data in a format compatible with FOUNDATION’s import functionality.


The Las Vegas Foundation College fee includes: 3 days of FOUNDATION learning, PLUS daily beverage service, lunches, and snacks.
Travel and lodging are not included.

Registered CPE Sponsor

NASBA CPE Sponsor Logo Foundation Software, Inc. 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 submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org.

Questions / Cancellations / Complaint Resolution

Contact Nancy Kleinhans at 800-246-0800 x 259.

Other Important Details

The delivery method of all classes listed above is "Group Live" and the field of study falls under the classification of "Specialized Knowledge & Application."
Beverage service, lunches, and snacks are included in registration price. Travel and lodging ARE NOT included.




Register Today!

Foundation College: Las Vegas May


per person

(Regular Price: $1,795 per person)
Lodging is not included in Conference pricing.

Registration is on a first come, first served basis.


© Copyright 2014 Foundation Software, Inc. FOUNDATION® is a registered trademark of Foundation Software, Inc.
Windows® is a registered trademark of Microsoft Corporation in the United States and other countries.