Austin - Excel to the Max 2/6-7/2019 (Two Day Class)

Class time: 8:30am - 4:30pm

Location:

Entrepreneur Center of Austin
4029 S. Capital of Texas Hwy., Ste 110
Austin, TX 78704

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

For class fees paid directly to Cloud Training Services a person must cancel by the class deadline to receive a full refund. The cancellation deadline is 10 days prior to the class. The cancellation deadline is stated at the botoom of this page.

If you are unable to attend and do not cancel prior to the class, you may send a substitute. Cloud Training Services will consider emergency situations such as a death in the family, illness and weather, and will make every attempt to work with the person in the event of an emergency.

Note: Cloud Training Services partners with other traning vendors such as Odessa College and New Mexico Junior College and has no control over payment and registration process. When the registration fees are paid to another agency or vendor, the cancellation and refund policy will be those of that agency or vendor.

Cancellation Deadline for Full Refund: 10 days prior to class date.

Class Information

Class date: 02/06/19
Class end date: 02/07/19
Seats Remaining: 16
Cut off date: 02/06/19
Individual Price: $299.00
Location: Entrepreneur Center of Austin

Group Rate

No Number registrants Rate/Person($)
1 3 279.00
Share this class: