Invalid quantity. Please enter a quantity of 1 or more.
The quantity you chose exceeds the quantity available.
Please enter your name.
Please enter an email address.
Please enter a valid email address.
Please enter your message or comments.
Please enter the code as shown on the image.
Please select the date you would like to attend.
Please enter an email address.
Please enter a valid email address in the To: field.
Please enter a subject for your message.
Please enter a message.
You can only send this invitations to 10 email addresses at a time.
$$$$ is not a properly formatted color. Please use the format #RRGGBB for all colors.
Please limit your message to $$$$ characters. There are currently ££££.
$$$$ is not a valid email address.
Please enter a promotional code.
N/A
Sold Out
You have exceeded the time limit and your reservation has been released.
The purpose of this time limit is to ensure that registration is available to as many people as possible. We apologize for the inconvenience.
This is option is not available anymore. Please choose a different option.
Please read and accept the waiver.
All fields marked with * are required.
Please double check your email address. The email address format does not appear valid.
$$$$ requires a number between ££££ and §§§§
US Zipcodes need to be 5 digits.
Please double check your website URL.
All fields marked with * are required.
Your credit card expiration date is in the past.
Your credit card CSC needs to be 4 digits.
Please confirm your order:
$$$$
You have selected to Pay by Check.
Click OK to confirm your order.
Please confirm your order:
$$$$
You have selected to Pay at the Door.
Click OK to confirm your order.
Please confirm your order:
$$$$
You have selected to Pay upon Receiving an Invoice.
Click OK to confirm your order.
Your credit card CSC needs to be 3 digits.
Your billing zip code needs to be 5 digits.
There was a problem saving your address.
There was a problem saving your credit card info.
There was a problem saving your personal information.
Please select the date you would like to attend.
McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams.
Copying Prohibited by Law - McAfee Secure is a Trademark of McAfee, Inc.
Unknown card type.
No card number provided.
Credit card number is in invalid format.
Wrong card type or credit card number is invalid.
Credit card number has an inappropriate number of digits.
Please enter numbers here.
Please enter an integer value.
Numbers must be less or equal to $$$$
All the required fields have not been filled out. Click OK to proceed without all the required information, or click Cancel to finish entering the missing data.
Sorry, invalid event registration form.
Sorry, invalid event or database error.
Sorry, quantity must be a positive integer.
Sorry, you did not select a valid ticket.
Sorry, invalid event organizer email address.
Your order was canceled.
Thank You. Your order has been successfully completed. Your name and email address have been added to the list of event attendees.
Sorry, that option is sold out.
Sorry, that option is no longer available.
Sorry, there are only tickets of that type still available.
Sorry, you entered an invalid quantity. Please enter a quantity of 1 or more next to the type or types of tickets you would like to purchase.
Sorry, you did not select any tickets to purchase. Please enter a quantity of 1 or more next to the type or types of tickets you would like to purchase.
Sorry, there are no tickets left for this event.
The tickets, ticket quantity or date and time you've requested are no longer available, due to previous sales. Please choose a different date, time or number of tickets and place your order again.
Sorry, one or more of the tickets you requested are no longer available for purchase.
Sorry, you need to select the date you want to attend.
Sorry, the promotional code you entered is not valid yet.
Sorry, the promotional code you entered has expired.
Sorry, the promotional code you entered is not valid.
Your session has expired. Try ordering again.
Sorry, your requested ticket quantity exceeds the number provided by your promotional code.
Sorry, the tickets you are trying to order are not currently available.
Sorry, the payment type chosen is invalid for this event.
Sorry, there is only 1 ticket left for this event.
Sorry, there are only tickets left for this event.
We're sorry, this invitation is invalid.
We're sorry, this invitation has already been used.
We're sorry, you already have an order being processed for this event. Please wait a few minutes and try again.
We're sorry, there is a problem with your invitation. Please try again.
Invalid quantity of tickets selected.
Sorry, the payment type chosen is invalid for this event.
Sorry, your billing address was not saved properly, please try again.
Sorry, we experienced an internal error, please try again.
The captcha you entered is invalid. Please try again.
Invalid credit card selected. You have been logged out.
Sorry, your team selection was not valid.
Sorry, the payment type chosen is invalid for this event.
Sorry, your billing address was not saved properly, please try again.
Sorry, we experienced an internal error, please try again.
State
Zip Code
Province
Postal Code
County
State/Territory
State/Province
Event Details
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.
Learning Objectives
Upon successful completion of this course, participants will be able to:
- Cite and describe the five things that can be included in any Excel formula.
- Employ absolute versus relative (or default) referencing in formulas.
- Use and interpret three-dimensional cell references, even across multiple workbooks.
- Discover and demonstrate resources like shortcut menus, screen tips and shortcut keys that increase formula creation speed and productivity.
- Define range names and apply range names to formulas and workbook navigation.
- Apply functions and practice using at least one function in the six most popular function categories available in Excel.
- Produce formulas that combine multiple calculations and return a single result or multiple results.
- Solve conditional test with array formulas, including the ability to create a logical AND test and apply a logical OR test.
|
DESIGNED FOR:
|
Independent Professionals including Real Estate Agents, Financial Advisors, Accountants and Bookkeepers
|
|
TEACHING METHOD:
|
Lecture Demo
|
|
RECOMMENDED CE:
|
3 credit hours
|
|
PREREQUISITE:
|
none
|
|
COURSE MATERIAL:
|
Practice files and the program workbook, a 50 to 70 page .pdf file available for download 10 days prior to workshop date at http://www.christopher-inc.net/SSCE
|
|
EVENT ACRONYM:
|
SEE1
|
|
LEVEL:
|
Beginner - Intermediate
|
|
MEETING LOCATION:
|
Solid Source Realty
Buckhead Office
20 Lenox Pointe
Atlanta, GA 30324
|
|
PRICE:
|
$39.00 Early registration price is $34.00 (expires on Feb. XX, 2010)
|
When & Where
Solid Source Realty
20 Lenox Pointe
Atlanta,
GA 30324
Monday, March 15, 2010 from 9:00 AM to 1:30 PM (ET)
Add to my calendar
Hosted By
glen.christopher.net ltd.
Meet Glen Christopher: Achieving the productivity gains promised by technology requires a comprehensive training program. Glen Christopher works with business professionals who want to streamline financial reporting and eliminae repetitive steps in data analysis.
Glen is a popular and entertaining speaker. Since 1997, Glen Christopher has delivered over 1,000 technology presentations and seminars, for all types and sizes of organizations including:
Glen provides hands-on training and lecture/demo presentations on all versions of Microsoft Excel and QuickBooks. In addition to public seminars and on-site programs, Glen delivers webinars and VBA consulting & design services for financial reporting and data management solutions.