Monday, June 24, 2019
Intro to Quick Books Pro
8:30:00 AM - 8:30:00 AM
 
Learn methods for setting up and tracking accounting information for a small business using QB Pro. Utilize basics for setting up your company and A/R, A/P, and Payroll for your company. Understand items, lists and reports.

Advanced MS Excel 2013
8:30:00 AM - 8:30:00 AM
 
Students will work with advanced functions and formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation, and will use advanced data filtering. They will apply advanced chart formatting options, and create more complex charts. They will work with PivotTables and PivotCharts, export and import data, and query external databases. Students will learn about the analytical features of Excel, such as Goal Seek, and how to create scenarios. Finally, they will run and record macros, and explore VBA code.