Course Outline
Excel to the Max
Two-Day Class
8/17/2010, 8/18/2010
8:30AM - 4:30PM
8/17/2010
$425.00 ** (Group discounts
$425.00 per class participant.)
City of Austin SBDP Lab
One Texas Building 505 Barton Springs Rd
Austin,
TX
This course is designed for intermediate to advanced user. In the class you will learn the following:
Understand Absolute References
• Work with relative and absolute references
• Create and use Absolute References
Create and use Named Ranges
• Navigate with named ranges
• Use named ranges in formulas
• Print using range names
Working with multiple pages in a workbook
• Group sheets
• Navigate multiple sheets
• Link multiple sheets
Advanced formulas
• The IF Function
• The Vlookup Function
• Text Functions
• The Concatenate Function
Working with Dates
• Understand date serial numbers
• Create date formats
• The Now Function
• The Today Function
Charting
• Creating a chart
• Modifying charts
• Create user defined charts
Database Functions
• Sorting
• Custom Sorts
• Filtering
• Create And/Or Conditions
• Automatic Subtotaling
• Pivot Tables
Customizing the Work Area
• Add, Delete and Rearrange toolbar buttons
• Working with Styles
• Creating and Using Templates
• Learn shortcuts
Working with Macros
• Running macros
• Recording macros
• The Basics of VBA
• Viewing and Editing macro
The website will automatically email a confirmation confirming you have been registered in this class. You will be sent an invoice within 7-10 days of registration. If credit card information is given, we send you an invoice for your records and will charge your credit card. Payment by check should be made to CLOUD TRAINING SERVICES, Federal Tax ID 75-2745586 and mailed to P O Box 94686, Lubbock, TX 79493. (Please note that classes held at Odessa College or Solutions Training Group will be invoiced by them and paid directly to them.)
In some locations group discounts are given if 3 or more people from the same organization attend this class or if the organization has a volume discount based on regular class attendance. If you are not sure if your organization qualifies for a group discount please contact Darla Cloud at dcloud@cloudtraining.com or call 806.793.3301.
If a person cancels a class up to five days prior to a workshop, they will receive a full refund. If they are unable to attend and do not cancel five days prior to the workshop, they may send a substitute. Cloud Training Services will consider emergency situations such as death of family members, illness, and weather and will make every attempt to work with the person in the event of an emergency.