Programs on this page are sponsored by Solid Source Realty and the Clarity School of Real Estate. Registration is limited to licensed real estate brokers in the state of Georgia.
Microsoft Excel 2007 Formulas & Functions (SEE1)
Monday, March 15, 2010 9:00AM to 1:30 PM (tentative)
Whether you’re modeling a mortgage amortization schedule or managing your company’s inventory, you’re using (or need to be using) Excel formulas. This program covers nearly every aspect of Excel formulas, from the very simple to the extremely complex.
Lesson Objectives include:
- Use and interpret three-dimensional cell references, even across multiple workbooks.
- Produce formulas that combine multiple calculations and return a single result or multiple results.
- Define range names and apply range names to formulas and workbook navigation.
| |
 |
Analyzing Data and Creating Reports with Excel 2007 (SEE2)
Tuesday, March 16, 2010 9:00 AM to 1:30 PM (tentative)
Excel is famous for it’s What-If capabilities. Take this class to become a What-If wizard. And perhaps Excel’s most technologically sophisticated feature is the ability to Pivot data tables to create reports. With PivotTables you can slice and dice your data in seconds and build virtually any type of summary report you can think of, including charts and graphs.
Lesson Objectives include:
- Cite and describe pivot table terminology.
- Produce and manage multiple business model situations using Scenario Manager, including the automatic and instant creation of a columnar summary report showing all situations side-by-side.
- Describe the types of data that are appropriate for a pivot table and recommend how to arrange inappropriate data so that it can be pivoted.
| |
|
QuickBooks 2009: The Basics (SQB1)
Wednesday, March 17, 2010, 9:00 AM to 1:30 PM (tentative)
- Open and use registers for any QuickBooks balance sheet accounts.
- Reconcile a QuickBooks checking account.
- Invoice customers, create sales orders and print customer statements.
|
QuickBooks 2009: Intermediate (SQB2)
Thursday, March 18, 2010 9:00 AM to 1:30 PM (tentative)
Independent professionals and small business owners use QuickBooks for a wide range of financial business processes, from billing customers to the preparation of letters and documents. Take this course to master advanced QuickBooks 2009 concepts and tools.
Lesson Objectives include:
- Track time, mileage and other expense. Allocate billable time and cost to customers and job while invoicing.
- Customize QuickBooks sales forms by applying and rearranging fields, headings, fonts and images, like your organization’s logo.
- Create estimates and do progress invoicing.
| |
|
